CST_IGNORE_INV_ORGS_GT

This Global Temporary table stores the inventory organizations for which the interface transactions cannot be processed by the preprocessor and must be marked as error.

Details

Schema: FUSION
Object owner: CST
Object type: TABLE

Primary Key

Name	Columns
CST_IGNORE_INV_ORGS_GT_PK	INVENTORY_ORG_ID, REASON

Columns

Name
INVENTORY_ORG_IDNUMBER18YesThe inventory organizations for which transactions exist in the interface but have missing or incomplete costing setup. The transactions in these inventory organization will not be processed by the PreProcessor. REASONVARCHAR210YesThis is to identify the type of setup missing. It can be one of "ORPHAN" meaning it is not associated to any Cost Org, "NO_BOOK" meaning that no Cost Book is associated to its Cost Org or "INACTIVE" meaning that the Cost Org - Inv Org association is no longer active.

Name

INVENTORY_ORG_IDNUMBER18YesThe inventory organizations for which transactions exist in the interface but have missing or incomplete costing setup. The transactions in these inventory organization will not be processed by the PreProcessor.

REASONVARCHAR210YesThis is to identify the type of setup missing. It can be one of "ORPHAN" meaning it is not associated to any Cost Org, "NO_BOOK" meaning that no Cost Book is associated to its Cost Org or "INACTIVE" meaning that the Cost Org - Inv Org association is no longer active.

Indexes

Index	Uniqueness	Columns
CST_IGNORE_INV_ORGS_GT_U1	Unique	INVENTORY_ORG_ID, REASON