M3 Reference

CMNDIV

Prefix: CCmasterDivision-level

The division master — one row per division within a company; the DIVI that financial and divisional tables carry resolves here

Module: FoundationCompany-partitioned (CONO)

Fields

3 fields · 2 key

Key	Field	Alias	Description	Type
Key	CCCONO	CONO	Company	numeric
Key	CCDIVI	DIVI	Division — the code divisional and financial tables carry	alphanumeric
	CCTX40	TX40	Division name	alphanumeric

Field provenance: hand-curated.

Boilerplate SQL

Starting point for reading CMNDIVon 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)

Include optional filters (1)

-- ============================================================
-- Table  : CMNDIV — The division master — one row per division within a company; the DIVI that financial and divisional tables carry resolves here
-- Purpose: Column-selected read of CMNDIV — auto-generated from field metadata
-- Grain  : One row per company (CONO) + CCDIVI
-- 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
  c.CCCONO AS "Company",
  c.CCDIVI AS "Division — the code divisional and financial tables carry",
  c.CCTX40 AS "Division name"
FROM <catalog>.<schema>.CMNDIV c
WHERE
  c.CCCONO = <company>
  -- AND c.CCDIVI = '<DIVI>'
ORDER BY c.CCCONO;

4 parameters not filled: <catalog>, <schema>, <company>, <DIVI>

Relationships

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

Join details

CFACILCMNDIVforeign key · N:1
ON CFACIL.CFDIVI = CMNDIV.CCDIVI AND CFACIL.CFCONO = CMNDIV.CCCONO

Programs That Use This Table

No program mappings populated for this table yet.