CSYTAB

-- ============================================================
-- Table  : CSYTAB — The generic system code table — hundreds of logical code tables share this one physical table, separated by the STCO constant; a code field elsewhere decodes here by matching its value against STKY under the right STCO (M3's analog of JDE's UDC table)
-- Purpose: Column-selected read of CSYTAB — auto-generated from field metadata
-- Grain  : One row per company (CONO) + CTDIVI + CTSTCO + CTSTKY + CTLNCD
-- 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
  ct.CTCONO AS "Company",
  ct.CTDIVI AS "Division — blank rows hold the company-level defaults",
  ct.CTSTCO AS "Constant naming the logical code table this row belongs to — the discriminator that splits CSYTAB into hundreds of code tables",
  ct.CTSTKY AS "Code key — the value coded fields elsewhere match against",
  ct.CTLNCD AS "Language code — texts repeat per language; filter to one or names multiply",
  ct.CTTX40 AS "Description (40 characters) — the text a decode join selects",
  ct.CTTX15 AS "Short description (15 characters)",
  ct.CTPARM AS "Parameter string — some code tables pack extra attributes here, positionally"
FROM <catalog>.<schema>.CSYTAB ct
WHERE
  ct.CTCONO = <company>
  -- AND ct.CTDIVI = '<DIVI>'
  -- AND ct.CTSTCO = '<STCO>'
  -- AND ct.CTSTKY = '<STKY>'
ORDER BY ct.CTSTCO;