PayablesPaymentDistribution

The payment distribution stores the distributions details for each payment accounting event.

Expand all

Collapse all

Business Views

** Available for extracting data

• payablesPaymentDistributionExtract**

  The payment distribution stores the distributions details for each payment accounting event.

  Label, Plural Label

  Payables Payment Distribution, Payables Payment Distributions

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • amount (big-decimal)

    The amount of the distribution in the payment history.

    Label

    Payment History Distribution Amount

    Properties

    • not nullable
  • amountVariance (big-decimal)

    The variance amount of the payment distribution.

    Label

    Payment History Distribution Amount Variance

  • bankCurrencyAmount (big-decimal)

    The amount of the distribution in the bank account currency.

    Label

    Payment History Distributions Bank Current Amount

  • clearedBaseAmount (big-decimal)

    The payment cleared amount in the ledger currency.

    Label

    Cleared Base Amount

  • createdBy (string)

    The user who created the payment history distribution row.

    Label

    Created By

    Properties

    • not nullable
  • invoiceBaseAmountVariance (big-decimal)

    The variance amount on the invoice for the payment distribution in the ledger currency.

    Label

    Payment History Distribution Invoice Base Amount Variance

  • invoiceBaseQuantityVariance (big-decimal)

    The quantity variance amount in the ledger currency for invoice distribution lines matched to a purchase order or receipt.

    Label

    Invoice Base Quantity Variance

  • invoiceDistributionAmount (big-decimal)

    The amount paid of the related invoice distribution in entered invoice currency.

    Label

    Payment History Distribution Invoice Distribution Amount

  • invoiceDistributionBaseAmount (big-decimal)

    Amount of related invoice distribution in the ledger currency using the invoice conversion rate.

    Label

    Payment History Distribution Invoice Distribution Base Amount

  • maturedBaseAmount (big-decimal)

    The matured payment amount of a future dated payment in ledger currency

    Label

    Payment History Distribution Matured Base Amount

  • paidBaseAmount (big-decimal)

    The payment distribution amount in the ledger currency using the payment conversion rate.

    Label

    Payment History Distributions Paid Base Amount

  • paymentHistoryDistributionId (int64)

    The unique identifier of the payment history distribution row. This is the primary key of the Payment History Distributions view object.

    Label

    Payment History Distribution Identifier

    Properties

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

    Indicates whether project related invoice distributions have been transferred to Oracle Projects when cash basis accounting is used.

    Label

    Transferred to Projects Indicator

  • quantityVariance (big-decimal)

    The quantity variance amount for invoice distribution lines matched to a purchase order or receipt.

    Label

    Quantity Variance

  • reversalFlag (boolean)

    Indicates if the distribution reverses another payment distribution.

    Label

    Reversal Indicator

  • roundingAmount (big-decimal)

    The rounding amount resulting from proration using the payment conversion rate.

    Label

    Payment History Distribution Rounding Amount

  • timeCreated (date-time)

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

    Label

    Creation Date

    Properties

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

    The date when the payment history distribution row was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • not nullable
  • updatedBy (string)

    The user who last updated the payment history distribution row.

    Label

    Last Updated 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

    • applicationId (int64)

      The unique identifier of the source application that represents a functional area.

      Label

      Application

      Properties

      • searchable
      • sortable
      • not nullable
    • 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 for which the payment adjustment event is created in this view object. When a paid invoice is adjusted, an invoice adjustment event is created for the adjustment accounting entries. For each such invoice adjustment event, there is a corresponding payment adjustment event that adjusts the supplier liability.

    Business Object

    SubledgerAccountingEvent

    Expand all

    Collapse all

    Fields

    • applicationId (int64)

      The unique identifier of the source application that represents a functional area.

      Label

      Application

      Properties

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

      The unique identifier of the accounting event within an application and event class.

      Label

      Event Identifier

      Properties

      • searchable
      • sortable
      • not nullable

  • invoiceDistribution (PayablesInvoiceDistribution)

    Invoice distribution provides the allocation details of the costs or charges from an invoice to various accounts or departments within an organization. The details include distribution code combination, distribution amount, and so on. The invoice distributions are entered manually or system generated. An invoice can have multiple distributions, and there is one row for each distribution.

    Business Object

    PayablesInvoiceDistribution

    Expand all

    Collapse all

    Fields

    • distributionLineNumber (int64)

      The line number associated with the invoice distribution.

      Label

      Line Number

      Properties

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

      The unique identifier of the invoice distribution. This attribute forms part of the primary key for the Invoice Distributions view object.

      Label

      Invoice Distribution ID

      Properties

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

      The unique identifier of the invoice associated with the invoice distribution.

      Label

      Invoice ID

      Properties

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

      The unique number for the invoice line associated with the invoice distribution.

      Label

      Line

      Properties

      • searchable
      • sortable

  • invoicePayment (PayablesInvoicePayment)

    Invoice payment records contain details regarding payments made to suppliers, including payment amount, payment number, bank information, and other relevant data. Each payment made for an invoice is represented by a single row in the database.

    Business Object

    PayablesInvoicePayment

    Expand all

    Collapse all

    Fields

    • invoicePaymentId (int64)

      The unique identifier of the payment. This is the primary key of the Invoice Payments view object.

      Label

      Invoice Payment ID

      Properties

      • searchable
      • sortable
      • not nullable

  • paymentDistributionType (ERPLookupCode)

    The name of the distribution type used for the payment distribution.

    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

  • paymentHistory (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.

    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

  • releaseInvoiceDistribution (PayablesInvoiceDistribution)

    The identifier of the retainage release invoice distribution used for subledger accounting business flows.

    Business Object

    PayablesInvoiceDistribution

    Expand all

    Collapse all

    Fields

    • distributionLineNumber (int64)

      The line number associated with the invoice distribution.

      Label

      Line Number

      Properties

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

      The unique identifier of the invoice distribution. This attribute forms part of the primary key for the Invoice Distributions view object.

      Label

      Invoice Distribution ID

      Properties

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

      The unique identifier of the invoice associated with the invoice distribution.

      Label

      Invoice ID

      Properties

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

      The unique number for the invoice line associated with the invoice distribution.

      Label

      Line

      Properties

      • searchable
      • sortable

  • reversedPaymentDistribution (PayablesPaymentDistribution)

    The unique identifier of the reversed payment history transaction.

    Business Object

    PayablesPaymentDistribution

    Expand all

    Collapse all

    Fields

    • paymentHistoryDistributionId (int64)

      The unique identifier of the payment history distribution row. This is the primary key of the Payment History Distributions view object.

      Label

      Payment History Distribution Identifier

      Properties

      • searchable
      • sortable
      • not nullable

  • withholdingTaxDistribution (PayablesInvoiceDistribution)

    The line number of the withholding distribution.

    Business Object

    PayablesInvoiceDistribution

    Expand all

    Collapse all

    Fields

    • distributionLineNumber (int64)

      The line number associated with the invoice distribution.

      Label

      Line Number

      Properties

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

      The unique identifier of the invoice distribution. This attribute forms part of the primary key for the Invoice Distributions view object.

      Label

      Invoice Distribution ID

      Properties

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

      The unique identifier of the invoice associated with the invoice distribution.

      Label

      Invoice ID

      Properties

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

      The unique number for the invoice line associated with the invoice distribution.

      Label

      Line

      Properties

      • searchable
      • sortable

Back to Top