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 |