AP_INVOICES_ALL
Invoice header — supplier, amount, invoice date, payment terms, currency.
Key Columns
Child Tables
AP_INVOICE_LINES_ALL
Invoice line detail — item/expense lines tied to a header.
AP_PAYMENT_SCHEDULES_ALL
Scheduled payment installments for an invoice, including due dates and amounts remaining.
AP_INVOICE_PAYMENTS_ALL
Links invoices to the payments (checks/EFT) that settled them.
AP_HOLDS_ALL
Holds placed on an invoice (matching, tax, variance, etc.) that block payment/accounting.
Common Joins
AP_INVOICE_LINES_ALLvia INVOICE_IDLine-level detail for the invoice — one row per item/expense line, tied back to the header by INVOICE_ID.
AP_PAYMENT_SCHEDULES_ALLvia INVOICE_IDThe scheduled payment installment(s) for this invoice — due dates and amount remaining.
AP_HOLDS_ALLvia INVOICE_IDAny holds currently blocking this invoice from accounting or payment.
PO_HEADERS_ALLvia 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.
Used In
Related
AP invoice holds
Invoices go on hold when validation finds a matching, tax, variance, or funds issue. Holds are recorded in AP_HOLDS_ALL and must be released before the invoice can be accounted or paid.
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.