CST_SCENARIO_ROLLUP_OUT_GT
This table is used during the cost roll up process to aid in deriving the temporary cost break down of rolled up costs for output items.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| SCENARIO_ID | NUMBER | 18 | Indicates the surrogate identifier generated for scenario rollup headers. | |
| WORK_DEFINITION_ITEM_ID | NUMBER | 18 | Identifies the work definition item for which the rollup outputs are derived. | |
| REF_SCENARIO_ROLLUP_HEADER_ID | NUMBER | 18 | Indicates the reference of where used scenario rollup header record for the inventory organization. | |
| SCENARIO_ROLLUP_HEADER_ID | NUMBER | 18 | Indicates the surrogate identifier generated for scenario rollup headers. | |
| 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. | |
| OUTPUT_SEQ_NUMBER | NUMBER | Indicates the sequence of this output line within an operation. | ||
| CST_OPERATION_ID | NUMBER | 18 | Identifies the costing work definition reference for which the work definition operation outputs are derived. | |
| WD_OPERATION_ID | NUMBER | 18 | Indicates the Fusion manufacturing operation identifier as stored in WIS_WD_OPERATIONS_VL. | |
| OPERATION_SEQ_NUMBER | NUMBER | Indicates the operation sequence within a work definition. | ||
| COST_ALLOCATION_PERCENTAGE | NUMBER | Indicates the cost percentage share of this output across all outputs. | ||
| OUTPUT_QUANTITY | NUMBER | Represents the quantity of the output item. | ||
| UOM_CODE | VARCHAR2 | 3 | Represents the unit of measure code of the output quantity. | |
| CST_WORK_DEFINITION_ID | NUMBER | 18 | Identifies the costing work definition snapshot. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_SCN_ROLLUP_OUT_GT_N1 | Non Unique | REF_SCENARIO_ROLLUP_HEADER_ID, CST_OPERATION_ID |