Payables Payments
The payables payments view object contains information about payments issued to suppliers or refunds received from suppliers. This view object has one row for each payment made or refund received for a supplier.
Data Store Key : FscmTopModelAM.FinExtractAM.ApBiccExtractAM.DisbursementHeaderExtractPVO
Primary Keys : ApChecksAllCheckId
Initial Extract Date : ApChecksAllCreationDate
Incremental Extract Date : ApChecksAllLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| ApChecksAllActualValueDate | The actual value date of the payment on the statement lines used for bank reconciliation in Oracle Fusion Cash Management. |
| ApChecksAllAddressLine1 | The first address line of the party to whom the payment is made. |
| ApChecksAllAddressLine2 | The second address line of the party to whom the payment is made. |
| ApChecksAllAddressLine3 | The third address line of the party to whom the payment is made. |
| ApChecksAllAddressLine4 | The fourth address line of the party to whom the payment is made. |
| ApChecksAllAddressStyle | The address style of the payee address. |
| ApChecksAllAmount | The payment amount in the payment currency. |
| ApChecksAllAnticipatedValueDate | The anticipated date when the funds will reach the destination bank account. Used by Oracle Fusion Cash Management. |
| ApChecksAllAttribute1 | A segment for the Payables Payment Information descriptive flexfield. |
| ApChecksAllAttribute10 | A segment for the Payables Payment Information descriptive flexfield. |
| ApChecksAllAttribute11 | A segment for the Payables Payment Information descriptive flexfield. |
| ApChecksAllAttribute12 | A segment for the Payables Payment Information descriptive flexfield. |
| ApChecksAllAttribute13 | A segment for the Payables Payment Information descriptive flexfield. |
| ApChecksAllAttribute14 | A segment for the Payables Payment Information descriptive flexfield. |
| ApChecksAllAttribute15 | A segment for the Payables Payment Information descriptive flexfield. |
| ApChecksAllAttribute2 | A segment for the Payables Payment Information descriptive flexfield. |
| ApChecksAllAttribute3 | A segment for the Payables Payment Information descriptive flexfield. |
| ApChecksAllAttribute4 | A segment for the Payables Payment Information descriptive flexfield. |
| ApChecksAllAttribute5 | A segment for the Payables Payment Information descriptive flexfield. |
| ApChecksAllAttribute6 | A segment for the Payables Payment Information descriptive flexfield. |
| ApChecksAllAttribute7 | A segment for the Payables Payment Information descriptive flexfield. |
| ApChecksAllAttribute8 | A segment for the Payables Payment Information descriptive flexfield. |
| ApChecksAllAttribute9 | A segment for the Payables Payment Information descriptive flexfield. |
| ApChecksAllAttributeCategory | The context name for the Payables Payment Information descriptive flexfield. |
| ApChecksAllAttributeDate1 | A date segment for the Payables Payment Information descriptive flexfield. |
| ApChecksAllAttributeDate2 | A date segment for the Payables Payment Information descriptive flexfield. |
| ApChecksAllAttributeDate3 | A date segment for the Payables Payment Information descriptive flexfield. |
| ApChecksAllAttributeDate4 | A date segment for the Payables Payment Information descriptive flexfield. |
| ApChecksAllAttributeDate5 | A date segment for the Payables Payment Information descriptive flexfield. |
| ApChecksAllAttributeNumber1 | A number segment for the Payables Payment Information descriptive flexfield. |
| ApChecksAllAttributeNumber2 | A number segment for the Payables Payment Information descriptive flexfield. |
| ApChecksAllAttributeNumber3 | A number segment for the Payables Payment Information descriptive flexfield. |
| ApChecksAllAttributeNumber4 | A number segment for the Payables Payment Information descriptive flexfield. |
| ApChecksAllAttributeNumber5 | A number segment for the Payables Payment Information descriptive flexfield. |
| ApChecksAllBankAccountName | The name of the internal bank account from where the payment is made. |
| ApChecksAllBankAccountNum | The supplier's bank account number. This is used for electronic payments. |
| ApChecksAllBankAccountType | The supplier's bank account type. This is used for electronic payments. |
| ApChecksAllBankChargeBearer | The party that agrees to assume the liability for bank charges assessed on a transaction. A list of accepted values is defined in the lookup type IBY_BANK_CHARGE_BEARER. |
| ApChecksAllBankNum | The supplier's bank number. This is used for electronic payments. |
| ApChecksAllBaseAmount | The payment amount in ledger currency. |
| ApChecksAllCeBankAcctUseId | The identifier of the internal bank account used for the payment. |
| ApChecksAllCheckDate | The date when the payment is made and mentioned on the payment document. |
| ApChecksAllCheckFormatId | The identifier of the check format used to make the payment. |
| ApChecksAllCheckId | The unique identifier assigned to every payment made. This is the primary key of the Payables Payments view object. |
| ApChecksAllCheckNumber | The check number printed on the physical check. |
| ApChecksAllCheckStockId | The identifier of the payment document used to make the payment. |
| ApChecksAllCheckVoucherNum | The manual voucher number for the payment when document sequential numbering is not used. |
| ApChecksAllCheckrunId | The unique identifier of a payment batch, not applicable to a quick payment. |
| ApChecksAllCheckrunName | The name of the payment batch or quick payment identifier. |
| ApChecksAllCity | The city name of the party to whom the payment is made. |
| ApChecksAllClearedAmount | The payment amount cleared against the payment in Oracle Fusion Cash Management. |
| ApChecksAllClearedBaseAmount | The payment cleared amount in ledger currency. |
| ApChecksAllClearedChargesAmount | The cleared charges amount of the payment. |
| ApChecksAllClearedChargesBaseAmount | The cleared payment charges amount in the ledger currency. |
| ApChecksAllClearedDate | The date when the payment is cleared in Oracle Fusion Cash Management. |
| ApChecksAllClearedErrorAmount | The cleared error amount of the payment. |
| ApChecksAllClearedErrorBaseAmount | The cleared payment error amount in the ledger currency. |
| ApChecksAllClearedExchangeDate | The date when the clearing conversion rate is effective, which is usually the accounting date of a transaction. |
| ApChecksAllClearedExchangeRate | The conversion rate at which the payment is cleared. The resource is only used for foreign currency payments. |
| ApChecksAllClearedExchangeRateType | The conversion rate type at which the payment is cleared. This attribute is only used for foreign currency payments. |
| ApChecksAllCompletedPmtsGroupId | The group identifier used when processing payments in a batch. |
| ApChecksAllCountry | The country name of the party to whom the payment is made. |
| ApChecksAllCounty | The county name of the party to whom the payment is made. |
| ApChecksAllCreatedBy | The user who create the payment row. |
| ApChecksAllCreationDate | The date and time when the payment was created. |
| ApChecksAllCurrencyCode | The currency in which the payment is made. |
| ApChecksAllDescription | The user description for a payment. |
| ApChecksAllDocCategoryCode | The sequential numbering document category name. |
| ApChecksAllDocSequenceId | The identifier of the sequential numbering document sequence. |
| ApChecksAllDocSequenceValue | The sequence number when document sequential numbering is enabled. |
| ApChecksAllEmployeeAddressCode | The address code for the employee. Valid values are Home or Office. |
| ApChecksAllExchangeDate | The date when the conversion rate was used to convert foreign currency payments. |
| ApChecksAllExchangeRate | The conversion rate used to convert foreign currency payments. |
| ApChecksAllExchangeRateType | The type of conversion rate used to convert foreign currency payments. |
| ApChecksAllExternalBankAccountId | The unique identifier for the supplier bank account. |
| ApChecksAllFuturePayDueDate | The negotiable date for future dated payments. |
| ApChecksAllGlobalAttribute1 | A segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttribute10 | A segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttribute11 | A segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttribute12 | A segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttribute13 | A segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttribute14 | A segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttribute15 | A segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttribute16 | A segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttribute17 | A segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttribute18 | A segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttribute19 | A segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttribute2 | A segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttribute20 | A segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttribute3 | A segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttribute4 | A segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttribute5 | A segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttribute6 | A segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttribute7 | A segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttribute8 | A segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttribute9 | A segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttributeCategory | The context name for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttributeDate1 | A date segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttributeDate2 | A date segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttributeDate3 | A date segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttributeDate4 | A date segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttributeDate5 | A date segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttributeNumber1 | A number segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttributeNumber2 | A number segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttributeNumber3 | A number segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttributeNumber4 | A number segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllGlobalAttributeNumber5 | A number segment for the Payables Payment Information global descriptive flexfield. |
| ApChecksAllIbanNumber | The international bank account number. This is used internationally to uniquely identify the account of a customer at a financial institution. |
| ApChecksAllLastUpdateDate | The date when the payment row was last updated. |
| ApChecksAllLastUpdateLogin | The session login associated with the user who last updated the payment. |
| ApChecksAllLastUpdatedBy | The user who last updated the payment row. |
| ApChecksAllLegalEntityId | The unique number of the legal entity associated with the payment. |
| ApChecksAllLogicalGroupReference | The reference of the logical group available on the manual reconciliation search results. Used by Oracle Fusion Cash Management. |
| ApChecksAllMaturityExchangeDate | The date when the maturity conversion rate is effective, which is usually the maturity date for the payment. |
| ApChecksAllMaturityExchangeRate | The conversion rate type at a future dated payment maturity time. This attribute is only used for foreign currency payments. |
| ApChecksAllMaturityExchangeRateType | The conversion rate at a future dated payment maturity time. This attribute is only used for foreign currency payments. |
| ApChecksAllObjectVersionNumber | The number of times the payment row has been updated. |
| ApChecksAllOrgId | The identifier of the business unit associated with the payment. |
| ApChecksAllPartyId | The unique identifier of the party to whom the payment is made. |
| ApChecksAllPartySiteId | The unique identifier of the party site to whom the payment is made. |
| ApChecksAllPaymentDocumentId | The identifier of the payment document used to make the payment. |
| ApChecksAllPaymentId | The unique identifier of the payment. |
| ApChecksAllPaymentInstructionId | The identifier of the payment file generated for the given payment. |
| ApChecksAllPaymentMethodCode | The user-entered payment method code that helps to uniquely identify a payment method. |
| ApChecksAllPaymentMethodLookupCode | The payment method used to make the payment. |
| ApChecksAllPaymentProfileId | The identifier of the payment process profile. |
| ApChecksAllPaymentTypeFlag | The type of payment such as Manual, Quick, Refund, and Payment Process Request. |
| ApChecksAllPositivePayStatusCode | The payment status for the invoice. This is used by the Positive Pay Report to select records. |
| ApChecksAllProvince | The province of the party to whom the payment is made. |
| ApChecksAllReconFlag | The option to indicate whether the payment is reconciled. Accepted values are Y and N. |
| ApChecksAllReconciliationBatchId | The identifier of the batch used for reconciliation in Oracle Fusion Cash Management. |
| ApChecksAllRelationshipId | The identifier of the third party relationship to whom the payment is made. |
| ApChecksAllReleasedBy | The user who released the stop payment. |
| ApChecksAllReleasedDate | The date on which the stop payment was released. |
| ApChecksAllRemitToAddressId | The identifier of the remit-to address where the payment is sent. |
| ApChecksAllRemitToAddressName | The third-party payment related remit-to address where the payment is sent. |
| ApChecksAllRemitToSupplierId | The identifier of the third-party payment related remit-to supplier where the payment is sent. |
| ApChecksAllRemitToSupplierName | The third-party payment related remit-to supplier where the payment is sent. |
| ApChecksAllRequestId | The unique identifier of the job that created or last updated the payment row. |
| ApChecksAllSettlementPriority | The priority with which the financial institution or payment system should settle payment for this document. A list of accepted values is defined in the lookup type IBY_SETTLEMENT_PRIORITY. |
| ApChecksAllStampDutyAmt | The stamp duty tax amount. |
| ApChecksAllStampDutyBaseAmt | The stamp duty tax amount in the ledger currency. |
| ApChecksAllState | The state name of the party to whom the payment is made. |
| ApChecksAllStatusLookupCode | The status of the payment. Accepted values include Negotiable, Set Up, and Spoiled. |
| ApChecksAllStoppedBy | The user who recorded the stop payment. |
| ApChecksAllStoppedDate | The date and time when the user recorded the stop payment. |
| ApChecksAllTransferPriority | The transfer priority of the payment. |
| ApChecksAllTreasuryPayDate | The date on which the payment is processed through the internal treasury department of the organization. |
| ApChecksAllTreasuryPayNumber | The payment number assigned to payments processed through the internal treasury department of the organization. |
| ApChecksAllUssglTransactionCode | The USSGL transaction code used to create Standard General Ledger journal entries. |
| ApChecksAllUssglTrxCodeContext | The context name for the USSGL Transaction Code Descriptive flexfield. |
| ApChecksAllVendorId | The unique identifier of the supplier to whom the payment is made. |
| ApChecksAllVendorName | The name of the supplier to whom the payment is made. |
| ApChecksAllVendorSiteCode | The name of the supplier site to whom the payment is made. |
| ApChecksAllVendorSiteId | The identifier of the supplier site to whom the payment is made. |
| ApChecksAllVoidDate | The date when the payment is voided. |
| ApChecksAllXCurrRateType | The conversion rate type used to convert the invoice currency to payment currency. |
| ApChecksAllZip | The postal code or ZIP code of the party to whom the payment is made. |