CST_SCENARIO_ROLLUP_DETAILS_GT
This table contains the temporary cost component level break up of rolled up costs for input components, resources, operations, sub-assemblies and output items.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_SCN_ROLLUP_DTLS_GT_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 | 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'. | ||
| 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 snap shot 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 actually incorporated into the finished good. | |||
| COST_UOM_CONVERSION_FACTOR | NUMBER | Indicates the conversion factor for converting from the Primary UOM to the Costing UOM. | |||
| 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. | ||
| ROLLUP_ITEM_TYPE | VARCHAR2 | 30 | Indicates whether the item being rolled up is (1) Standard (2) Purchased CTO (3) Manufactured CTO. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_SCN_ROLLUP_DTLS_GT_PK | Unique | SCENARIO_ROLLUP_DETAIL_ID |
| CST_SCN_ROLLUP_DTLS_GT_U1 | Unique | SCENARIO_ROLLUP_HEADER_ID, CST_OPERATION_ID, RESOURCE_SEQ_NUMBER, RESOURCE_ID, MATERIAL_INVENTORY_ITEM_ID, COST_ELEMENT_ID, EXPENSE_POOL_ID, COST_LEVEL, OVERHEAD_RATE_ID |