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.