Depreciation Summaries

The Depreciation Summaries view object contains depreciation information for the assets.

Data Store Key : FscmTopModelAM.FinExtractAM.FaBiccExtractAM.DepreciationSummaryExtractPVO

Primary Keys : DepreciationSummaryAssetId, DepreciationSummaryBookTypeCode, DepreciationSummaryPeriodCounter

Initial Extract Date : DepreciationSummaryCreationDate

Incremental Extract Date : DepreciationSummaryLastUpdateDate

Attributes

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

Name Description
DepreciationSummaryAdjustedCost Depreciable basis of the asset, calculated as the recoverable cost for cost basis depreciation methods and the recoverable cost minus the accumulated depreciation for net book value basis methods.
DepreciationSummaryAssetId Identifier of the asset number.
DepreciationSummaryBacklogDeprnReserve Life-to-date backlog depreciation amount.
DepreciationSummaryBonusDeprnAdjustmentAmount Adjustment to the bonus depreciation amount for retroactive asset transactions.
DepreciationSummaryBonusDeprnAmount Depreciation expense calculated due to bonus depreciation.
DepreciationSummaryBonusDeprnReserve The total amount of bonus depreciation recorded against an asset.
DepreciationSummaryBonusRate Rate for calculating bonus depreciation amounts.
DepreciationSummaryBonusYtdDeprn The year-to-date bonus depreciation amount.
DepreciationSummaryBookTypeCode Name of the asset book.
DepreciationSummaryCapitalAdjustment Capital adjustment balance for the period.
DepreciationSummaryCreatedBy The user who last updated the depreciation summary row.
DepreciationSummaryCreationDate The date the depreciation summary row was created.
DepreciationSummaryDeprnAdjustmentAmount Adjustment to the depreciation amount for retroactive asset transactions.
DepreciationSummaryDeprnAdjustmentFactor Depreciation Rate Adjustment Factor
DepreciationSummaryDeprnAmount Depreciation amount calculated for an asset.
DepreciationSummaryDeprnOverrideFlag Indicates whether a depreciation override amount is allowed for assets in the book.
DepreciationSummaryDeprnReserve Total depreciation expense for the asset.
DepreciationSummaryDeprnRunDate Date the Calculate Depreciation process was run.
DepreciationSummaryDeprnRunId 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.
DepreciationSummaryDeprnSourceCode Indicates whether the depreciation record was created by running the Calculate Depreciation process or by the Member Asset Tracking functionality.
DepreciationSummaryEventId Identifier of the transaction event that is associated with this row for accounting purposes.
DepreciationSummaryGeneralFund General fund balance for the period.
DepreciationSummaryImpairLossBalance Impairment Loss Balance
DepreciationSummaryImpairmentAmount Impairment loss amount of the asset.
DepreciationSummaryImpairmentReserve The impairment reserve amount.
DepreciationSummaryLastUpdateDate The date the depreciation summary row was updated.
DepreciationSummaryLastUpdateLogin The session login associated with the user who last updated the depreciation summary row.
DepreciationSummaryLastUpdatedBy The user who last updated the depreciation summary row.
DepreciationSummaryLtdProduction Life-to-date production for a units of production depreciation method.
DepreciationSummaryObjectVersionNumber The number of times the Depreciation Summary row has been updated.
DepreciationSummaryPeriodCounter Identifier of the depreciation period.
DepreciationSummaryPriorFyBonusExpense Bonus depreciation expense from prior fiscal years.
DepreciationSummaryPriorFyExpense Depreciation expense for prior fiscal years.
DepreciationSummaryProduction Indicates the Units of Production depreciation method used for assets.
DepreciationSummaryRevalAmortBalance Revaluation Amortization Balance
DepreciationSummaryRevalAmortization Amount of revaluation reserve amortized during the current period.
DepreciationSummaryRevalAmortizationAdjustment Revaluation Reserve Amortization Adjustment Amount
DepreciationSummaryRevalAmortizationBasis The revaluation reserve amortization basis amount of the asset.
DepreciationSummaryRevalDeprnExpense 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 purposes only.
DepreciationSummaryRevalLossBalance The revaluation loss balance of the asset.
DepreciationSummaryRevalReserve The revaluation reserve of the assets.
DepreciationSummarySystemBonusDeprnAmount Bonus depreciation amount calculated by the application.
DepreciationSummarySystemDeprnAmount Depreciation amount calculated by the application.
DepreciationSummaryYtdBacklogDeprn Year-to-date backlog depreciation amount.
DepreciationSummaryYtdDeprn Year-to-date depreciation expense.
DepreciationSummaryYtdImpairment Year-to-date impairment amount.
DepreciationSummaryYtdProduction Year-to-date production for assets depreciating in units of production methods.
DepreciationSummaryYtdRevalAmortization Year-to-date revaluation reserve amortization amount.
DepreciationSummaryYtdRevalDeprnExpense 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.