# DW_FA_MC_IMPAIRMENTS_D

This is the FA dimension table for Fixed asset Impairment details

## Details

Module: Assets

## Key Columns

IMPAIRMENT_ID, MC_FLAG, LEDGER_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. |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.