CST_SCENARIO_ROLLUP_DETAILS
This table contains the cost component level break down of rolled up costs for input components, resources, operations, sub-assemblies and output items.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CST_SCN_ROLLUP_DETAILS_PK |
SCENARIO_ROLLUP_DETAIL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SCENARIO_ROLLUP_DETAIL_ID | NUMBER | 18 | Yes | Indicates the surrogate identifier for the scenario rollup detail record. | |
| SCENARIO_ROLLUP_HEADER_ID | NUMBER | 18 | Yes | Indicates the surrogate identifier generated for scenario rollup headers. | |
| CST_OPERATION_ID | NUMBER | 18 | Yes | For standard scenarios, indicates the work definition operation identifier WD_OPERATION_ID from manufacturing. For configured item scenarios, indicates the Fusion costing operation identifier and is used to model the BOM structure of all assemblies in the snapshot as it uniquely identifies an operation for every assembly structure. | |
| 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. | |||
| RESOURCE_ID | NUMBER | 18 | Indicates the resource used for the work definition operation. | ||
| MATERIAL_INVENTORY_ITEM_ID | NUMBER | 18 | Indicates the material identifier of the material used in the work definition operation. | ||
| MATERIAL_INVENTORY_ORG_ID | NUMBER | 18 | Indicates the organization in which the material is defined. | ||
| COST_ELEMENT_ID | NUMBER | 18 | Yes | Identifies the cost element of the rolled-up cost details. | |
| EXPENSE_POOL_ID | NUMBER | 18 | Identifies the expense pool of the rolled-up cost details. | ||
| COST_LEVEL | VARCHAR2 | 30 | Yes | Indicates the level of the cost detail. Valid values are THIS_LEVEL and LOWER_LEVEL. | |
| OVERHEAD_RATE_ID | NUMBER | 18 | Indicates the source of the overhead cost when the overhead flag is 'Y'. The value corresponds to column STD_OVERHEAD_RATE_DETAIL_ID in the CST_STD_OVERHEAD_RATE_DETAILS table. | ||
| OVERHEAD_FLAG | VARCHAR2 | 1 | Indicates if the cost originated from overhead rate calculations. | ||
| COSTING_BATCH_OUTPUT_SIZE | NUMBER | Yes | Indicates the costing batch output size for work definition for which the snapshot is created. | ||
| BASIS_TYPE | VARCHAR2 | 30 | Indicates whether the usage is fixed (e.g., usage per lot produced) or variable (e.g., usage per item produced). | ||
| QUANTITY_USAGE | NUMBER | Yes | Indicates the unscaled resource usage rate for the resource or the unscaled material quantity for the input material. | ||
| QTY_UOM_CODE | VARCHAR2 | 3 | Yes | Indicates the unit of measure of the quantity usage. | |
| EXTENDED_COST | NUMBER | Yes | Indicates the rate*usage scaled amount or the material cost*quantity scaled amount that takes into consideration the costing batch output size and basis type, along with the material yield when applicable. | ||
| UNIT_COST | NUMBER | Yes | Indicates the average per output amount calculated as EXTENDED_COST/COSTING_BATCH_OUTPUT_SIZE and is the amount used for rolling up to the next level. | ||
| YIELD_FACTOR | NUMBER | Indicates the percentage of material quantity incorporated into the finished good. | |||
| WD_OPERATION_ID | NUMBER | 18 | Indicates the Fusion manufacturing operation identifier as stored in WIS_WD_OPERATIONS_VL. For CTO snapshot data, this identifier can be shared across different assemblies and therefore should only be used to reference the data stored in WIS_WD_OPERATIONS_VL. Indicates the following when negative value: -1 Plant or work center overhead -2 Cost organization level valuation unit averaging adjustment -3 "Transfer From" pseudo record | ||
| 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. | ||
| COST_COMPONENT_ID | NUMBER | 18 | OBSOLETE: Identifies the cost component of the rolled-up cost details. | ||
| COST_UOM_CODE | VARCHAR2 | 3 | OBSOLETE: Indicates the unit of measure in which the material cost or resource rate is defined. | ||
| CUMULATIVE_UNIT_COST | NUMBER | Captures the cumulative unit cost for the operation. It is equal to the total unit cost of the input components and input resources and the unallocated unit cost from the previous operations. | |||
| CUMULATIVE_EXTENDED_COST | NUMBER | Captures the cumulative extended cost for the operation. It is equal to the total extended cost of the input components and input resources and the unallocated extended cost from the previous operations. | |||
| ALLOCATED_UNIT_COST | NUMBER | Captures the unit cost allocated for a particular output item based on the cost allocation percentage. It is calculated by applying the cost allocation percentage on the sum of current operation unit cost and previous unit unallocated costs. | |||
| ALLOCATED_EXTENDED_COST | NUMBER | Captures the extended cost allocated for a particular output item based on the cost allocation percentage. It is calculated by applying the cost allocation percentage on the sum of current operation extended cost and previous unallocated extended costs. | |||
| UNALLOCATED_UNIT_COST | NUMBER | Captures the unallocated unit cost left after all the allocations for output items for a particular operation are completed. It is calculated as the difference between cumulative unit cost and allocated unit cost. | |||
| UNALLOCATED_EXTENDED_COST | NUMBER | Captures the unallocated extended cost left after all the allocations for output items for a particular operation are completed. It is calculated as the difference between cumulative extended cost and allocated extended cost. | |||
| COST_ALLOCATION_PERCENTAGE | NUMBER | Identifies the cost allocation percentage for an output item for a particular operation. | |||
| OPERATION_EXTENDED_COST | NUMBER | Indicates the rate*usage scaled amount or the material cost*quantity scaled amount at an operation level. | |||
| OPERATION_UNIT_COST | NUMBER | Indicates the rate*usage amount or the material cost*quantity amount at an operation level. | |||
| PREV_UNALLOCATED_EXTENDED_COST | NUMBER | Indicates the prior operation unallocated extended cost. | |||
| PREV_UNALLOCATED_UNIT_COST | NUMBER | Indicates the prior operation unallocated unit cost. | |||
| THIS_ALLOCATION_PERCENTAGE | NUMBER | Identifies the cost allocation percentage for an output item in a particular operation. | |||
| OTHER_ALLOCATION_PERCENTAGE | NUMBER | Identifies the cost allocation percentage for an output item for a prior operation. | |||
| THIS_ALLOCATED_EXTENDED_COST | NUMBER | Captures the extended cost allocated for a particular output item based on the cost allocation percentage. | |||
| THIS_ALLOCATED_UNIT_COST | NUMBER | Captures the unit cost allocated for a particular output item based on the cost allocation percentage. | |||
| OTHER_ALLOCATED_EXTENDED_COST | NUMBER | Captures the extended cost allocated for other output item based on the cost allocation percentage. | |||
| OTHER_ALLOCATED_UNIT_COST | NUMBER | Captures the unit cost allocated for other output item based on the cost allocation percentage. | |||
| TOTAL_ALLOCATED_EXTENDED_COST | NUMBER | Captures the total of all the allocated extended cost. | |||
| TOTAL_ALLOCATED_UNIT_COST | NUMBER | Captures the total of all the allocated unit cost. | |||
| SOURCE_TYPE | VARCHAR2 | 30 | Indicates the cost rollup derived source table linked to the rollup header. | ||
| SOURCE_ID | NUMBER | 18 | Indicates the cost rollup derived source identifier of the input material cost or the resource rate linked to the rollup header. | ||
| OUTPUT_INVENTORY_ITEM_ID | NUMBER | 18 | Represents the unique identifier of the output item. | ||
| OUTPUT_INVENTORY_ORG_ID | NUMBER | 18 | The organization identifier that represents the manufacturing plant to which this operation output item belongs. | ||
| RUNNING_UNIT_TOTAL | NUMBER | Captures the running total of unit cost. | |||
| RUNNING_EXTENDED_TOTAL | NUMBER | Captures the running total of extended cost. | |||
| OUTPUT_QUANTITY | NUMBER | Represents the quantity of the output item. | |||
| OUTPUT_UOM_CONVERSION_FACTOR | NUMBER | Indicates the conversion factor between the output item's UOM to its primary UOM. | |||
| OUTPUT_UOM_CODE | VARCHAR2 | 3 | Represents the unit of measure of the output quantity. | ||
| BATCH_QUANTITY | NUMBER | Represents the quantity produced for the work definition. In process manufacturing, this is the batch quantity. | |||
| BATCH_UOM_CONVERSION_FACTOR | NUMBER | Indicates the conversion factor from batch UOM to primary UOM. | |||
| BATCH_UOM_CODE | VARCHAR2 | 3 | Represents the unit of measure code of the batch quantity. | ||
| OUTPUT_SEQ_NUMBER | NUMBER | Indicates the sequence of this output line within an operation. | |||
| OPERATION_SEQ_NUMBER | NUMBER | 9 | Indicates the sequence of this operation within the work definition. | ||
| SCENARIO_ID | NUMBER | 18 | Indicates the scenario from which the rollup details records were created. | ||
| CST_MSC_SOURCE_RULE_ID | NUMBER | 18 | Indicates the costing identifier for the sourcing rule. | ||
| STD_TXFR_COST_RULE_ID | NUMBER | 18 | Unique identifier for the transfer rule transfer charge percentage. | ||
| TXFR_CURRENCY_CONVERSION_FLAG | VARCHAR2 | 1 | Indicates the rollup detail has been converted from source currency code to the currency code of the context organization when doing transfer sourcing rules. Possible values are Y, NULL. | ||
| ROLLUP_DETAIL_SOURCE | VARCHAR2 | 20 | Indicates the source of the rollup detail record. Possible values are MAKE, TXFR, BLEND_MAKE_ADJ, BLEND_TXFR_ADJ, BLEND_BUY_PCT, COST_ORG_VU_AVG_ADJ, OVHD. | ||
| OP_YIELD_FACTOR | NUMBER | Yes | Indicates the yield factor for the operation. Default value is 1 (100%). Used by Cost Rollup process for yield calculations. | ||
| OP_REV_YIELD_FACTOR | NUMBER | Yes | Indicates the reverse cumulative yield factor for the operation. Default value is 1 (100%). |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CST_SCENARIO_ROLLUP_DETAILS | cst_scenario_rollup_headers | SCENARIO_ROLLUP_HEADER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_SCN_ROLLUP_DETAILS_PK | Unique | FUSION_TS_TX_DATA | SCENARIO_ROLLUP_DETAIL_ID |
| CST_SCN_ROLLUP_DETAILS_U1 | Unique | FUSION_TS_TX_DATA | SCENARIO_ROLLUP_HEADER_ID, CST_OPERATION_ID, OUTPUT_INVENTORY_ITEM_ID, RESOURCE_SEQ_NUMBER, RESOURCE_ID, MATERIAL_INVENTORY_ITEM_ID, COST_ELEMENT_ID, EXPENSE_POOL_ID, COST_LEVEL, OVERHEAD_RATE_ID, COST_COMPONENT_ID, MATERIAL_INVENTORY_ORG_ID, CST_MSC_SOURCE_RULE_ID, STD_TXFR_COST_RULE_ID |