ReportingBookAssetLeaseExpenseDetail

A lease expense detail stores lease expense details for each asset associated with the lease at the distribution level in the reporting asset book.

Expand all

Collapse all

Business Views

** Available for extracting data

• reportingBookAssetLeaseExpenseDetailsExtract**

  A lease expense detail stores lease expense details for each asset associated with the lease at the distribution level in the reporting asset book.

  Label

  Reporting Book Asset Lease Expense Details

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • bookName (string)

    The name of the asset book.

    Label

    Book

    Properties

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

    The user who created the record.

    Label

    Created By

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

    The depreciation reserve adjustment amount for the period.

    Label

    Depreciation Reserve Adjustment Amount

    Properties

    • searchable
    • sortable
  • distributionId (int64)

    Identifier of the asset distribution line.

    Label

    Distribution ID

    Properties

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

    Periodic lease expense adjustment amount for type B leased assets.

    Label

    Lease Expense Adjustment Amount

    Properties

    • searchable
    • sortable
  • leaseExpenseAmount (big-decimal)

    Lease expense amount for the asset for the period.

    Label

    Lease Expense Amount

    Properties

    • searchable
    • sortable
  • leaseExpenseDetailId (int64)

    Number that uniquely identifies the lease expense event.

    Label

    Lease Expense Detail ID

    Properties

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

    Interest adjustment on lease liability calculated for the leased asset.

    Label

    Lease Interest Adjustment Amount

    Properties

    • searchable
    • sortable
  • leaseInterestAmount (big-decimal)

    The interest on lease liability charged to this account.

    Label

    Lease Interest Amount

    Properties

    • searchable
    • sortable
  • leaseLiability (big-decimal)

    Account code combination identifier used to account for the lease liability.

    Label

    Lease Liability

    Properties

    • searchable
    • sortable
  • leasePayment (big-decimal)

    The amount of the periodic lease payment that the lessee pays to the lessor.

    Label

    Lease Payment

    Properties

    • searchable
    • sortable
  • leasePaymentAdjustmentAmount (big-decimal)

    Lease payment adjustment amount for the period.

    Label

    Lease Payment Adjustment Amount

    Properties

    • searchable
    • sortable
  • leaseRateGainLossAmount (big-decimal)

    Gain or loss amount on lease liability for the currency exchange rate changes.

    Label

    Lease Rate Gain Loss Amount

    Properties

    • searchable
    • sortable
  • leaseSourceCode (string)

    Source from which the lease record was created. Possible values are B (books) and L (lease).

    Label

    Lease Source Code

    Properties

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

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

    Label

    Ledger ID

    Properties

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

    Accumulated lease expense for the asset.

    Label

    Life-to-Date Lease Expense Amount

    Properties

    • searchable
    • sortable
  • periodId (int64)

    The identifier of the asset calendar period.

    Label

    Period ID

    Properties

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

    The accumulated depreciation charged for the asset for the period.

    Label

    Periodic Depreciation Reserve

    Properties

    • searchable
    • sortable
  • periodicLeaseClearingAmount (big-decimal)

    Periodic payment invoice amount transferred to Oracle Payables.

    Label

    Periodic Lease Clearing Amount

    Properties

    • searchable
    • sortable
  • periodicLeaseLiabilityAmount (big-decimal)

    Reduction in lease liability due to the lease payments made to the lessor.

    Label

    Periodic Lease Liability 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
  • ytdLeaseExpenseAmount (big-decimal)

    Year-to-date lease expense amount for the asset.

    Label

    YTD Lease Expense Amount

    Properties

    • searchable
    • sortable
  • ytdLeaseInterestAmount (big-decimal)

    Year-to-date lease interest expense for the asset.

    Label

    YTD Lease Interest Amount

    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

Back to Top