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

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