DW_CST_INV_VALUATION_CF

This fact table contains inventory valuation with quantities at the inventory attribute level and the costs at total level

Details

Module: Cost Management

Key Columns

VALUATION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
VALUATION_ID NUMBER 38 0 True Surrogate key that identifies a row in this table.    
SOURCE_RECORD_ID VARCHAR2 32     System Identifier    
COST_BOOK_ID NUMBER 38 0   Identifies the Cost Book assigned to the Cost Organization. DW_CST_COST_ORG_BOOKS_D COST_BOOK_ID
COST_ORG_ID NUMBER 38 0   Identifies the Cost Organization associated with the inventory organization. DW_CST_COST_ORG_BOOKS_D COST_ORG_ID
EFFECTIVE_START_DATE DATE       Snapshot Start Date DW_DAY_D CALENDAR_DATE
EFFECTIVE_END_DATE DATE       Snapshot End date 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
CURRENCY_CODE VARCHAR2 32     Identifies the currency of the transaction.    
VAL_UNIT_ID NUMBER 38 0   Valuation unit identifier DW_CST_VALUATION_UNITS_D VAL_UNIT_ID
INVENTORY_ORG_ID NUMBER 38 0   Indicates The Inventory Org To Which The Item Belongs DW_INTERNAL_ORG_D ORGANIZATION_ID
INVENTORY_ITEM_ID NUMBER 38 0   Inventory Item Identifier #1 DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
SUBINVENTORY_CODE VARCHAR2 16     The subinventory code DW_INV_SUBINVENTORY_D SECONDARY_INVENTORY_NAME
SUBINVENTORY_LOCATION_ID NUMBER 38 0   This identifies the location of the subinventory DW_WORKER_LOCATION_D LOCATION_ID
LOCATOR_ID NUMBER 38 0   Inventory locator identifier DW_INV_LOCATOR_D INVENTORY_LOCATION_ID
QUANTITY_ONHAND NUMBER       Quantity Onhand for the period.    
VU_QUANTITY_ONHAND NUMBER       Total quantity at the VU level for the period    
UOM_CODE VARCHAR2 16     Unit of Measure of the quantities DW_UNIT_OF_MEASURE_D_TL UOM_CODE
GLOBAL_CURRENCY_CODE VARCHAR2 32     Analytics currency code    
GLOBAL_CURRENCY_EXCH_RATE NUMBER       Transaction to Global currency exchange rate    
AMOUNT NUMBER       Quantity onhand amount    
VU_AMOUNT NUMBER       Total amount at the VU level    
WRITEOFF_AMOUNT NUMBER       Quantity onhand amount that is in write-off instead of inventory.    
VU_WRITEOFF_AMOUNT NUMBER       Total amount that is in write-off instead of Inventory at the VU level.    
STANDARD_COST NUMBER       Standard cost, if the valuation is for standard cost method.    
VU_UNIT_COST NUMBER       Unit Cost at the VU level    
PERP_AVERAGE_COST NUMBER       Perpetual Average cost, if the valuation is for perpetual average cost method.    
ACCTD_AMOUNT NUMBER       Amount that is final accounted.    
EXCL_FROM_ACCTG_AMOUNT NUMBER       Amount that is excluded from accounting.    
GLOBAL_AMOUNT NUMBER       Global Quantity onhand amount    
GLOBAL_VU_AMOUNT NUMBER       Total global amount at the VU level    
GLOBAL_WRITEOFF_AMOUNT NUMBER       Quantity onhand global amount that is in write-off instead of inventory.    
GLOBAL_VU_WRITEOFF_AMOUNT NUMBER       Total global amount that is in write-off instead of Inventory at the VU level.    
GLOBAL_STANDARD_COST NUMBER       Global Standard cost, if the valuation is for standard cost method.    
GLOBAL_VU_UNIT_COST NUMBER       Global Unit Cost at the VU level    
GLOBAL_PERP_AVERAGE_COST NUMBER       Global Perpetual Average cost, if the valuation is for perpetual average cost method.    
GLOBAL_ACCTD_AMOUNT NUMBER       Global Amount that is final accounted.    
GLOBAL_EXCL_FROM_ACCTG_AMOUNT NUMBER       Global Amount that is excluded from accounting.    
COST_METHOD_CODE VARCHAR2 32     The cost method code. Contains values 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
LAST_UPDATE_DATE DATE       Who column: indicates the date and time of the last update of the row. DW_DAY_D CALENDAR_DATE
CREATION_DATE TIMESTAMP       Creation Date    

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 or EFFECTIVE_END_DATE columns depending on Fiscal Period is being checked for Effective_Start_Date or Effective_End_Date

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