MITWHL

-- ============================================================
-- Table  : MITWHL — The warehouse master — one row per warehouse with its name, facility, and warehouse type; the WHLO every balance and movement carries resolves here
-- Purpose: Column-selected read of MITWHL — auto-generated from field metadata
-- Grain  : One row per company (CONO) + MWWHLO
-- 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
  w.MWCONO AS "Company",
  w.MWWHLO AS "Warehouse — the code balances and movements carry",
  w.MWWHNM AS "Warehouse name",
  w.MWFACI AS "Facility the warehouse belongs to — the costing/manufacturing level between division and warehouse",
  w.MWWHTY AS "Warehouse type — the code classifying how the warehouse is used"
FROM <catalog>.<schema>.MITWHL w
WHERE
  w.MWCONO = <company>
  -- AND w.MWWHLO = '<WHLO>'
ORDER BY w.MWWHLO;