1. Tables and Views for Financials
  2. FA_MC_BOOKS

FA_MC_BOOKS

FA_MC_BOOKS contains currency and financial information about assets in each reporting book associated with the parent record in FA_BOOKS. This table stores one active row for each asset per reporting book identified by a null TRANSACTION_HEADER_ID_OUT. Oracle Assets updates this table when ever a financial adjustment is performed on the asset by setting the TRANSACTION_HEADER_ID_OUT of the current row to the TRANSACTION_HEADER_ID_IN of the new row. RATE_ADJUSTMENT_FACTOR is stored in the parent record in FA_BOOKS. It is an MRC sub-table of FA_BOOKS.

Details

  • Schema: FUSION

  • Object owner: FA

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

FA_MC_BOOKS_PK

SET_OF_BOOKS_ID, TRANSACTION_HEADER_ID_IN

Columns

Name Datatype Length Precision Not-null Comments
SET_OF_BOOKS_ID NUMBER 18 Yes Identifier of the accounting ledger.
ASSET_ID NUMBER 18 Yes Identifier of the asset number.
BOOK_TYPE_CODE VARCHAR2 30 Yes Unique book identification name.
TRANSACTION_HEADER_ID_IN NUMBER 18 Yes Identifier of the transaction that created the row.
TRANSACTION_HEADER_ID_OUT NUMBER 18 Identifier of the transaction that terminated the row.
ADJUSTED_COST NUMBER Yes 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.
COST NUMBER Yes Total recorded cost of the asset.
SOURCE_COST NUMBER Current cost of the asset in the primary functional currency.
ORIGINAL_COST NUMBER Yes Cost of the asset at the time of its addition.
SOURCE_ORIGINAL_COST NUMBER Original cost of the asset in the primary functional currency.
SALVAGE_VALUE NUMBER Yes Salvage value amount for the asset.
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.
RECOVERABLE_COST NUMBER Yes Cost minus salvage value, or depreciation ceiling, whichever is lower.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REVAL_CEILING NUMBER Upper limit for revaluing asset cost.
PERIOD_COUNTER_FULLY_RESERVED NUMBER 18 Identifier of the depreciation period in which the asset was fully reserved.
UNREVALUED_COST NUMBER Yes Asset cost without regard to any revaluations.
ALLOWED_DEPRN_LIMIT_AMOUNT NUMBER Depreciation limit amount for the asset.
PERIOD_COUNTER_LIFE_COMPLETE NUMBER 18 Identifier of the asset book period in which the asset's life was completed.
PERIOD_COUNTER_FULLY_XFRD NUMBER 18 Period identifier in which the asset was fully transferred to another book.
ADJUSTED_RECOVERABLE_COST NUMBER Adjusted recoverable cost with special depreciation limits taken into account.
CONVERTED_FLAG VARCHAR2 1 Status indicating whether the transaction amounts have been converted to the reporting currency.
ANNUAL_DEPRN_ROUNDING_FLAG VARCHAR2 5 Option indicating whether Oracle Fusion Assets should subtract year-to-date depreciation from the annual depreciation amount to get the depreciation amount for the last period of the fiscal year.
EOFY_ADJ_COST NUMBER Adjusted cost at the end of the previous fiscal year.
OLD_ADJUSTED_COST NUMBER Cost before adjustment transaction for the asset depreciation under formula net book value based depreciation method.
EOFY_FORMULA_FACTOR NUMBER Formula factor at the end of the previous fiscal year.
FORMULA_FACTOR NUMBER Factor used to adjust the depreciation rate for formula-net book value method assets.
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.
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.
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.
RETIREMENT_ID NUMBER 18 Identifier of the asset retirement transaction.
ADJUSTED_CAPACITY NUMBER Remaining production capacity used to depreciate assets that use units of production method.
FULLY_RSVD_REVALS_COUNTER NUMBER Number of times the asset has been revalued as fully reserved.
PERIOD_COUNTER_CAPITALIZED NUMBER Identifier of the depreciation period in which asset is capitalized.
PERIOD_COUNTER_FULLY_RETIRED NUMBER Identifier of the depreciation period in which the asset was fully retired.
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.
PERCENT_SALVAGE_VALUE NUMBER Salvage value percentage for the asset.
ALLOWED_DEPRN_LIMIT NUMBER Depreciation limit percentage for the asset.
DATE_PLACED_IN_SERVICE DATE Yes Date on which the asset was placed in service.
DATE_EFFECTIVE DATE Yes Date when the row became effective.
DEPRN_START_DATE DATE Yes Date when the asset started to depreciate.
RATE_ADJUSTMENT_FACTOR NUMBER Yes Internal factor used to adjust depreciation rates to depreciate the net book value over the remaining life.
PRORATE_DATE DATE Yes Date used to calculate the annual depreciation for assets.
CAPITALIZE_FLAG VARCHAR2 3 Yes Option indicating whether the asset is a capitalized or construction-in-process asset.
DEPRECIATE_FLAG VARCHAR2 3 Yes Option indicating whether the asset is depreciating.
DATE_INEFFECTIVE DATE Date when the row became inactive.
CONVERSION_DATE DATE Date on which short tax year asset was added to the acquiring company.
ORIGINAL_DEPRN_START_DATE DATE Date when the short tax year asset begin depreciating in the books of the acquired company.
SALVAGE_TYPE VARCHAR2 30 Yes Salvage type assigned to the asset. It can be either amount, percentage, or sum of member assets.
DEPRN_LIMIT_TYPE VARCHAR2 30 Yes Depreciation limit type assigned to the asset. It can be either amount, percentage, sum of member assets, or none.
REDUCTION_RATE NUMBER Depreciation reduction percentage for the group and its member assets.
REDUCE_ADDITION_FLAG VARCHAR2 1 Option indicating whether depreciation reduction should be considered for addition transaction.
REDUCE_ADJUSTMENT_FLAG VARCHAR2 1 Option indicating whether depreciation reduction should be considered for adjustment transaction.
REDUCE_RETIREMENT_FLAG VARCHAR2 1 Option indicating whether depreciation reduction should be considered for retirement transaction.
RECOGNIZE_GAIN_LOSS VARCHAR2 30 Option indicating whether gain or loss should be recognized for member asset retirement.
RECAPTURE_RESERVE_FLAG VARCHAR2 1 Option indicating whether reserve for the group asset can exceed its recoverable cost.
LIMIT_PROCEEDS_FLAG VARCHAR2 1 Option indicating whether the member asset proceed of sale should be limited to its recoverable cost or not.
TERMINAL_GAIN_LOSS VARCHAR2 30 Option indicating how terminal gain or loss should be recognized for member asset retirement.
TRACKING_METHOD VARCHAR2 30 Option indicating the group asset tracking method that is used to calculate group and its member asset depreciation.
EXCLUDE_FULLY_RSV_FLAG VARCHAR2 1 Option indicating whether fully reserved assets depreciable basis should be excluded from the group asset's depreciable basis or not.
EXCESS_ALLOCATION_OPTION VARCHAR2 30 Option indicating whether excess depreciation of the group asset is to be allocated to its member assets or reduced from the group asset depreciation.
DEPRECIATION_OPTION VARCHAR2 30 Option indicating whether the depreciation expense of the member asset is calculated using its group asset depreciation rules or the member asset depreciation rules.
MEMBER_ROLLUP_FLAG VARCHAR2 1 Option indicating whether group asset depreciation is sum of member asset depreciation or calculated separately.
ALLOCATE_TO_FULLY_RSV_FLAG VARCHAR2 1 Option indicating whether group asset depreciation amount should be allocated to fully retired assets.
ALLOCATE_TO_FULLY_RET_FLAG VARCHAR2 1 Option indicating whether group asset depreciation amount should be allocated to fully retired assets.
TERMINAL_GAIN_LOSS_AMOUNT NUMBER Accumulated depreciation remaining for the group asset after the last member asset of the group asset is retired.
CIP_COST NUMBER Construction-in-Process cost of the asset.
YTD_PROCEEDS NUMBER Year to date proceeds from sale of an asset.
LTD_PROCEEDS NUMBER Life-to-date proceeds of sale amount for the asset.
LTD_COST_OF_REMOVAL NUMBER Life-to-date cost of removal amount for the asset.
EOFY_RESERVE NUMBER Depreciation reserve at the end of the previous fiscal year.
PRIOR_EOFY_RESERVE NUMBER Previous accumulated depreciation 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
EXCLUDE_PROCEEDS_FROM_BASIS VARCHAR2 1 Group asset retirement rule which indicates whether proceeds of sale should be excluded when calculating the group asset's depreciable basis or not.
RETIREMENT_DEPRN_OPTION VARCHAR2 30 Option indicating whether group asset should depreciate till the last member asset is retired or end of the fiscal year.
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.
OVER_DEPRECIATE_OPTION VARCHAR2 30 Option indicating whether over depreciation is allowed for the group asset depreciation.
DISABLED_FLAG VARCHAR2 1 Option indicating whether the group asset is enabled or disabled.
OLD_ADJUSTED_CAPACITY NUMBER Remaining production capacity before the last depreciation process run for assets that that use units of production method.
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.
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.
METHOD_ID NUMBER 18 Identifier of the depreciation method.
FLAT_RATE_ID NUMBER 18 Identifier of the rates for the flat rate depreciation method.
CONVENTION_TYPE_ID NUMBER 18 Identifier of the prorate convention.
BONUS_RULE_ID NUMBER 18 Identifier of the depreciation bonus rule.
CEILING_TYPE_ID NUMBER 18 Identifier of the depreciation ceiling.
CASH_GENERATING_UNIT_ID NUMBER 18 Identifier of the cash generating unit.
CONTRACT_ID NUMBER 18 Identifier of the lease contract of the asset.
DRY_HOLE_FLAG VARCHAR2 1 Option indicating whether energy asset is classified as dry hole.
EXTENDED_DEPRECIATION_PERIOD NUMBER 18 No longer used.
EXTENDED_DEPRN_FLAG VARCHAR2 1 Option indicating whether the asset depreciation is extended or not.
ITC_AMOUNT NUMBER Investment tax credit amount of the asset.
ITC_AMOUNT_ID NUMBER 18 Identifier of the investment tax credit.
ITC_BASIS NUMBER Investment tax credit calculation basis.
NBV_AT_SWITCH NUMBER Net book value of the asset as of the date at which the original rate was switched to the revised rate.
PERIOD_COUNTER_FULLY_EXTENDED NUMBER 18 Identifier of the depreciation period in which the asset life was extended.
PRIOR_DEPRN_LIMIT NUMBER Depreciation limit as a percentage of cost for the asset immediately before it began extended depreciation.
PRIOR_DEPRN_LIMIT_AMOUNT NUMBER Depreciation limit amount for the asset immediately before it began extended depreciation.
PRIOR_DEPRN_LIMIT_TYPE VARCHAR2 30 Depreciation limit type for the asset immediately before it began extended depreciation.
RATE_IN_USE NUMBER Depreciation rates used to depreciate the net book value over the remaining life.
PRIOR_METHOD_ID NUMBER 18 Identifier of the depreciation method for the asset immediately before it began extended depreciation.
PRIOR_FLAT_RATE_ID NUMBER 18 Identifier of the flat rate for the depreciation method of the asset immediately before it began extended depreciation.
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 30 Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
FAIR_MARKET_VALUE NUMBER Stores the fair value of an asset.
LAST_PRICE_INDEX_VALUE NUMBER Stores the value of the price index used during index-based revaluation for future revaluation.
PERIOD_COUNTER_EXTENDED NUMBER 18 Extended depreciation start period identifier.
LOW_VALUE_ASSET_FLAG VARCHAR2 1 Indicates whether this line is a low value asset.
USE_BOOKS_SUMMARY_FLAG VARCHAR2 1 Indicates whether the FA_MC_BOOKS_SUMMARY table for the asset was populated.
ACCELERATED_BONUS_RULE_ID NUMBER 18 Bonus rule used to take a higher depreciation amount than the amount calculated by the depreciation method.
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.
GLOBAL_ATTRIBUTE_NUMBER6 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER7 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER8 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER9 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER10 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
LEASE_SCHEDULE_ID NUMBER 18 Unique lease payment schedule identification number.
LEASE_ID NUMBER 18 Unique lease 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.
REVALUED_COST NUMBER Increase or decrease in cost due to revaluation of the asset. Can be a positive or negative amount.
EOFY_REVAL_RESERVE NUMBER Revaluation reserve at the end of previous fiscal year.
PRIOR_EOFY_REVAL_RESERVE NUMBER Stores the value of revaluation reserve at the end of fiscal year before the transaction. This is used to rollback the depreciation for the last period of fiscal year.

Foreign Keys

Table Foreign Table Foreign Key Column
FA_MC_BOOKS fa_book_controls BOOK_TYPE_CODE
FA_MC_BOOKS fa_convention_types CONVENTION_TYPE_ID
FA_MC_BOOKS fa_ceiling_types CEILING_TYPE_ID
FA_MC_BOOKS fa_retirements RETIREMENT_ID
FA_MC_BOOKS fa_mc_retirements SET_OF_BOOKS_ID, RETIREMENT_ID
FA_MC_BOOKS fa_deprn_periods BOOK_TYPE_CODE, PERIOD_COUNTER_FULLY_RESERVED
FA_MC_BOOKS fa_deprn_periods BOOK_TYPE_CODE, PERIOD_COUNTER_LIFE_COMPLETE
FA_MC_BOOKS fa_deprn_periods BOOK_TYPE_CODE, PERIOD_COUNTER_CAPITALIZED
FA_MC_BOOKS fa_deprn_periods BOOK_TYPE_CODE, PERIOD_COUNTER_FULLY_RETIRED
FA_MC_BOOKS fa_mc_book_controls SET_OF_BOOKS_ID, BOOK_TYPE_CODE
FA_MC_BOOKS fa_itc_rates ITC_AMOUNT_ID
FA_MC_BOOKS gl_ledgers SET_OF_BOOKS_ID
FA_MC_BOOKS fa_cash_gen_units CASH_GENERATING_UNIT_ID
FA_MC_BOOKS fa_bonus_rules ACCELERATED_BONUS_RULE_ID
FA_MC_BOOKS fa_additions_b ASSET_ID
FA_MC_BOOKS fa_additions_b GROUP_ASSET_ID
FA_MC_BOOKS fa_transaction_headers TRANSACTION_HEADER_ID_IN, BOOK_TYPE_CODE
FA_MC_BOOKS fa_transaction_headers TRANSACTION_HEADER_ID_OUT, BOOK_TYPE_CODE
FA_MC_BOOKS fa_methods METHOD_ID
FA_MC_BOOKS fa_flat_rates METHOD_ID, FLAT_RATE_ID
FA_MC_BOOKS fa_bonus_rules BONUS_RULE_ID

Indexes

Index Uniqueness Tablespace Columns
FA_MC_BOOKS_N2 Non Unique Default SET_OF_BOOKS_ID, TRANSACTION_HEADER_ID_OUT
FA_MC_BOOKS_N3 Non Unique Default SET_OF_BOOKS_ID, RETIREMENT_ID
FA_MC_BOOKS_N4 Non Unique Default GROUP_ASSET_ID
FA_MC_BOOKS_U1 Unique Default SET_OF_BOOKS_ID, TRANSACTION_HEADER_ID_IN
FA_MC_BOOKS_U2 Unique Default SET_OF_BOOKS_ID, ASSET_ID, BOOK_TYPE_CODE, TRANSACTION_HEADER_ID_OUT