AssetPeriodicDepreciationSummary

A periodic depreciation summary history shows depreciation information used to audit and inquire on transactions accounted for in Oracle Subledger Accounting.

Expand all

Collapse all

Business Views

** Available for extracting data

• assetPeriodicDepreciationSummariesExtract**

  A periodic depreciation summary history shows depreciation information used to audit and inquire on transactions accounted for in Oracle Subledger Accounting.

  Label

  Asset Periodic Depreciation Summaries

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • adjustedCost (big-decimal)

    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.

    Label

    Adjusted Cost

    Properties

    • searchable
    • sortable
    • not nullable
  • assetId (int64)

    The identifier of the asset number.

    Label

    Asset ID

    Properties

    • searchable
    • sortable
    • not nullable
  • backlogDepreciationReserve (big-decimal)

    Life-to-date backlog depreciation amount.

    Label

    Backlog Depreciation Reserve

    Properties

    • searchable
    • sortable
  • bonusAdjustedCost (big-decimal)

    Amount used to calculate the periodic bonus depreciation amount.

    Label

    Bonus Adjusted Cost

    Properties

    • searchable
    • sortable
  • bonusDepreciationAdjustmentAmount (big-decimal)

    Adjustment to the bonus depreciation amount for retroactive asset transactions.

    Label

    Bonus Depreciation Adjustment Amount

    Properties

    • searchable
    • sortable
  • bonusDepreciationAmount (big-decimal)

    Depreciation expense calculated due to bonus depreciation.

    Label

    Bonus Depreciation Amount

    Properties

    • searchable
    • sortable
  • bonusDepreciationReserve (big-decimal)

    The total amount of bonus depreciation recorded against an asset.

    Label

    Bonus Depreciation Reserve

    Properties

    • searchable
    • sortable
  • bonusRate (big-decimal)

    Rate for calculating bonus depreciation amounts.

    Label

    Bonus Rate

    Properties

    • searchable
    • sortable
  • bonusYtdDepreciation (big-decimal)

    The year-to-date bonus depreciation amount.

    Label

    Bonus YTD Depreciation

    Properties

    • searchable
    • sortable
  • bookName (string)

    The name of the asset book.

    Label

    Book

    Properties

    • searchable
    • sortable
    • not nullable
  • capitalAdjustment (big-decimal)

    Capital adjustment balance for the period.

    Label

    Capital Adjustment

    Properties

    • searchable
    • sortable
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • searchable
    • sortable
    • not nullable
  • depreciationAdjustmentAmount (big-decimal)

    Adjustment to the depreciation amount for retroactive asset transactions.

    Label

    Depreciation Adjustment Amount

    Properties

    • searchable
    • sortable
  • depreciationAdjustmentFactor (big-decimal)

    Multiplier of the annual depreciation rate used to speed up or slow down the asset depreciation.

    Label

    Depreciation Adjustment Factor

    Properties

    • searchable
    • sortable
  • depreciationAmount (big-decimal)

    Asset depreciation expense amount.

    Label

    Depreciation Amount

    Properties

    • searchable
    • sortable
    • not nullable
  • depreciationOverride (string)

    Indicates whether a depreciation override amount is allowed for assets in the book.

    Label

    Depreciation Override Indicator

    Properties

    • searchable
    • sortable
  • depreciationReserve (big-decimal)

    Total depreciation expense including the bonus depreciation recognized for the asset.

    Label

    Depreciation Reserve

    Properties

    • searchable
    • sortable
    • not nullable
  • depreciationRunDate (date)

    Date the Calculate Depreciation process was run.

    Label

    Depreciation Run Date

    Properties

    • searchable
    • sortable
    • not nullable
  • depreciationSourceCode (string)

    Indicates whether the depreciation record was created by the Books page, by running the Calculate Depreciation process, or by the Member Asset Tracking functionality.

    Label

    Depreciation Source Code

    Properties

    • searchable
    • sortable
    • not nullable
  • generalFund (big-decimal)

    General fund balance for the period.

    Label

    General Fund Amount

    Properties

    • searchable
    • sortable
  • impairmentAmount (big-decimal)

    Impairment loss amount of the asset.

    Label

    Impairment Amount

    Properties

    • searchable
    • sortable
  • impairmentLossBalance (big-decimal)

    Net impairment loss balance amount for the asset.

    Label

    Impairment Loss Balance

    Properties

    • searchable
    • sortable
  • impairmentReserve (big-decimal)

    Total impairment loss recognized for the asset.

    Label

    Impairment Reserve

    Properties

    • searchable
    • sortable
  • lifeToDateProduction (big-decimal)

    Life-to-date production for a units of production depreciation method.

    Label

    Life-to-Date Production

    Properties

    • searchable
    • sortable
  • periodId (int64)

    Identifier of the depreciation period.

    Label

    Period ID

    Properties

    • searchable
    • sortable
    • not nullable
  • priorFiscalYearExpense (big-decimal)

    The depreciation expense amount related to the previous fiscal year.

    Label

    Prior Fiscal Year Expense

    Properties

    • searchable
    • sortable
  • priorYearBonusExpenseAmount (big-decimal)

    The bonus depreciation expense amount related to the previous fiscal year.

    Label

    Prior Year Bonus Expense Amount

    Properties

    • searchable
    • sortable
  • productionQuantity (big-decimal)

    Current period production for a units of production asset.

    Label

    Production Quantity

    Properties

    • searchable
    • sortable
  • revaluationAmortization (big-decimal)

    Amount of revaluation reserve amortized during this period.

    Label

    Revaluation Amortization

    Properties

    • searchable
    • sortable
  • revaluationAmortizationBalance (big-decimal)

    Accumulated revaluation reserve amortization.

    Label

    Revaluation Amortization Balance

    Properties

    • searchable
    • sortable
  • revaluationAmortizationBasis (big-decimal)

    The revaluation reserve amortization basis amount of the asset.

    Label

    Revaluation Amortization Basis

    Properties

    • searchable
    • sortable
  • revaluationDepreciationExpense (big-decimal)

    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's used for reporting purposes only.

    Label

    Revaluation Depreciation Expense

    Properties

    • searchable
    • sortable
  • revaluationLossBalance (big-decimal)

    The revaluation loss balance of the asset after revaluation.

    Label

    Revaluation Loss Balance

    Properties

    • searchable
    • sortable
  • revaluationReserve (big-decimal)

    Life-to-date revaluation reserve amount.

    Label

    Revaluation Reserve

    Properties

    • searchable
    • sortable
  • revaluationReserveAmortizationAdjustmentAmount (big-decimal)

    Revaluation reserve amortization amount calculated for the period by the adjustment transaction.

    Label

    Revaluation Reserve Amortization Adjustment Amount

    Properties

    • searchable
    • sortable
  • systemBonusDepreciation (big-decimal)

    Bonus depreciation amount calculated by the application.

    Label

    System Bonus Depreciation

    Properties

    • searchable
    • sortable
  • systemDepreciation (big-decimal)

    Depreciation amount calculated by the application.

    Label

    System Depreciation

    Properties

    • searchable
    • sortable
  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • searchable
    • sortable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • sortable
    • not nullable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • searchable
    • sortable
    • not nullable
  • ytdBacklogDepreciation (big-decimal)

    Year-to-date backlog depreciation amount.

    Label

    YTD Backlog Depreciation

    Properties

    • searchable
    • sortable
  • ytdDepreciation (big-decimal)

    Year-to-date depreciation amount.

    Label

    YTD Depreciation

    Properties

    • searchable
    • sortable
    • not nullable
  • ytdImpairment (big-decimal)

    Year-to-date impairment amount.

    Label

    YTD Impairment

    Properties

    • searchable
    • sortable
  • ytdProduction (big-decimal)

    Year-to-date production for assets depreciating in units of production methods.

    Label

    YTD Production

    Properties

    • searchable
    • sortable
  • ytdRevaluationDepreciationExpense (big-decimal)

    Year-to-date depreciation expense due to revaluation. Oracle Assets doesn't create any journal entries for this amount. It's for reporting purposes only.

    Label

    YTD Revaluation Depreciation Expense

    Properties

    • searchable
    • sortable
  • ytdRevaluationReserveAmortization (big-decimal)

    Year-to-date revaluation reserve amortization amount.

    Label

    YTD Revaluation Reserve Amortization

    Properties

    • searchable
    • sortable

  Expand all

  Collapse all

  Reference Object

  • subledgerAccountingEvent (SubledgerAccountingEvent)

    A Subledger Accounting event is an event raised to account for the Subledger Accounting transaction.

    Business Object

    SubledgerAccountingEvent

    Expand all

    Collapse all

    Fields

    • eventId (int64)

      The unique identifier of the accounting event within an application and event class.

      Label

      Event Identifier

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top