Reporting Depreciation Details

The Reporting Depreciation Details view object contains currency and financial information about asset depreciation in each reporting book. It stores depreciation detail information of tax books that have secondary ledgers with different currencies.

Data Store Key : FscmTopModelAM.FinExtractAM.FaBiccExtractAM.ReportingDepreciationDetailExtractPVO

Primary Keys : ReportingDepreciationDetailSetOfBooksId, ReportingDepreciationDetailPeriodCounter, ReportingDepreciationDetailBookTypeCode, ReportingDepreciationDetailAssetId, ReportingDepreciationDetailDistributionId

Initial Extract Date : ReportingDepreciationDetailCreationDate

Incremental Extract Date : ReportingDepreciationDetailLastUpdateDate

Attributes

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

Name	Description
ReportingDepreciationDetailAccDeprnAdjustmentAmount	Adjustment amount calculated for retroactive adjustments included in the accelerated depreciation for the period.
ReportingDepreciationDetailAcceleratedDeprnAmount	Adjustment to the accelerated depreciation amount for retroactive asset transactions.
ReportingDepreciationDetailAcceleratedDeprnReserve	Accelerated depreciation reserve balance for the period.
ReportingDepreciationDetailAcceleratedYtdDeprn	Year-to-date accelerated depreciation balance for the period.
ReportingDepreciationDetailAdditionCostToClear	The asset cost posted to the asset clearing account when the asset is added.
ReportingDepreciationDetailAssetId	Identifier of the asset number.
ReportingDepreciationDetailBacklogDeprnReserve	Life-to-date backlog depreciation amount.
ReportingDepreciationDetailBonusDeprnAdjustmentAmount	Adjustment to the bonus depreciation amount for retroactive asset transactions.
ReportingDepreciationDetailBonusDeprnAmount	Bonus depreciation expense for the depreciation period.
ReportingDepreciationDetailBonusDeprnReserve	Total bonus depreciation taken since the beginning of the asset life.
ReportingDepreciationDetailBonusYtdDeprn	The year-to-date bonus depreciation amount.
ReportingDepreciationDetailBookTypeCode	Name of the asset book.
ReportingDepreciationDetailCapitalAdjustment	Capital adjustment balance for the period.
ReportingDepreciationDetailConvertedFlag	Indicates whether the transaction amounts have been converted to the reporting currency.
ReportingDepreciationDetailCost	Total recorded cost of the asset.
ReportingDepreciationDetailCreatedBy	The user who created the depreciation detail row.
ReportingDepreciationDetailCreationDate	The date the transaction was created in the depreciation detail row.
ReportingDepreciationDetailDeprnAdjustmentAmount	Adjustment to the depreciation amount for retroactive asset transactions.
ReportingDepreciationDetailDeprnAmount	Asset depreciation expense amount.
ReportingDepreciationDetailDeprnReserve	Total depreciation expense including the bonus depreciation recognized for the asset.
ReportingDepreciationDetailDeprnRunDate	Asset depreciation expense amount.
ReportingDepreciationDetailDeprnRunId	The identification number of the asset depreciation process instance. This attribute is used in the SLA subject area to analyze the accounting information of the asset depreciation.
ReportingDepreciationDetailDeprnSourceCode	Indicates whether the depreciation record was created by the Books page, by running the Calculate Depreciation process, or by the Member Asset Tracking functionality.
ReportingDepreciationDetailDistributionId	Identifier of the asset distribution line.
ReportingDepreciationDetailEventId	Identifier of the transaction event that is associated with this row for accounting purposes.
ReportingDepreciationDetailGeneralFund	General fund balance for the period.
ReportingDepreciationDetailImpairmentAmount	Impairment loss expense balance for the period.
ReportingDepreciationDetailImpairmentReserve	The impairment reserve amount.
ReportingDepreciationDetailLastUpdateDate	The date the transaction was updated in the FA_DEPRN_DETAIL table.
ReportingDepreciationDetailLastUpdateLogin	The session login associated with the user who last updated the FA_DEPRN_DETAIL row.
ReportingDepreciationDetailLastUpdatedBy	The user who last updated the FA_DEPRN_DETAIL row.
ReportingDepreciationDetailObjectVersionNumber	The number of times the Reporting Depreciation Detail row has been updated.
ReportingDepreciationDetailPeriodCounter	Identifier of the depreciation period.
ReportingDepreciationDetailRevalAmortBalance	Life-to-date revaluation reserve amortization amount.
ReportingDepreciationDetailRevalAmortization	Amount of revaluation reserve amortized during this period.
ReportingDepreciationDetailRevalAmortizationAdjustment	Periodic revaluation reserve amortization adjustment amount for the asset.
ReportingDepreciationDetailRevalDeprnExpense	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.
ReportingDepreciationDetailRevalReserve	Periodic revaluation reserve amortization amount for the asset.
ReportingDepreciationDetailSetOfBooksId	Identifier of the accounting ledger.
ReportingDepreciationDetailSourceAdditionCostToClear	The asset cost posted to the asset clearing account when the asset is added.
ReportingDepreciationDetailSourceDeprnAdjustmentAmount	Adjustment to the depreciation amount for retroactive asset transactions.
ReportingDepreciationDetailSourceDeprnAmount	Depreciation expense allocated to the distribution line for the current period in the primary functional currency.
ReportingDepreciationDetailSourceDeprnReserve	Depreciation reserve in the primary functional currency for the asset allocated to the distribution line.
ReportingDepreciationDetailSourceRevalAmortization	Amount of revaluation reserve in the primary functional currency that is amortized during a period.
ReportingDepreciationDetailSourceRevalDeprnExpense	Portion of depreciation expense in the primary functional currency 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.
ReportingDepreciationDetailSourceRevalReserve	For a period in which this asset was revalued, the change in net book value due to revaluation of the asset cost and sometimes revaluation of the depreciation reserve. For all other periods, the revaluation reserve amount after depreciation is calculated.
ReportingDepreciationDetailSourceYtdDeprn	Year-to-date depreciation amount.
ReportingDepreciationDetailSourceYtdRevalDeprnExpense	Year-to-date depreciation expense in the primary functional currency due to revaluation.
ReportingDepreciationDetailYtdBacklogDeprn	Year-to-date backlog depreciation amount.
ReportingDepreciationDetailYtdDeprn	Year-to-date depreciation expense.
ReportingDepreciationDetailYtdImpairment	Year-to-date impairment amount.
ReportingDepreciationDetailYtdRevalAmortization	Year-to-date revaluation reserve amortization amount.
ReportingDepreciationDetailYtdRevalDeprnExpense	Year-to-date depreciation expense due to revaluation. Oracle Fusion Assets does' nt create any journal entries for this amount. It is for reporting only.