AP Invoice Tables
AP_INVOICES_ALL is the invoice header; lines, distributions, holds, payment schedule and settlement live in related child tables.
Key tables
AP_INVOICES_ALL
CuratedInvoice header — supplier, amount, invoice date, payment terms, currency.
Key columns
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
CuratedInvoice line detail — item/expense lines tied to a header.
Key columns
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
CuratedAccounting distributions generated from invoice lines for GL posting.
Key columns
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
CuratedScheduled payment installments for an invoice, including due dates and amounts remaining.
Key columns
Common joins
AP_INVOICES_ALL via INVOICE_ID
The invoice this payment installment belongs to.
AP_INVOICE_PAYMENTS_ALL
CuratedLinks invoices to the payments (checks/EFT) that settled them.
Key columns
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
CuratedHolds placed on an invoice (matching, tax, variance, etc.) that block payment/accounting.
Key columns
Common joins
AP_INVOICES_ALL via INVOICE_ID
The invoice this hold is blocking.
AP_CHECKS_ALL
CuratedPayment (check/EFT) header issued to a supplier.
Key columns
Common joins
AP_INVOICE_PAYMENTS_ALL via CHECK_ID
The invoice(s) this payment settled — a single payment can pay multiple invoices.
Key columns
| Table | Key columns |
|---|---|
| AP_INVOICES_ALL | INVOICE_IDINVOICE_NUMVENDOR_IDINVOICE_AMOUNTINVOICE_DATE |
| AP_INVOICE_LINES_ALL | INVOICE_IDLINE_NUMBERLINE_TYPE_LOOKUP_CODEAMOUNT |
| AP_INVOICE_DISTRIBUTIONS_ALL | INVOICE_IDINVOICE_LINE_NUMBERDIST_CODE_COMBINATION_ID |
| AP_PAYMENT_SCHEDULES_ALL | INVOICE_IDPAYMENT_NUMDUE_DATEAMOUNT_REMAINING |
| AP_INVOICE_PAYMENTS_ALL | INVOICE_IDCHECK_IDAMOUNT |
| AP_HOLDS_ALL | INVOICE_IDHOLD_LOOKUP_CODERELEASE_LOOKUP_CODEHOLD_DATE |
| AP_CHECKS_ALL | CHECK_IDVENDOR_IDAMOUNTSTATUS_LOOKUP_CODE |
Relationships
- AP_INVOICES_ALLInvoice headerINVOICE_ID
- AP_INVOICE_LINES_ALLInvoice line detailINVOICE_ID + INVOICE_LINE_NUMBER
- AP_INVOICE_DISTRIBUTIONS_ALLAccounting distributions generated from invoice lines for GL posting.
- AP_PAYMENT_SCHEDULES_ALLScheduled payment installments for an invoice, including due dates and amounts remaining.
- AP_INVOICE_PAYMENTS_ALLLinks invoices to the payments (checks/EFT) that settled them.
- AP_HOLDS_ALLHolds placed on an invoice (matching, tax, variance, etc.) that block payment/accounting.
- AP_CHECKS_ALLPayment (check/EFT) header issued to a supplier.
Technical flow
Related questions
Model-generated, grounded against the curated knowledge layer. Check specifics against your instance.