DW_FA_CONVENTION_TYPES_D

This is the FA dimension table for Fixed asset Convention types details

Details

Module: Assets

Key Columns

CONVENTION_TYPE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CONVENTION_TYPE_ID NUMBER 38 0 True Identifier of the prorate convention.    
SOURCE_RECORD_ID VARCHAR2 64     This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of prorate convention identifier.    
PRORATE_CONVENTION_CODE VARCHAR2 16     Unique name of the prorate convention. DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
DESCRIPTION VARCHAR2 64     Description of the prorate convention.    
FISCAL_YEAR_NAME VARCHAR2 32     Name of the fiscal year for which the convention is defined.    

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