M3 Reference
MMS025MI
APIItem alias API — lists the external item identities (customer and supplier item numbers, barcodes) that MITPOP maps to the internal ITNO
Tables vs APIs
This MI API program works over the tables below. For analytics at scale, land the raw tables — the SQL further down reads them directly, joined on their keys and CONO. When to land tables vs call MI APIs →
Notes
The verified transaction is LstAlias, named in Infor's published M3 Cross-BOD mapping; the API exposes more than this one.
Boilerplate SQL
Databricks SQLStarting point for reading the tables behind MMS025MI from landed data — the backing tables joined on their keys and CONO. Set your Unity Catalog location, company, and filter values below.
Query parameters
3 parameters not filled: <catalog>, <schema>, <company>
-- ============================================================
-- Program: MMS025MI — Item alias API — lists the external item identities (customer and supplier item numbers, barcodes) that MITPOP maps to the internal ITNO
-- Purpose: Read the tables behind API program MMS025MI — auto-generated from program-table-map
-- Grain : One row per MITPOP record
-- Tables : MITPOP
-- 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; company-partitioned tables are joined on CONO to prevent cross-company fan-out. Audit columns (RGDT/RGTM/LMDT/CHNO/CHID) omitted — see the quirks guide.
-- ============================================================
SELECT
h.MPCONO AS "Company",
h.MPALWT AS "Alias category — what kind of external identity the alias is",
h.MPALWQ AS "Alias qualifier — narrows the category, e.g. to a specific partner",
h.MPPOPN AS "The alias number itself — the external item identity being mapped",
h.MPITNO AS "Internal item number the alias resolves to"
FROM <catalog>.<schema>.MITPOP h
WHERE
h.MPCONO = <company>
ORDER BY h.MPALWT;