CST_WO_DTL_COST_VARIANCES_GT
This GT table would be used for detailed variance computation. All UoM conversions, currency conversions and cost component to cost element mapping are done in this table.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| RECORD_TYPE | VARCHAR2 | 30 | Indicates whether the record is populated from rolled up cost or from actual work order. Possible values:- 'WORK_ORDER' 'WORK_DEFINITION'. | |
| WO_UPDATE_EVENT_TXN_ID | NUMBER | 18 | The work order update evnt transaction identifier. | |
| CST_WORK_ORDER_ID | NUMBER | 18 | Work Order Identifier in costing | |
| COST_ORG_ID | NUMBER | 18 | Surrogate key identifying cost organization | |
| COST_BOOK_ID | NUMBER | 18 | COST_BOOK_IDSurrogate key identifying cost book. | |
| OUTPUT_INVENTORY_ITEM_ID | NUMBER | 18 | Surrogate key identifying output item. | |
| OUTPUT_INVENTORY_ORG_ID | NUMBER | 18 | Surrogate key identifying plant. | |
| STD_COST_ID | NUMBER | 18 | The standard cost header identifier. | |
| SCENARIO_ROLLUP_HEADER_ID | NUMBER | 18 | Surrogate key identifying the scneraio rollup header. | |
| SCENARIO_ROLLUP_DETAIL_ID | NUMBER | 18 | Surrogate key identifying scenario detail record. | |
| WD_OPERATION_ID | NUMBER | 18 | Surrogate key identifying work definiton operation. | |
| CST_WORK_ORDER_OPERATION_ID | NUMBER | 18 | Work Order Operation Identifier in costing. | |
| OPERATION_SEQ_NUMBER | NUMBER | Operation sequence number of the operation. | ||
| TRANSACTION_TYPE | VARCHAR2 | 30 | Indicates whether the row is for a resource or a component. | |
| RESOURCE_ID | NUMBER | 18 | Surrogate key identifying the resource. | |
| MATERIAL_INVENTORY_ITEM_ID | NUMBER | 18 | Surrogate key identifying the component item. | |
| COST_COMPONENT_ID | NUMBER | 18 | Surrogate key identifying the cost component. | |
| EXPENSE_POOL_ID | NUMBER | 18 | Surrogate key identifying the expense pool. | |
| COST_LEVEL | VARCHAR2 | 30 | Cost Level | |
| BASIS_TYPE | VARCHAR2 | 30 | Basis type. | |
| COSTING_BATCH_OUTPUT_SIZE | NUMBER | Costing batch output size from CST_SCENARIO_ROLLUP_DETAILS table. | ||
| WD_QUANTITY | NUMBER | Quantity from CST_SCENARIO_ROLLUP_DETAILS. | ||
| QTY_UOM_CODE | VARCHAR2 | 3 | QTY_UOM_CODE from ST_SCENARIO_ROLLUP_DETAILS. | |
| COST_UOM_CODE | VARCHAR2 | 3 | Indicates the unit of measure in which the material cost / resource rate is defined. | |
| QTY_UOM_CONVERSION_FACTOR | NUMBER | Quantity UoM conversion Factor | ||
| COST_UOM_CONVERSION_FACTOR | NUMBER | Cost UoM conversion factor. | ||
| WD_QUANTITY_COST_UOM | NUMBER | Quantity on work definition converted to costing UoM. | ||
| COST_BAT_OP_SIZE_COST_UOM | NUMBER | Costing batch output size converted to costing UoM. | ||
| WD_SCALED_QTY | NUMBER | Scaled input quantity in the work definition in costing UoM. | ||
| COSTING_UOM_CODE | VARCHAR2 | 3 | Costing UoM code. | |
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Currency cpnversion type for conversting from Scenario currency to Cost Book currency. | |
| CURRENCY_CONVERSION_DATE | DATE | Currency cpnversion date. | ||
| CURRENCY_CONVERSION_RATE | NUMBER | Currency conversion rate to convert from scenario currency to cost book currency. | ||
| WD_UNIT_COST | NUMBER | Unit cost from CST_SCENARIO_ROLLUP_DETAILS. | ||
| SCENARIO_CURRENCY_CODE | VARCHAR2 | 15 | Scenario currency code. | |
| WD_UNIT_COST_COST_BOOK_CURR | NUMBER | Unit cost at work definition side in cost book currency. | ||
| COST_BOOK_CURRENCY_CODE | VARCHAR2 | 15 | Cost book currency code. | |
| COST_PROFILE_ID | NUMBER | 18 | Surrogate key of cost profile. | |
| COMPONENT_GROUP_ID | NUMBER | 18 | Surrogate key identifying cost component group. | |
| COST_ELEMENT_ID | NUMBER | 18 | Surrogate key identifying the cost element. | |
| WORK_ORDER_QUANTITY | NUMBER | Quantity at work order side. | ||
| OPERATION_SCRAP_QTY | NUMBER | Scrap quantity for this operation. | ||
| OPERATION_COMPLETION_QTY | NUMBER | Completion quantity for this operation. | ||
| TOT_INP_QTY_EXCL_SCRAP | NUMBER | This indicates the total input quantity of resource/input excluding scrap. | ||
| TOTAL_INPUT_QUANTITY | NUMBER | Total input quantity at work order side. | ||
| WO_TOTAL_COST | NUMBER | Total cost on work order side. | ||
| WO_UNIT_COST | NUMBER | Unit cost at work order side. | ||
| SUBSTITUTION_FLAG | VARCHAR2 | 1 | This flag indicates whether the cost for the row goes in as substitution variance. | |
| 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. | ||
| WD_MAKE_COST_COST_BOOK_CURR | NUMBER | The make unit cost at cost definition side in cost book currency. | ||
| WORK_METHOD_CODE | VARCHAR2 | 30 | Indicates the work method code of the work definition snapshot. Possible values: DISCRETE_MANUFACTURING,PROCESS_MANUFACTURING. | |
| 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. |