Payment Schedule

The payment schedule view object contains information about all transactions except adjustments and miscellaneous cash receipts. It is updated when activities occur against an invoice, debit memo, chargeback, credit memo, on-account credit, or receipt. Upon receipt application, the amount applied, amount due remaining, and status are updated. The status changes from open to closed if the amount due remaining becomes zero. Amount due includes on-account and unapplied amounts. Invoices, debit memos, chargebacks, and deposits have positive amount due remaining and amount due original values, whereas credit memos and receipts have negative amounts. The sum of amount due remaining for all confirmed payment schedules is the customer balance. If the customer balance is negative, amount due remaining is the credit balance amount. If a debit memo reversal is created, a payment schedule record is created for the debit memo.

Data store key : FscmTopModelAM.FinExtractAM.ArBiccExtractAM.PaymentScheduleExtractPVO

Primary Keys : ArPaymentSchedulePaymentScheduleId

Initial Extract Date : ArPaymentScheduleCreationDate

Incremental Extract Date : ArPaymentScheduleLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

This table provides the list of exposed attributes and their descriptions.
Name Description
ArPaymentScheduleAcctdAmountDueRemaining The remaining amount due on the transaction in the ledger currency.
ArPaymentScheduleActiveClaimFlag The option that indicates whether an active claim exists in Trade Management for this transaction.
ArPaymentScheduleActualDateClosed The actual date the payment schedule was closed.
ArPaymentScheduleAmountAdjusted The amount of the payment schedule or payment schedule installment that is adjusted.
ArPaymentScheduleAmountAdjustedPending The amount of the payment schedule or payment schedule installment that is pending adjustment approval.
ArPaymentScheduleAmountApplied The amount applied to the payment schedule installment.
ArPaymentScheduleAmountCredited The amount credited against the payment schedule installment.
ArPaymentScheduleAmountDueOriginal The original amount due on the payment schedule.
ArPaymentScheduleAmountDueRemaining The remaining amount due on the payment schedule.
ArPaymentScheduleAmountInDispute The amount in dispute on the payment schedule.
ArPaymentScheduleAmountLineItemsOriginal The original line amount due on the payment schedule.
ArPaymentScheduleAmountLineItemsRemaining The remaining line amount due on the payment schedule.
ArPaymentScheduleAmountOnAccount The payment schedule amount placed on account.
ArPaymentScheduleAmountOtherAccount The payment schedule amount for Oracle internal use only.
ArPaymentScheduleAssociatedCashReceiptId The identifier of the cash receipt from which the chargeback is created.
ArPaymentScheduleAttribute1 A segment of the Receivables Payment Schedule descriptive flexfield 1.
ArPaymentScheduleAttribute10 A segment of the Receivables Payment Schedule descriptive flexfield 10.
ArPaymentScheduleAttribute11 A segment of the Receivables Payment Schedule descriptive flexfield 11.
ArPaymentScheduleAttribute12 A segment of the Receivables Payment Schedule descriptive flexfield 12.
ArPaymentScheduleAttribute13 A segment of the Receivables Payment Schedule descriptive flexfield 13.
ArPaymentScheduleAttribute14 A segment of the Receivables Payment Schedule descriptive flexfield 14.
ArPaymentScheduleAttribute15 A segment of the Receivables Payment Schedule descriptive flexfield 15.
ArPaymentScheduleAttribute2 A segment of the Receivables Payment Schedule descriptive flexfield 2.
ArPaymentScheduleAttribute3 A segment of the Receivables Payment Schedule descriptive flexfield 3.
ArPaymentScheduleAttribute4 A segment of the Receivables Payment Schedule descriptive flexfield 4.
ArPaymentScheduleAttribute5 A segment of the Receivables Payment Schedule descriptive flexfield 5.
ArPaymentScheduleAttribute6 A segment of the Receivables Payment Schedule descriptive flexfield 6.
ArPaymentScheduleAttribute7 A segment of the Receivables Payment Schedule descriptive flexfield 7.
ArPaymentScheduleAttribute8 A segment of the Receivables Payment Schedule descriptive flexfield 8.
ArPaymentScheduleAttribute9 A segment of the Receivables Payment Schedule descriptive flexfield 9.
ArPaymentScheduleAttributeCategory The descriptive flexfield context name of the Receivables Payment Schedule descriptive flexfield.
ArPaymentScheduleBrAmountAssigned The amount of a bill receivable that is applied to a transaction in the entered currency.
ArPaymentScheduleCallDateLast The date a collector most recently called the customer.
ArPaymentScheduleCashReceiptId The identifier of the cash receipt payment.
ArPaymentScheduleCollectorLast The last collector that called the customer.
ArPaymentScheduleConsInvId The unique identifier of the balance forward bill. This is a primary key of the Balance Forward Bill view object.
ArPaymentScheduleConsInvIdRev The consolidated bill number of the balance forward bill that the transaction payment schedule cash receipt reversal belongs to.
ArPaymentScheduleCreatedBy The user who created the payment schedule.
ArPaymentScheduleCreationDate The date and time the payment schedule was created.
ArPaymentScheduleCustTrxTypeSeqId The sequence identifier of the payment schedule transaction type used for invoices, bills receivable, and credit memos.
ArPaymentScheduleCustomerId The identifier of the customer associated with the transaction payment schedule.
ArPaymentScheduleCustomerSiteUseId The identifier of the bill-to customer site.
ArPaymentScheduleCustomerTrxId The identifier of the transaction payment schedule.
ArPaymentScheduleDelContactEmailAddress The email address of the customer bill-to contact.
ArPaymentScheduleDiscountTakenEarned The actual amount of earned discount taken on the payment schedule line.
ArPaymentScheduleDiscountTakenUnearned The actual amount of unearned discount taken on the payment schedule line.
ArPaymentScheduleDisputeDate The most recent dispute date on the payment schedule.
ArPaymentScheduleDueDate The due date of the transaction installment.
ArPaymentScheduleDunningLevelOverrideDate The date when the user manually adjusted the dunning level of a debit item.
ArPaymentScheduleExchangeDate The payment schedule conversion date.
ArPaymentScheduleExchangeRate The payment schedule conversion rate.
ArPaymentScheduleExchangeRateType The payment schedule conversion rate type.
ArPaymentScheduleExcludeFromConsBillFlag The option that indicates whether to exclude the current payment schedule from the balance forward bill.
ArPaymentScheduleExcludeFromDunningFlag The option that indicates whether to exclude the customer from the dunning process.
ArPaymentScheduleFollowUpCodeLast The code that describes the outcome of the last follow-up with the customer about the transaction line item.
ArPaymentScheduleFollowUpDateLast The date the customer was last contacted about the transaction line item.
ArPaymentScheduleFreightOriginal The original freight amount on the transaction line.
ArPaymentScheduleFreightRemaining The remaining freight amount on the transaction line.
ArPaymentScheduleGlDate The payment schedule accounting date.
ArPaymentScheduleGlDateClosed The accounting date the payment schedule was closed.
ArPaymentScheduleGlobalAttribute1 A segment of the Receivables Payment Schedule global descriptive flexfield 1.
ArPaymentScheduleGlobalAttribute10 A segment of the Receivables Payment Schedule global descriptive flexfield 10.
ArPaymentScheduleGlobalAttribute11 A segment of the Receivables Payment Schedule global descriptive flexfield 11.
ArPaymentScheduleGlobalAttribute12 A segment of the Receivables Payment Schedule global descriptive flexfield 12.
ArPaymentScheduleGlobalAttribute13 A segment of the Receivables Payment Schedule global descriptive flexfield 13.
ArPaymentScheduleGlobalAttribute14 A segment of the Receivables Payment Schedule global descriptive flexfield 14.
ArPaymentScheduleGlobalAttribute15 A segment of the Receivables Payment Schedule global descriptive flexfield 15.
ArPaymentScheduleGlobalAttribute16 A segment of the Receivables Payment Schedule global descriptive flexfield 16.
ArPaymentScheduleGlobalAttribute17 A segment of the Receivables Payment Schedule global descriptive flexfield 17.
ArPaymentScheduleGlobalAttribute18 A segment of the Receivables Payment Schedule global descriptive flexfield 18.
ArPaymentScheduleGlobalAttribute19 A segment of the Receivables Payment Schedule global descriptive flexfield 19.
ArPaymentScheduleGlobalAttribute2 A segment of the Receivables Payment Schedule global descriptive flexfield 2.
ArPaymentScheduleGlobalAttribute20 A segment of the Receivables Payment Schedule global descriptive flexfield 20.
ArPaymentScheduleGlobalAttribute3 A segment of the Receivables Payment Schedule global descriptive flexfield 3.
ArPaymentScheduleGlobalAttribute4 A segment of the Receivables Payment Schedule global descriptive flexfield 4.
ArPaymentScheduleGlobalAttribute5 A segment of the Receivables Payment Schedule global descriptive flexfield 5.
ArPaymentScheduleGlobalAttribute6 A segment of the Receivables Payment Schedule global descriptive flexfield 6.
ArPaymentScheduleGlobalAttribute7 A segment of the Receivables Payment Schedule global descriptive flexfield 7.
ArPaymentScheduleGlobalAttribute8 A segment of the Receivables Payment Schedule global descriptive flexfield 8.
ArPaymentScheduleGlobalAttribute9 A segment of the Receivables Payment Schedule global descriptive flexfield 9.
ArPaymentScheduleGlobalAttributeCategory The descriptive flexfield context name of the Receivables Payment Schedule global descriptive flexfield.
ArPaymentScheduleGlobalAttributeDate1 A segment of the Receivables Payment Schedule Date global descriptive flexfield 1.
ArPaymentScheduleGlobalAttributeDate2 A segment of the Receivables Payment Schedule Date global descriptive flexfield 2.
ArPaymentScheduleGlobalAttributeDate3 A segment of the Receivables Payment Schedule Date global descriptive flexfield 3.
ArPaymentScheduleGlobalAttributeDate4 A segment of the Receivables Payment Schedule Date global descriptive flexfield 4.
ArPaymentScheduleGlobalAttributeDate5 A segment of the Receivables Payment Schedule Date global descriptive flexfield 5.
ArPaymentScheduleGlobalAttributeNumber1 A segment of the Receivables Payment Schedule Number global descriptive flexfield 1.
ArPaymentScheduleGlobalAttributeNumber2 A segment of the Receivables Payment Schedule Number global descriptive flexfield 2.
ArPaymentScheduleGlobalAttributeNumber3 A segment of the Receivables Payment Schedule Number global descriptive flexfield 3.
ArPaymentScheduleGlobalAttributeNumber4 A segment of the Receivables Payment Schedule Number global descriptive flexfield 4.
ArPaymentScheduleGlobalAttributeNumber5 A segment of the Receivables Payment Schedule Number global descriptive flexfield 5.
ArPaymentScheduleInCollection The option that indicates whether the transaction is in collections.
ArPaymentScheduleInvoiceCurrencyCode The payment schedule currency code.
ArPaymentScheduleLastChargeDate The late charge date of the payment schedule.
ArPaymentScheduleLastUpdateDate The date and time the payment schedule was last updated.
ArPaymentScheduleLastUpdateLogin The session login of the user who last updated the payment schedule.
ArPaymentScheduleLastUpdatedBy The user who last updated the payment schedule.
ArPaymentScheduleModuleId The module that owns the row. A module is an entry in the Application Taxonomy, such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
ArPaymentScheduleNumberOfDueDates The total number of installment due dates on the transaction payment schedule.
ArPaymentScheduleObjectVersionNumber The number used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a payment schedule to detect whether another session has updated the row since it was queried.
ArPaymentScheduleOrgId The identifier of the business unit on the payment schedule.
ArPaymentSchedulePaymentApproval The option that indicates whether a payment is approved or rejected.
ArPaymentSchedulePaymentScheduleClass1 The lookup code for the class of the payment schedule.
ArPaymentSchedulePaymentScheduleId The identifier of the payment schedule.
ArPaymentSchedulePrintRequestId The request identifier of the last printing of the transaction.
ArPaymentScheduleProgramApplicationId The identifier of the process that corresponds to the application that last updated the payment schedule.
ArPaymentScheduleProgramId The identifier of the process that last updated the payment schedule.
ArPaymentScheduleProgramUpdateDate The date a process last updated the payment schedule.
ArPaymentSchedulePromiseAmountLast The amount the customer last promised to pay.
ArPaymentSchedulePromiseDateLast The date the customer last promised to pay.
ArPaymentScheduleReceiptConfirmedFlag The option that indicates whether the receipt was confirmed.
ArPaymentScheduleReceivablesChargesCharged The total additional charges on a payment schedule other than lines, tax, and freight.
ArPaymentScheduleReceivablesChargesRemaining The balance due of the sum of all additional charges on a payment schedule other than lines, tax, and freight.
ArPaymentScheduleRequestId The request identifier of the process that created or last updated the payment schedule or payment schedule installment.
ArPaymentScheduleReservedType The transaction payment schedule reserved for remittance batch processing.
ArPaymentScheduleReservedValue The batch number stored for remittance batch processing.
ArPaymentScheduleReversedCashReceiptId The identifier of the reversed receipt from which a debit memo is created.
ArPaymentScheduleSeedDataSource The source of the payment schedule seed data record. A value of BULK_SEED_DATA_SCRIPT indicates that the record was uploaded in bulk. Otherwise, it specifies the name of the seed data file.
ArPaymentScheduleSelectedForReceiptBatchId The identifier of the automatic receipt batch. A transaction is available for automatic receipt application if this column is null and the transaction is assigned an automatic receipt method.
ArPaymentScheduleStagedDunningLevel The dunning level of the payment schedule item as printed on the dunning correspondence.
ArPaymentScheduleStatus The payment schedule status. Valid values are: OP - Open: amount due remaining, CL - Closed: no amount due.
ArPaymentScheduleTaxOriginal The original tax amount on the payment schedule.
ArPaymentScheduleTaxRemaining The remaining tax amount on the payment schedule.
ArPaymentScheduleTermId The identifier of the payment terms used to calculate the payment schedule.
ArPaymentScheduleTermsSequenceNumber The sequence number assigned to each installment of the payment schedule.
ArPaymentScheduleTrxDate The payment schedule transaction creation date.
ArPaymentScheduleTrxNumber The payment schedule transaction number.