DW_FA_MC_REVALUATIONS_D

This is the Dimension table for Fixed asset Revaluations details

Details

Module: Assets

Key Columns

LEDGER_ID, MC_FLAG, 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     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, 2023, Oracle and/or its affiliates.