OracleOps AI
← All tables
Oracle Fusion/Financials/AP

AP_INVOICE_PAYMENTS_ALL

Links invoices to the payments (checks/EFT) that settled them.

Key Columns

INVOICE_IDCHECK_IDAMOUNT

Parent Table

AP_INVOICES_ALL

Invoice header — supplier, amount, invoice date, payment terms, currency.

Common Joins

AP_INVOICES_ALLvia INVOICE_ID

The invoice this payment was applied to.

AP_CHECKS_ALLvia CHECK_ID

The payment (check/EFT) header that paid this invoice.

Used In

AP

Related

AP invoice data model

AP_INVOICES_ALL (header) → AP_INVOICE_LINES_ALL (lines) → AP_INVOICE_DISTRIBUTIONS_ALL (accounting). Payment status lives on AP_PAYMENT_SCHEDULES_ALL and settlement on AP_INVOICE_PAYMENTS_ALL/AP_CHECKS_ALL.

Ask Oracle AI about AP_INVOICE_PAYMENTS_ALL