DW_CST_VALUATION_UNITS_D

This table contains the valuation unit information

Details

Module: Cost Management

Key Columns

VAL_UNIT_ID

Columns

Columns
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 This column is for Oracle Internal use only. 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