Results for “ra_terms_lines_discounts”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

RA_TERMS_LINES_DISCOUNTS is a Receivables (AR) module table in the Oracle E-Business Suite 12.1.1 and 12.2.2 data model that stores discount information attached to payment terms. Within Oracle Receivables, payment terms define the due dates, installment schedules, and early-payment discounts that drive customer invoice settlement behaviour. The RA_TERMS_LINES_DISCOUNTS table provides the granular discount detail that sits beneath the header-level payment terms record, capturing the discount percentage, the window of days within which the discount may be taken, and the associated date logic used to compute the discount period.

The table resides in the AR schema and is documented as VALID in ETRM. Its logical relationship to RA_TERMS_B is one of a dependent child: a term header (payment terms) can be associated with one or more discount lines, each represented by a row in RA_TERMS_LINES_DISCOUNTS. From a Data Vault modelling perspective, the mined FK structure classifies this object as satellite-leaning. This suggests that RA_TERMS_LINES_DISCOUNTS behaves as a descriptive satellite attached to the payment terms hub (RA_TERMS_B via TERM_ID), holding attributes that describe discount behaviour rather than acting as an independent hub or a pure link between two business keys.

Key Information Stored

The table contains 30 documented columns. The most significant, together with their roles, are:

• TERMS_LINES_DISCOUNT_ID — the surrogate primary key, uniquely identifying each discount line (enforced by RA_TERMS_LINES_DISCOUNTS_PK).
• TERM_ID — the foreign key to RA_TERMS_B, associating the discount line with its parent payment term.
• SEQUENCE_NUM — orders multiple discount lines under a single term when more than one discount is defined.
• DISCOUNT_PERCENT — the percentage discount allowed if payment is made within the discount window.
• DISCOUNT_DAYS — the number of days from the invoice or term start date within which the discount may be taken.
• DISCOUNT_DATE — an absolute date-based discount trigger, used when the discount is not expressed relative to the invoice date.
• DISCOUNT_DAY_OF_MONTH and DISCOUNT_MONTHS_FORWARD — define recurring or forward-dated discount logic (for example, discount available by a particular day of a month, N months forward).
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard Oracle WHO columns supporting auditing and concurrency.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the flexible descriptive flexfield (DFF) columns for customer-specific extensions.
• ZD_EDITION_NAME — the editioning column supporting Oracle EBS online patching (ADOP) in 12.2.x.

The unique index RA_TERMS_LINES_DISCOUNTS_U1 spans (TERMS_LINES_DISCOUNT_ID, ZD_EDITION_NAME), reflecting the edition-aware business-key candidate in the 12.2.2 schema. The surrogate primary key remains TERMS_LINES_DISCOUNT_ID.

Common Use Cases and Queries

Typical use cases involve reporting on available early-payment discounts, validating term setup, and reconciling discount handling against invoice payments.

• Listing all discount lines for a given payment term:

  SELECT TERMS_LINES_DISCOUNT_ID, SEQUENCE_NUM, DISCOUNT_PERCENT, DISCOUNT_DAYS, DISCOUNT_DATE
FROM RA_TERMS_LINES_DISCOUNTS
WHERE TERM_ID = :term_id
ORDER BY SEQUENCE_NUM;

• Joining to the term header to display terms name and discount percentage:

  SELECT t.NAME, d.DISCOUNT_PERCENT, d.DISCOUNT_DAYS
FROM RA_TERMS_B t, RA_TERMS_LINES_DISCOUNTS d
WHERE t.TERM_ID = d.TERM_ID;

• Identifying terms that offer a discount of a given size, for negotiation or cash-management analysis.
• Auditing recently changed discount definitions using LAST_UPDATE_DATE and LAST_UPDATED_BY.
• Extracting DFF attribute values for downstream reporting where ATTRIBUTE_CATEGORY is populated.

Related Objects

The following objects are most directly relevant when working with this table:

• RA_TERMS_B — the parent payment terms header; joined on TERM_ID. This is the documented FK relationship and the primary reference for the discount line.
• RA_TERMS_TL — stores language-specific term names and descriptions, typically joined via TERM_ID to enrich reports.
• RA_TERMS_LINES — the sibling table holding installment lines for payment terms, frequently queried alongside discount lines.
• RA_CUSTOMER_TRX / RA_CUSTOMER_TRX_LINES — transactions that inherit payment terms and therefore drive discount computation at the invoice level.
• AR_PAYMENT_SCHEDULES — stores scheduled payment amounts and discount dates derived from term definitions, providing the operational link between term setup and actual receivable balances.

Standard AR APIs and concurrent programs (such as payment terms setup forms and the Receivables AutoInvoice process) read these configurations indirectly through RA_TERMS_B and related tables rather than querying RA_TERMS_LINES_DISCOUNTS directly.