MHDISH

-- ============================================================
-- Table  : MHDISH — The delivery header — one row per delivery (inbound or outbound, discriminated by INOU) identified by the delivery index DLIX, carrying the warehouse and the shipment it rides on; the unit picking and dispatch work against. DLIX is scoped by direction — inbound and outbound deliveries share the number space, so the key is CONO + INOU + DLIX, and a join from an order table that carries no direction column matches on DLIX alone
-- Purpose: Column-selected read of MHDISH — auto-generated from field metadata
-- Grain  : One row per company (CONO) + OQINOU + OQDLIX
-- 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.OQCONO AS "Company",
  m.OQINOU AS "Direction — inbound or outbound delivery",
  m.OQDLIX AS "Delivery index — the delivery's identity, carried by every line and document that rides on it",
  m.OQWHLO AS "Warehouse the delivery ships from or arrives at",
  m.OQCONN AS "Shipment the delivery is grouped onto",
  m.OQPGRS AS "Progress status — release, picking and reporting progress; the ladder is direction-scoped by INOU, so it is not decoded here — see the quirks guide",  -- status: decode m.OQPGRS against your configuration — see quirks guide #statuses
  CASE m.OQPIST WHEN '00' THEN 'Packing not used' WHEN '10' THEN 'Packing not started' WHEN '20' THEN 'Packing started but not completed' WHEN '30' THEN 'Packing completed' ELSE m.OQPIST END AS "Packing status — whether packing is unused, not started, started, or completed for the delivery"  -- status: PIST_DISH (all 4 curated values)
FROM <catalog>.<schema>.MHDISH m
WHERE
  m.OQCONO = <company>
ORDER BY m.OQINOU;