FA_REVALUATIONS
FA_REVALUATIONS stores revaluation transaction related information at asset level.
Details
-
Schema: FUSION
-
Object owner: FA
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
FA_REVALUATIONS_PK |
TRANSACTION_HEADER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_HEADER_ID | NUMBER | 18 | Yes | Identifier of the asset revaluation transaction. | |
| ASSET_ID | NUMBER | 18 | Yes | Identifier of the asset number on which the revaluation transaction is performed. | |
| BOOK_TYPE_CODE | VARCHAR2 | 30 | Yes | Asset book identification name. | |
| MASS_REVAL_ID | NUMBER | 18 | Yes | Identifier of the mass revaluation transaction. | |
| REVAL_METHOD | VARCHAR2 | 30 | Yes | Stores the method used for revaluation. | |
| REVAL_FULLY_RSVD_FLAG | VARCHAR2 | 1 | Allows fully reserved asset revaluation. | ||
| LIFE_EXTENSION_FACTOR | NUMBER | Value of the life extension factor used when revaluing fully reserved assets using life-based methods. | |||
| LIFE_EXTENSION_CEILING | NUMBER | Value of the life extension ceiling used when revaluing fully reserved assets using life-based methods. | |||
| REVAL_VALUE_TYPE | VARCHAR2 | 30 | Yes | 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. | |||
| FAIR_MARKET_VALUE | NUMBER | Fair value of the asset after revaluation. | |||
| MAX_FULLY_RSVD_REVALS | NUMBER | 18 | Default value of the maximum number of revaluations allowed on a fully reserved asset. | ||
| LINKED_FLAG | VARCHAR2 | 1 | Allows revaluation to be linked to prior impairment transactions. | ||
| REVAL_GAIN_LOSS | NUMBER | Stores the revaluation gain or loss amounts. | |||
| ALLOW_FUND_ACCOUNTING_FLAG | VARCHAR2 | 1 | Enables fund accounting in the book. | ||
| AMORTIZE_REVAL_RESERVE_FLAG | VARCHAR2 | 1 | Book-level option at the time of the revaluation transaction indicating whether revaluation reserve amortization is allowed. | ||
| REVAL_DEPRN_RESERVE_FLAG | VARCHAR2 | 1 | Book-level option at the time of the revaluation transaction indicating whether depreciation reserve can be revalued. | ||
| REVAL_YTD_DEPRN_FLAG | VARCHAR2 | 1 | Book-level option at the time of the revaluation transaction indicating whether year-to-date depreciation reserve can be revalued. | ||
| PERIOD_END_REVAL_FLAG | VARCHAR2 | 1 | Include current period depreciation in revaluation calculations. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| PRICE_INDEX_ID | NUMBER | 18 | Stores the identifier of the price index used during index-based revaluation. | ||
| PRICE_INDEX_VALUE | NUMBER | Stores the value of the price index used during index-based revaluation. | |||
| PRIOR_COST | NUMBER | Cost of an asset before revaluation. | |||
| COST | NUMBER | Cost of an asset after revaluation. | |||
| PRIOR_DEPRN_RESERVE | NUMBER | Depreciation reserve of an asset before revaluation. | |||
| DEPRN_RESERVE | NUMBER | Depreciation reserve of an asset after revaluation. | |||
| PRIOR_BONUS_DEPRN_RESERVE | NUMBER | Bonus depreciation reserve of an asset before revaluation. | |||
| BONUS_DEPRN_RESERVE | NUMBER | Bonus depreciation reserve of an asset after revaluation. | |||
| PRIOR_REVAL_RESERVE | NUMBER | Revaluation reserve of an asset before revaluation. | |||
| REVAL_RESERVE | NUMBER | Revaluation reserve of an asset after revaluation. | |||
| PRIOR_FAIR_MARKET_VALUE | NUMBER | Fair value of an asset before revaluation. | |||
| PRIOR_IMPAIRMENT_RESERVE | NUMBER | Impairment reserve of an asset before revaluation. | |||
| IMPAIRMENT_RESERVE | NUMBER | Impairment reserve of an asset prior to revaluation. | |||
| PRIOR_IMPAIR_LOSS_BALANCE | NUMBER | Impairment loss of an asset before revaluation. | |||
| IMPAIR_LOSS_BALANCE | NUMBER | Impairment loss of an asset after revaluation. | |||
| PRIOR_REVAL_LOSS_BALANCE | NUMBER | Revaluation loss of an asset before revaluation. | |||
| REVAL_LOSS_BALANCE | NUMBER | Revaluation loss of an asset after revaluation. | |||
| PRIOR_REVAL_AMORT_BASIS | NUMBER | Revaluation amortization basis of an asset before revaluation. | |||
| REVAL_AMORTIZATION_BASIS | NUMBER | Revaluation amortization basis of an asset after revaluation. | |||
| PRIOR_LIFE_IN_MONTHS | NUMBER | 4 | Life of an asset in months before revaluation. | ||
| LIFE_IN_MONTHS | NUMBER | 4 | Life of an asset in months after revaluation. | ||
| UPDATE_LAST_USED_INDEX_FLAG | VARCHAR2 | 1 | Specifies whether the value of the last used price index will be updated to a new value as of the revaluation date. | ||
| BACKLOG_DEPRN_RESERVE | NUMBER | Life-to-date backlog depreciation amount. | |||
| REVALUED_COST | NUMBER | Increase or decrease in cost due to revaluation of the asset. Can be a positive or negative amount. | |||
| REVAL_AMORT_BALANCE | NUMBER | Accumulated revaluation amortization. | |||
| PRIOR_BACKLOG_DEPRN_RESERVE | NUMBER | Life-to-date backlog depreciation amount before the transaction. | |||
| PRIOR_REVALUED_COST | NUMBER | Life-to-date revalued cost amount before the transaction. | |||
| PRIOR_REVAL_AMORT_BALANCE | NUMBER | Accumulated revaluation amortization amount before the transaction. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| FA_REVALUATIONS | fa_transaction_headers | TRANSACTION_HEADER_ID, BOOK_TYPE_CODE |
| FA_REVALUATIONS | fa_additions_b | ASSET_ID |
| FA_REVALUATIONS | fa_book_controls | BOOK_TYPE_CODE |
| FA_REVALUATIONS | fa_mass_transactions | MASS_REVAL_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FA_REVALUATIONS_U1 | Unique | Default | TRANSACTION_HEADER_ID |