1. Tables and Views for SCM
  2. CST_WO_DTL_COST_VARIANCES

CST_WO_DTL_COST_VARIANCES

This entity stores the cost and quantity information for each component/resource at work definition and work order side. This data will be further used to find the variance

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

CST_WO_DTL_COST_VARIAN_PK

WO_DTL_COST_VARIANCE_ID

Columns

Name Datatype Length Precision Not-null Comments
WO_DTL_COST_VARIANCE_ID NUMBER 18 Yes Surrogate key identifying the work order variance detail record
WO_UPDATE_EVENT_TXN_ID NUMBER 18 Yes Surrogate key identifying the work order update event txn.
OUTPUT_INVENTORY_ITEM_ID NUMBER 18 Yes Surrogate key identifying the output item of the work order.
OUTPUT_INVENTORY_ORG_ID NUMBER 18 Yes Surrogate key identifying the plant where the job is done.
COST_ORGANIZATION_ID NUMBER 18 Yes Surrogate key identifying the cost organization.
COST_BOOK_ID NUMBER 18 Yes Surrogate key identifying the cost book.
COST_DATE TIMESTAMP Yes The cost date derived on the variance transaction. This date will always be equal to the WO closed date persisted in the WO status transaction table.
COSTING_BATCH_OUTPUT_SIZE NUMBER The costing batch size based on which costs are rolled up, in Costing UOM.
WO_COMPLETION_QTY NUMBER The total quantity of output items completed by the work order.
OUTPUT_UOM_CODE VARCHAR2 3 Yes Costing UoM of the output item.
TRANSACTION_TYPE VARCHAR2 30 Yes A value of ???COMPONENT??? indicates this is a record for a component. ???RESOURCE??? indicates this is a record for a resource.
WD_OPERATION_ID NUMBER 18 The work definition operation identifier.
OPERATION_SEQUENCE_NUM NUMBER Yes Number identifying the operation sequence within a work order. This is the sequence in which operation will be performed in the work order.
CST_WORK_ORDER_ID NUMBER 18 Yes Surrogate ID identifying the work order in costing.
CST_WORK_ORDER_OPERATION_ID NUMBER 18 Surrogate ID identifying the work order operation in costing.
MATERIAL_INVENTORY_ITEM_ID NUMBER 18 Surrogate ID of the component item if transaction_type = ???COMPONENT???.
RESOURCE_ID NUMBER 18 Surrogate ID of the resource if transaction_type = ???RESOURCE???
OPERATION_OUTPUT_ITEM_ID NUMBER 18 Surrogate key identifying the output item in case of process manufacturing work orders. These can be either primary product, by-product or co-product.
SUBSTITUTION_FLAG VARCHAR2 1 Indicates whether the component/resource exists only at work order. The substation variance will be calculated if this flag is ???Y???
WO_QUANTITY NUMBER Total quantity reported at the work order side for resource/component as the case may be.
BASIS_TYPE VARCHAR2 30 Indicates the basis type for the resource/component usage rate. Fixed rate means that the resource/component is used once as per the resource usage rate for the entire batch. Variable rate means that for each item produced, the resource/component is used as per the resource usage rate specified. A value of 1 indicate 'Variable'. A value of 2 indicate 'Fixed'.
WD_SCALED_QTY NUMBER Scaled up quantity at the work definition side for resource/component as the case may be.
UOM_CODE VARCHAR2 3 Costing UoM of the resource/component in which the quantities are stored.
COST_ELEMENT_ID NUMBER 18 Surrogate ID of the cost element.
EXPENSE_POOL_ID NUMBER 18 Surrogate ID of the expense pool.
WD_UNIT_COST NUMBER The published unit standard cost in Cost Book currency.
SCENARIO_ROLLUP_HEADER_ID NUMBER 18 The scenario rollup header identifier from where the standard cost was derived.
SCENARIO_ROLLUP_DETAIL_ID NUMBER 18 The scenario detail header identifier from where the standard was derived.
STD_COST_ID NUMBER 18 The surrogate ID identifying the published standard cost record.
WO_UNIT_COST NUMBER The unit cost calculated at work order side.
CURRENCY_CODE VARCHAR2 15 Cost Book currency code, in which all amounts are calculated.
VARIANCE_GROUP VARCHAR2 30 Yes Variance Group. Values from lookup type 'CST_WO_VARIANCE_GROUP'.
VARIANCE_TYPE VARCHAR2 30 Yes Variance Type; values from lookup type 'CST_WO_VARIANCE_TYPE'.
VARIANCE_COST NUMBER Total calculated variance cost
RESOURCE_SEQ_NUMBER NUMBER Defines the actual sequence of the resource used in operations. Multiple resources can be scheduled to be working concurrently within the same operation.
WD_MAKE_UNIT_COST NUMBER The make unit cost derived from the scenario rollup results.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
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.

Indexes

Index Uniqueness Tablespace Columns Status
CST_WO_DTL_COST_VARIAN_PK Unique Default WO_DTL_COST_VARIANCE_ID
CST_WO_DTL_COST_VARIAN_U1 Unique Default WO_UPDATE_EVENT_TXN_ID, OPERATION_SEQUENCE_NUM, TRANSACTION_TYPE, MATERIAL_INVENTORY_ITEM_ID, RESOURCE_ID, COST_ELEMENT_ID, VARIANCE_GROUP, VARIANCE_TYPE, EXPENSE_POOL_ID Obsolete
CST_WO_DTL_COST_VARIAN_U2 Unique Default WO_UPDATE_EVENT_TXN_ID, OPERATION_SEQUENCE_NUM, TRANSACTION_TYPE, MATERIAL_INVENTORY_ITEM_ID, RESOURCE_ID, OPERATION_OUTPUT_ITEM_ID, COST_ELEMENT_ID, VARIANCE_GROUP, VARIANCE_TYPE, EXPENSE_POOL_ID, RESOURCE_SEQ_NUMBER, BASIS_TYPE