DW_FA_METHODS_D

This is the FA dimension table for Fixed asset depreciation methods.

Details

Module: Assets

Key Columns

METHOD_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
METHOD_ID NUMBER 38 0 True Identifier of the depreciation method.    
SOURCE_RECORD_ID VARCHAR2 64     Source record identifier. Value is derived from a combination of depreciation method identifier.    
METHOD_CODE VARCHAR2 16     Name of the depreciation method.    
NAME VARCHAR2 128     Name of the depreciation method.    
LIFE_IN_MONTHS NUMBER 38 0   Life in months for the investment tax credit.