What tables contain AP invoices?
AP Invoice Tables
Oracle Fusion · Financials · AP
AP_INVOICES_ALL is the invoice header; lines, distributions, holds, payment schedule and settlement live in related child tables.
Grounded in: Curated Oracle knowledge layer — AP
Key Tables
AP_INVOICES_ALL
Invoice header — supplier, amount, invoice date, payment terms, currency.
Common Joins
AP_INVOICE_LINES_ALL via INVOICE_ID
Line-level detail for the invoice — one row per item/expense line, tied back to the header by INVOICE_ID.
AP_PAYMENT_SCHEDULES_ALL via INVOICE_ID
The scheduled payment installment(s) for this invoice — due dates and amount remaining.
AP_HOLDS_ALL via INVOICE_ID
Any holds currently blocking this invoice from accounting or payment.
PO_HEADERS_ALL via PO_HEADER_ID (when PO-matched)
The purchase order this invoice was matched to, when it's a PO-matched invoice rather than a standalone one.
AP_INVOICE_LINES_ALL
Invoice line detail — item/expense lines tied to a header.
Common Joins
AP_INVOICES_ALL via INVOICE_ID
The invoice header this line belongs to.
AP_INVOICE_DISTRIBUTIONS_ALL via INVOICE_ID + INVOICE_LINE_NUMBER
The GL accounting distribution(s) generated from this line for posting.
AP_INVOICE_DISTRIBUTIONS_ALL
Accounting distributions generated from invoice lines for GL posting.
Common Joins
AP_INVOICE_LINES_ALL via INVOICE_ID + INVOICE_LINE_NUMBER
The invoice line this distribution was generated from.
GL_CODE_COMBINATIONS via DIST_CODE_COMBINATION_ID = CODE_COMBINATION_ID
The GL account this distribution posted to.
AP_PAYMENT_SCHEDULES_ALL
Scheduled payment installments for an invoice, including due dates and amounts remaining.
Common Joins
AP_INVOICES_ALL via INVOICE_ID
The invoice this payment installment belongs to.
AP_INVOICE_PAYMENTS_ALL
Links invoices to the payments (checks/EFT) that settled them.
Common Joins
AP_INVOICES_ALL via INVOICE_ID
The invoice this payment was applied to.
AP_CHECKS_ALL via CHECK_ID
The payment (check/EFT) header that paid this invoice.
AP_HOLDS_ALL
Holds placed on an invoice (matching, tax, variance, etc.) that block payment/accounting.
Common Joins
AP_INVOICES_ALL via INVOICE_ID
The invoice this hold is blocking.
AP_CHECKS_ALL
Payment (check/EFT) header issued to a supplier.
Common Joins
AP_INVOICE_PAYMENTS_ALL via CHECK_ID
The invoice(s) this payment settled — a single payment can pay multiple invoices.
Technical Flow
Relationships
AP_INVOICES_ALL
├── AP_INVOICE_LINES_ALL
│ └── AP_INVOICE_DISTRIBUTIONS_ALL
├── AP_PAYMENT_SCHEDULES_ALL
├── AP_HOLDS_ALL
└── AP_INVOICE_PAYMENTS_ALL
└── AP_CHECKS_ALLRelated Questions
Have a follow-up, or a different question?
Continue in Ask Oracle AI