MITALO

-- ============================================================
-- Table  : MITALO — Allocations — one row per item, location, and lot allocated to a specific order line, connecting demand (the order reference) to the exact stock that will fill it; the bridge between order lines and MITLOC balances
-- Purpose: Column-selected read of MITALO — auto-generated from field metadata
-- Grain  : Transaction-grain — finer than company (CONO) + MQWHLO + MQITNO + MQWHSL + MQBANO; the full row key is not yet cataloged (see the table description)
-- Notes  : Auto-generated skeleton for a prefixed physical M3 schema or a landing schema normalized to the prefixed names in this catalog. Raw Data Lake property names vary with the published object: map them through Data Catalog before running this SQL. Dates are numeric YYYYMMDD (0 = none, mapped to NULL); all curated status values are decoded inline. Audit columns (RGDT/RGTM/LMDT/CHNO/CHID) omitted — see the quirks guide.
-- ============================================================
SELECT
  m.MQCONO AS "Company",
  m.MQWHLO AS "Warehouse",
  m.MQITNO AS "Item number",
  m.MQWHSL AS "Stock location the allocation points at",
  m.MQBANO AS "Lot (batch) number allocated",
  m.MQORCA AS "Order category of the demand being served (customer order, manufacturing order…)",
  m.MQRIDN AS "Order number of the demand line the stock is allocated to",
  m.MQRIDL AS "Order line number of the demand",
  m.MQALQT AS "Allocated quantity"
FROM <catalog>.<schema>.MITALO m
WHERE
  m.MQCONO = <company>
  -- AND m.MQWHLO = '<WHLO>'
  -- AND m.MQITNO = '<ITNO>'
  -- AND m.MQWHSL = '<WHSL>'
  -- AND m.MQBANO = '<BANO>'
ORDER BY m.MQWHLO;