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

IBY_DOCS_PAYABLE_ALL

Documents payable — one row per invoice selected into a payment, carrying the paid amount and discount taken.

Key Columns

DOCUMENT_PAYABLE_IDPAYMENT_IDCALLING_APP_DOC_REF_NUMBERCALLING_APP_DOC_UNIQUE_REF2PAYMENT_CURRENCY_CODEAMOUNT

Parent Table

IBY_PAYMENTS_ALL

Oracle Payments — the actual payment created by a payment process request, before it becomes an AP check row.

Used In

APPayments

Notes

CALLING_APP_DOC_UNIQUE_REF2 typically holds the AP INVOICE_ID.

Related

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 IBY_DOCS_PAYABLE_ALL