This table contains the valuation unit information
Module: Cost Management
VAL_UNIT_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
VAL_UNIT_ID | NUMBER | 38 | 0 | True | Surrogate key identifying Valuation Unit row in this table. | DW_CST_VALUATION_UNITS_TL | VAL_UNIT_ID |
SOURCE_RECORD_ID | VARCHAR2 | 64 | System Generated | ||||
VAL_STRUCTURE_ID | NUMBER | 38 | 0 | Identifies the Valuation Structure. | DW_CST_VALUATION_STRUCTURES_TL | VAL_STRUCTURE_ID | |
VAL_UNIT_CODE | VARCHAR2 | 999 | Valuation Unit Code | ||||
COST_ORG_ID | NUMBER | 38 | 0 | Identifies the Cost Organization. | DW_CST_COST_ORG_BOOKS_D | COST_ORG_ID | |
COST_BOOK_ID | NUMBER | 38 | 0 | Identifies the Cost Book assigned to the Cost Organization. | DW_CST_COST_ORG_BOOKS_D | COST_BOOK_ID | |
VAL_STRUCTURE_CODE | VARCHAR2 | 32 | Valuation Structure Code | ||||
VAL_STRUCTURE_TYPE_CODE | VARCHAR2 | 32 | Valuation Structure Type | DW_CST_VALUATION_STRUCTURE_TYPES_LKP_TL | CST_VALUATION_STRUCTURE_TYPES_CODE | ||
VAL_STRUCTURE_MODE_CODE | VARCHAR2 | 32 | Valuation Structure Creation Mode | DW_CST_VALUATION_STRUCTURE_MODES_LKP_TL | CST_VALUATION_STRUCTURE_MODES_CODE |