This is the Dimension table for Fixed asset Revaluations details
Module: Assets
TRANSACTION_HEADER_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
TRANSACTION_HEADER_ID | NUMBER | 38 | 0 | True | Revaluation identifier. | ||
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_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. | |||||
TRANSACTION_DATE_ENTERED | DATE | Date when the transaction occurred. |