Search Results term_start_date_effective




Overview
Explore in AI Chat

Overview

The AR_XML_PAYMENT_TERMS_V view is a public Oracle E-Business Suite Receivables (AR) database object owned by the APPS schema. It exists to surface payment-terms and discount information for a transaction's payment schedules in a flattened, denormalized form suitable for XML-based document generation, reporting, and external integrations. In release 12.1.1 and 12.2.2, the view is a standard, VALID implementation component of the AR module and is referenced in the ETRM (E-Business Suite Technical Reference Manual) repository.

Because it joins payment schedules to term definitions and discount records, the view is particularly relevant when a user searches for discount_date. The DISCOUNT_DATE column exposed here is the date on which an invoice's early-payment discount is available, computed once per payment schedule row. Consumers can query a single view to retrieve the customer transaction identifier, the associated term name, the due date, the remaining amount due, the discount date, and the computed discount amount without writing the underlying joins themselves.

Underlying Base Objects

The documented base objects for this view are:

  • AR_PAYMENT_SCHEDULES (SYNONYM) — the primary driving table, aliased PS. Provides the payment schedule row, transaction reference (CUSTOMER_TRX_ID), due date, and remaining amount due.
  • RA_TERMS (SYNONYM) — aliased T. Supplies the term name, description, and effective start date; joined to payment schedules on TERM_ID.
  • AR_TRX_DISCOUNTS_V (VIEW) — aliased DISC. Supplies the discount percentage, discount date, and discount currency for the schedule. It is outer-joined on PAYMENT_SCHEDULE_ID, so schedules without an eligible discount still return a row.
  • ARPCURR (PACKAGE) — provides the CURRROUND function used to round the calculated discount amount to the transaction currency.
  • AR_XML_VIEW_FUNCTIONS (PACKAGE) — provides the PT_FUNCTION1 through PT_FUNCTION5 functions that populate the extension columns USER1 through USER5, each receiving the transaction, term, and payment schedule IDs.

Key Columns

  • TERM_NAME / TERM_DESCRIPTION / TERM_START_DATE_EFFECTIVE — the payment term's name, description, and active start date from RA_TERMS.
  • CUSTOMER_TRX_ID — the transaction (invoice, debit memo, credit memo) to which the schedule belongs.
  • DUE_DATE — the payment schedule due date.
  • DUE_AMOUNT — the remaining amount due on the schedule.
  • DISCOUNT_DATE — the date by which payment must be received to qualify for the early-payment discount; sourced from AR_TRX_DISCOUNTS_V.
  • DISCOUNT_AMOUNT — calculated as ARPCURR.CURRROUND(DISCOUNT_PERCENT/100 * AMOUNT_DUE_REMAINING, CURRENCY).
  • USER1 – USER5 — extensibility columns whose values are returned by the AR_XML_VIEW_FUNCTIONS package.

Common Use Cases and Queries

Typical uses include generating XML output for payment-term documents, embedding term and discount data in customer-facing correspondence, and building custom reports that require discount-eligibility dates. A representative query filtering on discount date is:

SELECT customer_trx_id, term_name, due_date, due_amount, discount_date, discount_amount
FROM apps.ar_xml_payment_terms_v
WHERE discount_date IS NOT NULL
ORDER BY discount_date;

Because the discount join is outer, rows with no discount return NULL in DISCOUNT_DATE and DISCOUNT_AMOUNT, so filtering with IS NOT NULL isolates schedules with active discount terms.