DW_FA_MC_IMPAIRMENTS_D

This is the FA dimension table for Fixed asset Impairment details

Details

Module: Assets

Key Columns

LEDGER_ID, MC_FLAG, IMPAIRMENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
IMPAIRMENT_ID NUMBER 38 0 True Impaiement identifier.
LEDGER_ID NUMBER 38 0 True Identifier of the accounting ledger.
MC_FLAG VARCHAR2 16 True Flag to indicate the source of data is MC or Regular dataset
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. 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_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.