CIDMAS

-- ============================================================
-- Table  : CIDMAS — The supplier master — one row per supplier per company with identity, status, and name; purchasing and supplier-ledger records join back to it on SUNO
-- Purpose: Column-selected read of CIDMAS — auto-generated from field metadata
-- Grain  : One row per company (CONO) + IDSUNO
-- 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
  s.IDCONO AS "Company",
  s.IDSUNO AS "Supplier number — the natural key purchase orders join on",
  s.IDSTAT AS "Supplier status — whether the supplier is active for new business",  -- status: decode s.IDSTAT against your configuration — see quirks guide #statuses
  s.IDSUNM AS "Supplier name"
FROM <catalog>.<schema>.CIDMAS s
WHERE
  s.IDCONO = <company>
  -- AND s.IDSUNO = '<SUNO>'
ORDER BY s.IDSUNO;