This is the FA dimension table for Fixed asset Impairment details
Module: Assets
IMPAIRMENT_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
IMPAIRMENT_ID | NUMBER | 38 | 0 | True | Impaiement identifier. | ||
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_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. |
Copyright © 2019, 2024, Oracle and/or its affiliates.