Search Results calc_discount_on_lines_flag




Overview
Explore in AI Chat

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

Overview

RA_TERMS_B is the base table that stores payment term definitions in Oracle Receivables (AR). It records each payment term header—the rule set that determines when an invoice or transaction becomes due, whether discounts apply for early payment, and how installments are structured. The table is owned by the AR schema and is a foundational reference object shared across Receivables, Order Management, Purchasing, and Advanced Pricing.

In Data Vault modeling terms, the mined foreign-key structure classifies RA_TERMS_B as hub-leaning. It behaves as a central business-key reference (hub) around which many dependent satellites and links are built, such as RA_TERMS_LINES and RA_TERMS_LINES_DISCOUNTS. This classification is a heuristic suggestion based on the density of inbound foreign keys rather than an enforced constraint.

Key Information Stored

The table contains 35 documented columns in ETRM 12.2.2. The surrogate primary key is TERM_ID (constraint RA_TERMS_B_PK). A unique index, RA_TERMS_B_U1, covers TERM_ID and ZD_EDITION_NAME. The most important columns include:

Common Use Cases and Queries

RA_TERMS_B is most frequently queried to retrieve the payment terms attached to customers, transactions, sales orders, or items. Reports often join it to RA_CUSTOMER_TRX_ALL to display the term name on invoices, or to RA_CUSTOMERS to audit default terms. A typical query retrieves active terms:

  • SELECT TERM_ID, DUE_CUTOFF_DAY, START_DATE_ACTIVE, END_DATE_ACTIVE FROM RA_TERMS_B WHERE SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE+1);
  • SELECT t.TERM_ID, c.CUSTOMER_NAME FROM RA_TERMS_B t, RA_CUSTOMERS c WHERE t.TERM_ID = c.PAYMENT_TERM_ID;
  • SELECT t.TERM_ID FROM RA_TERMS_B t, RA_CUSTOMER_TRX_ALL x WHERE t.TERM_ID = x.TERM_ID;

Common scenarios include reconciling default terms assigned to transaction types (RA_CUST_TRX_TYPES_ALL.DEFAULT_TERM), validating item-level terms (MTL_SYSTEM_ITEMS_B.PAYMENT_TERMS_ID), and tracing order-to-cash term propagation through OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL.

Related Objects

RA_TERMS_B is referenced by a large set of dependent tables through TERM_ID and related foreign keys. The most significant include:

  • RA_TERMS_LINES — installment/discount lines, joined on TERM_ID.
  • RA_TERMS_LINES_DISCOUNTS — discount definitions, joined on TERM_ID.
  • RA_CUSTOMER_TRX_ALL — invoices and credit memos, joined on TERM_ID.
  • RA_CUSTOMERS — customer default term, joined on PAYMENT_TERM_ID.
  • RA_CUST_TRX_TYPES_ALL — default terms by transaction type, joined on DEFAULT_TERM.
  • RA_SITE_USES_ALL — site-level term assignment, joined on PAYMENT_TERM_ID.
  • AR_PAYMENT_SCHEDULES_ALL — payment schedules, joined on TERM_ID.
  • OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL — order terms, joined on PAYMENT_TERM_ID.
  • MTL_SYSTEM_ITEMS_B — item-level terms, joined on PAYMENT_TERMS_ID.
  • SO_HEADERS_ALL and SO_PRICE_LISTS_B — pricing and order terms, joined on TERMS_ID.

These relationships confirm RA_TERMS_B as a central reference hub whose TERM_ID cascades into discounting, scheduling, and order-capture processes throughout Oracle E-Business Suite.