DW_FA_IMPAIRMENTS_D

This is the FA dimension table for Fixed asset Impairment details

Details

Module: Assets

Key Columns

IMPAIRMENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
IMPAIRMENT_ID NUMBER 38 0 True Impaiement identifier.    
SOURCE_RECORD_ID VARCHAR2 64     Source record identifier. Value is derived from a combination of Impaiement identifier.    
BOOK_TYPE_CODE VARCHAR2 32     Unique book identification name.    
ASSET_ID NUMBER       Identifier of the asset number.    
IMPAIRMENT_NAME VARCHAR2 32     Name of the impairment transaction.    
NET_BOOK_VALUE NUMBER       Net book value of an asset is the current cost minus total reserve, times the accumulated depreciation plus bonus reserve.    
GLOBAL_NET_BOOK_VALUE NUMBER       Net book value of an asset is the current cost minus total reserve, times the accumulated depreciation plus bonus reserve in Global Currency    
NET_SELLING_PRICE NUMBER       Price for selling the asset net of cost of removal.    
GLOBAL_NET_SELLING_PRICE NUMBER       Price for selling the asset net of cost of removal in Global Currency    
VALUE_IN_USE NUMBER       Asset value in use for impairment evaluation.    
GLOBAL_VALUE_IN_USE NUMBER       Asset value in use for impairment evaluation in Global Currency    
IMPAIRMENT_AMOUNT NUMBER       Impairment loss amount of the asset.    
GLOBAL_IMPAIRMENT_AMOUNT NUMBER       Impairment loss amount of the asset in Global Currency    
IMPAIRMENT_DATE DATE       Date when the impairment transaction occurs.    
STATUS VARCHAR2 32     Status of the impairment transaction.    
REASON VARCHAR2 128     Reason for performing the impairment transaction.    
REVERSAL_FLAG VARCHAR2 16     Option indicating whether the transaction is impairment or impairment reversal    
CASH_GENERATING_UNIT_ID NUMBER 38 0   Identifier of the cash generating unit.    
LEDGER_ID NUMBER 38 0   Identifier of the accounting ledger    
LEDGER_CURRENCY_CODE VARCHAR2 16     Functional currency of the ledger.    
GLOBAL_CURRENCY_CODE VARCHAR2 16     Global currency code.    
GLOBAL_CURRENCY_EXCH_RATE NUMBER       Global currency conversion rate.