JDE Reference

F40941

control

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

Module: 45 · Advanced PricingColumn prefix: IK

Notes

Decode table for ADIGID in F4072: join IGID to recover which item group and category-code values a rate row covers. IGID 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	IKPRGR	PRGR	Item price group this combination belongs to.	String	8	UDC
Primary key	IKIGP1	IGP1	Value of the first item category code in the combination.	String	6
Primary key	IKIGP2	IGP2	Value of the second item category code in the combination.	String	6
Primary key	IKIGP3	IGP3	Value of the third item category code in the combination.	String	6
Primary key	IKIGP4	IGP4	Value of the fourth item category code in the combination.	String	6
Primary key	IKIGP5	IGP5	Value of the fifth item category code in the combination.	String	6
Primary key	IKIGP6	IGP6	Value of the sixth item category code in the combination.	String	6
Primary key	IKIGP7	IGP7	Value of the seventh item category code in the combination.	String	6
Primary key	IKIGP8	IGP8	Value of the eighth item category code in the combination.	String	6
Primary key	IKIGP9	IGP9	Value of the ninth item category code in the combination.	String	6
Primary key	IKIGP10	IGP10	Value of the tenth item category code in the combination.	String	6
	IKIGID	IGID	Item group key ID — the surrogate key F4072 stores in ADIGID; unique per combination.	Numeric	8

Field provenance: hand-curated.

Boilerplate SQL

Starting point for reading F40941 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  : F40941 One row per item price group combination: an item group plus a specific set of item category-code values, assigned a numeric key ID (IGID) that F4072 rate rows point at.
-- Purpose: Column-selected read of F40941 — auto-generated from field metadata
-- Grain  : One row per IKPRGR + IKIGP1 + IKIGP2 + IKIGP3 + IKIGP4 + IKIGP5 + IKIGP6 + IKIGP7 + IKIGP8 + IKIGP9 + IKIGP10
-- 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.IKPRGR AS "Item price group this combination belongs to.",
  f.IKIGP1 AS "Value of the first item category code in the combination.",
  f.IKIGP2 AS "Value of the second item category code in the combination.",
  f.IKIGP3 AS "Value of the third item category code in the combination.",
  f.IKIGP4 AS "Value of the fourth item category code in the combination.",
  f.IKIGP5 AS "Value of the fifth item category code in the combination.",
  f.IKIGP6 AS "Value of the sixth item category code in the combination.",
  f.IKIGP7 AS "Value of the seventh item category code in the combination.",
  f.IKIGP8 AS "Value of the eighth item category code in the combination.",
  f.IKIGP9 AS "Value of the ninth item category code in the combination.",
  f.IKIGP10 AS "Value of the tenth item category code in the combination.",
  f.IKIGID AS "Item group key ID — the surrogate key F4072 stores in ADIGID; unique per combination."
FROM <catalog>.<schema_data>.f40941 f
ORDER BY f.IKPRGR;

Verified September 2026

Relationships

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

Join details

F4072F40941foreign key · N:1
ON f4072.ADIGID = f40941.IKIGID

Programs That Use This Table

No program mappings populated for this table yet.

Browse more 45 tables