PayablesPrepaymentApplicationDistribution

Prepayment application distribution stores the information regarding the allocation of prepayment amounts to specific invoice distributions. These records are generated as part of the data extraction preprocessing from Accounts Payable to Subledger Accounting.

Expand all

Collapse all

Business Views

** Available for extracting data

• payablesPrepaymentApplicationDistributionsExtract**

  Prepayment application distribution stores the information regarding the allocation of prepayment amounts to specific invoice distributions. These records are generated as part of the data extraction preprocessing from Accounts Payable to Subledger Accounting.

  Label, Plural Label

  Payables Prepayment Application Distributions, Payables Prepayment Application Distributions

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • amountAtPrepayClearingConversionRate (big-decimal)

    The ledger amount derived using the prepayment clearing conversion rate.

    Label

    Ledger Amount at Prepayment Clearing Conversion Rate

  • amountAtPrepayPaymentConversionRate (big-decimal)

    The ledger amount derived using the prepayment payment clearing conversion rate.

    Label

    Ledger Amount at Prepayment Payment Conversion Rate

  • amountInLedgerCurrency (big-decimal)

    The prorated invoice distribution amount in the ledger currency that's derived using the invoice conversion rate.

    Label

    Prepayment Application Distribution Ledger Amount

  • amountVariance (big-decimal)

    The amount variance in the entered currency for invoice distributions matched to a service shipment or receipt.

    Label

    Amount Variance

  • amountVarianceInLedgerCurrency (big-decimal)

    The amount variance in the ledger currency for invoice distributions matched to a service shipment or receipt.

    Label

    Invoice Variance Amount Ledger Currency

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • prepayAmountAtPrepayConversionRate (big-decimal)

    The ledger amount derived using the prepayment conversion rate.

    Label

    Ledger Amount at Prepayment Conversion Rate

  • prepayAmountInInvoiceCurrency (big-decimal)

    The prorated invoice distribution amount of the prepayment that's applied to the invoice.

    Label

    Prorated invoice distribution amount of the prepayment that's applied to the invoice.

  • prepayAppDistributionId (int64)

    Unique identifier of the prepayment application distribution.

    Label

    Prepayment Application Distribution Identifier

    Properties

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

    The date used to derive the conversion rate for the prepayment payment bank currency to the ledger currency. Used for calculation at the time of payment clearing for prepayment invoices.

    Label

    Prepayment Payment Clearing Conversion Date

  • prepayClearingConversionRate (big-decimal)

    The rate used to convert the bank currency amount of a prepayment to the ledger currency at clearing time.

    Label

    Prepayment Payment Clearing Conversion Rate

  • prepayConversionDate (date)

    The date when the prepayment to the supplier was created.

    Label

    Prepayment Invoice Conversion Date

  • prepayConversionRate (big-decimal)

    The conversion rate at which the prepayment to the supplier was created.

    Label

    Prepayment Invoice Conversion Rate

  • prepayDistributionTypeCode (string)

    The name of the distribution type. A list of accepted values is defined in the lookup type INVOICE DISTRIBUTION TYPE.

    Label

    Prepayment Distribution Type Code

    Properties

    • not nullable
  • prepayPaymentConversionDate (date)

    The date used to derive the conversion rate for the prepayment payment currency to the ledger currency.

    Label

    Prepayment Payment Conversion Date

  • prepayPaymentConversionRate (big-decimal)

    The rate used to convert the foreign currency prepayment payment amount to the ledger currency.

    Label

    Prepayment Payment Conversion Rate

  • projectsAdditionCode (string)

    Indicates whether the invoice distribution has been transferred to Oracle Fusion Assets. A value of U indicates that the distribution isn't yet processed for transfer to Oracle Fusion Assets. A value of Y indicates that the distribution has been transferred and a value of N indicates that the distribution hasn't been transferred to Oracle Fusion Assets.

    Label

    Invoice Distribution Projects Addition Indicator

  • quantityVarianceAmount (big-decimal)

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

    Label

    Quantity Variance

  • quantityVarianceAmountInLedgerCurrency (big-decimal)

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

    Label

    Ledger Currency Quantity Variance Amount

  • requestIdentifier (int64)

    Properties

    • not nullable
  • retainageReleaseInvoiceDistributionIdentifier (int64)

    The identifier of the retainage release invoice distribution.

  • roundingAmountAtPrepayClearingRate (big-decimal)

    The rounding amount that results from proration using the prepayment conversion rate.

    Label

    Rounding Amount at Prepayment Creation Conversion Rate

  • roundingAmountAtPrepayPaymentClearingRate (big-decimal)

    The rounding amount that results from proration using the prepayment payment clearing conversion rate.

    Label

    Rounding Amount at Prepayment Clearing Conversion Rate

  • roundingAmountAtPrepayPaymentRate (big-decimal)

    The rounding amount that results from proration using the prepayment payment conversion rate.

    Label

    Rounding Amount at Prepayment Payment Conversion Rate

  • roundingAmountInLedgerCurrency (big-decimal)

    The amount that was added to the distribution line to ensure that the total of distribution line amounts adds up to the invoice amount in the ledger currency.

    Label

    Rounding Amount

  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

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

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • not nullable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable

  Expand all

  Collapse all

  Reference Object

  • accountingEvent (SubledgerAccountingEvent)

    Identifier of the prepayment application 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
    • processStatusCode (enumeration: ProcessStatusEnum)

      Indicates the processing status of the event within the accounting program.

      Label

      Process Status

      Type

      • Module: oraErpCoreSubledgerAccountingEntries

      • Enumeration Type: ProcessStatusEnum

      Properties

      • searchable
      • sortable

      Valid Values

      • D
      • E
      • I
      • P
      • R
      • U

  • conversionRateType (CurrencyConversionRateType)

    A currency conversion rate type defines conversion rate types such as Corporate, Daily, Period End, and Period Average. These conversion rate types are used to convert foreign currency journal amounts to ledger currency equivalents or translate and remeasure account balances to a reporting 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

  • prepayInvoiceDistribution (PayablesInvoiceDistribution)

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

    Business Object

    PayablesInvoiceDistribution

    Expand all

    Collapse all

    Fields

    • 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

  • prepaymentApplicationHistory (PayablesPrepaymentApplication)

    A prepayment is a payment made in advance to a supplier in anticipation of their provision of goods or services. A prepayment is a type of invoice that you can apply to an outstanding invoice to reduce the invoice amount. It contains details of the prepayment applications, unapplying prepayment, and prepayment adjustments.

    Business Object

    PayablesPrepaymentApplication

    Expand all

    Collapse all

    Fields

    • prepayHistoryId (int64)

      Indicates whether the payment related transaction resulted in gain or loss.

      Label

      Prepayment History Identifier

      Properties

      • searchable
      • sortable
      • not nullable

  • prepaymentClearingConversionRateType (CurrencyConversionRateType)

    A currency conversion rate type defines conversion rate types such as Corporate, Daily, Period End, and Period Average. These conversion rate types are used to convert foreign currency journal amounts to ledger currency equivalents or translate and remeasure account balances to a reporting 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

  • prepaymentConversionRateType (CurrencyConversionRateType)

    The conversion rate type of a future dated maturity payment. This attribute value is only used for foreign currency payments.

    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

  • recipientInvoiceDistribution (PayablesInvoiceDistribution)

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

    Business Object

    PayablesInvoiceDistribution

    Expand all

    Collapse all

    Fields

    • 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

  • recipientPrepaymentApplicationDistribution (PayablesInvoiceDistribution)

    The identifier of the prepayment distribution line related to the prepayment line.

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

    Expand all

    Collapse all

    Reference Object

    • prepayDistribution (PayablesInvoiceDistribution)

      The identifier of the prepayment distribution line related to the prepayment line.

      Business Object

      PayablesInvoiceDistribution

      Expand all

      Collapse all

      Fields

      • 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

  • reversePrepayInvoiceDistribution (PayablesInvoiceDistribution)

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

    Business Object

    PayablesInvoiceDistribution

    Expand all

    Collapse all

    Fields

    • 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

  • withholdingTaxDistribution (PayablesInvoiceDistribution)

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

    Business Object

    PayablesInvoiceDistribution

    Expand all

    Collapse all

    Fields

    • 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

Back to Top