1. Tables and Views for Financials
  2. FA_MC_DEPRN_SUMMARY_H

FA_MC_DEPRN_SUMMARY_H

FA_MC_DEPRN_SUMMARY_H contains the depreciation information originally stored in FA_MC_DEPRN_SUMMARY for audit and inquiry purposes for records that were accounted for. Only those records that were accounted for in FINAL mode in Subledger Accounting are archived into this table.

Details

  • Schema: FUSION

  • Object owner: FA

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

FA_MC_DEPRN_SUMMARY_H_PK

SET_OF_BOOKS_ID, ASSET_ID, BOOK_TYPE_CODE, PERIOD_COUNTER, DEPRN_RUN_ID

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.
DEPRN_RUN_DATE DATE The system date when depreciation was run.
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.
DEPRN_SOURCE_CODE VARCHAR2 15 The source from where the depreciation record was created. Possible values are BOOKS, DEPRN, and TRACK.
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.
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.
PERIOD_COUNTER NUMBER Yes Identifier of the depreciation period.
PRODUCTION NUMBER Current period production for a units of production asset.
REVAL_AMORTIZATION NUMBER Amount of revaluation reserve amortized during this period.
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_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 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_PRODUCTION NUMBER Year-to-date production for a units of production asset.
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.
PRIOR_FY_EXPENSE NUMBER Depreciation expense of prior fiscal years.
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.
PRIOR_FY_BONUS_EXPENSE NUMBER Bonus depreciation expense from prior fiscal years.
DEPRN_OVERRIDE_FLAG VARCHAR2 1 Indicator as to whether the depreciation amount for the period is overridden or not.
SYSTEM_DEPRN_AMOUNT NUMBER System calculated depreciation amount.
SYSTEM_BONUS_DEPRN_AMOUNT NUMBER System calculated depreciation amount.
EVENT_ID NUMBER 18 Identifier of the transaction event which is associated with this row for accounting purposes.
DEPRN_RUN_ID NUMBER 18 Yes Identifier of the depreciation submission.
SET_OF_BOOKS_ID NUMBER 18 Yes Identifier of the accounting ledger.
REVERSAL_EVENT_ID NUMBER 18 Identifier of the transaction event which is associated with this depreciation reversal for accounting purposes.
REVERSAL_DATE DATE Date when the depreciation was reversed.
DEPRN_ADJUSTMENT_AMOUNT NUMBER Depreciation expense adjustment amount for the period.
BONUS_DEPRN_ADJUSTMENT_AMOUNT NUMBER Bonus depreciation adjustment amount.
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.
GENERAL_FUND NUMBER Value of general fund after considering impairment effect.
CAPITAL_ADJUSTMENT NUMBER Value of capital adjustment after considering impairment transaction.
IMPAIRMENT_AMOUNT NUMBER Total impairment loss recognized for the asset.
YTD_IMPAIRMENT NUMBER Year-to-date impairment amount.
IMPAIRMENT_RESERVE NUMBER Impairment loss amount of the asset.
IMPAIR_LOSS_BALANCE NUMBER Accumulated impairment expense.
REVAL_LOSS_BALANCE NUMBER Accumulated revaluation loss balance.
REVAL_AMORT_BALANCE NUMBER REVAL_AMORT_BALANCE
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.
DEPRN_ADJUSTMENT_FACTOR NUMBER Controls the speed of depreciation of an asset by multiplying this factor by the annual depreciation rate.
YTD_REVAL_AMORTIZATION NUMBER Year-to-date revaluation reserve amortization amount.
REVAL_AMORTIZATION_ADJUSTMENT NUMBER Revaluation reserve amortization amount calculated for the period by the adjustment transaction.
BACKLOG_DEPRN_RESERVE NUMBER Life-to-date backlog depreciation amount.
YTD_BACKLOG_DEPRN NUMBER Year-to-date backlog depreciation amount.

Foreign Keys

Table Foreign Table Foreign Key Column
FA_MC_DEPRN_SUMMARY_H fa_additions_b ASSET_ID
FA_MC_DEPRN_SUMMARY_H fa_book_controls BOOK_TYPE_CODE
FA_MC_DEPRN_SUMMARY_H fa_deprn_periods BOOK_TYPE_CODE, PERIOD_COUNTER
FA_MC_DEPRN_SUMMARY_H fa_deprn_events ASSET_ID, BOOK_TYPE_CODE, PERIOD_COUNTER, DEPRN_RUN_ID
FA_MC_DEPRN_SUMMARY_H fa_mc_book_controls SET_OF_BOOKS_ID, BOOK_TYPE_CODE
FA_MC_DEPRN_SUMMARY_H fa_mc_deprn_periods SET_OF_BOOKS_ID, BOOK_TYPE_CODE, PERIOD_COUNTER
FA_MC_DEPRN_SUMMARY_H gl_ledgers SET_OF_BOOKS_ID
fa_mc_deprn_detail_h fa_mc_deprn_summary_h SET_OF_BOOKS_ID, ASSET_ID, BOOK_TYPE_CODE, PERIOD_COUNTER, DEPRN_RUN_ID

Indexes

Index Uniqueness Tablespace Columns
FA_MC_DEPRN_SUMMARY_H_U1 Unique Default SET_OF_BOOKS_ID, ASSET_ID, BOOK_TYPE_CODE, PERIOD_COUNTER, DEPRN_RUN_ID
FA_MC_DEPRN_SUMMARY_H_U2 Unique Default EVENT_ID, SET_OF_BOOKS_ID