CST_ROLLUP_REPORTS
This is a table used for storing all the data for Cost Rollup Details OTBI Report 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_ROLLUP_REPORTS_PK |
ROLLUP_REPORT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ROLLUP_REPORT_ID | NUMBER | 18 | Yes | Surrogate key and generated unique identifier for summarized rollup costs at each BOM level. | |
| OP_REV_YIELD_FACTOR | NUMBER | Indicates the reverse cumulative yield factor for the operation. | |||
| OP_YIELD_FACTOR | NUMBER | Indicates the yield factor for the operation. Default value is 1 (100%). | |||
| SCENARIO_ID | NUMBER | 18 | Yes | Unique identifier for each cost planning scenario. | |
| EFFECTIVE_START_DATE | DATE | Yes | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. | ||
| ROOT_ASSEMBLY_ITEM_ID | NUMBER | Indicates the root assembly output item of the work definition snapshot. | |||
| ROOT_ASSEMBLY_ORG_ID | NUMBER | Indicates the organization identifier of the root assembly output item of the work definition snapshot. | |||
| ASSEMBLY_ITEM_ID | NUMBER | Indicates the assembly output item of the work definition snapshot. | |||
| ASSEMBLY_ORG_ID | NUMBER | Indicates the organization identifier of the assembly output item of the work definition snapshot. | |||
| DISPLAY_NAME | VARCHAR2 | 4000 | Indicates the name of the output item, or resource, or operation, or input item, or overhead, or sourcing rule. | ||
| ROLLUP_HEADER_KEY | VARCHAR2 | 120 | Unique identifier for each rollup header. | ||
| ROLLUP_HEADER_TYPE | VARCHAR2 | 30 | Indicates the rollup header type. Valid values are ITEM, SOURCING_RULE, OPERATION, OVERHEAD, RESOURCE, OUTPUT_ITEM, or RESIDUAL. | ||
| PARENT_ROLLUP_HEADER_KEY | VARCHAR2 | 120 | Unique identifier for each parent rollup header. | ||
| PARENT_ROLLUP_HEADER_TYPE | VARCHAR2 | 30 | Indicates the parent rollup header type. Valid values are ITEM, SOURCING_RULE, OPERATION, OVERHEAD, RESOURCE, OUTPUT_ITEM, or RESIDUAL. | ||
| STATUS_CODE | VARCHAR2 | 30 | Indicates the status of the rollup header. Valid values are NOT_PROCESSED, SUCCESS, CHANGED, or other message codes. | ||
| CURRENCY_CODE | VARCHAR2 | 80 | Indicates currency code for costs. | ||
| 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 a material 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 x usage scaled amount or the material cost x quantity scaled amount that takes into consideration the costing batch output size and basis type. | |||
| COST_ALLOCATION_PERCENTAGE | 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 | NUMBER | Captures the total of all the allocated unit cost for output at operation level in process manufacturing. | |||
| OUTPUT_COST | NUMBER | Captures the total of all the allocated extended cost for output in process manufacturing. | |||
| SUPPLIER_ID | NUMBER | 18 | Identifies the supplier reference of the outside processing operation. | ||
| SUPPLIER_SITE_ID | NUMBER | 18 | Identifies the supplier site reference of the outside processing operation. | ||
| SUPPLY_ALLOCATION | NUMBER | Percent of supply allocated to this source. | |||
| EXTRACTION_DATE | DATE | Indicates the date and time of the creation of the sourcing rule. | |||
| REFERENCE_TYPE | VARCHAR2 | 80 | Indicates the references type. Valid values are PURCHASE_ORDER, WORK_ORDER, ITEM_STRUCTURE, or WORK_DEFINITION. | ||
| 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_DEFINITION_ID | NUMBER | 18 | Identifies the fusion manufacturing work definition identifier from which the work definition snapshot is created. | ||
| WORK_DEFINITION_NAME_ID | NUMBER | Indicates the name of the work definition for which the snapshot is being created for. | |||
| 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. | ||
| COSTING_BATCH_OUTPUT_SIZE | NUMBER | Indicates the costing batch output size for work definition. | |||
| OPERATION_SEQ_NUMBER | NUMBER | Indicates the sequence of the operation in the work definition snapshot. | |||
| OUTPUT_QUANTITY | NUMBER | Represents the output quantity expected to be produced. | |||
| UNIT_OF_MEASURE | VARCHAR2 | 120 | Indicates the unit of measure of the output. | ||
| 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). | ||
| ABSORPTION_TYPE | VARCHAR2 | 30 | Identifies the absorption type of the overhead rate details. | ||
| OVERHEAD_RATE | VARCHAR2 | 40 | Indicates the unit rate of overhead that was applied by rollup. | ||
| OVERHEAD_RATE_DETAILS | VARCHAR2 | 750 | Indicates the overhead rate details. | ||
| 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. | ||
| 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 | NUMBER | Identifies the allocated cost of a material. | |||
| ALLOCATED_RESOURCE_COST | NUMBER | Identifies the allocated cost of a resource. | |||
| ALLOCATED_OVERHEAD_COST | NUMBER | Identifies the allocated cost of an overhead. | |||
| ALLOCATED_EXTENDED_COST | 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, | |||
| ALLOCATED_UNIT_COST | NUMBER | Captures the unit cost allocated for a particular output item based on the cost allocation percentage. It is calculated by applying the cost allocation percentage on the sum of current operation unit cost and previous unit unallocated costs. | |||
| 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. | |||
| ALLOCATED_MATERIAL_COST_SR | NUMBER | Identifies the allocated cost of a material at sourcing rule level. | |||
| ALLOCATED_OVERHEAD_COST_SR | NUMBER | Identifies the allocated cost of an overhead at sourcing rule level. | |||
| ALLOCATED_RESOURCE_COST_SR | NUMBER | Identifies the allocated cost of a resource at sourcing rule level. | |||
| COST_ALLOCATION_SEQ | NUMBER | Sequence of cost allocation for output at operation level in process manufacturing. | |||
| OUTPUT_SEQ_NUMBER | NUMBER | Indicates the sequence of this output line. | |||
| RUNNING_TOTAL | NUMBER | Captures the running total of extended 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. | |||
| RESOURCE_SEQ_NUMBER | NUMBER | Indicates the resource sequence for the resource under the work definition operation. | |||
| COST_BOOK_ID | NUMBER | 18 | Indicates the accounting cost book to which the results of the cost rollup would be associated to. | ||
| COST_ORG_ID | NUMBER | 18 | Indicates the accounting cost organization to which the results of the cost rollup would be associated to. | ||
| COST_ELEMENT_ID | NUMBER | 18 | Identifies the cost element of the standard cost detail. | ||
| EXPENSE_POOL_ID | NUMBER | 18 | Indicates the expense pool for the standard cost detail. It is populated for cost details with the cost component type as "Overhead". For other cost component types, this attribute is not populated. | ||
| QUANTITY | NUMBER | Indicates the quantity of the material for the work definition. | |||
| QTY_UOM_CODE | VARCHAR2 | 3 | Indicates the unit of measure of the quantity usage. | ||
| COST_UOM_CODE | VARCHAR2 | 3 | Indicates the Costing unit of measure. | ||
| OVERHEAD_RATE_DETAIL_ID | NUMBER | 18 | Indicates the source of the overhead cost when the overhead flag is 'Y'. | ||
| WORK_METHOD_CODE | VARCHAR2 | 30 | A code that represents the user key to the work method. | ||
| CST_MSC_SOURCE_RULE_ID | NUMBER | 18 | Indicates the costing identifier for the sourcing rule. | ||
| 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. | |||
| VAL_UNIT_ID | NUMBER | 18 | Unique identifier for valuation unit. | ||
| RESOURCE_ID | NUMBER | 18 | Indicates the resource used for the work definition operation. | ||
| YIELD_FACTOR | NUMBER | Indicates the percentage of material quantity incorporated into the finished good. | |||
| 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. | ||
| ORGANIZATION_ID | NUMBER | 18 | Indicates the plant under which the work definition snapshot is created. | ||
| 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. | ||
| SOURCE_TYPE | VARCHAR2 | 30 | Indicates the cost rollup derived source table linked to the rollup header. | ||
| COST_ORG_LEVEL_COST_FLAG | VARCHAR2 | 1 | Indicates that the cost is specified at the cost organization level. Possible values are N or Y. | ||
| 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. | |||
| ITEM_DESCRIPTION | VARCHAR2 | 240 | Indicates the output or input item description. | ||
| TRANSFER_CHARGE_RULE_NAME | VARCHAR2 | 200 | This value indicates transfer charge rule name. | ||
| PLANT_ORG_NAME | VARCHAR2 | 240 | Denotes the name for the organization unit. | ||
| WORK_METHOD_NAME | VARCHAR2 | 120 | Indicates the name of the work method. | ||
| 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. | ||
| WORK_DEFINITION_NAME | VARCHAR2 | 150 | Indicates the name of the work definition for which the snapshot is being created for. | ||
| 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. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_ROLLUP_REPORTS_N1 | Non Unique | Default | EFFECTIVE_START_DATE, SCENARIO_ID, ROLLUP_REPORT_ID |
| CST_ROLLUP_REPORTS_U1 | Unique | Default | ROLLUP_REPORT_ID |