CST_SCENARIO_ROLLUP_OUTPUTS_GT
This table contains the temporary cost break up 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. | |
| NEXT_CST_OPERATION_ID | NUMBER | 18 | Identifies the next costing work definition operation. | |
| 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. | ||
| 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 | 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 | 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 | 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 | Indicates the unscaled resource usage rate for the resource or the unscaled material quantity. | ||
| QTY_UOM_CODE | VARCHAR2 | 3 | Indicates the unit of measure of the quantity usage. | |
| 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. | ||
| CUMULATIVE_EXTENDED_COST | NUMBER | Captures the cumulative extended cost for the operation. | ||
| CUMULATIVE_UNIT_COST | NUMBER | Captures the cumulative unit cost for the operation. | ||
| THIS_ALLOCATION_PERCENTAGE | NUMBER | Identifies the cost allocation percentage for a output item in a particular operation. | ||
| OTHER_ALLOCATION_PERCENTAGE | NUMBER | Identifies the cost allocation percentage for a 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. | ||
| UNALLOCATED_EXTENDED_COST | NUMBER | Captures the unallocated extended cost. | ||
| UNALLOCATED_UNIT_COST | NUMBER | Captures the unallocated unit cost. | ||
| YIELD_FACTOR | NUMBER | Indicates the percentage of material quantity actually incorporated into the finished good. | ||
| CALCULATION_SEQUENCE | NUMBER | The sequence in which the calculations are performed. | ||
| 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 output material cost or the resource rate linked to the rollup header. | |
| VALUE_TYPE | VARCHAR2 | 30 | Indicates the value type of the output cost detail. Valid values are ALLOCATION, CARRY_FORWARD, RESIDUAL, OUTPUT_REFERENCE. | |
| 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_PRIMARY_UOM_CODE | VARCHAR2 | 3 | Represents the primary unit of measure of the output item. | |
| 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_CODE | VARCHAR2 | 3 | Represents the unit of measure code of the batch quantity. | |
| BATCH_PRIMARY_UOM_CODE | VARCHAR2 | 3 | Represents the primary unit of measure code of the batch quantity. | |
| BATCH_UOM_CONVERSION_FACTOR | NUMBER | Indicates the conversion factor from batch UOM to primary UOM. | ||
| WORK_METHOD_CODE | VARCHAR2 | 30 | Indicates the work method type. | |
| CST_MSC_SRC_RULE_ID | NUMBER | 18 | Indicates the costing identifier for the sourcing rule. | |
| OP_YIELD_FACTOR | NUMBER | 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 | Indicates the reverse cumulative yield factor for the operation. Default value is 1 (100%). |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_SCN_ROLLUP_OUTPUTS_N1 | Non Unique | SCENARIO_ROLLUP_HEADER_ID |
| CST_SCN_ROLLUP_OUTPUTS_N2 | Non Unique | WORK_DEFINITION_ITEM_ID, NEXT_CST_OPERATION_ID |
| CST_SCN_ROLLUP_OUTPUTS_N3 | Non Unique | SCENARIO_ID, WORK_DEFINITION_ITEM_ID, SCENARIO_ROLLUP_HEADER_ID |