DW_CST_ITEM_COST_CF

This fact table contains information about Item Costing

Details

Module: Cost Management

Key Columns

COST_ORG_ID, COST_BOOK_ID, COST_ELEMENT_ID, EXPENSE_POOL_ID, COST_LEVEL_CODE, INVENTORY_ITEM_ID, VAL_UNIT_ID, EFFECTIVE_START_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
COST_ORG_ID NUMBER 38 0 True Cost Org identifier DW_CST_COST_ORG_BOOKS_D COST_ORG_ID
COST_BOOK_ID NUMBER 38 0 True Cost Book identifier DW_CST_COST_ORG_BOOKS_D COST_BOOK_ID
INVENTORY_ITEM_ID NUMBER 38 0 True Inventory Item Identifier #1 DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
VAL_UNIT_ID NUMBER 38 0 True Valuation Unit Identifier DW_CST_VALUATION_UNITS_D VAL_UNIT_ID
COST_ELEMENT_ID NUMBER 38 0 True Cost element corresponding to the cost of the transaction. DW_CST_COST_ELEMENTS_D COST_ELEMENT_ID
EXPENSE_POOL_ID NUMBER 38 0 True Identifies the expense pool for which this cost is created. DW_CST_EXPENSE_POOLS_D EXPENSE_POOL_ID
COST_LEVEL_CODE VARCHAR2 32   True Indicates the level of the standard cost detail. Options are This Level Cost and Lower Level Cost. DW_ORA_CST_STD_COST_LEVEL_LKP_TL ORA_CST_STD_COST_LEVEL_CODE
EFFECTIVE_START_DATE DATE     True Indicates the date at the beginning of the date range within which the row is effective DW_DAY_D CALENDAR_DATE
SOURCE_RECORD_ID VARCHAR2 512     This column is for Oracle Internal use only. System Identifier    
EFFECTIVE_END_DATE DATE       Indicates the date at the end of the date range within which the row is effective 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
SCENARIO_ID NUMBER 38 0   Scenario Identifier DW_CST_SCENARIOS_D SCENARIO_ID
INVENTORY_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     Indicates the currency code in which the cost is entered    
GLOBAL_CURRENCY_CODE VARCHAR2 32     Analytics currency code    
GLOBAL_CURRENCY_EXCH_RATE NUMBER       Transaction to Global currency exchange rate    
UNIT_COST NUMBER       Indicates the unit cost in transaction/document currency    
GLOBAL_UNIT_COST NUMBER       Indicates the unit cost in global/analytical currency    
COST_METHOD_CODE VARCHAR2 32     The cost method code. Possible values are 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
UOM_CODE VARCHAR2 32     Unit of Measure DW_UNIT_OF_MEASURE_D_TL UOM_CODE
PUBLISHED_FLAG VARCHAR2 16     Denotes whether cost is published or unpublished DW_YN_LKP_TL YN_LKP_CODE
USED_FLAG VARCHAR2 16     Denotes whether cost is used or not DW_YN_LKP_TL YN_LKP_CODE

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 column

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