Search Results ap_terms_lines




Overview
Explore in AI Chat

Overview

The AP_TERMS_LINES table is a core data structure within the Oracle E-Business Suite Payables (AP) module. It stores the detailed, line-level components that define a payment term template. Payment terms are critical business rules that determine when supplier invoices are due for payment, often specifying multiple installments with distinct due dates and potential discount opportunities. This table works in conjunction with the header table, AP_TERMS, to provide a complete definition. Each record in AP_TERMS_LINES represents a single installment or line of a payment term, enabling the system to automatically calculate due dates, discount dates, and discount amounts for transactions.

Key Information Stored

The table's structure is defined by its primary key, which consists of TERM_ID and SEQUENCE_NUM. The TERM_ID is a foreign key linking the line to its parent payment term definition in the AP_TERMS table. The SEQUENCE_NUM dictates the order of installments. While the provided ETRM excerpt does not list specific columns, based on standard Oracle EBS Payables implementation, this table typically holds critical attributes for each term line. These include the DAYS (or DAYS_FROM), which specifies the number of days from a baseline date (e.g., invoice date, receipt date) for calculating the due date; the DISCOUNT_DAYS for early payment discount eligibility; the DISCOUNT_PERCENT offered; and columns indicating the baseline date type. It is the granular data in this table that allows the system to perform complex payment term calculations automatically.

Common Use Cases and Queries

The primary use case is the automatic population and calculation of payment schedules for invoices, debit memos, and credit memos. When a transaction is assigned a payment term, the application queries this table to generate the schedule. Common reporting and query scenarios include analyzing the structure of payment terms or troubleshooting payment schedule calculations. A typical SQL pattern to inspect a term's installments would join to the AP_TERMS header:

  • SELECT atl.sequence_num, atl.days, atl.discount_percent, atl.discount_days FROM ap_terms_lines atl JOIN ap_terms at ON at.term_id = atl.term_id WHERE at.name = 'NET 30';

This query retrieves the line details for a payment term named 'NET 30'. Data from this table is also essential for audits and for creating custom reports on payment term usage and discount liabilities.

Related Objects

AP_TERMS_LINES has a direct and fundamental relationship with several key Payables objects. Its most critical relationship is with the AP_TERMS table, which stores the header-level information (NAME, DESCRIPTION, CREATION_DATE). The TERM_ID column in AP_TERMS_LINES is a foreign key to AP_TERMS.TERM_ID. This table is referenced by transactional entities throughout Payables, such as the AP_INVOICES table (which stores the TERM_ID for an invoice) and the derived AP_PAYMENT_SCHEDULES table, whose records are generated based on the rules defined in AP_TERMS_LINES. Standard APIs for creating or modifying payment terms will also internally manipulate data in this table.