M3 Reference

MITPOP

Prefix: MPmaster

Item aliases — one row per alias type, qualifier, and alias number, mapping external identities (customer or supplier item numbers, barcodes) to the internal ITNO; the lookup behind alias-based item search

Module: Items & Product DataCompany-partitioned (CONO)Parent: MITMAS

Parent & satellites

MITPOP is a satellite of MITMAS — many rows here per MITMAS row; join on ITNO plus the CONO (exact ON clause under Join details below).

Fields

5 fields · 4 key

Key	Field	Alias	Description	Type
Key	MPCONO	CONO	Company	numeric
Key	MPALWT	ALWT	Alias category — what kind of external identity the alias is	numeric
Key	MPALWQ	ALWQ	Alias qualifier — narrows the category, e.g. to a specific partner	alphanumeric
Key	MPPOPN	POPN	The alias number itself — the external item identity being mapped	alphanumeric
	MPITNO	ITNO	Internal item number the alias resolves to	alphanumeric

Field provenance: hand-curated.

Boilerplate SQL

Starting point for reading MITPOPon 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)

-- ============================================================
-- Table  : MITPOP — Item aliases — one row per alias type, qualifier, and alias number, mapping external identities (customer or supplier item numbers, barcodes) to the internal ITNO; the lookup behind alias-based item search
-- Purpose: Column-selected read of MITPOP — auto-generated from field metadata
-- Grain  : One row per company (CONO) + MPALWT + MPALWQ + MPPOPN
-- 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.MPCONO AS "Company",
  m.MPALWT AS "Alias category — what kind of external identity the alias is",
  m.MPALWQ AS "Alias qualifier — narrows the category, e.g. to a specific partner",
  m.MPPOPN AS "The alias number itself — the external item identity being mapped",
  m.MPITNO AS "Internal item number the alias resolves to"
FROM <catalog>.<schema>.MITPOP m
WHERE
  m.MPCONO = <company>
ORDER BY m.MPALWT;

3 parameters not filled: <catalog>, <schema>, <company>

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

MITPOPMITMASforeign key · N:1
ON MITPOP.MPITNO = MITMAS.MMITNO AND MITPOP.MPCONO = MITMAS.MMCONO

Programs That Use This Table

No program mappings populated for this table yet.