M3 Reference

CSYTAB

Prefix: CTcodesDivision-level

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)

Module: FoundationCompany-partitioned (CONO)

Notes

Language-dependent texts repeat per LNCD language code — filter to one language or names multiply. Division-level overrides repeat per DIVI; blank DIVI rows are the company-level defaults.

Fields

8 fields · 5 key

Key	Field	Alias	Description	Type	Length
Key	CTCONO	CONO	Company	numeric
Key	CTDIVI	DIVI	Division — blank rows hold the company-level defaults	alphanumeric
Key	CTSTCO	STCO	Constant naming the logical code table this row belongs to — the discriminator that splits CSYTAB into hundreds of code tables	alphanumeric
Key	CTSTKY	STKY	Code key — the value coded fields elsewhere match against	alphanumeric
Key	CTLNCD	LNCD	Language code — texts repeat per language; filter to one or names multiply	alphanumeric
	CTTX40	TX40	Description (40 characters) — the text a decode join selects	alphanumeric	40
	CTTX15	TX15	Short description (15 characters)	alphanumeric	15
	CTPARM	PARM	Parameter string — some code tables pack extra attributes here, positionally	alphanumeric

Field provenance: hand-curated.

Boilerplate SQL

Starting point for reading CSYTABon Databricks — numeric YYYYMMDD dates are wrapped to NULL, verified status ladders are decoded, and the CONO anchor is in place. Set your Unity Catalog location, company, and filter values below; they’re substituted into the SQL and the copy button.

Query parameters

CatalogSchemaCompany (CONO)Division (DIVI)Code table constant (STCO)Code key (STKY)

Include optional filters (3)

-- ============================================================
-- 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 Infor Data Lake-landed M3 data. Dates are numeric YYYYMMDD (0 = none, mapped to NULL); status ladders decoded inline where verified. 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;

6 parameters not filled: <catalog>, <schema>, <company>, <DIVI>, <STCO>, <STKY>

Relationships

1-hop neighbors — click a table to navigate there. CSYTAB decode edges are highlighted; they’re the joins newcomers most often get wrong.

Programs That Use This Table

No program mappings populated for this table yet.