This fact table contains information about Item Costing
Module: Cost Management
COST_BOOK_ID, COST_ELEMENT_ID, INVENTORY_ITEM_ID, EFFECTIVE_START_DATE, COST_LEVEL_CODE, VAL_UNIT_ID, COST_ORG_ID, EXPENSE_POOL_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| COST_ORG_ID | NUMBER | 38 | 0 | True | Cost Org identifier | DW_CST_COST_ORG_BOOKS_D | COST_ORG_ID |
| COST_BOOK_ID | NUMBER | 38 | 0 | True | Cost Book identifier | DW_CST_COST_ORG_BOOKS_D | COST_BOOK_ID |
| INVENTORY_ITEM_ID | NUMBER | 38 | 0 | True | Inventory Item Identifier #1 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID |
| VAL_UNIT_ID | NUMBER | 38 | 0 | True | Valuation Unit Identifier | DW_CST_VALUATION_UNITS_D | VAL_UNIT_ID |
| COST_ELEMENT_ID | NUMBER | 38 | 0 | True | Cost element corresponding to the cost of the transaction. | DW_CST_COST_ELEMENTS_D | COST_ELEMENT_ID |
| EXPENSE_POOL_ID | NUMBER | 38 | 0 | True | Identifies the expense pool for which this cost is created. | DW_CST_EXPENSE_POOLS_D | EXPENSE_POOL_ID |
| COST_LEVEL_CODE | VARCHAR2 | 32 | True | Indicates the level of the standard cost detail. Options are This Level Cost and Lower Level Cost. | DW_ORA_CST_STD_COST_LEVEL_LKP_TL | ORA_CST_STD_COST_LEVEL_CODE | |
| EFFECTIVE_START_DATE | DATE | True | Indicates the date at the beginning of the date range within which the row is effective | DW_DAY_D | CALENDAR_DATE | ||
| SOURCE_RECORD_ID | VARCHAR2 | 512 | This column is for Oracle Internal use only. System Identifier | ||||
| EFFECTIVE_END_DATE | DATE | Indicates the date at the end of the date range within which the row is effective | DW_DAY_D | CALENDAR_DATE | |||
| LEGAL_ENTITY_ID | NUMBER | 38 | 0 | Legal entity Identifier | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID | |
| COST_ORG_BOOK_LEDGER_ID | NUMBER | 38 | 0 | This is the unique Ledger corresponding to the cost organization and cost book. It can be Primary, Secondary or any other Ledger defined in Financial setups. A Null value indicates Ledger-less cost organization and cost book entity, which may be used for costing simulations. | DW_LEDGER_D | LEDGER_ID | |
| SCENARIO_ID | NUMBER | 38 | 0 | Scenario Identifier | DW_CST_SCENARIOS_D | SCENARIO_ID | |
| INVENTORY_ORG_ID | NUMBER | 38 | 0 | Identifies the master organization of the item for which the standard cost is entered | |||
| COST_PROFILE_ID | NUMBER | 38 | 0 | Cost Profile Identifier | DW_CST_COST_PROFILES_D | COST_PROFILE_ID | |
| CURRENCY_CODE | VARCHAR2 | 16 | Indicates the currency code in which the cost is entered | ||||
| GLOBAL_CURRENCY_CODE | VARCHAR2 | 32 | Analytics currency code | ||||
| GLOBAL_CURRENCY_EXCH_RATE | NUMBER | Transaction to Global currency exchange rate | |||||
| UNIT_COST | NUMBER | Indicates the unit cost in transaction/document currency | |||||
| GLOBAL_UNIT_COST | NUMBER | Indicates the unit cost in global/analytical currency | |||||
| COST_METHOD_CODE | VARCHAR2 | 32 | The cost method code. Possible values are PERPETUAL AVERAGE,STANDARD and ACTUAL. | DW_CST_COST_METHODS_LKP_TL | CST_COST_METHODS_CODE | ||
| FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | Fiscal Period Set Name #2 | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME | ||
| FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | Period type. Examples are Weekly, Monthly, Quarterly #2 | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE | ||
| UOM_CODE | VARCHAR2 | 32 | Unit of Measure | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
| PUBLISHED_FLAG | VARCHAR2 | 16 | Denotes whether cost is published or unpublished | DW_YN_LKP_TL | YN_LKP_CODE | ||
| USED_FLAG | VARCHAR2 | 16 | Denotes whether cost is used or not | DW_YN_LKP_TL | YN_LKP_CODE |
#1 In these cases in addition to the item columns INVENTORY_ORG_ID column should also be used for join with DW_INVENTORY_ITEM_D
#2 In these cases to join with DW_FISCAL_DAY_D apart from FISCAL_PERIOD_TYPE and FISCAL_PERIOD_SET_NAME the relationship should be based on EFFECTIVE_START_DATE column
Copyright © 2019, 2025, Oracle and/or its affiliates.