ReceivablesTransactionPaymentSchedule

A receivables transaction payment schedule outlines the timeline and terms for payments to be made by customers for sales of goods or services. The details include information about all transactions except adjustments and miscellaneous cash receipts. It's updated when activities occur against an invoice, debit memo, chargeback, credit memo, on-account credit, or receipt. When a receipt is applied to a transaction, the system updates the amount applied, the remaining amount due, and the transaction status. The status changes from open to closed when the amount due remaining is zero.

Expand all

Collapse all

Business Views

** Available for extracting data

• receivablesTransactionPaymentSchedulesExtract**

  A receivables transaction payment schedule outlines the timeline and terms for payments to be made by customers for sales of goods or services. The details include information about all transactions except adjustments and miscellaneous cash receipts. It's updated when activities occur against an invoice, debit memo, chargeback, credit memo, on-account credit, or receipt. When a receipt is applied to a transaction, the system updates the amount applied, the remaining amount due, and the transaction status. The status changes from open to closed when the amount due remaining is zero.

  Label, Plural Label

  Receivables Transaction Payment Schedules, Receivables Transaction Payment Schedules

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • accountedBalanceDue (big-decimal)

    The remaining amount due on the transaction in the ledger currency.

    Label

    Accounted Balance Due

    Properties

    • not nullable
  • accountingDate (date)

    The payment schedule accounting date.

    Label

    Accounting Date

    Properties

    • not nullable
  • actualClosedDate (date)

    The actual date the payment schedule was closed.

    Label

    Actual Closed Date

    Properties

    • not nullable
  • amountAdjusted (big-decimal)

    The amount of the payment schedule or payment schedule installment that's adjusted.

    Label

    Amount Adjusted

  • amountApplied (big-decimal)

    The amount applied to the payment schedule installment.

    Label

    Amount Applied

  • amountCredited (big-decimal)

    The amount credited against the payment schedule installment.

    Label

    Amount Credited

  • amountOnAccount (big-decimal)

    The payment schedule amount placed on account.

    Label

    Amount on Account

    Properties

    • searchable
  • amountOtherAccount (big-decimal)

    The payment schedule amount for Oracle internal use only.

    Label

    Amount Other Account

  • amountRemaining (big-decimal)

    The remaining amount due on the payment schedule.

    Label

    Amount Remaining

    Properties

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

    The amount of a bill receivable that's applied to a transaction in the entered currency.

    Label

    Bill Receivable Amount Assigned

  • charges (big-decimal)

    The total additional charges on a payment schedule other than lines, tax, and freight.

    Label

    Charges

  • closedAccountingDate (date)

    The accounting date the payment schedule was closed.

    Label

    Closed Accounting Date

    Properties

    • not nullable
  • collectionBasedForecastAmount (big-decimal)

    Cash forecasting calculated amount, derived from: amount due, amount promised, or expected collection amount.

    Label

    Collection Based Forecast Amount

  • collectionBasedForecastDate (date)

    Cash forecasting calculated date, derived from: due date, promise date, or expected collection date.

    Label

    Collection Based Forecast Date

  • collectionFollowUpDate (date)

    The date the customer was last contacted about the transaction line item.

    Label

    Collection Follow-Up Date

  • collectionFollowUpResult (string)

    The code that describes the outcome of the last follow-up with the customer about the transaction line item.

    Label

    Collection Follow-Up Result

  • conversionDate (date)

    The payment schedule conversion date.

    Label

    Conversion Date

  • conversionRate (big-decimal)

    The payment schedule conversion rate.

    Label

    Conversion Rate

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • discountBalanceDue (big-decimal)

    Remaining discount amount on the transaction line.

    Label

    Discount Balance Due

  • discountDate (date)

    The date when the first discount is available.

    Label

    Discount Date

  • disputeAmount (big-decimal)

    The amount in dispute on the payment schedule.

    Label

    Dispute Amount

    Properties

    • searchable
  • disputeDate (date)

    The most recent dispute date on the payment schedule.

    Label

    Dispute Date

    Properties

    • searchable
  • dunningLevel (int32)

    The dunning level of the payment schedule item as printed on the dunning correspondence.

    Label

    Dunning Level

    Properties

    • searchable
  • dunningLevelOverrideDate (date)

    The date when the user manually adjusted the dunning level of a debit item.

    Label

    Dunning Level Override Date

  • earnedDiscount (big-decimal)

    The actual amount of earned discount taken on the payment schedule line.

    Label

    Earned Discount

  • excludeFromConsolidatedInvoice (enumeration: ExcludeFromConsolidatedInvoiceIndicator)

    The option that indicates whether to exclude the current payment schedule from the balance forward bill.

    Label

    Exclude from Consolidated Invoice

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: ExcludeFromConsolidatedInvoiceIndicator

    Valid Values

    • N
    • Y
  • excludeFromDunning (enumeration: ExcludeFromDunningIndicator)

    The option that indicates whether to exclude the customer from the dunning process.

    Label

    Exclude from Dunning

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: ExcludeFromDunningIndicator

    Properties

    • searchable

    Valid Values

    • N
    • Y
  • expectedCollectionAmount (big-decimal)

    Amount expected to be collected by the collector.

    Label

    Expected Collection Amount

    Properties

    • searchable
  • expectedCollectionDate (date)

    Date the expected payment amount is expected to be collected by the collector.

    Label

    Expected Collection Date

    Properties

    • searchable
  • freightBalanceDue (big-decimal)

    The remaining freight amount on the transaction line.

    Label

    Freight Balance Due

  • installmentClass (enumeration: InstallmentClass)

    The lookup code for the class of the payment schedule.

    Label

    Installment Class

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: InstallmentClass

    Properties

    • searchable
    • not nullable

    Valid Values

    • BR
    • CB
    • CM
    • DEP
    • DM
    • GUAR
    • INV
    • PMT
  • installmentDueDate (date)

    The due date of the transaction installment.

    Label

    Installment Due Date

    Properties

    • searchable
    • not nullable
  • installmentStatus (enumeration: PaymentScheduleStatus)

    The payment schedule status. Valid values are: OP - Open: amount due remaining, CL - Closed: no amount due.

    Label

    Installment Status

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: PaymentScheduleStatus

    Properties

    • searchable
    • not nullable

    Valid Values

    • CL
    • OP
  • lastCollectionsCallDate (date)

    The date a collector most recently called the customer.

    Label

    Last Collections Call Date

    Properties

    • searchable
  • lastPromiseAmount (big-decimal)

    The amount the customer last promised to pay.

    Label

    Last Promise Amount

    Properties

    • searchable
  • lastPromiseDate (date)

    The date the customer last promised to pay.

    Label

    Last Promise Date

    Properties

    • searchable
  • lateChargeDate (date)

    The late charge date of the payment schedule.

    Label

    Late Charge Date

  • lineItemOriginalAmount (big-decimal)

    The original line amount due on the payment schedule.

    Label

    Line Item Original Amount

  • lineItemRemainingAmount (big-decimal)

    The remaining line amount due on the payment schedule.

    Label

    Line Item Remaining Amount

  • numberOfInstallments (int64)

    The total number of installment due dates on the transaction payment schedule.

    Label

    Number of Installments

    Properties

    • not nullable
  • originalAmount (big-decimal)

    The original amount due on the payment schedule.

    Label

    Original Amount

    Properties

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

    Original discount amount on the transaction line.

    Label

    Original Discount Amount

  • originalFreightAmount (big-decimal)

    The original freight amount on the transaction line.

    Label

    Original Freight Amount

  • originalTaxAmount (big-decimal)

    The original tax amount on the payment schedule.

    Label

    Original Tax Amount

  • overdueFlag (boolean)

    Option that indicates whether the transaction installment is current or overdue.

    Label

    overdueFlag

    Properties

    • searchable
  • paymentScheduleId (int64)

    The identifier of the payment schedule.

    Label

    Payment Schedule ID

    Properties

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

    The amount of the payment schedule or payment schedule installment that's pending adjustment approval.

    Label

    Pending Adjustment Amount

  • receiptConfirmedFlag (boolean)

    The option that indicates whether the receipt was confirmed.

    Label

    Receipt Confirmed

  • receivablesChargesBalanceDue (big-decimal)

    The balance due of the sum of all additional charges on a payment schedule other than lines, tax, and freight.

    Label

    Receivables Charges Balance Due

  • sequence (int64)

    The sequence number assigned to each installment of the payment schedule.

    Label

    Sequence

    Properties

    • searchable
  • taxRemainingAmount (big-decimal)

    The original tax amount on the payment schedule.

    Label

    Tax Balance Due

  • 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
  • transactionDate (date)

    The payment schedule transaction creation date.

    Label

    Transaction Date

    Properties

    • searchable
  • transactionNumber (string)

    The payment schedule transaction number.

    Label

    Transaction Number

    Properties

    • searchable
  • unearnedDiscount (big-decimal)

    The actual amount of unearned discount taken on the payment schedule line.

    Label

    Unearned Discount

  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable

  Expand all

  Collapse all

  Reference Object

  • activeClaimCodeLookup (ERPLookupCode)

    The option that indicates whether an active claim exists in Trade Management for this transaction.

    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

  • associatedCashReceipt (ReceivablesReceipt)

    Business Object

    ReceivablesReceipt

    Expand all

    Collapse all

    Fields

    • cashReceiptId (int64)

      The identifier of the cash receipt.

      Label

      Cash Receipt ID

      Properties

      • searchable
      • sortable
      • not nullable

  • balanceForwardBill (BalanceForwardBill)

    The balance forward bill contains information about balance forward bills, including bill number, bill-to customer number, customer site, bill-from, bill-to, billing date, due date, currency, amount due, beginning balance, ending balance, payment terms, payments, adjustments, credits, current charges, tax, and late charges. Balance forward bills are generated by the Generate Balance Forward Bill process. The balance forward bill contains all transactions created within the period specified by the balance forward billing cycle.

    Business Object

    BalanceForwardBill

    Expand all

    Collapse all

    Fields

    • consolidatedInvoiceId (int64)

      The identifier of the balance forward bill.

      Label

      Consolidated Invoice ID

      Properties

      • searchable
      • sortable
      • not nullable

  • billToCustomerAccount (CustomerAccount)

    Business Object

    CustomerAccount

    Expand all

    Collapse all

    Fields

    • customerAccountId (int64)

      Identifier of the customer account.

      Label

      Customer Account ID

      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

    • id (int64)

      The unique identifier of the business unit.

      Label

      Business Unit ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable

  • cashReceipt (ReceivablesReceipt)

    Business Object

    ReceivablesReceipt

    Expand all

    Collapse all

    Fields

    • cashReceiptId (int64)

      The identifier of the cash receipt.

      Label

      Cash Receipt ID

      Properties

      • searchable
      • sortable
      • not nullable

  • customerAccount (CustomerAccount)

    The Customer Account business object provides the details of the specific business activities that the deploying company engages in with a customer party of type Organization or Person.

    Business Object

    CustomerAccount

    Expand all

    Collapse all

    Fields

    • customerAccountId (int64)

      Identifier of the customer account.

      Label

      Customer Account ID

      Properties

      • searchable
      • sortable
      • not nullable

  • customerSiteUse (CustomerAccountSitePurpose)

    Business Object

    CustomerAccountSitePurpose

    Expand all

    Collapse all

    Fields

    • siteUseId (int64)

      Identifier of the customer account site business purpose.

      Label

      Site Use ID

      Properties

      • searchable
      • sortable
      • not nullable

  • customerTransaction (ReceivablesTransaction)

    Business Object

    ReceivablesTransaction

    Expand all

    Collapse all

    Fields

    • customerTransactionId (int64)

      The identifier of the transaction used when creating the transaction.

      Label

      Customer Transaction ID

      Properties

      • searchable
      • sortable
      • not nullable

  • customerTransactionType (ReceivablesTransactionType)

    Business Object

    ReceivablesTransactionType

    Expand all

    Collapse all

    Fields

    • customerTransactionTypeSequenceId (int64)

      The sequence identifier of the transaction type.

      Label

      Customer Transaction Type Sequence ID

      Properties

      • searchable
      • sortable
      • not nullable

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

  • invoiceCurrency (Currency)

    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

  • legalEntity (LegalEntity)

    A legal entity represents an entity created under a commercial law which can own property, create obligation, recruit people, trade, account for themselves to regulators, taxation authorities, and owners. It identifies the legal owner or custodian for each business transaction for legal compliance and reporting.

    Business Object

    LegalEntity

    Expand all

    Collapse all

    Fields

    • legalEntityId (int64)

      The unique identifier of the legal entity. This is the primary key of the Legal Entities view object.

      Label

      Legal Entity ID

      Properties

      • searchable
      • sortable
      • not nullable

  • paymentTerm (ReceivablesPaymentTerm)

    The receivables payment terms contain the information related to payment terms that outline the timing and method of payment, as well as any applicable discounts or penalties for early or late payment. The information includes reference set, name, description, billing cycle, base amount, discount basis, discount basis date, from and to dates, print lead days, and installment option.

    Business Object

    ReceivablesPaymentTerm

    Expand all

    Collapse all

    Fields

    • termId (int64)

      The identifier of the payment terms.

      Label

      Term ID

      Properties

      • searchable
      • sortable
      • not nullable

  • receiptBatch (ReceivablesManualReceiptBatch)

    The Receivables Manual Receipt Batch and Receivables Automatic Receipt Batch business object provides information that includes the receipt batch name, the total number of receipts in the batch, the total receipt amount, currency, and the deposit date and accounting date, as well as information about each receipt in the manual or automatic receipt batch.

    Business Object

    ReceivablesManualReceiptBatch

    Expand all

    Collapse all

    Fields

    • batchId (int64)

      The identifier of the receipt batch.

      Label

      Batch ID

      Properties

      • searchable
      • sortable
      • not nullable

  • receiptReversalBalanceForwardBill (BalanceForwardBill)

    The balance forward bill contains information about balance forward bills, including bill number, bill-to customer number, customer site, bill-from, bill-to, billing date, due date, currency, amount due, beginning balance, ending balance, payment terms, payments, adjustments, credits, current charges, tax, and late charges. Balance forward bills are generated by the Generate Balance Forward Bill process. The balance forward bill contains all transactions created within the period specified by the balance forward billing cycle.

    Business Object

    BalanceForwardBill

    Expand all

    Collapse all

    Fields

    • consolidatedInvoiceId (int64)

      The identifier of the balance forward bill.

      Label

      Consolidated Invoice ID

      Properties

      • searchable
      • sortable
      • not nullable

  • receivablesSystemOption (ReceivablesEnterpriseConfiguration)

    Business Object

    ReceivablesEnterpriseConfiguration

    Expand all

    Collapse all

    Fields

    • businessUnitId (int64)

      The identifier of the business unit associated with the system options.

      Label

      Business Unit ID

      Properties

      • searchable
      • sortable
      • not nullable

  • reversedCashReceipt (ReceivablesReceipt)

    Business Object

    ReceivablesReceipt

    Expand all

    Collapse all

    Fields

    • cashReceiptId (int64)

      The identifier of the cash receipt.

      Label

      Cash Receipt ID

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top