DW_FA_MC_REVALUATIONS_D

This is the Dimension table for Fixed asset Revaluations details

Details

Module: Assets

Key Columns

LEDGER_ID, TRANSACTION_HEADER_ID, MC_FLAG

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.