OracleOps AI
← All tables
Oracle Fusion/Financials/AP

AP_INVOICE_DISTRIBUTIONS_ALL

Accounting distributions generated from invoice lines for GL posting.

Key Columns

INVOICE_IDINVOICE_LINE_NUMBERDIST_CODE_COMBINATION_ID

Parent Table

AP_INVOICE_LINES_ALL

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

Common Joins

AP_INVOICE_LINES_ALLvia INVOICE_ID + INVOICE_LINE_NUMBER

The invoice line this distribution was generated from.

GL_CODE_COMBINATIONSvia DIST_CODE_COMBINATION_ID = CODE_COMBINATION_ID

The GL account this distribution posted to.

Used In

APSubledger AccountingGeneral Ledger

Related

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.

Ask Oracle AI about AP_INVOICE_DISTRIBUTIONS_ALL