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 |