CST_STD_ITEM_COST_DETAILS_GT
This table contains the temporary data pertaining to standard item cost details populated as part of the publish process.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| COST_COMPONENT_ID | NUMBER | 18 | Yes | Identifies the cost component of the item cost detail being published. | |
| EXPENSE_POOL_ID | NUMBER | 18 | Identifies the expense pool of the item cost detail being published. This value is populated for cost components of type overhead. | ||
| COST_LEVEL_CODE | VARCHAR2 | 30 | Yes | Indicates the level from which the cost detail is applied to an item cost. Valis values are this level and lower level. | |
| COST_ELEMENT_ID | NUMBER | 18 | Indicates the cost element derived based on the cost component and the component group mapping based on the item for the item cost detail being published. | ||
| ENTERED_UNIT_COST | NUMBER | Indicates the unit cost as available fromthe source. For item costs coming from item cost plan, this would be the item cost in the item cost plan currency. For rolled up costs, this would the costs in the cost planning scenario currency. | |||
| ENTERED_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Indicates the currency code as available from the source. For item costs coming from item cost plan, this would be the item cost plan currency. For rolledup costs this would be the cost planning scenario currency. | |
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Yes | Indicates the currency conversion type used to derive the currency conversion rate. | |
| CURRENCY_CONVERSION_DATE | DATE | Yes | Indicates the currency conversion date used to derive the currency conversion rate. | ||
| CURRENCY_CONVERSION_RATE | NUMBER | Yes | Indicates the calculated currency conversion rate for converting the entered unit cost to the unit cost in the cost accounting currency based on cost organization and cost book. | ||
| UNIT_COST | NUMBER | Indicatres the calculated unit cost in cost organization, cost book currency. | |||
| STD_COST_ID | NUMBER | 18 | Yes | Identifies the standard cost identifier of the item cost detail being published. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_STD_ITEM_COST_DTL_GT_PK | Unique | STD_COST_ID, COST_COMPONENT_ID, EXPENSE_POOL_ID, COST_LEVEL_CODE |