1. Tables and Views for SCM
  2. CST_WO_UPD_EVENT_TXNS_GT

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.
CONTAINS_OP_YIELD_OPERATION VARCHAR2 1 Indicates if the work order has at least one operation with operation yield factor not equal to 1. Possible values are Y, N.
OP_COMPL_WITH_VARIANCE_FLAG VARCHAR2 1 Indicates whether the work order has at least one operation that is completed with variance quantity. Possible values are Y, N.
WO_FIRST_OP_TOTAL_QTY NUMBER Indicates the total quantity of the first operation from the actual work execution. This will be the sum of completion, scrap and variance quantities.
PROCESS_BATCH_TYPE VARCHAR2 30 Indicates how the batch quantity is calculated for a process work definition. Valid values exist in the lookup with lookup type = ORA_WIS_PROCESS_BATCH_TYPES.
PRIMARY_PRODUCT_QUANTITY NUMBER Represents the output quantity of the primary product used to create the work order.
PRIMARY_PROD_UOM_CODE VARCHAR2 3 Represents the unit of measure code of the primary product used to create the work order. This can be termed as planned primary product unit of measure code.
PRIMARY_PROD_WD_UOM_CODE VARCHAR2 3 Represents the unit of measure code of the primary product from the work definition used for publishing the standard cost. This can be different from the Costing unit of measure code.
PRIMARY_PROD_UOM_CONV_FACTOR NUMBER Indicates the conversion factor between the planned primary product UOM taken from the work order header and the primary product UOM taken from the work definition used for publishing the standard cost.