# 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 |  |  | This column is for Oracle Internal use only. 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, 2025, Oracle and/or its affiliates.