CST_CSRH_AVG_COST_DTL_GT
This table stores the average cost of an item, valuation unit across plants that share the same cost organization.
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 average cost of item will be computed. | |
ROLLUP_HEADER_KEY | NUMBER | 18 | Indicates the item for which the average cost will be computed. | |
VAL_UNIT_ID | NUMBER | 18 | Indicates the valuation unit of the item. | |
ROLLUP_HEADER_TYPE | VARCHAR2 | 30 | Indicates the type of rollup header. | |
COST_ELEMENT_ID | NUMBER | 18 | Indicates the cost element for which average cost is computed. | |
EXPENSE_POOL_ID | NUMBER | 18 | Indicates the expense pool of the item cost. | |
AVG_UNIT_COST | NUMBER | Indicates the average unit cost computed for items that share costs. | ||
AVG_EXTENDED_COST | NUMBER | Indicates the average extended cost computed for items that share costs. | ||
STD_TXFR_COST_RULE_ID | NUMBER | 18 | Unique identifier for the transfer rule transfer charge percentage. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
CST_CSRH_AVG_COST_DTL_GT_U1 | Unique | SCENARIO_ID, ROLLUP_HEADER_KEY, VAL_UNIT_ID, COST_ELEMENT_ID, EXPENSE_POOL_ID, STD_TXFR_COST_RULE_ID |