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