AssetLeaseExpenseSummary

A lease expense summary contains the lease interest expense and lease expense values for a leased asset for each period.

Expand all

Collapse all

Business Views

** Available for extracting data

• assetLeaseExpenseSummariesExtract**

  A lease expense summary contains the lease interest expense and lease expense values for a leased asset for each period.

  Label

  Asset Lease Expense Summaries

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • assetId (int64)

    The identifier of the asset number.

    Label

    Asset ID

    Properties

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

    The weighted average exchange rate used to convert the lease payments from the primary currency to the reporting currency.

    Label

    Invoice Date Rate

    Properties

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

    The basis used for calculating the periodic lease expense of the asset.

    Label

    Lease Expense Basis

    Properties

    • searchable
    • sortable
  • leaseExpenseSummaryId (int64)

    Lease expense summary identification number.

    Label

    Lease Expense Summary 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
  • leasePeriodEndFlag (boolean)

    Indicates the end of the lease period for quarterly, semiannual, and annual leases.

    Label

    Lease Period End Indicator

    Properties

    • searchable
    • sortable
  • leasePeriodStartFlag (boolean)

    Indicates the beginning of the lease period for quarterly, semiannual, and annual leases.

    Label

    Lease Period Start Indicator

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

Back to Top