Results for “op_prce_itm”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OP_PRCE_ITM is the GML (Process Manufacturing Logistics) item price detail table that stores the individual item-level prices belonging to a pricelist. Its documented description is "Item prices on a pricelist." Each row represents a single priced line — a combination of pricelist, price class, item, warehouse, quality grade, pricing unit of measure, freight-billing method, and line number — within a parent pricelist record held in OP_PRCE_MST. The table is owned by the GML schema and contains 52 columns in the documented 12.2.2 physical schema. This is a high-volume transactional detail table that drives pricing at order entry, billing, and cost-capture time in Process Manufacturing.

Following the heuristic Data Vault classification derived from its foreign-key structure, OP_PRCE_ITM is best modelled as satellite-leaning: it hangs off a parent pricelist hub (OP_PRCE_MST) via the PRICELIST_ID foreign key and carries descriptive pricing attributes that change over time rather than serving as a pure hub or a many-to-many link. The surrogate key PRICE_ID, backed by unique index OP_PRCE_ITM_PK, is the stable row identifier most commonly referenced by downstream foreign keys.

Key Information Stored

The surrogate primary key documented for this object is PRICE_ID, enforced by unique index OP_PRCE_ITM_PK. A separate unique index, OP_PRCE_ITMI1, defines the composite business-key candidate over PRICELIST_ID, PRICE_CLASS, ITEM_ID, WHSE_CODE, QC_GRADE, PRICE_UM, FRTBILL_MTHD, and LINE_NO. The most significant columns include:

• PRICE_ID — surrogate identifier; parent key for OP_PRCE_BRK break records.
• PRICELIST_ID — foreign key to OP_PRCE_MST; the owning pricelist.
• ITEM_ID — the priced item, joined to IC_ITEM_MST and IC_ITEM_MST_B.
• PRICE_CLASS — pricing classification referencing IC_PRCE_CLS.
• BASE_PRICE — the base price amount for the line.
• PRICE_TYPE and BREAK_TYPE — control how the price is interpreted and how break pricing is applied.
• WHSE_CODE — warehouse qualification, referencing IC_WHSE_MST.
• QC_GRADE — quality grade, referencing GMD_GRADES_B and QC_GRAD_MST.
• PRICE_UM — pricing unit of measure, referencing SY_UOMS_MST.
• FRTBILL_MTHD — freight-billing method, referencing OP_FRGT_MTH.
• LINE_NO — ordering of lines within a pricelist.
• TEXT_CODE — reference to descriptive text in OP_TEXT_HDR.
• PRICE_CATEGORY_ID — price category grouping.
• Standard WHO/audit columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, DELETE_MARK, plus the ATTRIBUTE1–ATTRIBUTE30 and ATTRIBUTE_CATEGORY flexfield set.

Common Use Cases and Queries

Typical reporting retrieves all priced lines for a given pricelist, optionally filtered by item or warehouse. A representative query joining the parent pricelist and item master follows:

• Select all lines for a pricelist: SELECT PRICE_ID, ITEM_ID, BASE_PRICE, PRICE_UM FROM OP_PRCE_ITM WHERE PRICELIST_ID = :p AND NVL(DELETE_MARK,0) = 0;
• Item price lookup across pricelists: join OP_PRCE_ITM to IC_ITEM_MST on ITEM_ID to resolve item descriptions.
• Break-price reporting: join OP_PRCE_BRK to OP_PRCE_ITM on PRICE_ID to obtain quantity-break tiers.
• Price maintenance: application logic inserts and updates rows keyed by PRICE_ID, enforcing the composite uniqueness of OP_PRCE_ITMI1.
• Grade and warehouse analysis: join GMD_GRADES_B, QC_GRAD_MST, and IC_WHSE_MST to segment prices by quality grade or facility.

Because DELETE_MARK is present, most queries should filter logically deleted rows. Note that the documented metadata references a foreign key from PRICE_ID to OP_CNTR_DTL; the surrogate key is therefore referenced by several downstream objects.

Related Objects

• OP_PRCE_MST — parent pricelist header, joined on OP_PRCE_ITM.PRICELIST_ID = OP_PRCE_MST.PRICELIST_ID.
• OP_PRCE_BRK — price-break tiers, joined on OP_PRCE_BRK.PRICE_ID = OP_PRCE_ITM.PRICE_ID.
• IC_ITEM_MST / IC_ITEM_MST_B — item master definitions, joined on ITEM_ID.
• IC_PRCE_CLS — price class validation, joined on PRICE_CLASS.
• IC_WHSE_MST — warehouse reference, joined on WHSE_CODE.
• GMD_GRADES_B / QC_GRAD_MST — quality grade references, joined on QC_GRADE.
• SY_UOMS_MST — unit-of-measure reference, joined on PRICE_UM.
• OP_FRGT_MTH — freight-billing method reference, joined on FRTBILL_MTHD.
• OP_TEXT_HDR — descriptive text, joined on TEXT_CODE.