AssetLease

A lease stores information about assets that are leased, such as the lease terms, lessor, and whether the lease is an operating or capital lease asset.

Expand all

Collapse all

Business Views

** Available for extracting data

• assetLeasesExtract**

  A lease stores information about assets that are leased, such as the lease terms, lessor, and whether the lease is an operating or capital lease asset.

  Label

  Asset Leases

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • contractNumber (string)

    Unique identifier of the lease contract.

    Label

    Contract Number

    Properties

    • searchable
    • sortable
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

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

    The detailed description of the asset leases.

    Label

    Description

    Properties

    • searchable
    • sortable
    • not nullable
  • generatePaymentInvoiceCode (enumeration: GenerateLeasePaymentInvoiceCode)

    Indicates whether lease payment invoices are generated at the lease level or asset level.

    Label

    Generate Payment Invoices

    Type

    • Module: oraErpCoreFixedAssets

    • Enumeration Type: GenerateLeasePaymentInvoiceCode

    Properties

    • searchable
    • sortable
    • not nullable

    Valid Values

    • FA_ASSET_LEVEL
    • FA_LEASE_LEVEL
    • FA_NO_INVOICE
  • leaseId (int64)

    The unique identifier of the asset lease number.

    Label

    Lease ID

    Properties

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

    The unique identifier of the asset lease number.

    Label

    Lease Number

    Properties

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

    Date on which the lease payment starts according to the lease contract.

    Label

    Lease Start Date

    Properties

    • searchable
    • sortable
    • not nullable
  • paymentFrequencyCode (enumeration: LeasePaymentFrequencyCode)

    The intervals in which the lease amount is payable.

    Label

    Payment Frequency

    Type

    • Module: oraErpCoreFixedAssets

    • Enumeration Type: LeasePaymentFrequencyCode

    Properties

    • searchable
    • sortable
    • not nullable

    Valid Values

    • FA_ANNUALLY
    • FA_MONTHLY
    • FA_QUARTERLY
    • FA_SEMI_ANNUALLY
  • paymentOptionTypeCode (enumeration: LeasePaymentOptionTypeCode)

    Indicates whether the lease payment is paid in advance or in arrears.

    Label

    Payment Option

    Type

    • Module: oraErpCoreFixedAssets

    • Enumeration Type: LeasePaymentOptionTypeCode

    Properties

    • searchable
    • sortable
    • not nullable

    Valid Values

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

Back to Top