Depreciation Details

The Depreciation Details view object contains the depreciation amounts that the Calculate Depreciation process charges to the depreciation expense account in each distribution line. Oracle Fusion Assets uses this information to create depreciation expense journal entries.

Data Store Key : FscmTopModelAM.FinExtractAM.FaBiccExtractAM.DepreciationDetailExtractPVO

Primary Keys : DepreciationDetailDistributionId, DepreciationDetailBookTypeCode, DepreciationDetailPeriodCounter, DepreciationDetailAssetId

Initial Extract Date : DepreciationDetailCreationDate

Incremental Extract Date : DepreciationDetailLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
DepreciationDetailAccDeprnAdjustmentAmount	Adjustment amount calculated for retroactive adjustments included in the accelerated depreciation for the period.
DepreciationDetailAcceleratedDeprnAmount	Adjustment to the accelerated depreciation amount for retroactive asset transactions.
DepreciationDetailAcceleratedDeprnReserve	Accelerated depreciation reserve balance for the period.
DepreciationDetailAcceleratedYtdDeprn	Year-to-date accelerated depreciation balance for the period.
DepreciationDetailAdditionCostToClear	The asset cost posted to the asset clearing account when the asset is added.
DepreciationDetailAssetId	Identifier of the asset number.
DepreciationDetailBacklogDeprnReserve	Backlog Depreciation Reserve
DepreciationDetailBonusDeprnAdjustmentAmount	Adjustment to the bonus depreciation amount for retroactive asset transactions.
DepreciationDetailBonusDeprnAmount	Depreciation expense calculated due to bonus depreciation.
DepreciationDetailBonusDeprnReserve	Life-to-date backlog depreciation amount.
DepreciationDetailBonusYtdDeprn	Accelerated bonus depreciation year-to-date balance for the period.
DepreciationDetailBookTypeCode	The name of the asset book.
DepreciationDetailCapitalAdjustment	Capital adjustment balance for the period.
DepreciationDetailCost	Total recorded cost of the asset.
DepreciationDetailCreatedBy	The user who created the depreciation detail row.
DepreciationDetailCreationDate	The date the transaction was created in the depreciation detail row.
DepreciationDetailDeprnAdjustmentAmount	Adjustment to the depreciation amount for retroactive asset transactions.
DepreciationDetailDeprnAmount	Asset depreciation expense amount.
DepreciationDetailDeprnReserve	Total depreciation expense including the bonus depreciation recognized for the asset.
DepreciationDetailDeprnRunDate	Date the Calculate Depreciation process was run.
DepreciationDetailDeprnRunId	The identification number of the Calculate Depreciation process instance. This attribute is used in the SLA subject area to analyze accounting information for the asset depreciation.
DepreciationDetailDeprnSourceCode	Indicates whether the depreciation record was created by running the Calculate Depreciation process or by the Member Asset Tracking functionality.
DepreciationDetailDistributionId	Identifier of the asset distribution line.
DepreciationDetailEventId	Identifier of the transaction event, which is associated with this row for accounting purposes.
DepreciationDetailGeneralFund	General fund balance for the period.
DepreciationDetailImpairmentAmount	Impairment loss balance of the asset immediately after the impairment.
DepreciationDetailImpairmentReserve	The impairment reserve amount.
DepreciationDetailLastUpdateDate	The date the transaction was updated in the FA_DEPRN_DETAIL row.
DepreciationDetailLastUpdateLogin	The session login associated with the user who last updated the FA_DEPRN_DETAIL row.
DepreciationDetailLastUpdatedBy	The user who last updated the FA_DEPRN_DETAIL row.
DepreciationDetailObjectVersionNumber	The number of times the Reporting Depreciation Detail row has been updated.
DepreciationDetailPeriodCounter	Identifier of the depreciation period.
DepreciationDetailRevalAmortBalance	Revaluation Amortization Balance
DepreciationDetailRevalAmortization	Amount of revaluation reserve amortized during this period.
DepreciationDetailRevalAmortizationAdjustment	Revaluation reserve amortization amount calculated for the period by the adjustment transaction.
DepreciationDetailRevalDeprnExpense	Portion of depreciation expense generated due to revaluation of the asset cost. Oracle Fusion Assets doesn't create any journal entries for this amount. It is for reporting purposes only.
DepreciationDetailRevalReserve	Periodic revaluation reserve amortization amount for the asset.
DepreciationDetailYtdBacklogDeprn	Year-to-date backlog depreciation amount.
DepreciationDetailYtdDeprn	Year-to-date depreciation expense.
DepreciationDetailYtdImpairment	Year-to-date impairment amount.
DepreciationDetailYtdRevalAmortization	Year-to-date revaluation reserve amortization amount.
DepreciationDetailYtdRevalDeprnExpense	Year-to-date depreciation expense due to revaluation. Oracle Fusion Assets doesn't create any journal entries for this amount. It is for reporting purposes only.