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, COST_DATE, INVENTORY_ITEM_ID

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     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, 2023, Oracle and/or its affiliates.