Search Results payment_term_description

Overview

ARFV_AR_TERMS_OLD1 is a retrofitted Oracle E-Business Suite view belonging to the Receivables (AR) product family. It exposes payment term definitions maintained in the Receivables module and is intended to present term data in a form compatible with the older (legacy) AR payment terms schema, hence the "_OLD1" suffix in its name. In EBS 12.1.1 and 12.2.2, such retrofitted views were introduced to preserve backward compatibility for custom reports, integrations, and third-party extracts that referenced earlier column naming conventions after the underlying tables were restructured.

The ETRM metadata explicitly notes that this view is "Not implemented in this database," meaning it may exist only as a compatibility artifact and is not physically created in all environments. Its role is therefore primarily as a reporting and integration interface — a read-only presentation layer over the RA_TERMS table rather than a transactional object.

Underlying Base Objects

The view is defined over a single base table: RA_TERMS (aliased as TE in the view text). The SELECT statement joins no additional tables and declares the view WITH READ ONLY, confirming it is strictly non-updatable. Although the documented metadata lists "none" under referenced base objects, the view text itself clearly identifies RA_TERMS as the sole source. The term "Retrofitted" indicates that the view was regenerated to align its column list and labels with an earlier naming standard while still reading from the current RA_TERMS structure.

Key Columns

The columns exposed by ARFV_AR_TERMS_OLD1 map to the RA_TERMS attributes, with several renamed or decorated for legacy compatibility:

• TERM_ID – Unique identifier of the payment term (RA_TERMS.TERM_ID).
• PAYMENT_TERM_NAME – The business-facing name of the payment term, corresponding to RA_TERMS.NAME. This is the column most commonly searched for as "payment_term_name."
• PAYMENT_TERM_DESCRIPTION – Free-text description of the term (RA_TERMS.DESCRIPTION).
• CUTOFF_DAY – The due cutoff day used in discount and due date calculations (RA_TERMS.DUE_CUTOFF_DAY).
• START_EFFECTIVE_DATE / END_EFFECTIVE_DATE – Active date range of the term (RA_TERMS.START_DATE_ACTIVE / END_DATE_ACTIVE).
• PRINT_LEAD_DAYS – Number of days in advance the term prints on documents (RA_TERMS.PRINTING_LEAD_DAYS).
• _LA:CREDIT_CHECK_FLAG, _LA:PARTIAL_DISCOUNT_FLAG, _LA:FIRST_INSTALLMENT_OPTION, _LA:DISCOUNT_BASIS – Lookup-encoded columns whose "_LA:" prefix indicates an AR_LOOKUPS lookup type (YES/NO, INSTALLMENT_OPTION, DISCOUNT_BASIS), providing the decoded meaning.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY – Standard WHO audit columns.

Common Use Cases and Queries

Because the view is read-only and surfaces term names, it is typically used in reporting, LOV-style validation, and data extracts that expect legacy column labels. A representative query retrieving active payment terms by name is:

SELECT term_id, payment_term_name, payment_term_description, cutoff_day, print_lead_days FROM arfv_ar_terms_old1 WHERE UPPER(payment_term_name) LIKE UPPER('%NET 30%');

Analysts commonly filter on START_EFFECTIVE_DATE and END_EFFECTIVE_DATE to isolate currently active terms, and join TERM_ID to AR_PAYMENT_SCHEDULES or RA_CUSTOMER_TRX_ALL to analyze the terms applied to transactions. It is important to remember that in environments where the view is not implemented, equivalent results must be obtained directly from RA_TERMS.