MITMAS

-- ============================================================
-- Table  : MITMAS — The item master — one row per item per company, carrying the item's identity, status, grouping codes, basic unit of measure, and physical attributes; every balance, order line, and stock movement joins back to it on ITNO
-- Purpose: Column-selected read of MITMAS — auto-generated from field metadata
-- Grain  : One row per company (CONO) + MMITNO
-- 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
  im.MMCONO AS "Company",
  im.MMITNO AS "Item number — the natural key every balance, order line, and movement joins on",
  im.MMSTAT AS "Item status — a two-char ladder from preliminary through active to deactivated",  -- status: decode im.MMSTAT against your configuration — see quirks guide #statuses
  im.MMITDS AS "Item name (short description)",
  im.MMFUDS AS "Item description (full)",
  im.MMITTY AS "Item type — the code that controls how the item behaves across modules",
  im.MMITGR AS "Item group — the primary reporting and posting bucket for the item",
  im.MMITCL AS "Product group — a second classification slice alongside the item group",
  im.MMBUAR AS "Business area — the broadest reporting classification on the item",
  im.MMUNMS AS "Basic unit of measure — the unit balances and movements are stored in",
  im.MMNEWE AS "Net weight of one basic unit",
  im.MMGRWE AS "Gross weight of one basic unit",
  im.MMVOL3 AS "Volume of one basic unit — with weight, the basis for load and freight math",
  im.MMRESP AS "Responsible — the user accountable for the item's master data"
FROM <catalog>.<schema>.MITMAS im
WHERE
  im.MMCONO = <company>
  -- AND im.MMITNO = '<ITNO>'
ORDER BY im.MMITNO;