Search Results ra_terms_lines

Overview

The RA_TERMS_LINES table is a core data object within the Oracle E-Business Suite (EBS) Receivables (AR) module, specifically for versions 12.1.1 and 12.2.2. It functions as the detailed repository for line-level information that defines the structure of a payment term. While the header table RA_TERMS_B defines the overall term, RA_TERMS_LINES stores the specific installment breakdown, including due dates, discount percentages, and installment amounts. This table is essential for the system's ability to calculate and schedule customer payment obligations and potential early payment discounts automatically upon transaction entry.

Key Information Stored

The table's structure centers on defining individual installments within a payment term. The primary key, composed of TERM_ID and SEQUENCE_NUM, ensures uniqueness for each line of a given term. Key columns include TERM_ID, which links the line to its parent definition in RA_TERMS_B, and SEQUENCE_NUM, which dictates the order of installments. Critical data columns typically include DAYS (the number of days from the transaction date for the installment due date), DISCOUNT_PERCENT (the percentage discount offered for early payment), and DISCOUNT_DAYS (the period within which the discount is valid). The table may also store a relative percentage for the installment amount, though specific column names for amounts are not detailed in the provided metadata.

Common Use Cases and Queries

This table is central to any process involving payment term analysis, validation, or reporting. Common use cases include auditing term structures, troubleshooting transaction payment schedules, and generating custom reports on discount policies. A typical query retrieves all installments for a specific term to understand its schedule. For example:

• SELECT sequence_num, days, discount_percent, discount_days FROM ra_terms_lines WHERE term_id = :p_term_id ORDER BY sequence_num;

Another common pattern joins RA_TERMS_LINES to RA_TERMS_B (and often RA_TERMS_TL for the name) to produce a comprehensive view of all payment terms and their structures for business review. Data from this table is also frequently accessed via the Receivables API, AR_TERMS_PUB, for programmatic term management.

Related Objects

RA_TERMS_LINES has a fundamental and mandatory relationship with the RA_TERMS_B table, as enforced by its foreign key on the TERM_ID column. Every line must belong to a valid parent term header. The table is a source for key Receivables views that present term information to the application, such as AR_TERMS_V. It is directly referenced by transaction tables (e.g., RA_CUSTOMER_TRX, RA_CUSTOMER_TRX_LINES) which store the TERM_ID, thereby inheriting the installment logic defined in RA_TERMS_LINES. Programmatic interaction is primarily handled through the public API AR_TERMS_PUB, which provides procedures for creating, updating, and querying term headers and their associated lines.