M3 Reference

MPAGRH

Prefix: AHmaster

The purchase agreement header — one row per supplier purchase agreement (agreement number), the negotiated terms record purchase-order pricing draws from; keyed by company, agreement number, and supplier

Module: PurchasingCompany-partitioned (CONO)

Notes

Agreement lines live in MPAGRL, whose column prefix is not yet verified from a second source — it joins the catalog in a later wave.

Fields

3 fields · 3 key

Key	Field	Alias	Description	Type
Key	AHCONO	CONO	Company	numeric
Key	AHAGNB	AGNB	Agreement number — the purchase agreement's identity	alphanumeric
Key	AHSUNO	SUNO	Supplier the agreement is held with — the join to CIDMAS	alphanumeric

Field provenance: hand-curated.

Boilerplate SQL

Starting point for reading MPAGRHon Databricks — numeric YYYYMMDD dates are wrapped to NULL, verified status ladders are decoded, and the CONO anchor is in place. Set your Unity Catalog location, company, and filter values below; they’re substituted into the SQL and the copy button.

Query parameters

CatalogSchemaCompany (CONO)Purchase agreement (AGNB)Supplier (SUNO)

Include optional filters (2)

-- ============================================================
-- Table  : MPAGRH — The purchase agreement header — one row per supplier purchase agreement (agreement number), the negotiated terms record purchase-order pricing draws from; keyed by company, agreement number, and supplier
-- Purpose: Column-selected read of MPAGRH — auto-generated from field metadata
-- Grain  : One row per company (CONO) + AHAGNB + AHSUNO
-- Notes  : Auto-generated skeleton for Infor Data Lake-landed M3 data. Dates are numeric YYYYMMDD (0 = none, mapped to NULL); status ladders decoded inline where verified. Audit columns (RGDT/RGTM/LMDT/CHNO/CHID) omitted — see the quirks guide.
-- ============================================================
SELECT
  m.AHCONO AS "Company",
  m.AHAGNB AS "Agreement number — the purchase agreement's identity",
  m.AHSUNO AS "Supplier the agreement is held with — the join to CIDMAS"
FROM <catalog>.<schema>.MPAGRH m
WHERE
  m.AHCONO = <company>
  -- AND m.AHAGNB = '<AGNB>'
  -- AND m.AHSUNO = '<SUNO>'
ORDER BY m.AHAGNB;

5 parameters not filled: <catalog>, <schema>, <company>, <AGNB>, <SUNO>

Relationships

1-hop neighbors — click a table to navigate there. CSYTAB decode edges are highlighted; they’re the joins newcomers most often get wrong.

Join details

MPAGRHCIDMASforeign key · N:1
ON MPAGRH.AHSUNO = CIDMAS.IDSUNO AND MPAGRH.AHCONO = CIDMAS.IDCONO

Programs That Use This Table

No program mappings populated for this table yet.