PayablesPaymentHistory

The payment history provides the clearing or unclearing status details of payments, as well as the maturity history for future dated payments. Each future dated payment is represented by a row once it matures. Additionally, a row is created in the payment history when a payment is cleared or uncleared.

Expand all

Collapse all

Business Views

** Available for extracting data

• payablesPaymentHistoryExtract**

  The payment history provides the clearing or unclearing status details of payments, as well as the maturity history for future dated payments. Each future dated payment is represented by a row once it matures. Additionally, a row is created in the payment history when a payment is cleared or uncleared.

  Label, Plural Label

  Payables Payment History, Payments History

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • accountingDate (date)

    The accounting date for accounting entries for this transaction

    Label

    Accounting Date

    Properties

    • not nullable
  • bankToBaseConversionRate (big-decimal)

    The conversion rate from bank account currency to ledger currency.

    Label

    Bank to Ledger Currency Conversion Rate

  • bankToBaseConversionRateDate (date)

    The date effective for the conversion rate from bank account currency to ledger currency.

    Label

    Bank to Ledger Currency Conversion Date

  • chargeAmount (big-decimal)

    The bank charge amount on the reconciled payment.

    Label

    Charge Amount

  • chargesBankAmount (big-decimal)

    The bank charges amount in bank account currency.

    Label

    Charge Amount in Bank Account Currency

  • chargesBaseAmount (big-decimal)

    The bank charges amount in ledger currency.

    Label

    Charge Amount in Ledger Currency

  • chargesPaymentAmount (big-decimal)

    The bank charges amount in payment currency.

    Label

    Charge Amount in Payment Currency

  • createdBy (string)

    The user who created the payment history row.

    Label

    Created By

    Properties

    • not nullable
  • errorAmount (big-decimal)

    The reconciliation error amount on the reconciled payment.

    Label

    Error Amount

  • errorsBankAmount (big-decimal)

    The reconciliation error amount in bank account currency.

    Label

    Error Amount in Bank Account Currency

  • errorsBaseAmount (big-decimal)

    The reconciliation error amount in ledger currency.

    Label

    Error Amount in Ledger Currency

  • errorsPaymentAmount (big-decimal)

    The reconciliation error amount in payment currency.

    Label

    Error Amount in Payment Currency

  • gainLossIndicator (enumeration: GainLossIndicator)

    Indicator for whether the payment related transaction resulted in gain or loss. Possible values are G or L.

    Label

    Payment History Gain Loss Indicator

    Type

    • Module: oraErpCorePayablesPayments

    • Enumeration Type: GainLossIndicator

    Valid Values

    • G
    • L
  • matchedFlag (boolean)

    Indicates whether the payment is matched to a bank statement line. It can have two possible values : Y or N. A value of Y indicates that the payment Is reconciled. A value of N indicates that the payment is cleared.

    Label

    Payment History Matched Indicator

  • paymentHistoryId (int64)

    The unique identifier of the payment history row. This is the primary key of the payment history view object.

    Label

    Payment History Identifier

    Properties

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

    The conversion rate from payment currency to ledger currency.

    Label

    Payment to Ledger Currency Conversion Rate

  • paymentToBaseConversionRateDate (date)

    The date effective for the conversion rate from payment currency to ledger currency.

    Label

    Payment to Ledger Currency Conversion Date

  • timeCreated (date-time)

    The date and time when the payment history row was created.

    Label

    Creation Date

    Properties

    • searchable
    • not nullable
  • timeUpdated (date-time)

    The date when the payment history row was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • not nullable
  • transactionAmount (big-decimal)

    The transaction amount in the payment history.

    Label

    Payment History Transaction Amount

  • transactionBankAmount (big-decimal)

    The payment amount to clear in bank account currency. This is inclusive of charges and errors.

    Label

    Payment History Transaction Bank Amount

  • transactionBaseAmount (big-decimal)

    The payment amount to clear in ledger currency. This is inclusive of charges and errors.

    Label

    Payment History Transaction Base Amount

  • transactionDate (date)

    The transaction date in the payment history.

    Label

    Payment History Transaction Date

  • transactionPaymentAmount (big-decimal)

    The payment amount to clear in payment currency. This is inclusive of charges and errors.

    Label

    Payment History Transaction Payment Amount

    Properties

    • not nullable
  • transactionType (string)

    The transaction type of the payment history row. It can have three possible values : Payment Maturity, Payment Clearing, Payment Unclearing.

    Label

    Payment History Transaction Type

    Properties

    • not nullable
  • updatedBy (string)

    The user who last updated the payment history row.

    Label

    Created By

    Properties

    • not nullable

  Expand all

  Collapse all

  Reference Object

  • accountingEvent (SubledgerAccountingEvent)

    A subledger accounting event contains all information related to a specific accounting event and the transactions linked to the event which are used to generate accounting entries. It stores details associated with the accounting event such as the associated accounting event identifier, application identifier, event type, event status, event processing status, and other information associated with the accounting event.

    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

  • adjustedInvoiceEvent (SubledgerAccountingEvent)

    The identifier of the invoice adjustment event that resulted in the payment distribution.

    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

  • bankToLedgerCoversionRateType (CurrencyConversionRateType)

    The conversion rate type for conversion from bank account currency to ledger currency.

    Business Object

    CurrencyConversionRateType

    Expand all

    Collapse all

    Fields

    • conversionRateType (string)

      The rate type of the conversion rate used for the currency conversion, such as Corporate, Daily, Period End, and Period Average.

      Label

      Conversion Rate Type

      Properties

      • searchable
      • sortable
      • not nullable

  • businessUnit (BusinessUnit)

    A business unit represents a unit of an enterprise that performs one or more business functions and may have service provider relationships between the units. It typically focuses on a specific market segment, product line, geographic region, or set of services. The business transactions are recorded, reported, and accounted against the business unit.

    Business Object

    BusinessUnit

    Expand all

    Collapse all

    Fields

    • effectiveEndDate (date)

      The end date of the date range within which the business unit is effective.

      Label

      End Date

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
    • effectiveStartDate (date)

      The start date of the date range within which the business unit is effective.

      Label

      Start Date

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
    • id (int64)

      The unique identifier of the business unit.

      Label

      Business Unit ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable
    • name (string)

      The translated name for the business unit.

      Label

      Business Unit

      Properties

      • inherited
      • translatable
      • not nullable
      • overridable

  • currency (Currency)

    A currency is a standardization of money used for displaying monetary amounts, assigning to ledgers, entering transactions, recording balances, and reporting. All currencies listed in the International Organization for Standardization 4217 standard are supported. The statistical unit currency is used for financial statistics in financial reports, allocation formulas, and other calculations.

    Business Object

    Currency

    Expand all

    Collapse all

    Fields

    • currencyCode (string)

      The currency in which an amount or a conversion rate is denominated.

      Label

      Currency Code

      Properties

      • searchable
      • sortable
      • not nullable

  • ledgerCurrency (Currency)

    The currency of the bank account used for the payment. This is a foreign key of the Currencies view object.

    Business Object

    Currency

    Expand all

    Collapse all

    Fields

    • currencyCode (string)

      The currency in which an amount or a conversion rate is denominated.

      Label

      Currency Code

      Properties

      • searchable
      • sortable
      • not nullable

  • originalEvent (SubledgerAccountingEvent)

    The identifier of the originating transaction event.

    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

  • payment (PayablesPayment)

    Payment represents the payments issued to suppliers or refunds received from suppliers. This information is utilized to accurately record and manage outgoing payments to suppliers or incoming refunds from suppliers.

    Business Object

    PayablesPayment

    Expand all

    Collapse all

    Fields

    • paymentId (int64)

      The unique identifier of the payment record.

      Label

      Payment ID

      Properties

      • searchable
      • sortable
      • not nullable

  • paymentCurrency (Currency)

    The currency of the payment. This is a foreign key of the Currencies view object.

    Business Object

    Currency

    Expand all

    Collapse all

    Fields

    • currencyCode (string)

      The currency in which an amount or a conversion rate is denominated.

      Label

      Currency Code

      Properties

      • searchable
      • sortable
      • not nullable

  • paymentToBaseConversionRateType (CurrencyConversionRateType)

    The conversion rate type for conversion from payment currency to ledger currency.

    Business Object

    CurrencyConversionRateType

    Expand all

    Collapse all

    Fields

    • conversionRateType (string)

      The rate type of the conversion rate used for the currency conversion, such as Corporate, Daily, Period End, and Period Average.

      Label

      Conversion Rate Type

      Properties

      • searchable
      • sortable
      • not nullable

  • postingStatus (ERPLookupCode)

    Indicates whether the maturity, clearing or unclearing transaction has been accounted. It can have two possible values: Y and N.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
    • lookupType (string)

      The unique identifier of the Lookup Type.

      Label

      Lookup Type ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
    • meaning (string)

      The translated meaning of the Lookup Code.

      Label

      Lookup Code Meaning

      Properties

      • inherited
      • translatable
      • not nullable

  • reversedPaymentHistory (PayablesPaymentHistory)

    The identifier of the accounting event of the payment distribution being reversed.

    Business Object

    PayablesPaymentHistory

    Expand all

    Collapse all

    Fields

    • paymentHistoryId (int64)

      The unique identifier of the payment history row. This is the primary key of the payment history view object.

      Label

      Payment History Identifier

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top