# DW_CST_ITEM_COST_CF

This fact table contains information about Item Costing

## Details

Module: Cost Management

## Key Columns

COST_BOOK_ID, COST_ELEMENT_ID, VAL_UNIT_ID, INVENTORY_ITEM_ID, EXPENSE_POOL_ID, COST_ORG_ID, COST_LEVEL_CODE, EFFECTIVE_START_DATE

## Columns

Columns
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

## Notes

#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.