Invoice Installments
The invoice installments view object contains information about scheduled payments for a supplier invoice. Each supplier invoice has one or more installments and this information is used to determine when to make payments on an invoice and how much to pay in an automatic payment batch. Each row of this view object stores the installment amount, discount available, payment priority, payment status and so on. The combination of ApPaymentSchedulesAllInvoiceId and ApPaymentSchedulesAllPaymentNum forms the unique identifier of the Invoice Installments view object.
Data Store Key : FscmTopModelAM.FinExtractAM.ApBiccExtractAM.InvoicePaymentScheduleExtractPVO
Primary Keys : ApPaymentSchedulesAllInvoiceId, ApPaymentSchedulesAllPaymentNum
Initial Extract Date : ApPaymentSchedulesAllCreationDate
Incremental Extract Date : ApPaymentSchedulesAllLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| ApPaymentSchedulesAllAmountRemaining | The invoice installment amount remaining for payment. |
| ApPaymentSchedulesAllAttribute1 | A segment for the Invoice Payments descriptive flexfield. |
| ApPaymentSchedulesAllAttribute10 | A segment for the Invoice Payments descriptive flexfield. |
| ApPaymentSchedulesAllAttribute11 | A segment for the Invoice Payments descriptive flexfield. |
| ApPaymentSchedulesAllAttribute12 | A segment for the Invoice Payments descriptive flexfield. |
| ApPaymentSchedulesAllAttribute13 | A segment for the Invoice Payments descriptive flexfield. |
| ApPaymentSchedulesAllAttribute14 | A segment for the Invoice Payments descriptive flexfield. |
| ApPaymentSchedulesAllAttribute15 | A segment for the Invoice Payments descriptive flexfield. |
| ApPaymentSchedulesAllAttribute2 | A segment for the Invoice Payments descriptive flexfield. |
| ApPaymentSchedulesAllAttribute3 | A segment for the Invoice Payments descriptive flexfield. |
| ApPaymentSchedulesAllAttribute4 | A segment for the Invoice Payments descriptive flexfield. |
| ApPaymentSchedulesAllAttribute5 | A segment for the Invoice Payments descriptive flexfield. |
| ApPaymentSchedulesAllAttribute6 | A segment for the Invoice Payments descriptive flexfield. |
| ApPaymentSchedulesAllAttribute7 | A segment for the Invoice Payments descriptive flexfield. |
| ApPaymentSchedulesAllAttribute8 | A segment for the Invoice Payments descriptive flexfield. |
| ApPaymentSchedulesAllAttribute9 | A segment for the Invoice Payments descriptive flexfield. |
| ApPaymentSchedulesAllAttributeCategory | The context name for the Invoice Payments descriptive flexfield. |
| ApPaymentSchedulesAllAttributeDate1 | A date segment for the Invoice Payments descriptive flexfield. |
| ApPaymentSchedulesAllAttributeDate2 | A date segment for the Invoice Payments descriptive flexfield. |
| ApPaymentSchedulesAllAttributeDate3 | A date segment for the Invoice Payments descriptive flexfield. |
| ApPaymentSchedulesAllAttributeDate4 | A date segment for the Invoice Payments descriptive flexfield. |
| ApPaymentSchedulesAllAttributeDate5 | A date segment for the Invoice Payments descriptive flexfield. |
| ApPaymentSchedulesAllAttributeNumber1 | A number segment for the Invoice Payments descriptive flexfield. |
| ApPaymentSchedulesAllAttributeNumber2 | A number segment for the Invoice Payments descriptive flexfield. |
| ApPaymentSchedulesAllAttributeNumber3 | A number segment for the Invoice Payments descriptive flexfield. |
| ApPaymentSchedulesAllAttributeNumber4 | A number segment for the Invoice Payments descriptive flexfield. |
| ApPaymentSchedulesAllAttributeNumber5 | A number segment for the Invoice Payments descriptive flexfield. |
| ApPaymentSchedulesAllBatchId | The identifier of the invoice batch referenced in the invoice installment. |
| ApPaymentSchedulesAllCheckrunId | The identifier of the payment batch in which the invoice installment is selected for payment. When the installment is selected for payment in a payment batch, this attribute is updated with the identifier of the payment batch. |
| ApPaymentSchedulesAllCreatedBy | The user who created the invoice installment. |
| ApPaymentSchedulesAllCreationDate | The date and time when the invoice installment was created. |
| ApPaymentSchedulesAllDiscountAmountAvailable | The discount amount available on the first discount date. |
| ApPaymentSchedulesAllDiscountAmountRemaining | The discount amount available on remaining payment amount. |
| ApPaymentSchedulesAllDiscountDate | The date when the first discount is available. |
| ApPaymentSchedulesAllDueDate | The date when the invoice installment is due for payment. |
| ApPaymentSchedulesAllExternalBankAccountId | The unique identifier for the supplier bank account. |
| ApPaymentSchedulesAllGlobalAttribute1 | A segment of the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttribute10 | A segment of the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttribute11 | A segment of the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttribute12 | A segment of the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttribute13 | A segment of the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttribute14 | A segment of the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttribute15 | A segment of the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttribute16 | A segment of the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttribute17 | A segment of the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttribute18 | A segment of the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttribute19 | A segment of the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttribute2 | A segment of the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttribute20 | A segment of the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttribute3 | A segment of the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttribute4 | A segment of the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttribute5 | A segment of the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttribute6 | A segment of the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttribute7 | A segment of the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttribute8 | A segment of the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttribute9 | A segment of the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttributeCategory | The context name for the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttributeDate1 | A date segment for the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttributeDate2 | A date segment for the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttributeDate3 | A date segment for the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttributeDate4 | A date segment for the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttributeDate5 | A date segment for the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttributeNumber1 | A number segment for the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttributeNumber2 | A number segment for the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttributeNumber3 | A number segment for the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttributeNumber4 | A number segment for the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGlobalAttributeNumber5 | A number segment for the Invoice Payments global descriptive flexfield. |
| ApPaymentSchedulesAllGrossAmount | The gross amount due for the invoice installment. |
| ApPaymentSchedulesAllHeldBy | The user who placed or requested the hold. |
| ApPaymentSchedulesAllHoldDate | The date when the hold was placed. |
| ApPaymentSchedulesAllHoldFlag | Indicates whether a scheduled payment is on hold. |
| ApPaymentSchedulesAllIbyHoldReason | An explanation or justification provided for placing or releasing the hold on the installment. |
| ApPaymentSchedulesAllInvCurrGrossAmount | The gross amount due for the invoice installment in the invoice currency. |
| ApPaymentSchedulesAllInvoiceId | The unique invoice identifier of the invoice referenced in the invoice installments. This forms part of the primary key for the Invoice Installments view object. |
| ApPaymentSchedulesAllLastUpdateDate | The date when the invoice installment was last updated. |
| ApPaymentSchedulesAllLastUpdateLogin | The session login associated with the user who last updated the invoice installment. |
| ApPaymentSchedulesAllLastUpdatedBy | The user who last updated the invoice installment. |
| ApPaymentSchedulesAllObjectVersionNumber | The number of times the invoice installment row has been updated. |
| ApPaymentSchedulesAllOrgId | The identifier of the business unit associated with the invoice installment. |
| ApPaymentSchedulesAllPaymentCrossRate | The conversion rate from invoice currency to payment currency for the invoice installment. |
| ApPaymentSchedulesAllPaymentMethodCode | The payment method of the installment. |
| ApPaymentSchedulesAllPaymentMethodLookupCode | This attribute is currently unused. |
| ApPaymentSchedulesAllPaymentNum | The identifying number of the installment. This forms part of the primary key of the Invoice Installments view object. |
| ApPaymentSchedulesAllPaymentPriority | The number representing the payment priority of an invoice installment. Valid values are from 1 to 99. |
| ApPaymentSchedulesAllPaymentStatusFlag | Indicates whether payment has been made for the installment. A value of Y indicates fully paid, N indicates unpaid and P indicates partially paid installments. |
| ApPaymentSchedulesAllRelationshipId | The identifier of the third-party payment relationship. |
| ApPaymentSchedulesAllRemitToAddressId | The identifier of the third-party payment related remit-to address where the payment should be sent. |
| ApPaymentSchedulesAllRemitToAddressName | The third-party payment related remit-to address where the payment should be sent. |
| ApPaymentSchedulesAllRemitToSupplierId | The identifier of the third-party payment related remit-to supplier where the payment should be sent. |
| ApPaymentSchedulesAllRemitToSupplierName | The third-party payment related remit-to supplier where the payment should be sent. |
| ApPaymentSchedulesAllRemittanceMessage1 | The remittance message for use in payment processing. |
| ApPaymentSchedulesAllRemittanceMessage2 | The remittance message for use in payment processing. |
| ApPaymentSchedulesAllRemittanceMessage3 | The remittance message for use in payment processing. |
| ApPaymentSchedulesAllSecondDiscAmtAvailable | The discount amount available on the second discount date. |
| ApPaymentSchedulesAllSecondDiscountDate | The date when the second discount is available. |
| ApPaymentSchedulesAllThirdDiscAmtAvailable | The discount amount available on the third discount date. |
| ApPaymentSchedulesAllThirdDiscountDate | The date when the third discount is available. |