CST_AS_OF_DATE_CO_CB_GT
This temporary table contains current period information for a combination of cost organization, cost book, valuation unit and item.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| COST_ORG_ID | NUMBER | 18 | Single column FK: Identifies the Cost Organization associated with the inventory organization. | |
| COST_BOOK_ID | NUMBER | 18 | Single column FK: Identifies the Cost Book assigned to the Cost Organization. | |
| VAL_UNIT_ID | NUMBER | 18 | Identifier for the valuation unit. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Identifier for the inventory item. | |
| PERIOD_NAME | VARCHAR2 | 15 | Period for which the valuation data exist. | |
| START_DATE | DATE | This column indicates the date on which this period starts. | ||
| END_DATE | DATE | This column indicates the date on which this period ends. | ||
| PRIOR_PERIOD_NAME | VARCHAR2 | 15 | Indicates the prior period applicable for the valuation data. | |
| COST_ORG_NAME | VARCHAR2 | 240 | Denotes the translated name for the Cost Organization Unit. | |
| COST_BOOK_CODE | VARCHAR2 | 30 | A unique code given for a particular cost book. Usually named to indicate the purpose of that cost book. | |
| INVENTORY_VALUE | NUMBER | Indicates as of date inventory valuation. | ||
| PRIOR_INVENTORY_VALUE | NUMBER | Indicates the inventory valuation for the prior period. | ||
| PERIOD_ACTIVITY_VALUE | NUMBER | Indicates as of date period activity inventory value. | ||
| CURRENCY_CODE | VARCHAR2 | 30 | Identifies the currency of the cost. | |
| UOM_CODE | VARCHAR2 | 3 | Unit of measure of the quantities. | |
| UNIT_OF_MEASURE | VARCHAR2 | 25 | Translatable Unit of Measure (UOM) name. | |
| COST_METHOD_CODE | VARCHAR2 | 30 | The cost method for valuation - PERPETUAL_AVERAGE, ACTUAL, STANDARD, or PERIODIC_AVERAGE. |