AssetPeriodicDepreciationDetail

The periodic depreciation detail stores the depreciation amount for each of the assets in the asset book calculated by the Calculate Depreciation process and generates depreciation expense journal entries.

Expand all

Collapse all

Business Views

** Available for extracting data

• assetPeriodicDepreciationDetailsExtract**

  This view contains the distribution details, descriptive details, depreciation period, and depreciation amount for each of the assets in the asset book calculated by the Calculate Depreciation process, and generates depreciation expense journal entries.

  Label

  Asset Periodic Depreciation Details

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • additionCostToClear (big-decimal)

    The asset cost posted to the asset clearing account when the asset is added.

    Label

    Addition Cost to Clear

    Properties

    • searchable
    • sortable
  • 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
  • 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
  • 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
  • cost (big-decimal)

    Total recorded cost of the asset.

    Label

    Cost

    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
  • depreciationAmount (big-decimal)

    Asset depreciation expense amount.

    Label

    Depreciation Amount

    Properties

    • searchable
    • sortable
    • not nullable
  • 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
  • depreciationRunId (int64)

    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.

    Label

    Depreciation Run ID

    Properties

    • searchable
    • sortable
  • 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
  • distributionId (int64)

    Identifier of the asset distribution line.

    Label

    Distribution ID

    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
  • impairmentReserve (big-decimal)

    Total impairment loss recognized for the asset.

    Label

    Impairment Reserve

    Properties

    • searchable
    • sortable
  • periodId (int64)

    Identifier of the depreciation period.

    Label

    Period ID

    Properties

    • searchable
    • sortable
    • not nullable
  • 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
  • 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
  • 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
  • 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
  • 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