# DW_FA_MC_REVALUATIONS_D

This is the Dimension table for Fixed asset Revaluations details

## Details

Module: Assets

## Key Columns

MC_FLAG, LEDGER_ID, TRANSACTION_HEADER_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
TRANSACTION_HEADER_ID | NUMBER | 38 | 0 | True | Revaluation 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 Revaluation identifier. |  |
BOOK_TYPE_CODE | VARCHAR2 | 32 |  |  | Asset book identification name. |  |
ASSET_ID | NUMBER | 38 | 0 |  | Identifier of the asset number on which the revaluation transaction is performed. |  |
REVAL_METHOD | VARCHAR2 | 32 |  |  | Stores the method used for revaluation. |  |
REVAL_VALUE_TYPE | VARCHAR2 | 32 |  |  | Stores the value type used for revaluation. |  |
REVAL_PERCENTAGE | NUMBER |  |  |  | Revaluation percentage value used for the revaluation. |  |
REVAL_AMOUNT | NUMBER |  |  |  | Revaluation amount value used for the revaluation. |  |
GLOBAL_REVAL_AMOUNT | NUMBER |  |  |  | Revaluation amount value used for the revaluation in Global Currency |  |
PRIOR_FAIR_MARKET_VALUE | NUMBER |  |  |  | Fair value of an asset before revaluation. |  |
GLOBAL_PRIOR_FAIR_MARKET_VALUE | NUMBER |  |  |  | Fair value of an asset before revaluation in Global Currency |  |
FAIR_MARKET_VALUE | NUMBER |  |  |  | Fair value of the asset after revaluation. |  |
GLOBAL_FAIR_MARKET_VALUE | NUMBER |  |  |  | Fair value of the asset after revaluation in Global Currency |  |
REVAL_GAIN_LOSS | NUMBER |  |  |  | Stores the revaluation gain or loss amounts. |  |
GLOBAL_REVAL_GAIN_LOSS | NUMBER |  |  |  | Stores the revaluation gain or loss amounts in Global Currency |  |
PRIOR_COST | NUMBER |  |  |  | Cost of an asset before revaluation. |  |
GLOBAL_PRIOR_COST | NUMBER |  |  |  | Cost of an asset before revaluation in Global Currency |  |
COST | NUMBER |  |  |  | Cost of an asset after revaluation. |  |
GLOBAL_COST | NUMBER |  |  |  | Cost of an asset after revaluation in Global Currency |  |
PRIOR_DEPRN_RESERVE | NUMBER |  |  |  | Depreciation reserve of an asset before revaluation. |  |
GLOBAL_PRIOR_DEPRN_RESERVE | NUMBER |  |  |  | Depreciation reserve of an asset before revaluation in Global Currency |  |
DEPRN_RESERVE | NUMBER |  |  |  | Depreciation reserve of an asset after revaluation. |  |
GLOBAL_DEPRN_RESERVE | NUMBER |  |  |  | Depreciation reserve of an asset after revaluation in Global Currency |  |
BONUS_DEPRN_RESERVE | NUMBER |  |  |  | Bonus depreciation reserve of an asset after revaluation. |  |
GLOBAL_BONUS_DEPRN_RESERVE | NUMBER |  |  |  | Bonus depreciation reserve of an asset after revaluation in Global Currency |  |
PRIOR_BONUS_DEPRN_RESERVE | NUMBER |  |  |  | Bonus depreciation reserve of an asset before revaluation. |  |
GLOBAL_PRIOR_BONUS_DEPRN_RESERVE | NUMBER |  |  |  | Bonus depreciation reserve of an asset before revaluation in Global Currency |  |
PRIOR_REVAL_RESERVE | NUMBER |  |  |  | Revaluation reserve of an asset before revaluation. |  |
GLOBAL_PRIOR_REVAL_RESERVE | NUMBER |  |  |  | Revaluation reserve of an asset before revaluation in Global Currency |  |
REVAL_RESERVE | NUMBER |  |  |  | Revaluation reserve of an asset after revaluation. |  |
GLOBAL_REVAL_RESERVE | NUMBER |  |  |  | Revaluation reserve of an asset after revaluation in Global Currency |  |
PRIOR_IMPAIRMENT_RESERVE | NUMBER |  |  |  | Impairment reserve of an asset before revaluation. |  |
GLOBAL_PRIOR_IMPAIRMENT_RESERVE | NUMBER |  |  |  | Impairment reserve of an asset before revaluation in Global Currency |  |
IMPAIRMENT_RESERVE | NUMBER |  |  |  | Impairment reserve of an asset prior to revaluation. |  |
GLOBAL_IMPAIRMENT_RESERVE | NUMBER |  |  |  | Impairment reserve of an asset prior to revaluation in Global Currency |  |
IMPAIR_LOSS_BALANCE | NUMBER |  |  |  | Impairment loss of an asset after revaluation. |  |
GLOBAL_IMPAIR_LOSS_BALANCE | NUMBER |  |  |  | Impairment loss of an asset after revaluation in Global Currency |  |
PRIOR_IMPAIR_LOSS_BALANCE | NUMBER |  |  |  | Impairment loss of an asset before revaluation. |  |
GLOBAL_PRIOR_IMPAIR_LOSS_BALANCE | NUMBER |  |  |  | Impairment loss of an asset before revaluation in Global Currency |  |
REVAL_LOSS_BALANCE | NUMBER |  |  |  | Revaluation loss of an asset after revaluation. |  |
GLOBAL_REVAL_LOSS_BALANCE | NUMBER |  |  |  | Revaluation loss of an asset after revaluation in Global Currency |  |
PRIOR_REVAL_LOSS_BALANCE | NUMBER |  |  |  | Revaluation loss of an asset before revaluation. |  |
GLOBAL_PRIOR_REVAL_LOSS_BALANCE | NUMBER |  |  |  | Revaluation loss of an asset before revaluation in Global Currency |  |
REVAL_AMORTIZATION_BASIS | NUMBER |  |  |  | Revaluation amortization basis of an asset after revaluation. |  |
GLOBAL_REVAL_AMORTIZATION_BASIS | NUMBER |  |  |  | Revaluation amortization basis of an asset after revaluation in Global Currency |  |
PRIOR_REVAL_AMORT_BASIS | NUMBER |  |  |  | Revaluation amortization basis of an asset before revaluation. |  |
GLOBAL_PRIOR_REVAL_AMORT_BASIS | NUMBER |  |  |  | Revaluation amortization basis of an asset before revaluation in Global Currency |  |
PRIOR_LIFE_IN_MONTHS | NUMBER | 38 | 0 |  | Life of an asset in months before revaluation. |  |
LIFE_IN_MONTHS | NUMBER | 38 | 0 |  | Life of an asset in months after revaluation. |  |
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. |  |
TRANSACTION_DATE_ENTERED | DATE |  |  |  | Date when the transaction occurred. |  |

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