JDE Reference

F40943

control

One row per order detail group combination: an order detail group plus a specific set of sales-order line attribute values (up to 8), assigned a numeric key ID (OGID) that F4072 rate rows point at.

Module: 45 · Advanced PricingColumn prefix: OK

Notes

Decode table for ADOGID in F4072. Which order line fields SDV1-SDV8 represent is defined by the order detail group setup (F4092 keys) — the values here are positional, not fixed columns. OGID 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

10 fields · 9 key

10 fields.

Table fields: key flag, field name, DD alias, description, data type, length, and quirk flags (Julian date, implied decimals, padded string, UDC decode). 10 fields.
Key	Field	Alias	Description	Type	Length	Flags
Primary key	OKSDGR	SDGR	Order detail group this combination belongs to.	String	8	UDC
Primary key	OKSDV1	SDV1	Value of the first order-detail attribute in the combination (positional, per group definition).	String	12
Primary key	OKSDV2	SDV2	Value of the second order-detail attribute in the combination.	String	12
Primary key	OKSDV3	SDV3	Value of the third order-detail attribute in the combination.	String	12
Primary key	OKSDV4	SDV4	Value of the fourth order-detail attribute in the combination.	String	12
Primary key	OKSDV5	SDV5	Value of the fifth order-detail attribute in the combination.	String	12
Primary key	OKSDV6	SDV6	Value of the sixth order-detail attribute in the combination.	String	12
Primary key	OKSDV7	SDV7	Value of the seventh order-detail attribute in the combination.	String	12
Primary key	OKSDV8	SDV8	Value of the eighth order-detail attribute in the combination.	String	12
	OKOGID	OGID	Order group key ID — the surrogate key F4072 stores in ADOGID; unique per combination.	Numeric	8

Field provenance: hand-curated.

Boilerplate SQL

Starting point for reading F40943 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  : F40943 One row per order detail group combination: an order detail group plus a specific set of sales-order line attribute values (up to 8), assigned a numeric key ID (OGID) that F4072 rate rows point at.
-- Purpose: Column-selected read of F40943 — auto-generated from field metadata
-- Grain  : One row per OKSDGR + OKSDV1 + OKSDV2 + OKSDV3 + OKSDV4 + OKSDV5 + OKSDV6 + OKSDV7 + OKSDV8
-- 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.OKSDGR AS "Order detail group this combination belongs to.",
  f.OKSDV1 AS "Value of the first order-detail attribute in the combination (positional, per group definition).",
  f.OKSDV2 AS "Value of the second order-detail attribute in the combination.",
  f.OKSDV3 AS "Value of the third order-detail attribute in the combination.",
  f.OKSDV4 AS "Value of the fourth order-detail attribute in the combination.",
  f.OKSDV5 AS "Value of the fifth order-detail attribute in the combination.",
  f.OKSDV6 AS "Value of the sixth order-detail attribute in the combination.",
  f.OKSDV7 AS "Value of the seventh order-detail attribute in the combination.",
  f.OKSDV8 AS "Value of the eighth order-detail attribute in the combination.",
  f.OKOGID AS "Order group key ID — the surrogate key F4072 stores in ADOGID; unique per combination."
FROM <catalog>.<schema_data>.f40943 f
ORDER BY f.OKSDGR;

Verified September 2026

Relationships

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

Join details

F4072F40943foreign key · N:1
ON f4072.ADOGID = f40943.OKOGID

Programs That Use This Table

No program mappings populated for this table yet.

Browse more 45 tables