Search Results ap_terms_pk

Overview

The AP_TERMS_TL table is a core translation table within the Oracle E-Business Suite Payables (AP) module. It stores the translated, language-specific definitions for payment terms, which are critical business rules governing when supplier invoices are due. This table works in conjunction with its base table, AP_TERMS_B, to support the application's multi-language functionality. The role of AP_TERMS_TL is to enable organizations operating in multiple countries or languages to define and display payment term names and descriptions in the language of the user, ensuring clarity and consistency in global financial operations. Its status as a translation table is confirmed by its structure, which includes standard Translation Table (TL) columns like LANGUAGE and SOURCE_LANG.

Key Information Stored

The table's primary purpose is to hold the human-readable text for payment terms across different languages. Its structure is defined by a composite primary key and foreign key relationships. The primary key, AP_TERMS_PK, consists of TERM_ID and LANGUAGE, ensuring a unique term definition per language. The TERM_ID column links each row to the corresponding base record in AP_TERMS_B. The LANGUAGE column stores the language code (e.g., 'US', 'FR', 'DE') and is a foreign key to FND_LANGUAGES, as is the SOURCE_LANG column, which indicates the original language in which the data was entered. The most critical user-facing columns are NAME and DESCRIPTION, which contain the translated term name (e.g., "Net 30", "2% 10 Net 30") and its explanatory description, respectively.

Common Use Cases and Queries

This table is primarily accessed by the application runtime to display appropriate term descriptions based on the user's session language. For reporting and data extraction, common queries involve joining AP_TERMS_TL with AP_TERMS_B to create comprehensive, multilingual lists of payment terms. A typical query pattern is:

• SELECT b.TERM_ID, tl.NAME, tl.DESCRIPTION, b.DUE_DAYS, tl.LANGUAGE
• FROM AP_TERMS_B b, AP_TERMS_TL tl
• WHERE b.TERM_ID = tl.TERM_ID
• AND tl.LANGUAGE = USERENV('LANG');

This is essential for generating supplier aging reports, understanding global payment practices, and auditing term usage in a multilingual environment. Data fixes or translations may also be performed directly in this table, though standard APIs are the recommended method.

Related Objects

AP_TERMS_TL has integral relationships with several key EBS objects. Its base table, AP_TERMS_B, stores the non-translatable attributes of a payment term, such as DUE_DAYS and DISCOUNT_DAYS. As documented in the metadata, it maintains two foreign key relationships to the FND_LANGUAGES table for both the LANGUAGE and SOURCE_LANG columns, enforcing valid language codes. The table is referenced by the AP_TERMS_VL view, which is the primary view used by the application for queries. Key transactional tables like AP_INVOICES_ALL store a TERM_ID, which ultimately points to the definitions in AP_TERMS_B and AP_TERMS_TL. Standard APIs, such as the Payment Terms API, provide the supported method for creating and maintaining records in these tables.