CST_PREV_COST_GT
This is a temporary table used by the perpetual cost engine to cache the Item cost for the previous set of functional attribute. This information is used during the perpetual cost averaging process in order to sequentially calculate the cost with good performance.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| COST_ORG_ID | NUMBER | 18 | Indentifies the Cost Organization. | |
| COST_BOOK_ID | NUMBER | Indentifies the Cost Book. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Indentifies the Inventory Item. | |
| VAL_UNIT_ID | NUMBER | 18 | Indentifies the Valuation Unit. | |
| COST_ELEMENT_ID | NUMBER | 18 | Indentifies the Cost Element. | |
| UNIT_COST_AVERAGE | NUMBER | Perpetual Average Cost. | ||
| PREV_COST_FLAG | VARCHAR2 | 1 | Indicates if this is a current or pervious cost for the funtional attributes. Values: Y : Previous Cost N : Current Cost | |
| CURRENCY_CODE | VARCHAR2 | 30 | Indentifies the the currency of the cost. | |
| START_DATE | DATE | Identifies the start date of the period when used within reports processor. | ||
| END_DATE | DATE | Identifies the end date of the period when used within reports processor. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_PREV_COST_GT_N1 | Non Unique | PREV_COST_FLAG, COST_ELEMENT_ID |