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. |