Search Results op_term_mst




Overview
Explore in AI Chat

Overview

The OP_TERM_MST table is a master data table within the GML (Process Manufacturing Logistics) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the central repository for defining and storing payment terms codes. These codes are critical for establishing the financial conditions under which transactions are settled between the organization and its business partners, such as customers and suppliers. The table's role is foundational to the financial logistics of the Process Manufacturing suite, enabling consistent application of payment terms across sales orders, purchase orders, and customer and supplier master records.

Key Information Stored

The primary data element stored in OP_TERM_MST is the payment terms code. The table's structure, as indicated by its primary key constraint, is centered on the TERMS_CODE column. This column uniquely identifies each payment term definition. While the provided metadata does not list all columns, typical attributes for a payment terms master table would include a description, the number of days until payment is due, discount percentages for early payment, and the discount grace period. The table also maintains a relationship with textual descriptions via a foreign key to OP_TEXT_HDR on the TEXT_CODE column, allowing for detailed, multilingual term descriptions.

Common Use Cases and Queries

This table is primarily referenced in transactional and master data processes. Common operational use cases include configuring customer credit profiles, defining supplier payment agreements, and defaulting terms onto sales and purchase documents. For reporting and data validation, typical SQL queries involve joining OP_TERM_MST to various transactional tables to analyze payment term usage. A fundamental query pattern is retrieving the terms description for a specific transaction:

  • SELECT otm.terms_code, oth.meaning
    FROM op_term_mst otm, op_text_hdr oth
    WHERE otm.text_code = oth.text_code
    AND otm.terms_code = :p_terms_code;

Another common reporting use case is listing all payment terms available for assignment to new customers or suppliers within the Process Manufacturing flows.

Related Objects

OP_TERM_MST is a key reference table with extensive integration across the GML and Purchasing (PO) modules. As documented, its TERMS_CODE column is referenced by numerous important transactional and master tables. Key foreign key relationships include:

These relationships enforce data integrity and ensure that any term used in a transaction is valid and defined in the master table.