Oracle Fusion/Financials/AP

AP_INVOICE_LINES_ALL

Invoice line detail — item/expense lines tied to a header.

Key Columns

INVOICE_IDLINE_NUMBERLINE_TYPE_LOOKUP_CODEAMOUNT

Parent Table

AP_INVOICES_ALL

Invoice header — supplier, amount, invoice date, payment terms, currency.

Child Tables

AP_INVOICE_DISTRIBUTIONS_ALL

Accounting distributions generated from invoice lines for GL posting.

Common Joins

AP_INVOICES_ALLvia INVOICE_ID

The invoice header this line belongs to.

AP_INVOICE_DISTRIBUTIONS_ALLvia INVOICE_ID + INVOICE_LINE_NUMBER

The GL accounting distribution(s) generated from this line for posting.

Used In

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.