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