CST_SCENARIO_ROLLUP_COSTS_GT
This table contains temporary cumulative cost data used to display rolled up costs.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SCENARIO_ID | NUMBER | 18 | Yes | Surrogate key and unique identifier for each cost planning scenario. | |
| SCENARIO_ROLLUP_HEADER_ID | NUMBER | 18 | Indicates the surrogate identifier generated for rollup headers. | ||
| ROLLUP_HEADER_TYPE | VARCHAR2 | 30 | Indicates the type of rollup header. Valid values are ITEM, RESOURCE, and OPERATION. | ||
| ROLLUP_HEADER_KEY | NUMBER | 18 | Indicates the identifier of the rollup header type. Valid values are the item identifier, the resource identifier, or the work definition operation identifier. | ||
| STATUS_CODE | VARCHAR2 | 30 | Indicates the status of the rollup header. Valid values are NOT_PROCESSED, SUCCESS, CHANGED, or an FND message name. | ||
| HEADER_SOURCE_TYPE | VARCHAR2 | 30 | Indicates the cost rollup derived source table linked to the rollup header. | ||
| 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. | ||
| CST_OPERATION_ID | NUMBER | 18 | 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. | ||
| 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. | ||
| 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. | ||
| CST_MSC_SRC_RULE_ID | VARCHAR2 | 18 | Indicates the costing identifier for the sourcing rule. | ||
| MATERIAL_INVENTORY_ORG_ID | NUMBER | 18 | Indicates the organization in which the material is defined. | ||
| OVERHEAD_RATE_ID | NUMBER | 18 | Indicates the source of the overhead cost when the overhead flag is 'Y'. | ||
| MATERIAL_COST | NUMBER | Identifies the cumulative cost of a material. | |||
| RESOURCE_COST | NUMBER | Identifies the cumulative cost of a resource. | |||
| OVERHEAD_COST | NUMBER | Identifies the cumulative cost of an overhead. | |||
| UNIT_COST | NUMBER | 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. | |||
| EXTENDED_COST | NUMBER | 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. | |||
| QUANTITY_USAGE | NUMBER | Indicates the unscaled resource usage rate for the resource or the unscaled material quantity for the input material. | |||
| VAL_UNIT_ID | NUMBER | 18 | Uniquely identifies valuation unit. | ||
| RESOURCE_SEQ_NUMBER | NUMBER | Indicates the resource sequence for the resource under the work definition operation. | |||
| ORGANIZATION_ID | NUMBER | 18 | Identifies the Organization if to which the valuation unit belongs to. | ||
| 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_OPR | NUMBER | 18 | Represents the unique identifier of the output item of operation. | ||
| OUTPUT_INVENTORY_ORG_ID_OPR | NUMBER | 18 | The organization identifier that represents the manufacturing plant to which this operation output item belongs. | ||
| 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. It is equal to the total extended cost of the input components and input resources and the unallocated extended cost from the previous operations. | |||
| 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. | |||
| THIS_ALLOCATION_PERCENTAGE | NUMBER | Identifies the cost allocation percentage for an output item for 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. | |||
| 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. | |||
| RUNNING_EXTENDED_TOTAL | NUMBER | Captures the running total of extended cost. | |||
| 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. | ||
| OUTPUT_QUANTITY | NUMBER | Represents the quantity of the output item. | |||
| OUTPUT_UOM_CODE | VARCHAR2 | 3 | Represents the unit of measure of the output quantity. | ||
| POSTED_FLAG | VARCHAR2 | 1 | Indicates if the rolled up cost has been posted to the standard costs table for publishing. Not applicable for resource costs, component costs, or operation level costs. Possible values are N, Y, I, or X. | ||
| ROLLUP_DETAIL_SOURCE | VARCHAR2 | 20 | Indicates the source of the rollup detail record. | ||
| COST_ORG_LEVEL_COST_FLAG | VARCHAR2 | 1 | Indicates that the cost is specified at the cost organization level. Possible values are N or Y. | ||
| COST_ORG_LEVEL_COST | NUMBER | Identifies the cost of an item which is specified at the cost organization level and shared across plants. This will be populated only for items where the valuation unit is at the cost organization level. | |||
| OP_YIELD_FACTOR | NUMBER | Indicates the yield factor for the operation. Default value is 1 (100%). Used by Cost Rollup process for yield calculations. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_SCN_ROLLUP_COSTS_GT_N1 | Non Unique | SCENARIO_ID, SCENARIO_ROLLUP_HEADER_ID, CST_OPERATION_ID, OVERHEAD_RATE_ID, RESOURCE_ID, MATERIAL_INVENTORY_ITEM_ID, MATERIAL_INVENTORY_ORG_ID |