Invoice Payments

The invoice payments view object contains information about invoice payments made to suppliers such as payment amount, payment number, bank details and so on. There is one row for each payment made for each invoice.

Data Store Key : FscmTopModelAM.FinExtractAM.ApBiccExtractAM.PaidDisbursementScheduleExtractPVO

Primary Keys : ApInvoicePaymentsAllInvoicePaymentId

Initial Extract Date : ApInvoicePaymentsAllCreationDate

Incremental Extract Date : ApInvoicePaymentsAllLastUpdateDate

Attributes

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

Name	Description
ApInvoicePaymentsAllAccountingDate	The date when payment accounting is posted.
ApInvoicePaymentsAllAccountingEventId	The identifier of the payment accounting event.
ApInvoicePaymentsAllAcctsPayCodeCombinationId	The identifier of the accounting code combination used for the payables liability account.
ApInvoicePaymentsAllAmount	The amount paid for each invoice installment in payment currency.
ApInvoicePaymentsAllAmountInvCurr	The amount paid for each invoice installment in invoice currency.
ApInvoicePaymentsAllAnnualPercentageRate	The discount percent rate for the dynamic discount calculation.
ApInvoicePaymentsAllAprAssignmentId	The early payment offer associated with the supplier.
ApInvoicePaymentsAllAssetCodeCombinationId	The identifier of the accounting code combination used for the cash account.
ApInvoicePaymentsAllAssetsAdditionFlag	Indicates whether discounts on the invoice payment have been transferred to Oracle Fusion Assets. A value of U indicates that the payment discount is not yet processed. A value of Y indicates that discount has been transferred and a value of N indicates that the discount has not been transferred to Oracle Fusion Assets.
ApInvoicePaymentsAllBankAccountNum	The number of the bank account from which a payment is issued.
ApInvoicePaymentsAllBankAccountType	The bank account type of the bank from which payment is being made. For example, a savings or checking account.
ApInvoicePaymentsAllBankNum	The unique identification number of the bank from which the payment is being made.
ApInvoicePaymentsAllCheckId	The unique identifier maintained for every payment made. This is a foreign key of the Payables Payments view object.
ApInvoicePaymentsAllCreatedBy	The user who created the invoice payment row.
ApInvoicePaymentsAllCreationDate	The date and time when the invoice payment was created.
ApInvoicePaymentsAllDaysAccelerated	The number of days used for the dynamic discount calculation.
ApInvoicePaymentsAllDiscountLost	The discount amount lost when the invoice payment is not made in time to avail the discount.
ApInvoicePaymentsAllDiscountLostInvCurr	The discount amount lost in payment currency when the invoice payment is not made in time to avail the discount.
ApInvoicePaymentsAllDiscountTaken	The amount of the discount realized at the time of payment creation.
ApInvoicePaymentsAllDiscountTakenInvCurr	The amount of the discount realized in invoice currency.
ApInvoicePaymentsAllExchangeDate	The date effective for the conversion rate.
ApInvoicePaymentsAllExchangeRate	The conversion rate used to convert the payment amount to ledger currency.
ApInvoicePaymentsAllExchangeRateType	The rate type associated with the conversion rate.
ApInvoicePaymentsAllExternalBankAccountId	The identifier of the external bank account.
ApInvoicePaymentsAllGainCodeCombinationId	The identifier of the accounting code combination used for the realized exchange rate gains account.
ApInvoicePaymentsAllIbanNumber	The international bank account number. Used internationally to uniquely identify the account of a customer at a financial institution.
ApInvoicePaymentsAllInvOrgId	The business unit name for the invoice.
ApInvoicePaymentsAllInvoiceBaseAmount	The payment amount in functional currency at the invoice conversion rate. This attribute is only used for foreign currency invoice payments.
ApInvoicePaymentsAllInvoiceCurrencyCode	The currency code of the supplier invoice.
ApInvoicePaymentsAllInvoiceId	The unique identifier of the supplier invoice for which the payment has been made.
ApInvoicePaymentsAllInvoicePaymentId	The unique identifier of the payment. This is the primary key of the Invoice Payments view object.
ApInvoicePaymentsAllInvoicePaymentType	Indicates the type of payment. Possible payment types are Quick, Manual, Payment Process Request, or Refund.
ApInvoicePaymentsAllInvoicingPartyId	The identifier of the original party for third party payments.
ApInvoicePaymentsAllInvoicingPartySiteId	The identifier of the original party site for third party payments.
ApInvoicePaymentsAllInvoicingVendorSiteId	The identifier of the original supplier site for third party payments.
ApInvoicePaymentsAllLastUpdateDate	The date when the invoice payment row was last updated.
ApInvoicePaymentsAllLastUpdateLogin	The session login associated with the user who last updated the invoice payment row.
ApInvoicePaymentsAllLastUpdatedBy	The user who last updated the invoice payment row.
ApInvoicePaymentsAllLossCodeCombinationId	The identifier of the accounting code combination used for realized exchange rate losses.
ApInvoicePaymentsAllObjectVersionNumber	The number of times that the invoice payment row has been updated.
ApInvoicePaymentsAllOrgId	The identifier of the business unit associated with the invoice.
ApInvoicePaymentsAllPaymentBaseAmount	The invoice payment amount in the ledger currency derived using the invoice payment amount at the payment conversion rate. Used only for foreign currency invoice payments.
ApInvoicePaymentsAllPaymentCurrencyCode	The currency code of the payment.
ApInvoicePaymentsAllPaymentNum	The identifying number of the payment.
ApInvoicePaymentsAllPeriodName	The period name associated with the payment.
ApInvoicePaymentsAllPostedFlag	Indicates if the payment has been posted.
ApInvoicePaymentsAllRemitToAddressId	The identifier of the remit-to address where the payment is sent.
ApInvoicePaymentsAllRemitToAddressName	The third-party payment related remit-to address where the payment is sent.
ApInvoicePaymentsAllRemitToSupplierId	The identifier of the third-party payment related remit-to supplier where the payment is sent.
ApInvoicePaymentsAllRemitToSupplierName	The third-party payment related remit-to supplier where the payment is sent.
ApInvoicePaymentsAllReversalFlag	Indicates if the invoice payment is a reversal of another invoice payment. Used for payments that are voided.
ApInvoicePaymentsAllReversalInvPmtId	The identifier of the invoice payment that was reversed through the current invoice payment. Used for payments that are voided.
ApInvoicePaymentsAllSetOfBooksId	The unique identifier of the ledger associated with the payment.
ApInvoicePaymentsAllXCurrRate	The conversion rate used to convert the invoice currency to the payment currency. Used when the payment currency differs from the invoice currency.