Search Results po_vgld_cls_pk

Overview

The PO_VGLD_CLS table is a core reference data object within the Oracle E-Business Suite Process Manufacturing Logistics (GML) module. It functions as a master repository for defining Vendor GL (General Ledger) classes. These classes are critical for financial accounting and control, as they categorize vendors based on their role in the procurement-to-pay process and link them to specific accounting rules and defaults. The table's primary role is to establish a standardized classification system that ensures consistent financial posting and reporting for transactions associated with different types of suppliers, such as raw material providers, service contractors, or freight carriers.

Key Information Stored

While the provided metadata does not list specific columns, the structure and relationships indicate the table's key data elements. The primary identifier is the VENDGL_CLASS column, which serves as the unique code for each vendor GL class. This column is the table's primary key (PO_VGLD_CLS_PK) and is referenced by multiple foreign keys in related tables. Additional columns likely store descriptive information for each class, such as a name, an active status indicator, and attributes that control default accounting behavior. The table's relationship to the PO_TEXT_HDR table via a TEXT_CODE foreign key suggests it may also store a reference to standard textual descriptions or terms and conditions associated with a particular vendor class.

Common Use Cases and Queries

This table is primarily used during vendor setup and transaction processing. When defining a new supplier in PO_VEND_MST, a user selects a VENDGL_CLASS to assign the appropriate accounting defaults. Common reporting and validation queries involve listing all active classes or identifying vendors assigned to a specific class. A typical SQL pattern to retrieve all vendor GL classes would be:

• SELECT vendgl_class, name, description FROM gml.po_vgld_cls WHERE enabled_flag = 'Y' ORDER BY vendgl_class;

Another critical use case is tracing the accounting setup: joining PO_VGLD_CLS to GL_ACCT_MAP reveals the specific general ledger accounts mapped to each vendor class for automatic accounting generation.

Related Objects

PO_VGLD_CLS is centrally connected to several key tables, as documented by its foreign key relationships:

• PO_VEND_MST (Vendor Master): The PO_VEND_MST.VENDGL_CLASS column references PO_VGLD_CLS.VENDGL_CLASS. This is the primary relationship, assigning a GL class to each supplier.
• GL_ACCT_MAP (General Ledger Account Mapping): The GL_ACCT_MAP.VENDGL_CLASS column references PO_VGLD_CLS.VENDGL_CLASS. This links each vendor class to specific GL account combinations for automated accounting entries.
• PO_TEXT_HDR (Standard Text Header): The PO_VGLD_CLS.TEXT_CODE column is a foreign key to PO_TEXT_HDR, associating standard text (like terms and conditions) with a vendor GL class.