JDE Reference

F40942

control

One row per customer price group combination: a customer group plus a specific set of customer category-code values, assigned a numeric key ID (CGID) that F4072 rate rows point at.

Module: 45 · Advanced PricingColumn prefix: CK

Notes

Decode table for ADCGID in F4072: join CGID to recover which customer group and category-code values a rate row covers. CGID has its own unique index.

What the badges mean

Superseded: Superseded — a newer table has replaced it, but older scripts still read this one.
Also in JDE World: Also present in JDE World A9.x on the same table name.
master: Data class: what the table holds — master data, transaction documents, control/setup values, history, or a workfile.
Read/write access: Access mode: how the paired program reads or writes this table — R (read), W (write), or R/W (both).

Fields

12 fields · 11 key

12 fields.

Table fields: key flag, field name, DD alias, description, data type, length, and quirk flags (Julian date, implied decimals, padded string, UDC decode). 12 fields.
Key	Field	Alias	Description	Type	Length	Flags
Primary key	CKCPGP	CPGP	Customer price group this combination belongs to.	String	8	UDC
Primary key	CKCGP1	CGP1	Value of the first customer category code in the combination.	String	3
Primary key	CKCGP2	CGP2	Value of the second customer category code in the combination.	String	3
Primary key	CKCGP3	CGP3	Value of the third customer category code in the combination.	String	3
Primary key	CKCGP4	CGP4	Value of the fourth customer category code in the combination.	String	3
Primary key	CKCGP5	CGP5	Value of the fifth customer category code in the combination.	String	3
Primary key	CKCGP6	CGP6	Value of the sixth customer category code in the combination.	String	3
Primary key	CKCGP7	CGP7	Value of the seventh customer category code in the combination.	String	3
Primary key	CKCGP8	CGP8	Value of the eighth customer category code in the combination.	String	3
Primary key	CKCGP9	CGP9	Value of the ninth customer category code in the combination.	String	3
Primary key	CKCGP10	CGP10	Value of the tenth customer category code in the combination.	String	3
	CKCGID	CGID	Customer group key ID — the surrogate key F4072 stores in ADCGID; unique per combination.	Numeric	8

Field provenance: hand-curated.

Boilerplate SQL

Starting point for reading F40942 on Databricks — Julian dates, implied decimals, and padded strings are already converted. Set your Unity Catalog location and filter values below; they’re substituted into the SQL and the copy button.

Query parameters

CatalogData Schema (PRODDTA)

2 parameters not filled: <catalog>, <schema_data>

-- ============================================================
-- Table  : F40942 One row per customer price group combination: a customer group plus a specific set of customer category-code values, assigned a numeric key ID (CGID) that F4072 rate rows point at.
-- Purpose: Column-selected read of F40942 — auto-generated from field metadata
-- Grain  : One row per CKCPGP + CKCGP1 + CKCGP2 + CKCGP3 + CKCGP4 + CKCGP5 + CKCGP6 + CKCGP7 + CKCGP8 + CKCGP9 + CKCGP10
-- Notes  : Auto-generated skeleton. Julian dates (CYYDDD) are converted to DATE and implied-decimal amounts are scaled (verify decimals in F9210); padded business-unit/UDC keys are TRIMmed. Audit columns (…USER/…PID/…UPMJ) are omitted — see the quirks guide. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- ============================================================
SELECT
  f.CKCPGP AS "Customer price group this combination belongs to.",
  f.CKCGP1 AS "Value of the first customer category code in the combination.",
  f.CKCGP2 AS "Value of the second customer category code in the combination.",
  f.CKCGP3 AS "Value of the third customer category code in the combination.",
  f.CKCGP4 AS "Value of the fourth customer category code in the combination.",
  f.CKCGP5 AS "Value of the fifth customer category code in the combination.",
  f.CKCGP6 AS "Value of the sixth customer category code in the combination.",
  f.CKCGP7 AS "Value of the seventh customer category code in the combination.",
  f.CKCGP8 AS "Value of the eighth customer category code in the combination.",
  f.CKCGP9 AS "Value of the ninth customer category code in the combination.",
  f.CKCGP10 AS "Value of the tenth customer category code in the combination.",
  f.CKCGID AS "Customer group key ID — the surrogate key F4072 stores in ADCGID; unique per combination."
FROM <catalog>.<schema_data>.f40942 f
ORDER BY f.CKCPGP;

Verified September 2026

Relationships

Diagram of 1-hop neighbors — join details below. UDC decode edges point coded fields at their F0005 lookup.

Join details

F4072F40942foreign key · N:1
ON f4072.ADCGID = f40942.CKCGID

Programs That Use This Table

No program mappings populated for this table yet.

Browse more 45 tables