CST_WO_RUNNING_DEPLETIONS_GT

This GT table would be used for in-process layer creation related to work order transactions. This table will be populated with the depletion layers created using onhand and depletion quantity.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
WIP_REC_TRXN_ID	NUMBER		18	Yes	Surrogate ID identifying the layer that gets depleted.
WIP_DEP_TRXN_ID	NUMBER		18	Yes	Surrogate ID identifying the depletion transaction.
COST_ORG_ID	NUMBER		18	Yes	Surrogate ID identifying the cost organization associated to the Plant.
COST_BOOK_ID	NUMBER		18	Yes	Surrogate ID identifying the cost book associated to the cost organization.
CST_WORK_ORDER_ID	NUMBER		18	Yes	Surrogate ID identifying the work order in costing.
CST_WORK_ORDER_OPERATION_ID	NUMBER		18	Yes	Surrogate ID identifying the work order operation in costing.
INVENTORY_ITEM_ID	NUMBER		18	Yes	Surrogate ID identifying the item recorded against the transaction.
WIP_ITEM_TYPE	VARCHAR2	30		Yes	Identifies the item use for this particular transaction. Possible values: COMPONENT/PRODUCT
TRANSACTION_DATE	TIMESTAMP			Yes	Indicates the transaction date as recorded in CST_TRANSACTIONS.
REC_TRANSACTION_DATE	TIMESTAMP				Transaction date of the receipt transaction
RUNNING_DEPL_QTY	NUMBER				Running depletion quantity at this layer.
DEPL_QUANTITY	NUMBER				Total depletion quantity