FA_MC_DEPRN_DETAIL
FA_MC_DEPRN_DETAIL contains currency and financial information about asset depreciation in each reporting book. It is an MRC sub-table of FA_DEPRN_DETAIL.
Details
-
Schema: FUSION
-
Object owner: FA
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
FA_MC_DEPRN_DETAIL_PK |
SET_OF_BOOKS_ID, DISTRIBUTION_ID, BOOK_TYPE_CODE, PERIOD_COUNTER |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
DISTRIBUTION_ID | NUMBER | 18 | Yes | Identifier of the asset distribution. | |
BOOK_TYPE_CODE | VARCHAR2 | 30 | Yes | Unique book identification name. | |
ASSET_ID | NUMBER | 18 | Yes | Identifier of the asset number. | |
PERIOD_COUNTER | NUMBER | 18 | Yes | Identifier of the depreciation period. | |
SET_OF_BOOKS_ID | NUMBER | 18 | Yes | Identifier of the accounting ledger. | |
DEPRN_SOURCE_CODE | VARCHAR2 | 1 | Yes | The source from where the depreciation record was created. Possible values are BOOKS, DEPRN, and TRACK. | |
DEPRN_RUN_DATE | DATE | Yes | The system date when depreciation was run. | ||
DEPRN_AMOUNT | NUMBER | Yes | Asset depreciation expense amount. | ||
YTD_DEPRN | NUMBER | Yes | Year-to-date depreciation expense. | ||
DEPRN_RESERVE | NUMBER | Yes | Total depreciation expense including the bonus depreciation recognized for the asset. | ||
ADDITION_COST_TO_CLEAR | NUMBER | Asset cost in row for period before period you added the asset. | |||
COST | NUMBER | Total recorded cost of the asset. | |||
DEPRN_ADJUSTMENT_AMOUNT | NUMBER | Depreciation expense adjustment amount for the period. | |||
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 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. | |||
SOURCE_DEPRN_AMOUNT | NUMBER | Depreciation expense allocated to the distribution line for the current period in the primary functional currency. | |||
SOURCE_YTD_DEPRN | NUMBER | Year to date depreciation expense, in the primary functional currency, allocated to the distribution line. | |||
SOURCE_DEPRN_RESERVE | NUMBER | Depreciation reserve, in the primary functional currency, for the asset allocated to the distribution line. | |||
SOURCE_ADDITION_COST_TO_CLEAR | NUMBER | Asset cost in row for period before period you added the asset in the primary functional currency. | |||
SOURCE_DEPRN_ADJUSTMENT_AMOUNT | NUMBER | Depreciation adjustment amount in the primary functional currency. | |||
SOURCE_REVAL_AMORTIZATION | NUMBER | Amount of revaluation reserve, in primary functional currency, amortized during a period. | |||
SOURCE_REVAL_DEPRN_EXPENSE | NUMBER | Portion of depreciation expense, in the primary functional currency, due to revaluation of the asset cost. Oracle Assets does not create any journal entries for this amount. It is for reporting only. | |||
SOURCE_REVAL_RESERVE | NUMBER | For a period in which this asset was revalued, change in net book value due to revaluation of the asset cost and sometimes revaluation of depreciation reserve. For all other periods: revaluation reserve amount after depreciation run. | |||
SOURCE_YTD_REVAL_DEPRN_EXPENSE | NUMBER | Year to date depreciation expense, in the primary functional currency, due to revaluation. | |||
CONVERTED_FLAG | VARCHAR2 | 1 | Yes | Status Indicating whether the transaction amounts have been converted to the reporting currency. | |
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_DEPRN_ADJUSTMENT_AMOUNT | NUMBER | Bonus depreciation adjustment amount. | |||
EVENT_ID | NUMBER | 18 | Identifier of the transaction event which is associated with this row for accounting purposes. | ||
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. | |||
DEPRN_RUN_ID | NUMBER | 18 | Identifier of the depreciation submission. | ||
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. | |
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. | |||
REVAL_AMORT_BALANCE | NUMBER | Accumulated revaluation amortization. | |||
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. | |||
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. | |||
ANNUITY_INTEREST_ADJ_AMOUNT | NUMBER | Annuity interest expense adjustment amount. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
FA_MC_DEPRN_DETAIL | fa_book_controls | BOOK_TYPE_CODE |
FA_MC_DEPRN_DETAIL | gl_ledgers | SET_OF_BOOKS_ID |
FA_MC_DEPRN_DETAIL | fa_additions_b | ASSET_ID |
FA_MC_DEPRN_DETAIL | fa_distribution_history | DISTRIBUTION_ID, BOOK_TYPE_CODE |
FA_MC_DEPRN_DETAIL | fa_deprn_periods | BOOK_TYPE_CODE, PERIOD_COUNTER |
FA_MC_DEPRN_DETAIL | fa_mc_book_controls | SET_OF_BOOKS_ID, BOOK_TYPE_CODE |
FA_MC_DEPRN_DETAIL | fa_mc_deprn_periods | SET_OF_BOOKS_ID, BOOK_TYPE_CODE, PERIOD_COUNTER |
FA_MC_DEPRN_DETAIL | fa_mc_deprn_summary | SET_OF_BOOKS_ID, ASSET_ID, BOOK_TYPE_CODE, PERIOD_COUNTER |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
FA_MC_DEPRN_DETAIL_N1 | Non Unique | Default | SET_OF_BOOKS_ID, ASSET_ID, BOOK_TYPE_CODE, PERIOD_COUNTER |
FA_MC_DEPRN_DETAIL_N2 | Non Unique | Default | SET_OF_BOOKS_ID, BOOK_TYPE_CODE, PERIOD_COUNTER |
FA_MC_DEPRN_DETAIL_U1 | Unique | Default | SET_OF_BOOKS_ID, DISTRIBUTION_ID, BOOK_TYPE_CODE, PERIOD_COUNTER |