This fact table contains inventory valuation with quantities at the inventory attribute level and the costs at total level
Module: Cost Management
VALUATION_ID
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 |
#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, 2024, Oracle and/or its affiliates.