This fact table contains information about Item Costing
Module: Cost Management
EXPENSE_POOL_ID, INVENTORY_ITEM_ID, EFFECTIVE_START_DATE, COST_ELEMENT_ID, VAL_UNIT_ID, COST_ORG_ID, COST_LEVEL_CODE, COST_BOOK_ID
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 | 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 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 | Unit of Measure | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE |
#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