CST_INV_TRANSACTION_STATUS_GT

The global temporary table is used to explode the inventory transactions by cost organization and cost book and is then eventually stored in CST_INV_TRANSACTION_STATUS table

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Precision	Not-null	Comments
CST_INV_TRANSACTION_ID	NUMBER	18	Yes	Single column FK: Identifies the inventory transaction within the costing system.
COST_ORG_ID	NUMBER	18	Yes	Single column FK: Identifies the Cost Organization associated with the inventory organization.
COST_BOOK_ID	NUMBER	18	Yes	Single column FK: Identifies the Cost Book assigned to the Cost Organization.
TRANSACTION_DATE	TIMESTAMP		Yes	The date when this transaction happened.
INVENTORY_ITEM_ID	NUMBER	18		Identifies the item associated to the transaction.