# DW_CST_ITEM_COST_INV_ORG_CF (Preview)

This table requires activation of Inventory Organisation Item Costs functional area. This fact table to store average cost for each day at inventory org level for an item and organization

## Details

Module: Cost Management

## Key Columns

INV_ORG_ID, INVENTORY_ITEM_ID, COST_DATE

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
INVENTORY_ITEM_ID | NUMBER | 38 | 0 | True | Inventory Item Identifier #1 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
INV_ORG_ID | NUMBER | 38 | 0 | True | Inventory Org identifier | DW_INTERNAL_ORG_D | ORGANIZATION_ID
COST_DATE | DATE |  |  | True | Costing date | DW_DAY_D | CALENDAR_DATE
SOURCE_RECORD_ID | VARCHAR2 | 512 |  |  | This column is for Oracle Internal use only. System Identifier |  |
COST_ORG_ID | NUMBER | 38 | 0 |  | Cost Org identifier | DW_CST_COST_ORG_BOOKS_D | COST_ORG_ID
COST_BOOK_ID | NUMBER | 38 | 0 |  | Primary Cost Book identifier | DW_CST_COST_ORG_BOOKS_D | COST_BOOK_ID
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
ITEM_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 |  |  | Cost Book Ledger Currency |  |
GLOBAL_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Analytics currency code |  |
GLOBAL_CURRENCY_EXCH_RATE | NUMBER |  |  |  | Cost Book Ledger Currency to Global currency exchange rate |  |
UNIT_COST | NUMBER |  |  |  | Indicates the unit cost in primary cost book ledger currency for costing UOM |  |
GLOBAL_UNIT_COST | NUMBER |  |  |  | Indicates the unit cost in global currency for costing UOM |  |
COST_METHOD_CODE | VARCHAR2 | 32 |  |  | The cost method code. Possible values are PERPETUAL AVERAGE,STANDARD ad 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 |  |  | Costing UOM | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
PUOM_CODE | VARCHAR2 | 16 |  |  | Item Primary UOM | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
PUOM_CONVERSION_FACTOR | NUMBER |  |  |  | UOM conversion factor from Costing UOM to Primary UOM |  |
GLOBAL_PUOM_UNIT_COST | NUMBER |  |  |  | Indicates the unit cost in global currency for primary UOM |  |
INVENTORY_ORG_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Reference to Business Unit ID of Inventory Org | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
PROFIT_CENTER_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Identifies the Profit Center Business Unit associated to the Cost Organization. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID

## Notes

#1 In these cases in addition to the item columns ITEM_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 COST_DATE column

Copyright © 2019, 2025, Oracle and/or its affiliates.