ReportingBookAssetPeriodicDepreciationDetail

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

Expand all

Collapse all

Business Views

** Available for extracting data

• reportingBookAssetPeriodicDepreciationDetailsExtract**

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

  Label

  Reporting Book 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
  • 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
  • conversionStatus (string)

    Indicates whether the transaction amounts have been converted to the reporting currency.

    Label

    Conversion Status

    Properties

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

    Total recorded cost of the asset.

    Label

    Cost

    Properties

    • searchable
    • sortable
  • costInPrimaryCurrency (big-decimal)

    Asset cost in the primary ledger currency posted to the asset clearing account when the asset is added.

    Label

    Cost in Primary Currency

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

    Adjustment to the depreciation amount in the primary ledger currency for retroactive asset transactions.

    Label

    Depreciation Adjustment in Primary Currency

    Properties

    • searchable
    • sortable
  • depreciationAmount (big-decimal)

    Asset depreciation expense amount.

    Label

    Depreciation Amount

    Properties

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

    Depreciation expense allocated to the distribution line for the current period in the primary functional currency.

    Label

    Depreciation Expense in Primary Currency

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

    Depreciation reserve in the primary functional currency for the asset allocated to the distribution line.

    Label

    Depreciation Reserve in Primary Currency

    Properties

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

    Code that identifies the ledger the accounting entry is created for.

    Label

    Ledger ID

    Properties

    • searchable
    • sortable
    • not nullable
  • 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
  • revaluationAmortizationInPrimaryCurrency (big-decimal)

    Amortization of revaluation reserve for assets in the primary ledger currency.

    Label

    Revaluation Amortization in Primary Currency

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

    Revaluation depreciation expense for assets in the primary ledger currency.

    Label

    Revaluation Expense in Primary Currency

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

    Revaluation reserve for assets in the primary ledger currency.

    Label

    Revaluation Reserve in Primary Currency

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

    Year-to-date depreciation amount for the asset in the primary ledger currency.

    Label

    Year-to-Date Depreciation Expense in Primary Currency

    Properties

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

    Year-to-date depreciation expense in the primary functional currency due to revaluation.

    Label

    YTD Revaluation Depreciation Expense in Primary Currency

    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

  • asset (Asset)

    An asset contains the descriptive information such as units, asset type, tag number, manufacturer number, serial number, and model number added in the asset book.

    Business Object

    Asset

    Expand all

    Collapse all

    Fields

    • assetId (int64)

      The identifier of the asset number.

      Label

      Asset ID

      Properties

      • searchable
      • sortable
      • not nullable

  • assetBook (AssetBook)

    A book represents the grouping in which fixed assets of the entity are recorded, tracked, depreciated, reported, and accounted for in the primary ledger.

    Business Object

    AssetBook

    Expand all

    Collapse all

    Fields

    • name (string)

      The name of the asset book.

      Label

      Book

      Properties

      • searchable
      • sortable
      • not nullable

  • 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