Skip to main content
OracleOps AI
← All tables
Oracle Fusion/Financials/AP

AP_CHECKS_ALL

Payment (check/EFT) header issued to a supplier.

Key Columns

CHECK_IDVENDOR_IDAMOUNTSTATUS_LOOKUP_CODE

Common Joins

AP_INVOICE_PAYMENTS_ALLvia CHECK_ID

The invoice(s) this payment settled — a single payment can pay multiple invoices.

Used In

APCash Management

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.

How a Payables payment is built and accounted

A payment process request selects invoices as documents payable (IBY_DOCS_PAYABLE_ALL) and creates payments in Oracle Payments (IBY_PAYMENTS_ALL). Payables records the payment in AP_CHECKS_ALL, and every subsequent event (clearing, void) is a row in AP_PAYMENT_HISTORY_ALL that Create Accounting posts.

Ask Oracle AI about AP_CHECKS_ALL