CST_SCENARIO_ROLLUP_HEADERS
This table contains the results of the rollup process for input components, resources, operations, sub-assemblies and output items.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CST_SCN_ROLLUP_HEADERS_PK |
SCENARIO_ROLLUP_HEADER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SCENARIO_ROLLUP_HEADER_ID | NUMBER | 18 | Yes | Indicates the surrogate identifier generated for rollup headers. | |
| SCENARIO_ID | NUMBER | 18 | Yes | Indicates the scenario from which the rollup header records were created. | |
| INV_ORG_ID | NUMBER | 18 | Yes | Indicates the inventory organization information for which the rollup header is created. | |
| ROLLUP_HEADER_TYPE | VARCHAR2 | 30 | Yes | Indicates the type of rollup header. Valid values are ITEM, RESOURCE, and OPERATION. | |
| ROLLUP_HEADER_KEY | NUMBER | 18 | Yes | Indicates the identifier of the rollup header type. Valid values are the item identifier, the resource identifier, or the work definition operation identifier. | |
| ROLLUP_HEADER_LEVEL | NUMBER | 9 | Yes | Indicates the level at which the cost rollup should pick up the rollup header for processing. A value of 1 indicates a top level assembly, values greater than 1 indicate the lower level operations and subassemblies, and a value of 0 indicates a resource or input material. | |
| SCENARIO_EVENT_ID | NUMBER | 18 | Yes | Indicates the scenario event from which the rollup header records were created. | |
| 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. | ||
| STATUS_CODE | VARCHAR2 | 30 | Yes | Indicates the status of the rollup header. Valid values are NOT_PROCESSED, SUCCESS, CHANGED, or an FND message name. | |
| 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. | ||
| COST_UOM_CODE | VARCHAR2 | 3 | Indicates the Costing unit of measure. | ||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | Indicates the primary unit of measure. | ||
| COST_UOM_CONVERSION_FACTOR | NUMBER | Indicates the conversion factor for converting from the Primary UOM to the Costing UOM. | |||
| 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. | ||
| COST_ORG_LEVEL_COST_FLAG | VARCHAR2 | 1 | Indicates that the cost is specified at the cost organization level and shared across plants. Possible values are N or Y. | ||
| 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. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| CURRENCY_CONVERSION_RATE | NUMBER | OBSOLETE: Indicates the currency conversion factor to be used for converting the costs coming from the item cost plan and resource rate plan to the scenario currency. | |||
| PUBLISHED_FLAG | VARCHAR2 | 1 | OBSOLETE: Indicates the record has been published to the cost accounting domain. Possible values are Y, N, or X. | ||
| ROLLUP_ITEM_TYPE | VARCHAR2 | 30 | Indicates whether the item being rolled up is (1) Standard (2) Purchased CTO (3) Manufactured CTO. | ||
| COST_UOM_CONVERSION_FLAG | VARCHAR2 | 1 | Indicates the rollup detail record has been converted from the Primary UOM to the Costing UOM. Possible values are Y, N, or null. | ||
| CURRENCY_CODE | VARCHAR2 | 60 | Indicates the currency code in which the cost is stored. | ||
| VAL_UNIT_ID | NUMBER | 18 | Unique identifier for valuation unit. | ||
| ASSET_COST_PROFILE_ID | NUMBER | 18 | Unique identifier for the asset cost profile. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CST_SCENARIO_ROLLUP_HEADERS | cst_scenarios | SCENARIO_ID |
| cst_scenario_rollup_details | cst_scenario_rollup_headers | SCENARIO_ROLLUP_HEADER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_SCN_ROLLUP_HEADERS_PK | Unique | FUSION_TS_TX_DATA | SCENARIO_ROLLUP_HEADER_ID |
| CST_SCN_ROLLUP_HEADERS_U1 | Unique | FUSION_TS_TX_DATA | SCENARIO_ID, INV_ORG_ID, ROLLUP_HEADER_TYPE, ROLLUP_HEADER_KEY |