OracleOps AI
← All tables
Oracle Fusion/Financials/AP

AP_PAYMENT_SCHEDULES_ALL

Scheduled payment installments for an invoice, including due dates and amounts remaining.

Key Columns

INVOICE_IDPAYMENT_NUMDUE_DATEAMOUNT_REMAINING

Parent Table

AP_INVOICES_ALL

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

Common Joins

AP_INVOICES_ALLvia INVOICE_ID

The invoice this payment installment belongs to.

Used In

AP

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_PAYMENT_SCHEDULES_ALL