FA_MC_BOOKS_SUMMARY
FA_MC_BOOKS_SUMMARY contains currency and financial information about asset depreciation in each reporting book. It is an MRC sub-table of FA_BOOKS_SUMMARY.
Details
-
Schema: FUSION
-
Object owner: FA
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
FA_MC_BOOKS_SUMMARY_PK |
SET_OF_BOOKS_ID, ASSET_ID, BOOK_TYPE_CODE, PERIOD_COUNTER |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
ASSET_ID | NUMBER | 18 | Yes | Identifier of the asset number. | |
BOOK_TYPE_CODE | VARCHAR2 | 30 | Yes | Unique book identification name. | |
PERIOD_COUNTER | NUMBER | 18 | Yes | Identifier of the depreciation period. | |
FISCAL_YEAR | NUMBER | 18 | Name of the accounting fiscal year. | ||
PERIOD_NUM | NUMBER | 18 | Period number of depreciation period in the fiscal year. | ||
CALENDAR_PERIOD_OPEN_DATE | DATE | Start date of the calendar period. | |||
CALENDAR_PERIOD_CLOSE_DATE | DATE | End date of the calendar period. | |||
RESET_ADJUSTED_COST_FLAG | VARCHAR2 | 1 | Option indicating whether there is an adjustment that requires to recalculate the adjusted cost of the asset. | ||
CHANGE_IN_COST | NUMBER | Total change in the cost of the asset for the period. | |||
CHANGE_IN_ADDITIONS_COST | NUMBER | Change in the addition cost of the asset. | |||
CHANGE_IN_ADJUSTMENTS_COST | NUMBER | Change in the asset cost due to adjustment. | |||
CHANGE_IN_RETIREMENTS_COST | NUMBER | Not currently used. | |||
CHANGE_IN_GROUP_REC_COST | NUMBER | Not currently used. | |||
CHANGE_IN_CIP_COST | NUMBER | Change in the construction-in-process cost of the asset. | |||
COST | NUMBER | Total recorded cost of the asset. | |||
CIP_COST | NUMBER | Construction-in-Process cost of the asset. | |||
SALVAGE_TYPE | VARCHAR2 | 30 | Salvage type assigned to the asset. It can be either amount, percentage, or sum of member assets. | ||
PERCENT_SALVAGE_VALUE | NUMBER | Salvage value percentage for the asset. | |||
SALVAGE_VALUE | NUMBER | Salvage value amount for the asset. | |||
MEMBER_SALVAGE_VALUE | NUMBER | Sum of member assets salvage value. | |||
RECOVERABLE_COST | NUMBER | Cost minus salvage value, or depreciation ceiling, whichever is lower. | |||
DEPRN_LIMIT_TYPE | VARCHAR2 | 30 | Depreciation limit type assigned to the asset. It can be either amount, percentage, sum of member assets, or none. | ||
ALLOWED_DEPRN_LIMIT | NUMBER | Depreciation limit percentage for the asset. | |||
ALLOWED_DEPRN_LIMIT_AMOUNT | NUMBER | Depreciation limit amount for the asset. | |||
MEMBER_DEPRN_LIMIT_AMOUNT | NUMBER | Sum of depreciation limit as a flat amount, subtracted from cost. | |||
ADJUSTED_RECOVERABLE_COST | NUMBER | Adjusted recoverable cost with special depreciation limits taken into account. | |||
ADJUSTED_COST | NUMBER | Depreciable basis of the asset, calculated as recoverable cost for cost basis depreciation methods, and recoverable cost less the accumulated depreciation for net book value basis methods. | |||
DEPRECIATE_FLAG | VARCHAR2 | 3 | Option indicating whether the asset is depreciating. | ||
DISABLED_FLAG | VARCHAR2 | 1 | Option indicating whether the group asset is enabled or disabled. | ||
DATE_PLACED_IN_SERVICE | DATE | Date when the asset was placed in service. | |||
RATE_ADJUSTMENT_FACTOR | NUMBER | Internal factor used to adjust depreciation rates to depreciate the net book value over the remaining life. | |||
ADJUSTED_CAPACITY | NUMBER | Remaining production capacity used to depreciate assets that use units of production method. | |||
PRODUCTION_CAPACITY | NUMBER | Production capacity for assets that use units of production method. | |||
UNIT_OF_MEASURE | VARCHAR2 | 25 | Physical quantity that is used as a standard for measurement. | ||
REMAINING_LIFE1 | NUMBER | 4 | Remaining life of the asset calculated as on the conversion date, prorate date or fiscal year start date. | ||
REMAINING_LIFE2 | NUMBER | 4 | Remaining life of the asset calculated as on the fiscal year start date. | ||
FORMULA_FACTOR | NUMBER | Factor used to adjust the depreciation rate for formula-net book value method assets. | |||
UNREVALUED_COST | NUMBER | Asset cost without regard to any revaluations. | |||
REVAL_AMORTIZATION_BASIS | NUMBER | Revaluation reserve used in calculating amortization of revaluation reserve. This changes only when the asset is revalued or an amortized adjustment is performed. | |||
REVAL_CEILING | NUMBER | Upper limit for revaluing asset cost. | |||
EOFY_ADJ_COST | NUMBER | Adjusted cost at the end of the previous fiscal year. | |||
EOFY_FORMULA_FACTOR | NUMBER | Formula factor at the end of the previous fiscal year. | |||
EOFY_RESERVE | NUMBER | Depreciation reserve at the end of the previous fiscal year. | |||
EOP_ADJ_COST | NUMBER | Adjusted cost at the end of the previous period. | |||
EOP_FORMULA_FACTOR | NUMBER | Formula factor at the end of the previous period. | |||
SHORT_FISCAL_YEAR_FLAG | VARCHAR2 | 3 | Option indicating whether the asset is added in short tax year. | ||
GROUP_ASSET_ID | NUMBER | 18 | Identification number of the group asset. | ||
OVER_DEPRECIATE_OPTION | VARCHAR2 | 30 | Option indicating whether over depreciation is allowed for the group asset depreciation or not. | ||
FULLY_RSVD_REVALS_COUNTER | NUMBER | 5 | Number of times the asset has been revalued as fully reserved. | ||
CAPITALIZED_FLAG | VARCHAR2 | 1 | Option indicating whether the asset is a capitalized or construction-in-process asset. | ||
FULLY_RESERVED_FLAG | VARCHAR2 | 1 | Option indicating whether the asset is fully reserved. | ||
FULLY_RETIRED_FLAG | VARCHAR2 | 1 | Option indicating whether the asset is fully reserved. | ||
LIFE_COMPLETE_FLAG | VARCHAR2 | 1 | Option indicating whether the asset life is completed. | ||
TERMINAL_GAIN_LOSS_AMOUNT | NUMBER | Accumulated depreciation remaining for the group asset after the last member asset of the group asset is retired. | |||
TERMINAL_GAIN_LOSS_FLAG | VARCHAR2 | 1 | Option indicating whether terminal gain or loss amount needs to be processed by the Calculate Gains and Losses program, when it is running for the last period of the fiscal year. | ||
DEPRN_AMOUNT | NUMBER | Asset depreciation expense amount. | |||
YTD_DEPRN | NUMBER | Year-to-date depreciation expense. | |||
DEPRN_RESERVE | NUMBER | Total depreciation expense including the bonus depreciation recognized for the asset. | |||
BONUS_DEPRN_AMOUNT | NUMBER | Bonus depreciation expense. Amount included in DEPRN_AMOUNT. | |||
BONUS_YTD_DEPRN | NUMBER | Bonus year-to-date depreciation expense. Amount included in YTD_DEPRN. | |||
BONUS_DEPRN_RESERVE | NUMBER | Total bonus depreciation taken since the beginning of the asset life. Amount included in DEPRN_RESERVE. | |||
BONUS_RATE | NUMBER | Bonus rate used to calculate bonus depreciation. | |||
LTD_PRODUCTION | NUMBER | Life-to-date production for assets that use a units of production method. | |||
YTD_PRODUCTION | NUMBER | Year-to-date production for a units of production asset. | |||
PRODUCTION | NUMBER | Current period production for a units of production asset. | |||
REVAL_AMORTIZATION | NUMBER | Amount of revaluation reserve amortized during this period. | |||
REVAL_DEPRN_EXPENSE | NUMBER | Portion of depreciation expense generated due to revaluation of the asset cost. Oracle Fusion Assets does not create any journal entries for this amount. It is for reporting only. | |||
REVAL_RESERVE | NUMBER | Change in the net book value due to revaluation of asset cost and sometimes also revaluation of depreciation reserve for revaluation period. For all other periods, the revaluation reserve amount after depreciation run. | |||
YTD_REVAL_DEPRN_EXPENSE | NUMBER | Year-to-date depreciation expense due to revaluation. Oracle Fusion Assets does not create any journal entries for this amount. It is for reporting only. | |||
DEPRN_OVERRIDE_FLAG | VARCHAR2 | 1 | Indicator as to whether the depreciation amount for the period is overridden. | ||
SYSTEM_DEPRN_AMOUNT | NUMBER | System calculated depreciation amount. | |||
SYSTEM_BONUS_DEPRN_AMOUNT | NUMBER | System calculated depreciation amount. | |||
YTD_PROCEEDS_OF_SALE | NUMBER | Year-to-date proceeds of sale for an asset. | |||
LTD_PROCEEDS_OF_SALE | NUMBER | Life-to-date proceeds of sale amount for the asset. | |||
YTD_COST_OF_REMOVAL | NUMBER | Year-to-date cost of removal amount of the asset. | |||
LTD_COST_OF_REMOVAL | NUMBER | Life-to-date cost of removal amount for the asset. | |||
DEPRN_ADJUSTMENT_AMOUNT | NUMBER | Depreciation expense adjustment amount for the period. | |||
EXPENSE_ADJUSTMENT_AMOUNT | NUMBER | Depreciation expense adjustment amount for the period. | |||
UNPLANNED_AMOUNT | NUMBER | Unplanned depreciation amount of the asset. | |||
RESERVE_ADJUSTMENT_AMOUNT | NUMBER | Depreciation reserve adjustment amount for the asset. | |||
CHANGE_IN_EOFY_RESERVE | NUMBER | Change in depreciation reserve at the end previous of fiscal year. | |||
SWITCH_CODE | VARCHAR2 | 2 | Current depreciation code for a Polish depreciation basis that is in use for the asset. | ||
TRANSACTION_HEADER_ID_IN | NUMBER | 18 | Identifier of the transaction that created the row. | ||
TRANSACTION_HEADER_ID_OUT | NUMBER | 18 | Identifier of the transaction that terminated the row. | ||
POLISH_DEPRN_BASIS | NUMBER | Depreciation basis amount used for assets with a polish depreciation basis rule. | |||
POLISH_ADJ_REC_COST | NUMBER | Adjusted recoverable cost used for assets with a polish depreciation basis rule. | |||
METHOD_ID | NUMBER | 18 | Identifier of the depreciation method. | ||
FLAT_RATE_ID | NUMBER | 18 | Identifier of the rates for the flat rate depreciation method. | ||
BONUS_RULE_ID | NUMBER | 18 | Identifier of the depreciation bonus rule. | ||
CEILING_TYPE_ID | NUMBER | 18 | Identifier of the depreciation ceiling. | ||
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. | |
CAPITAL_ADJUSTMENT | NUMBER | Value of capital adjustment after considering impairment transaction. | |||
GENERAL_FUND | NUMBER | Value of general fund after considering impairment effect. | |||
IMPAIRMENT_AMOUNT | NUMBER | Impairment loss amount of the asset. | |||
IMPAIRMENT_RESERVE | NUMBER | Total impairment loss recognized for the asset. | |||
YTD_IMPAIRMENT | NUMBER | Year-to-date impairment amount. | |||
IMPAIR_LOSS_BALANCE | NUMBER | Accumulated impairment expense. | |||
REVAL_LOSS_BALANCE | NUMBER | Accumulated revaluation loss balance. | |||
REVAL_AMORT_BALANCE | NUMBER | Accumulated revaluation amortization. | |||
ASSET_TYPE | VARCHAR2 | 11 | The type of asset allowed in the Oracle Fusion Assets. The asset types allowed are Capitalized, Construction-in-Process, Expensed, and Group. | ||
BONUS_RESERVE_ADJ_AMOUNT | NUMBER | Bonus depreciation reserve adjustment amount for the asset. | |||
REVAL_RESERVE_ADJ_AMOUNT | NUMBER | Revaluation reserve adjustment amount for the asset. | |||
IMPAIRMENT_RESERVE_ADJ_AMOUNT | NUMBER | Impairment reserve adjustment amount for the asset. | |||
BONUS_EXPENSE_ADJ_AMOUNT | NUMBER | Bonus depreciation expense adjustment amount for the period. | |||
EXTENDED_DEPRN_FLAG | VARCHAR2 | 1 | Indicates whether the asset depreciation is extended. | ||
RESERVE_RET_ADJ_AMOUNT | NUMBER | Depreciation reserve adjustment amount for the period. | |||
BONUS_RESERVE_RET_ADJ_AMOUNT | NUMBER | Bonus depreciation reserve adjustment amount for the period. | |||
REVAL_RESERVE_RET_ADJ_AMOUNT | NUMBER | Revaluation reserve adjustment amount for the period. | |||
IMP_RESERVE_RET_ADJ_AMOUNT | NUMBER | Impairment reserve adjustment amount for the period. | |||
AMORTIZE_FLAG | VARCHAR2 | 1 | Indicates whether the asset is amortized or not. | ||
ACCELERATED_ADJUSTED_COST | NUMBER | The base amount on which the accelerated depreciation is calculated. | |||
BONUS_ADJUSTED_COST | NUMBER | The base amount on which the bonus depreciation is calculated. | |||
ACCELERATED_DEPRN_AMOUNT | NUMBER | The accelerated depreciation amount calculated for the period. | |||
ACCELERATED_DEPRN_RESERVE | NUMBER | The accelerated depreciation reserve balance for the period. | |||
ACCELERATED_YTD_DEPRN | NUMBER | The accelerated depreciation YTD balance for the period. | |||
ACC_DEPRN_ADJUSTMENT_AMOUNT | NUMBER | The adjustment amount calculated for retroactive adjustments included in the accelerated depreciation for the period. | |||
LEASE_ID | NUMBER | 18 | Identifier of the capital or operating lease. | ||
LEASE_SCHEDULE_ID | NUMBER | 18 | Unique lease payment schedule identification number. | ||
LEASE_EXPENSE_BASIS | NUMBER | Basis used for calculating the periodic lease expense of the asset. | |||
LEASE_ADJUSTMENT_FACTOR | NUMBER | Internal factor used to amortize the lease basis over the remaining lease term of the asset. | |||
DEPRN_ADJUSTMENT_FACTOR | NUMBER | Controls the speed of depreciation of an asset by multiplying this factor by the annual depreciation rate. | |||
FULLY_RESERVE_ON_ADD_FLAG | VARCHAR2 | 1 | Indicates whether to fully depreciate an asset when the asset is added. | ||
SET_OF_BOOKS_ID | NUMBER | 18 | Yes | Identifier of the accounting ledger. | |
ANNUITY_INTEREST_RATE | NUMBER | Annual interest rate used to calculate annual interest expense. | |||
ANNUITY_INTEREST_AMOUNT | NUMBER | Annuity interest expense amount. | |||
YTD_ANNUITY_INTEREST | NUMBER | Year-to-date annuity interest expense amount. | |||
LTD_ANNUITY_INTEREST | NUMBER | Total annuity interest expense amount. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
FA_MC_BOOKS_SUMMARY | fa_additions_b | ASSET_ID |
FA_MC_BOOKS_SUMMARY | fa_deprn_periods | BOOK_TYPE_CODE, PERIOD_COUNTER |
FA_MC_BOOKS_SUMMARY | gl_ledgers | SET_OF_BOOKS_ID |
FA_MC_BOOKS_SUMMARY | fa_mc_book_controls | SET_OF_BOOKS_ID, BOOK_TYPE_CODE |
FA_MC_BOOKS_SUMMARY | fa_book_controls | BOOK_TYPE_CODE |
FA_MC_BOOKS_SUMMARY | fa_transaction_headers | TRANSACTION_HEADER_ID_IN, BOOK_TYPE_CODE |
FA_MC_BOOKS_SUMMARY | fa_transaction_headers | TRANSACTION_HEADER_ID_OUT, BOOK_TYPE_CODE |
FA_MC_BOOKS_SUMMARY | fa_additions_b | GROUP_ASSET_ID |
FA_MC_BOOKS_SUMMARY | fa_methods | METHOD_ID |
FA_MC_BOOKS_SUMMARY | fa_flat_rates | METHOD_ID, FLAT_RATE_ID |
FA_MC_BOOKS_SUMMARY | fa_bonus_rules | BONUS_RULE_ID |
FA_MC_BOOKS_SUMMARY | fa_ceiling_types | CEILING_TYPE_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
FA_MC_BOOKS_SUMMARY_N1 | Non Unique | Default | SET_OF_BOOKS_ID, BOOK_TYPE_CODE, PERIOD_COUNTER, TRANSACTION_HEADER_ID_OUT |
FA_MC_BOOKS_SUMMARY_U1 | Unique | Default | SET_OF_BOOKS_ID, ASSET_ID, BOOK_TYPE_CODE, PERIOD_COUNTER |