Search Results ap_terms_lines




Overview
Explore in AI Chat

Overview

AP_TERMS_LINES is a detail table in the Oracle E-Business Suite Payables (AP) module, owned by the AP schema. It stores the line-level definition of payment terms configured in Oracle Payables. Where the header-level terms table (AP_TERMS) records the general attributes of a payment term such as its name and whether it is a discount or due term, AP_TERMS_LINES holds the individual installments and discount schedule entries that make up that term. Each row describes one line of a payment term, including the portion due, the number of days or months added to the invoice date, and any associated discount conditions.

Because the table pivots on a composite key of TERM_ID and SEQUENCE_NUM, the heuristic Data Vault classification mined from the FK structure is standalone. In a Data Vault modeling exercise, this object is best treated as a link-style or detail satellite candidate tied to the term header, since its grain is defined entirely by its parent term and an ordering attribute rather than by an independent business entity.

Key Information Stored

The physical schema documents 48 columns. The most significant are:

The surrogate primary key is AP_TERMS_LINES_PK on (TERM_ID, SEQUENCE_NUM). The unique index AP_TERMS_LINES_U1 mirrors that same column pair, confirming it as the business-key candidate.

Common Use Cases and Queries

Typical scenarios include reconstructing how a term will schedule invoice payments, reporting on discount opportunities, and reconciling payment term behavior during period close or cash forecasting.

  • List all lines for a term: SELECT * FROM ap_terms_lines WHERE term_id = :term_id ORDER BY sequence_num;
  • Join to the term header: SELECT t.name, l.sequence_num, l.due_percent, l.due_days FROM ap_terms t, ap_terms_lines l WHERE t.term_id = l.term_id;
  • Identify terms offering discounts: filter where DISCOUNT_PERCENT > 0 to drive early-payment discount analysis.
  • Installment extraction: multiply DUE_PERCENT by invoice amount to derive scheduled payment amounts for reporting.

Because the table carries audit and DFF columns, it is also common in interfaces and concurrent programs that validate or migrate payment term definitions between instances.

Related Objects

Given the standalone classification, the principal relationships are:

  • AP_TERMS — Parent header table joined on TERM_ID; supplies term name and type.
  • AP_INVOICE_PAYMENTS and AP_PAYMENT_SCHEDULES — Consume term line logic to generate scheduled installments.
  • AP_INVOICES_ALL — References the term via TERM_ID for payment scheduling.
  • AP_TERMS_LINES_PK / AP_TERMS_LINES_U1 — Constraining indexes on (TERM_ID, SEQUENCE_NUM).
  • PO_TERMS and its lines — Parallel purchasing-side term definitions frequently mapped against AP terms during setup.
  • AP_TERMS_LINES interfaces — Migration and validation routines that read and write this table during implementation.