CST_ROLLUP_HIERARCHY_GT
This table is used to build the hierarchy of items, resources and operations to identify the sequence in which the roll-up is to be performed based on the level where the item is used under.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| SCENARIO_ID | NUMBER | 18 | Identifies the scenario for which the rollup hierarchy is being derived. | |
| ROLLUP_HEADER_TYPE | VARCHAR2 | 30 | Identifies the rollup header type for which the rollup hierarchy is being derived. Possible values: ITEM, RESOURCE, OPERATION. | |
| ROLLUP_HEADER_KEY | NUMBER | 18 | Identifies the rollup header key for which the rollup hierarchy is being derived. | |
| INV_ORG_ID | NUMBER | 18 | Identifies the plant / inventory organization for which the rollup hierarchy is being derived. | |
| WD_OPERATION_ID | NUMBER | 18 | Identifies the manufacturing reference of operation identifier for which the rollup hierarchy is being derived. | |
| PARENT_ROLLUP_HEADER_KEY | NUMBER | 18 | Identifies the parent record of the rollup header key for which the rollup hierarchy is being derived. | |
| PARENT_ROLLUP_HEADER_TYPE | VARCHAR2 | 30 | Identifies the parent record of the rollup header type for which the rollup hierarchy is being derived. | |
| PARENT_INV_ORG_ID | NUMBER | 18 | Identifies the parent record of the plant / inventory organization for which the rollup hierarchy is being derived. | |
| PRIMARY_UOM_CODE | VARCHAR2 | 30 | Identifies the primary UOM of the rollup header key for which the rollup hierarchy is being derived. | |
| ROLLUP_ITEM_TYPE | VARCHAR2 | 30 | Identifies the rollup item type for which the rollup hierarchy is being derived. Possible values: STANDARD, CONFIGURED_ITEMS. | |
| VAL_UNIT_ID | NUMBER | 18 | Identifies the valuation unit of the item. | |
| ASSET_COST_PROFILE_ID | NUMBER | 18 | Identifies the asset cost profile of the item. | |
| COST_ORG_LEVEL_COST_FLAG | VARCHAR2 | 1 | Indicates if the valuation unit is at cost organization level. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_ROLLUP_HIERARCHY_N1 | Non Unique | ROLLUP_HEADER_KEY, ROLLUP_HEADER_TYPE, INV_ORG_ID |
| CST_ROLLUP_HIERARCHY_N2 | Non Unique | PARENT_ROLLUP_HEADER_KEY, PARENT_ROLLUP_HEADER_TYPE, INV_ORG_ID |
| CST_ROLLUP_HIERARCHY_PK | Unique | SCENARIO_ID, ROLLUP_HEADER_TYPE, ROLLUP_HEADER_KEY, INV_ORG_ID, PARENT_ROLLUP_HEADER_TYPE, PARENT_ROLLUP_HEADER_KEY |