CST_WO_UPD_EVENT_TXNS_GT

This GT table is used while job close variance processing is performed. It contains all the work order update event transactions eligible for variance processing.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
COST_ORG_ID	NUMBER		18	Yes	Surrogate key of the cost organization.
COST_BOOK_ID	NUMBER		18	Yes	Surrogate key of the cost book.
CST_WORK_ORDER_ID	NUMBER		18	Yes	The surrogate key identifying work order in costing.
WO_UPDATE_EVENT_TXN_ID	NUMBER		18		The surrogate key identifying work order status update event transaction in costing.
COST_METHOD_CODE	VARCHAR2	30			The cost method used for processing transaction. Value comes from lookup_type CST_COST_METHODS.
COST_DATE	TIMESTAMP				Cost date of the update event transaction.
PERIOD_NAME	VARCHAR2	15			Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method.
SCENARIO_ROLLUP_HEADER_ID	NUMBER		18		Surrogate key identifying scenario rollup header.
STD_COST_ID	NUMBER		18		The standard cost header identifier.
STATUS	VARCHAR2	1			This field indicates the status of the update event while variance processing is performed.
WORK_METHOD_CODE	VARCHAR2	30			Can contain the following values: DISCRETE_MANUFACTURING,MAINTENANCE,PROCESS_MANUFACTURING.
INVENTORY_ITEM_ID	NUMBER		18		Surrogate key identifying the item.
SCCR_SOURCE_TYPE_CODE	VARCHAR2	5			Indicates the supply chain cost rollup source types of buy, make and transfer. Valid values are: NULL, B, BM, BMT, BT, M, MT, T.