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
Module: Cost Management
INV_ORG_ID, COST_DATE, INVENTORY_ITEM_ID
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 |
#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.