CST_SCENARIO_ROLLUP_COSTS
This is a table with BOM details and the associated rolled up costs at each level.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: SUMMARY
Primary Key
| Name | Columns |
|---|---|
|
CST_SCN_ROLLUP_COSTS_PK |
SCENARIO_ROLLUP_COST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SCENARIO_ID | NUMBER | 18 | Yes | Unique identifier for each cost planning scenario. | |
| OP_REV_YIELD_FACTOR | NUMBER | Yes | Indicates the reverse cumulative yield factor for the operation. | ||
| DISPLAY_OP | VARCHAR2 | 1000 | Indicates the name of the Output Item. | ||
| DISPLAY_RS | VARCHAR2 | 1000 | Indicates the name of the Resource. | ||
| DISPLAY_OPR | VARCHAR2 | 1000 | Indicates the name of the Operation. | ||
| DISPLAY_IP | VARCHAR2 | 1000 | Indicates the name of the Input Item. | ||
| DISPLAY_OVERHEAD | VARCHAR2 | 1000 | Indicates the name of the Overhead. | ||
| DISPLAY_SR | VARCHAR2 | 1000 | Indicates the name of the Sourcing Rule. | ||
| ROLLUP_HEADER_KEY_OP | VARCHAR2 | 120 | Surrogate key identifying Output Item. | ||
| ROLLUP_HEADER_KEY_OPR | VARCHAR2 | 120 | Surrogate key identifying Operation. | ||
| ROLLUP_HEADER_KEY_RS | VARCHAR2 | 120 | Surrogate key identifying Resource. | ||
| ROLLUP_HEADER_KEY_IP | VARCHAR2 | 120 | Surrogate key identifying Input Item. | ||
| ROLLUP_HEADER_KEY_OVERHEAD | VARCHAR2 | 120 | Surrogate key identifying Overhead. | ||
| ROLLUP_HEADER_KEY_SR | VARCHAR2 | 120 | Surrogate key identifying Sourcing Rule. | ||
| ITEM_DESCRIPTION_OP | VARCHAR2 | 240 | Statement, picture in words, or account that describes; descriptive representation for an Output Item | ||
| ITEM_DESCRIPTION_IP | VARCHAR2 | 240 | Statement, picture in words, or account that describes; descriptive representation for an Input Item | ||
| SCENARIO_ROLLUP_COST_ID | NUMBER | 18 | Yes | Surrogate key and generated unique identifier for summarized rollup costs at each BOM level. | |
| OUTPUT_INV_ORG_ID_OPR | NUMBER | 18 | The organization identifier that represents the manufacturing plant to which this operation output item belongs. | ||
| OUTPUT_INV_ITEM_ID_OPR | NUMBER | 18 | Represents the unique identifier of the output item of a given operation. | ||
| OVERHEAD_RATE_ID | NUMBER | 18 | Indicates the source of the overhead cost when the overhead flag is 'Y'. | ||
| MATERIAL_COST_OP | NUMBER | Identifies the cumulative cost of a material for output Item level. | |||
| MATERIAL_COST_OPR | NUMBER | Identifies the cumulative cost of a material for an operation. | |||
| MATERIAL_COST_IP | NUMBER | Identifies the cumulative cost of a material for input Item level. | |||
| MATERIAL_COST_RS | NUMBER | Identifies the cumulative cost of a resource. | |||
| MATERIAL_COST_OVERHEAD | NUMBER | Identifies the cumulative cost of a material overhead. | |||
| RESOURCE_COST_OP | NUMBER | Identifies the cumulative cost of a resource at output Item level. | |||
| RESOURCE_COST_OVERHEAD | NUMBER | Identifies the cumulative cost of a resource overhead. | |||
| RESOURCE_COST_OPR | NUMBER | Identifies the cumulative cost of a resource at operation level. | |||
| MATERIAL_COST_SR | NUMBER | Identifies the cumulative cost of a material for a sourcing rule. | |||
| RESOURCE_COST_SR | NUMBER | Identifies the cumulative cost of a resource at sourcing rule level. | |||
| OVERHEAD_COST_SR | NUMBER | Identifies the cumulative cost of an overhead at sourcing rule level. | |||
| UNIT_COST_SR | 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 for a given sourcing rule. | |||
| EXTENDED_COST_SR | NUMBER | Indicates the rate x usage scaled amount or the material cost x quantity scaled amount that takes into consideration the costing batch output size and basis type, along with the material yield when applicable for sourcing rule level. | |||
| SOURCE_ID_SR | NUMBER | 18 | Indicates the cost rollup derived source identifier of the input material cost or the resource rate linked to the rollup header for a given sourcing rule. | ||
| STATUS_CODE_SR | VARCHAR2 | 30 | Indicates the status of the rollup header for a given sourcing rule. Valid values are NOT_PROCESSED, SUCCESS, CHANGED, or other message codes. | ||
| OPERATION_UNIT_COST_SR | NUMBER | Indicates the rate x usage amount or the material cost x quantity amount at sourcing rule level for a given operation. | |||
| OPERATION_EXTENDED_COST_SR | NUMBER | Indicates the rate x usage scaled amount or the material cost x quantity scaled amount at sourcing rule level for a given operation. | |||
| RUNNING_TOTAL_SR | NUMBER | Captures the running total of extended cost at operation level. | |||
| SOURCING_RULE_RANK | NUMBER | Sourcing rule rank used to determine the hierarchy in view rolled up costs UI. | |||
| RESOURCE_COST_IP | NUMBER | Identifies the cumulative cost of a resource at input item level. | |||
| RESOURCE_COST_RS | NUMBER | Identifies the cumulative cost of a resource. | |||
| OVERHEAD_COST_OPR | NUMBER | Identifies the cumulative cost of an overhead at operation level. | |||
| OVERHEAD_COST_OP | NUMBER | Identifies the cumulative cost of an overhead at output Item level. | |||
| OVERHEAD_COST_IP | NUMBER | Identifies the cumulative cost of an overhead at input item level. | |||
| OVERHEAD_COST_RS | NUMBER | Identifies the cumulative cost of an overhead at resource level. | |||
| OVERHEAD_COST_OVERHEAD | NUMBER | Identifies the cumulative cost of an overhead at overhead level. | |||
| UNIT_COST_OP | 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 for a given output item. | |||
| UNIT_COST_OPR | 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 for a given operation. | |||
| UNIT_COST_IP | 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 for a given input Item. | |||
| UNIT_COST_RS | 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 for a given resource. | |||
| UNIT_COST_OVERHEAD | 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 for a given overhead. | |||
| EXTENDED_COST_OP | NUMBER | Indicates the rate x usage scaled amount or the material cost x quantity scaled amount that takes into consideration the costing batch output size and basis type, along with the material yield when applicable for output Item level. | |||
| EXTENDED_COST_OVERHEAD | NUMBER | Indicates the rate x usage scaled amount or the material cost x quantity scaled amount that takes into consideration the costing batch output size and basis type, along with the material yield when applicable for overhead level. | |||
| EXTENDED_COST_OPR | NUMBER | Indicates the rate x usage scaled amount or the material cost x quantity scaled amount that takes into consideration the costing batch output size and basis type, along with the material yield when applicable for operation level. | |||
| EXTENDED_COST_IP | NUMBER | Indicates the rate x usage scaled amount or the material cost x quantity scaled amount that takes into consideration the costing batch output size and basis type, along with the material yield when applicable for input Item level. | |||
| EXTENDED_COST_RS | NUMBER | Indicates the rate x usage scaled amount or the material cost x quantity scaled amount that takes into consideration the costing batch output size and basis type, along with the material yield when applicable for resource level. | |||
| SOURCE_TYPE_OP | VARCHAR2 | 30 | Indicates the cost rollup derived source table linked to the rollup header for a given output item. | ||
| SOURCE_TYPE_OVERHEAD | VARCHAR2 | 30 | Indicates the cost rollup derived source table linked to the rollup header for a given overhead. | ||
| SOURCE_ID_OP | NUMBER | 18 | Indicates the cost rollup derived source identifier of the input material cost or the resource rate linked to the rollup header for a given output Item. | ||
| SOURCE_ID_OPR | NUMBER | 18 | Indicates the cost rollup derived source identifier of the input material cost or the resource rate linked to the rollup header for a given operation. | ||
| SOURCE_ID_IP | NUMBER | 18 | Indicates the cost rollup derived source identifier of the input material cost or the resource rate linked to the rollup header for a given input Item. | ||
| SOURCE_ID_RS | NUMBER | 18 | Indicates the cost rollup derived source identifier of the input material cost or the resource rate linked to the rollup header for a given resource. | ||
| SOURCE_ID_OVERHEAD | NUMBER | 18 | Indicates the cost rollup derived source identifier of the input material cost or the resource rate linked to the rollup header for a given overhead. | ||
| STATUS_CODE_OPR | VARCHAR2 | 30 | Indicates the status of the rollup header for a given operation. Valid values are NOT_PROCESSED, SUCCESS, CHANGED, or an FND message name. | ||
| STATUS_CODE_IP | VARCHAR2 | 30 | Indicates the status of the rollup header for a given input item. Valid values are NOT_PROCESSED, SUCCESS, CHANGED, or an FND message name. | ||
| STATUS_CODE_RS | VARCHAR2 | 30 | Indicates the status of the rollup header for a given resource. Valid values are NOT_PROCESSED, SUCCESS, CHANGED, or an FND message name. | ||
| STATUS_CODE_OVERHEAD | VARCHAR2 | 30 | Indicates the status of the rollup header for a given overhead. Valid values are NOT_PROCESSED, SUCCESS, CHANGED, or an FND message name. | ||
| STATUS_CODE_OP_OPR | VARCHAR2 | 30 | Indicates the status of the rollup header for Output at Operation level in process manufacturing. Valid values are NOT_PROCESSED, SUCCESS, CHANGED, or an FND message name. | ||
| STATUS_CODE_RSDL | VARCHAR2 | 30 | Indicates the status of the rollup header for Residual level in process manufacturing. Valid values are NOT_PROCESSED, SUCCESS, CHANGED, or an FND message name. | ||
| OPERATION_UNIT_COST_OP | NUMBER | Indicates the rate x usage amount or the material cost x quantity amount at an operation level for a given output item. | |||
| OPERATION_UNIT_COST_OP_OPR | NUMBER | Indicates the rate x usage amount or the material cost x quantity amount for output at operation level in process manufacturing. | |||
| OPERATION_UNIT_COST_RSDL | NUMBER | Indicates the rate x usage amount or the material cost x quantity amount at an operation level for residual level in process manufacturing. | |||
| OPERATION_UNIT_COST_OPR | NUMBER | Indicates the rate x usage amount or the material cost x quantity amount at an operation level for a given operation. | |||
| OPERATION_UNIT_COST_IP | NUMBER | Indicates the rate x usage amount or the material cost x quantity amount at an operation level for a given input item. | |||
| OPERATION_UNIT_COST_RS | NUMBER | Indicates the rate x usage amount or the material cost x quantity amount at an operation level for a given resource. | |||
| OPERATION_EXTENDED_COST_OP | NUMBER | Indicates the rate x usage scaled amount or the material cost x quantity scaled amount at an operation level for a given output Item. | |||
| OPERATION_EXTENDED_COST_OP_OPR | NUMBER | Indicates the rate x usage scaled amount or the material cost x quantity scaled amount for output at operation level in process manufacturing. | |||
| OPERATION_EXTENDED_COST_RSDL | NUMBER | Indicates the rate x usage scaled amount or the material cost x quantity scaled amount at an operation level for residual level in process manufacturing. | |||
| OPERATION_EXTENDED_COST_OPR | NUMBER | Indicates the rate x usage scaled amount or the material cost x quantity scaled amount at an operation level for a given operation. | |||
| OPERATION_EXTENDED_COST_IP | NUMBER | Indicates the rate x usage scaled amount or the material cost x quantity scaled amount at an operation level for a given input Item. | |||
| OPERATION_EXTENDED_COST_RS | NUMBER | Indicates the rate x usage scaled amount or the material cost x quantity scaled amount at an operation level for a given resource. | |||
| RUNNING_TOTAL_OPR | NUMBER | Captures the running total of extended cost at operation level. | |||
| RUNNING_TOTAL_IP | NUMBER | Captures the running total of extended cost at input item level. | |||
| RUNNING_TOTAL_RS | NUMBER | Captures the running total of extended cost at resource level. | |||
| RUNNING_TOTAL_OP_OPR | NUMBER | Captures the running total of extended cost for output at operation level in process manufacturing. | |||
| RUNNING_TOTAL_RSDL | NUMBER | Captures the running total of extended cost for residual level in process manufacturing. | |||
| COST_ALLOC_PERCENTAGE_OP_OPR | NUMBER | Identifies the cost allocation percentage for an output item for a particular operation + cost allocation percentage for an output item for a prior operation for output at operation level in process manufacturing. | |||
| COST_ALLOCATION_FIXED_OP_OPR | NUMBER | Captures the total of all the allocated unit cost for output at operation level in process manufacturing. | |||
| OUTPUT_COST_OP_OPR | NUMBER | Captures the total of all the allocated extended cost for output at operation level in process manufacturing. | |||
| OUTPUT_COST_RSDL | NUMBER | Captures the total of all the allocated extended cost for residual level in process manufacturing. | |||
| COST_ALLOCATION_SEQ_OP_OPR | NUMBER | Sequence of cost allocation for output at operation level in process manufacturing. | |||
| POSTED_FLAG_OP | VARCHAR2 | 1 | Indicates if the rolled up cost of an output item 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. | ||
| WORK_DEFINITION_ITEM_ID | NUMBER | 18 | Surrogate key and unique identifier for costing work definition items for which snapshot is to be created. | ||
| WORK_DEFINITION_ID | NUMBER | 18 | Identifies the fusion manufacturing work definition identifier from which the work definition snapshot is created. | ||
| ORGANIZATION_ID | NUMBER | 18 | Indicates the plant under which the work definition snapshot is created. | ||
| OUTPUT_INVENTORY_ITEM_ID | NUMBER | 18 | Indicates the primary output item of the work definition snapshot. | ||
| OUTPUT_INVENTORY_ORG_ID | NUMBER | 18 | Indicates the organization identifier of the primary output item of the work definition snapshot. | ||
| SCENARIO_ROLLUP_HEADER_ID | NUMBER | 18 | Indicates the surrogate identifier generated for rollup headers. | ||
| OUTPUT_ITEM_NUMBER | VARCHAR2 | 550 | Indicates the primary output item number of the work definition snapshot. | ||
| OUTPUT_ITEM_UNIT_OF_MEASURE | VARCHAR2 | 25 | Indicates the unit of measure of the output item. | ||
| WORK_DEFINITION_VERSION_ID | NUMBER | 18 | Identifies the fusion manufacturing work definition version identifier from which the work definition snapshot is created. | ||
| WORK_DEFINITION_NAME_ID | NUMBER | 18 | Indicates the name of the work definition for which the snapshot is being created for. | ||
| WORK_DEFINITION_NAME | VARCHAR2 | 150 | Indicates the name of the work definition for which the snapshot is being created for. | ||
| WORK_ORDER_ID | NUMBER | 18 | Surrogate identifying a work order uniquely in costing. | ||
| PO_LINE_LOCATION_ID | NUMBER | 18 | Indicates the unique identifier for purchase order schedule. | ||
| BILL_SEQUENCE_ID | NUMBER | 18 | Identifies the bill of material information for the standard item, when it is based on item structure instead of work definitions. | ||
| WORK_DEFINITION_TYPE | VARCHAR2 | 30 | Indicates the type of work definition for which the snapshot is being created for. | ||
| COSTING_BATCH_OUTPUT_SIZE | NUMBER | Indicates the costing batch output size for work definition for which the snapshot is created. | |||
| 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. | ||
| WORK_CENTER_CODE | VARCHAR2 | 30 | Indicates the work center code for the resource under the work definition operation. | ||
| OPERATION_SEQ_NUMBER | NUMBER | 9 | Indicates the sequence of the operation in the work definition snapshot. | ||
| OPERATION_TYPE | VARCHAR2 | 30 | Specifies the type of the operation. Valid values are contained within the ORA_WIS_OPERATION_TYPE lookup. | ||
| OPERATION_NAME | VARCHAR2 | 120 | Indicates the name of 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. | ||
| CST_MSC_SRC_RULE_ID | NUMBER | 18 | Indicates the costing identifier for the sourcing rule. | ||
| INPUT_ITEM_NUMBER | VARCHAR2 | 300 | Indicates the item number of the material used in the work definition operation. | ||
| RESOURCE_SEQ_NUMBER | NUMBER | Indicates the resource sequence for the resource under the work definition operation. | |||
| RESOURCE_ID | NUMBER | 18 | Indicates the resource used for the work definition operation. | ||
| RESOURCE_NAME | VARCHAR2 | 120 | Indicates the resource name used for the work definition operation. | ||
| QUANTITY | NUMBER | Indicates the quantity of the material for the work definition. | |||
| QUANTITY_OP_OPR | NUMBER | Indicates the quantity of the material for the work definition for output at operation level in process manufacturing. | |||
| UOM_CODE | VARCHAR2 | 3 | Represents the unit of measure of a scenario. | ||
| UOM_CONVERSION_FACTOR | NUMBER | Represents the unit of measure conversion factor. | |||
| BASIS_TYPE | VARCHAR2 | 30 | Indicates whether the item quantity is fixed (e.g., quantity per lot produced) or variable (e.g., quantity per item produced). | ||
| UNIT_OF_MEASURE | VARCHAR2 | 25 | Represents the unit of measure of a scenario. | ||
| OUTPUT_ITEM_RANK | NUMBER | Output Item rank used to determine the hierarchy in view rolled up costs UI. | |||
| OPERATION_RANK | NUMBER | Operation rank used to determine the hierarchy in view rolled up costs UI. | |||
| INPUT_ITEM_RANK | NUMBER | Input Item rank used to determine the hierarchy in view rolled up costs UI. | |||
| RESOURCE_RANK | NUMBER | Resource rank used to determine the hierarchy in view rolled up costs UI. | |||
| ASSET_VAL_UNIT_ID | NUMBER | 18 | Indicates the asset valuation unit reference generated / derived for the item and plant combination. | ||
| WORK_METHOD_CODE | VARCHAR2 | 30 | A code that represents the user key to the work method. | ||
| WORK_METHOD_NAME | VARCHAR2 | 120 | Indicates the name of the work method. | ||
| OUTPUT_TYPE | VARCHAR2 | 30 | Type of output produced by the operation. Valid values exist in the lookup with lookup type = ORA_WIS_WD_OUTPUT_MATERIAL. | ||
| WORK_DEFINITION_HEADER_NAME | VARCHAR2 | 120 | Represents the work definition name assigned to this work definition which is a foreign key to the WIS_WORK_DEFINITION_NAMES_B table. | ||
| OUTPUT_ITEM | VARCHAR2 | 300 | Indicates item number of output item. | ||
| BATCH_QUANTITY | NUMBER | Represents the quantity produced for the work definition. In process manufacturing, this is the batch quantity. | |||
| BATCH_QTY_UOM | VARCHAR2 | 3 | Represents the unit of measure code of the batch quantity. | ||
| OUTPUT_STATUS_CODE | VARCHAR2 | 30 | Indicates the status of the work definition operation output. | ||
| OUTPUT_QUANTITY | NUMBER | Represents the output quantity expected to be produced at this operation. | |||
| HEADER_STATUS_CODE | VARCHAR2 | 30 | Indicates the status of the rollup header. Valid values are NOT_PROCESSED, SUCCESS, CHANGED, or an FND message name. | ||
| 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. | ||
| OVERHEAD_RATE_DETAILS | VARCHAR2 | 750 | Indicates the category, item number, work center and the type of resource associated to the overhead. | ||
| ABSORPTION_TYPE | VARCHAR2 | 30 | Identifies the absorption type of the overhead rate details. | ||
| SUPPLY_CHAIN_ROLLUP_FLAG | VARCHAR2 | 1 | Indicates whether the scenario is enabled for Supply Chain Cost Rollup. | ||
| PLANT_ORG_NAME | VARCHAR2 | 240 | Name of the inventory organization where the work definition of the item is setup. | ||
| SOURCING_RULE_TYPE | NUMBER | 1 | Indicates the source type of the sourcing rule: 1 - Transfer from, 2 - Make at, 3 - Buy from. Lookup type is MSC_SOURCING_SOURCE_TYPE. | ||
| 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. | ||
| CURRENCY_CODE | VARCHAR2 | 60 | Indicates the currency code in which the cost is stored. | ||
| OVERHEAD_RATE | VARCHAR2 | 40 | Indicates the unit rate of overhead that was applied by rollup. | ||
| STD_TXFR_COST_RULE_ID | NUMBER | 18 | Indicates the key that uniquely identifies transfer cost rule for cost rollup. | ||
| SOURCING_RULE_NAME | VARCHAR2 | 80 | This value indicates sourcing rule name. | ||
| RULE_RANK | NUMBER | This value indicates the Rank of the sourcing rule. | |||
| RULE_TYPE | VARCHAR2 | 80 | Identifies the type of the sourcing rule. Possible values are - Buy from, Make at and Transfer from. | ||
| PARTNER_NAME | VARCHAR2 | 360 | This column indicates the supplier's name for buy type sourcing rules. | ||
| PARTNER_SITE_NAME | VARCHAR2 | 50 | This column indicates the supplier site identifier for buy type sourcing rules. | ||
| SOURCE_INV_ORG_ID | NUMBER | 18 | This value indicates the source organization identifier. | ||
| SOURCE_ORG | VARCHAR2 | 260 | This value indicates the name of the source organization. | ||
| ALLOCATION_PERCENT | NUMBER | Percent of supply allocated to this source. | |||
| TRANSFER_CHARGE_RULE_NAME | VARCHAR2 | 200 | Indicates the name for transfer type sourcing rules. | ||
| EXTRACTION_DATE | DATE | Indicates the date of creation of the sourcing rule. | |||
| ENTERED_UNIT_COST | NUMBER | Identifies the manually entered unit cost. This can be - buy or standard cost of a component, resource rate or fixed output costs. | |||
| ALLOCATED_MATERIAL_COST_SR | NUMBER | Identifies the allocated cost of a material at sourcing rule level. | |||
| ALLOCATED_RESOURCE_COST_SR | NUMBER | Identifies the allocated cost of a resource at sourcing rule level. | |||
| ALLOCATED_OVERHEAD_COST_SR | NUMBER | Identifies the allocated cost of an overhead at sourcing rule level. | |||
| ALLOCATED_EXTENDED_COST_SR | NUMBER | Indicates the allocated rate x usage scaled amount or the allocated material cost x quantity scaled amount that takes into consideration the costing batch output size and basis type, along with the material yield when applicable for sourcing rule level. | |||
| ALLOCATED_UNIT_COST_SR | NUMBER | Indicates the allocated average per output amount calculated as ALLOCATED_EXTENDED_COST/COSTING_BATCH_OUTPUT_SIZE and is the amount used for rolling up to the next level for a given sourcing rule. | |||
| COST_UOM_CODE | VARCHAR2 | 3 | Indicates the Costing unit of measure. | ||
| COST_UNIT_OF_MEASURE | VARCHAR2 | 25 | Indicates the costing unit of measure (UOM). | ||
| COST_UOM_CONVERSION_FACTOR | NUMBER | Indicates the conversion factor for converting from the Primary UOM to the Costing UOM. | |||
| COSTING_QUANTITY | NUMBER | Represents the quantity in costing. | |||
| 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 | Yes | Indicates the yield factor for the operation. Default value is 1 (100%). Used by Cost Rollup process for yield calculations. | ||
| COST_UOM_CODE_IP | VARCHAR2 | 3 | Indicates the Costing unit of measure code of an input component. | ||
| COST_UNIT_OF_MEASURE_IP | VARCHAR2 | 25 | Indicates the costing unit of measure of an input component. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_SCN_ROLLUP_COSTS_N1 | Non Unique | Default | SCENARIO_ID, OUTPUT_ITEM_RANK, SCENARIO_ROLLUP_HEADER_ID |
| CST_SCN_ROLLUP_COSTS_N10 | Non Unique | Default | SCENARIO_ID, ROLLUP_HEADER_KEY_OPR, RESOURCE_RANK |
| CST_SCN_ROLLUP_COSTS_N11 | Non Unique | Default | SCENARIO_ID, ROLLUP_HEADER_KEY_OP, SOURCING_RULE_RANK |
| CST_SCN_ROLLUP_COSTS_N12 | Non Unique | Default | SCENARIO_ID, ROLLUP_HEADER_KEY_OP, OUTPUT_ITEM_RANK |
| CST_SCN_ROLLUP_COSTS_N13 | Non Unique | Default | SCENARIO_ID, ROLLUP_HEADER_KEY_SR, OUTPUT_ITEM_RANK |
| CST_SCN_ROLLUP_COSTS_N2 | Non Unique | Default | SCENARIO_ID, OPERATION_RANK, SCENARIO_ROLLUP_HEADER_ID, CST_OPERATION_ID |
| CST_SCN_ROLLUP_COSTS_N3 | Non Unique | Default | SCENARIO_ID, INPUT_ITEM_RANK, SCENARIO_ROLLUP_HEADER_ID, CST_OPERATION_ID, MATERIAL_INVENTORY_ITEM_ID, ORGANIZATION_ID, BASIS_TYPE |
| CST_SCN_ROLLUP_COSTS_N4 | Non Unique | Default | SCENARIO_ID, RESOURCE_RANK, RESOURCE_ID, SCENARIO_ROLLUP_HEADER_ID, CST_OPERATION_ID |
| CST_SCN_ROLLUP_COSTS_N5 | Non Unique | Default | SCENARIO_ID, OPERATION_RANK, WORK_METHOD_CODE, WORK_DEFINITION_ITEM_ID, CST_OPERATION_ID, SCENARIO_ROLLUP_HEADER_ID |
| CST_SCN_ROLLUP_COSTS_N6 | Non Unique | Default | SCENARIO_ID, OUTPUT_ITEM_RANK, WORK_METHOD_CODE, SCENARIO_ROLLUP_HEADER_ID, OUTPUT_INV_ITEM_ID_OPR, OUTPUT_INV_ORG_ID_OPR |
| CST_SCN_ROLLUP_COSTS_N7 | Non Unique | Default | SCENARIO_ID, ROLLUP_HEADER_KEY_OP, OPERATION_RANK |
| CST_SCN_ROLLUP_COSTS_N8 | Non Unique | Default | SCENARIO_ID, ROLLUP_HEADER_KEY_SR, OPERATION_RANK |
| CST_SCN_ROLLUP_COSTS_N9 | Non Unique | Default | SCENARIO_ID, ROLLUP_HEADER_KEY_OPR, INPUT_ITEM_RANK |
| CST_SCN_ROLLUP_COSTS_U1 | Unique | Default | SCENARIO_ROLLUP_COST_ID |