CST_CSRH_LEVEL_INFO_GT
This table stores the level information for items that have costs maintained at cost organization level.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| SCENARIO_ID | NUMBER | 18 | Indicates the scenario for which the rollup header level information is stored. | |
| ROLLUP_HEADER_KEY | NUMBER | 18 | Indicates the item for which the level information is stored. | |
| VAL_UNIT_ID | NUMBER | 18 | Indicates the valuation unit of the item. | |
| ROLLUP_HEADER_TYPE | VARCHAR2 | 30 | Indicates the type of rollup header. | |
| MIN_ROLLUP_HEADER_LEVEL | NUMBER | 9 | Indicates the minimum rollup level for the combination of item and valuation unit in a scenario. | |
| MAX_ROLLUP_HEADER_LEVEL | NUMBER | 9 | Indicates the maximum rollup level for the combination of item and valuation unit in a scenario. | |
| COUNT_OCCURRENCES | NUMBER | 9 | Indicates the number of times the item that share the valuation unit occurs in a scenario. | |
| SCENARIO_ROLLUP_HEADER_ID | NUMBER | 18 | Identifies the scenario rollup header record with the lowest level. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_CSRH_LEVEL_INFO_GT_U1 | Unique | SCENARIO_ID, ROLLUP_HEADER_KEY, VAL_UNIT_ID |