Search Results op_chrg_mst




Overview
Explore in AI Chat

Overview

The OP_CHRG_MST table is a master data table within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. It functions as the central repository for defining and managing charges. A charge, in this context, represents a specific type of fee, cost, or levy that can be applied within logistics and order management processes, such as freight, handling, duties, or taxes. The table serves as the foundational reference for charge-related data, ensuring consistency and control across transactional systems like sales orders, purchase orders, invoices, and pricing agreements. Its role is critical for accurate financial calculations and cost tracking in supply chain operations.

Key Information Stored

The table stores the core attributes that define a charge. Based on the provided metadata, the primary identifiers are CHARGE_ID (the system-generated primary key) and CHARGE_CODE (a unique user-defined identifier, also a primary key). Other significant columns establish the charge's operational and financial context: CURRENCY_CODE links to GL_CURR_MST to define the monetary unit, CHARGE_UOM links to SY_UOMS_MST to define the unit of measure for calculation, and CHGTAX_CLASS links to OP_CHRG_CLS for tax classification. The TEXT_CODE column links to OP_TEXT_HDR, allowing for descriptive notes or terms to be associated with the charge definition.

Common Use Cases and Queries

This table is primarily referenced for charge validation, reporting, and transactional integration. Common operational scenarios include validating a charge code entered on a sales order line or retrieving the default currency and UOM for a freight charge during invoice creation. A typical query might involve joining OP_CHRG_MST with related transactional tables to analyze charge application. For example, to list all charges applied on recent sales orders, one might use:

Reporting use cases often involve summarizing total charges by type or analyzing charge effectiveness within pricing strategies.

Related Objects

OP_CHRG_MST has extensive relationships with other EBS objects, as shown by its foreign keys. It is a parent table to numerous transactional and setup tables. Key child tables include OP_ORDR_CHG (charges on sales orders), OP_INVC_CHG (charges on invoices), OP_PRSL_CHG (charges on price lists), and OP_PRCE_EFF (pricing effectiveness). The GL_ACCT_MAP table references it for accounting rule assignment, and OP_CHRG_BRK and OP_CHRG_ITM likely store charge breakdowns and item-specific charge details. Its foreign key dependencies link to master tables for currency (GL_CURR_MST), units of measure (SY_UOMS_MST), text (OP_TEXT_HDR), and charge class (OP_CHRG_CLS).