	Table	Prefix	Description
1	F4211	SD	Sales Order Detail File
2	F0101	AB	Address Book Master
3	F4101	IM	Item Master
4	F0911	GL	Account Ledger
5	F4311	PD	Purchase Order Detail File
6	F4102	IB	Item Branch File
7	F9671	SD	Software Update Detail Table
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

	Table	Prefix	Description
1	F0011W	IC	F0011W - WF - Batch To Detail
2	F76AUI46	WF	CERG A/R -Work File - ARG - 03B - 76A
3	F4211	SD	Sales Order Detail File
4	F4101	IM	Item Master
5	F0101	AB	Address Book Master
6	F0911	GL	Account Ledger
7	F4102	IB	Item Branch File
8	F03B11	RP	Customer Ledger
9	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
6	F4211	SD	Sales Order Detail File
7	F42119	SD	Sales Order History File
8	F03012	AI	Customer Master by Line of Business
9	F0902	GB	Account Balances
10	F4801	WA	Work Order Master File

116 COLUMNS | 8 INDEXES | 920 | 40R | F40R41 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
40R: Demand Scheduling
1	920	F40R41	DI	116	8	Demand History	Files	40R: Demand Scheduling	Business Data

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT DIUKID, DIDEID, DICREATEDJ, DICREATETM, DIMCU, DIAN8, DISHAN, DIDVAN, DISHPN, DIADDJ, DIADTM, DIITM, DIDETYP, DIDEPER, DICRTSOSTS, DIRLSNO, DIRLSDJ, DIRLSTM, DIRQSJ, DIERQSHPDJ, DIRSHT, DIRQSHPQTY, DIUOM, DIRSDJ, DIRSDT, DIHZED, DIHZSD, DIASBLNFD, DIASBLNLOC, DIASBNO, DIDMDBTHNO, DICSGSHPNO, DIGCNT, DICUMID, DITXTREFNO, DIREQFRQ, DICSTDMDPT, DIREQTYP, DICSTORDNO, DIDKID, DIENDJOBSQ, DIPSJOBNO, DIHZCLSNO, DIJOBSQ, DIKBSNO, DIKBENO, DILABORHR, DICIRV, DIYEAR1, DIPTRLSSTS, DICSTPODJ, DICSTPOTM, DICSTPOLIN, DICSTPO, DITPUR, DIQTYBYPOS, DISOCN, DIPSIG, DIRSVLNFD, DISTSSQIND, DIEDTCTDJ, DIEDTCTTM, DIOGDMDQTY, DIEDTMSGNM, DIEDTMSGSB, DIEDTMSGTP, DITRSRTE, DITRSRTSFX, DIUCARTNO, DIVINNO, DIPENDDLT, DISDID, DINETVC, DINETVCNTF, DICRTCLID, DISOQS, DIDMD06, DIDMD07, DIDMD08, DIDMD09, DIDMD10, DIDMDREF1, DIDMDREF2, DICTLNUM, DIURCD, DIURDT, DIURAT, DIURAB, DIURRF, DIUSER, DIPID, DIJOBN, DIUPMJ, DITDAY, DICARDNO, DIDELBATCH, DICIRVQ, DIPRODTYPE, DIRTORSQ, DIRTGDAT, DIRTGTIM, DIDMDREF3, DIDMDREF4, DIDMDREF5, DIDMDREF6, DIDMDREF7, DIDMDREF8, DIDMDREF9, DIDMDREF10, DISCAC, DIATMCN, DIOFFLNDT, DIENGTAG1, DIENGTAGR1, DIENGTAG2, DIENGTAGR2 FROM F40R41

TOP 920 | 40R | F40R41 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	DIUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
2	DIDEID	Demand Unique Key ID	Numeric	Generic Edit	15	0	Allow NULL?
3	DICREATEDJ	Date - Create	Date	Generic Edit	6	0
4	DICREATETM	Create Time	Numeric	Generic Edit	6	0	Allow NULL?
5	DIMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
6	DIAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
7	DISHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
8	DIDVAN	Address Number - Deliver To	Numeric	Generic Edit	8	0	Allow NULL?
9	DISHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
10	DIADDJ	Date - Actual Ship Date	Date	Generic Edit	6	0
11	DIADTM	Actual Shipment Time	Numeric	Generic Edit	6	0	Allow NULL?
12	DIITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
13	DIDETYP	Demand Type	String	UDC (40R DT)	2	0	Allow NULL?
14	DIDEPER	Demand Period	String	UDC (40R PD)	2	0	Allow NULL?
15	DICRTSOSTS	Status Code - Updated by Create Schedule	Character	Generic Edit	1	0	Allow NULL?
16	DIRLSNO	Release Number	String	Generic Edit	10	0	Allow NULL?
17	DIRLSDJ	Date - Release	Date	Generic Edit	6	0
18	DIRLSTM	Time - Release	Numeric	Generic Edit	6	0	Allow NULL?
19	DIRQSJ	Date - Requested Ship	Date	Generic Edit	6	0
20	DIERQSHPDJ	Date - Ending Requested Ship	Date	Generic Edit	6	0
21	DIRSHT	Requested Ship Time	Numeric	Generic Edit	6	0	Allow NULL?
22	DIRQSHPQTY	Requested Ship Quantity	Numeric	Generic Edit	15	0	Allow NULL?
23	DIUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
24	DIRSDJ	Date - Promised Delivery	Date	Generic Edit	6	0
25	DIRSDT	Promised Delivery Time	Numeric	Generic Edit	6	0	Allow NULL?
26	DIHZED	Horizon End Date	Date	Generic Edit	6	0
27	DIHZSD	Horizon Start Date	Date	Generic Edit	6	0
28	DIASBLNFD	Assembly Line Feed	String	Generic Edit	10	0	Allow NULL?
29	DIASBLNLOC	Assembly Line Location	String	Generic Edit	6	0	Allow NULL?
30	DIASBNO	Assembly Number	String	Generic Edit	15	0	Allow NULL?
31	DIDMDBTHNO	Demand Batch Number	Numeric	Generic Edit	15	0	Allow NULL?
32	DICSGSHPNO	Consignee Shipment Number	String	Generic Edit	35	0	Allow NULL?
33	DIGCNT	Contract Number	String	Generic Edit	12	0	Allow NULL?
34	DICUMID	CUM ID	Numeric	Generic Edit	15	0	Allow NULL?
35	DITXTREFNO	Text Reference Number	String	Generic Edit	15	0	Allow NULL?
36	DIREQFRQ	Requirement Frequency	String	Generic Edit	3	0	Allow NULL?
37	DICSTDMDPT	Customer Demand Pattern	String	Generic Edit	3	0	Allow NULL?
38	DIREQTYP	Requirement Type	String	Generic Edit	3	0	Allow NULL?
39	DICSTORDNO	Customer Order Number	String	Generic Edit	15	0	Allow NULL?
40	DIDKID	Dock ID	String	Generic Edit	20	0	Allow NULL?
41	DIENDJOBSQ	Ending Job Sequence Number	String	Generic Edit	15	0	Allow NULL?
42	DIPSJOBNO	Production Sequencing Job Number	String	Generic Edit	15	0	Allow NULL?
43	DIHZCLSNO	Hazardous Goods Classification	String	Generic Edit	15	0	Allow NULL?
44	DIJOBSQ	Job Sequence Number	String	Generic Edit	15	0	Allow NULL?
45	DIKBSNO	Kanban Start Number	String	Generic Edit	15	0	Allow NULL?
46	DIKBENO	Kanban End Number	String	Generic Edit	15	0	Allow NULL?
47	DILABORHR	Labor Hours	Numeric	Generic Edit	15	0	Allow NULL?
48	DICIRV	Item Revision Level - Customer/Supplier	String	Generic Edit	20	0	Allow NULL?
49	DIYEAR1	Model Year 1	Numeric	Generic Edit	4	0	Allow NULL?
50	DIPTRLSSTS	Code - Part Release Status	String	Generic Edit	2	0	Allow NULL?
51	DICSTPODJ	Date - Customer PO	Date	Generic Edit	6	0
52	DICSTPOTM	Customer PO Time	Numeric	Generic Edit	6	0	Allow NULL?
53	DICSTPOLIN	Customer PO Line	String	Generic Edit	5	0	Allow NULL?
54	DICSTPO	Customer PO	String	Generic Edit	30	0	Allow NULL?
55	DITPUR	Transaction Set Purpose	String	UDC (47 PU)	2	0	Allow NULL?
56	DIQTYBYPOS	Quantity by Position	Numeric	Generic Edit	15	0	Allow NULL?
57	DISOCN	Units - Quantity Canceled/Scrapped	Numeric	Generic Edit	15	0	Allow NULL?
58	DIPSIG	Pull Signal	String	Generic Edit	30	0	Allow NULL?
59	DIRSVLNFD	Reserve Line Feed	String	Generic Edit	10	0	Allow NULL?
60	DISTSSQIND	Status Sequence Indicator	String	Generic Edit	3	0	Allow NULL?
61	DIEDTCTDJ	Date - EDI Transaction Create	Date	Generic Edit	6	0
62	DIEDTCTTM	EDI Transaction Create Time	Numeric	Generic Edit	6	0	Allow NULL?
63	DIOGDMDQTY	Original Demand Quantity	Numeric	Generic Edit	15	0	Allow NULL?
64	DIEDTMSGNM	EDI Transaction/Message Name	String	Generic Edit	10	0	Allow NULL?
65	DIEDTMSGSB	EDI Transaction/Message Name Subset	String	Generic Edit	3	0	Allow NULL?
66	DIEDTMSGTP	EDI Transaction/Message Name Type	String	Generic Edit	3	0	Allow NULL?
67	DITRSRTE	Transportation Route	String	Generic Edit	15	0	Allow NULL?
68	DITRSRTSFX	Transportation Route Suffix	String	Generic Edit	15	0	Allow NULL?
69	DIUCARTNO	Ultimate Customer's Article Number	String	Generic Edit	15	0	Allow NULL?
70	DIVINNO	Vehicle Identification Number	String	Generic Edit	20	0	Allow NULL?
71	DIPENDDLT	Option - Pending Delete	Character	Generic Edit	1	0	Allow NULL?
72	DISDID	Supplemental Data ID	Numeric	Generic Edit	8	0	Allow NULL?
73	DINETVC	Net Variance	Numeric	Generic Edit	7	3	Allow NULL?
74	DINETVCNTF	Option - Net Variance Notification	Character	Generic Edit	1	0	Allow NULL?
75	DICRTCLID	Critical ID	String	UDC (40R CI)	2	0	Allow NULL?
76	DISOQS	Quantity Shipped	Numeric	Generic Edit	15	0	Allow NULL?
77	DIDMD06	Category Code - Demand 06	String	UDC (40R 06)	3	0	Allow NULL?
78	DIDMD07	Category Code - Demand 07	String	UDC (40R 07)	3	0	Allow NULL?
79	DIDMD08	Category Code - Demand 08	String	UDC (40R 08)	3	0	Allow NULL?
80	DIDMD09	Category Code - Demand 09	String	UDC (40R 09)	3	0	Allow NULL?
81	DIDMD10	Category Code - Demand 10	String	UDC (40R 10)	3	0	Allow NULL?
82	DIDMDREF1	Demand Reference 1	String	Generic Edit	35	0	Allow NULL?
83	DIDMDREF2	Demand Reference 2	String	Generic Edit	35	0	Allow NULL?
84	DICTLNUM	Control Number	String	Generic Edit	35	0	Allow NULL?
85	DIURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
86	DIURDT	User Reserved Date	Date	Generic Edit	6	0
87	DIURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
88	DIURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
89	DIURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
90	DIUSER	User ID	String	Generic Edit	10	0	Allow NULL?
91	DIPID	Program ID	String	Generic Edit	10	0	Allow NULL?
92	DIJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
93	DIUPMJ	Date - Updated	Date	Generic Edit	6	0
94	DITDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
95	DICARDNO	Card Number	String	UDC (40R CD)	4	0	Allow NULL?
96	DIDELBATCH	Delivery Batch Number	String	Generic Edit	6	0	Allow NULL?
97	DICIRVQ	Item Revision Level Qualifier	String	UDC (40R IQ)	2	0	Allow NULL?
98	DIPRODTYPE	Product Type	String	Generic Edit	30	0	Allow NULL?
99	DIRTORSQ	Routing Order Sequence Number	String	Generic Edit	30	0	Allow NULL?
100	DIRTGDAT	Routing Date	Date	Generic Edit	6	0
101	DIRTGTIM	Routing Time	Numeric	Generic Edit	6	0	Allow NULL?
102	DIDMDREF3	Demand Reference 3	String	Generic Edit	35	0	Allow NULL?
103	DIDMDREF4	Demand Reference 4	String	Generic Edit	35	0	Allow NULL?
104	DIDMDREF5	Demand Reference 5	String	Generic Edit	35	0	Allow NULL?
105	DIDMDREF6	Demand Reference 6	String	Generic Edit	35	0	Allow NULL?
106	DIDMDREF7	Demand Reference 7	String	Generic Edit	35	0	Allow NULL?
107	DIDMDREF8	Demand Reference 8	String	Generic Edit	35	0	Allow NULL?
108	DIDMDREF9	Demand Reference 9	String	Generic Edit	35	0	Allow NULL?
109	DIDMDREF10	Demand Reference 10	String	Generic Edit	35	0	Allow NULL?
110	DISCAC	Standard Carrier Alpha Code	String	Generic Edit	4	0	Allow NULL?
111	DIATMCN	Authorization To Meet Competition Number	Numeric	Generic Edit	6	0	Allow NULL?
112	DIOFFLNDT	Off Line Date	Date	Generic Edit	6	0
113	DIENGTAG1	Engineering Tag 1	String	Generic Edit	15	0	Allow NULL?
114	DIENGTAGR1	Engineering Tag Reason Code 1	String	UDC (40R EN)	2	0	Allow NULL?
115	DIENGTAG2	Engineering Tag 2	String	Generic Edit	15	0	Allow NULL?
116	DIENGTAGR2	Engineering Tag Reason Code 2	String	UDC (40R EN)	2	0	Allow NULL?

TOP 920 | 40R | F40R41 INDEXES

Number

Description

Demand ID Create Date + (Primary/Unique)

Element	Alias	Description	Sequence
1	DEID	Demand Unique Key ID	Ascending
2	CREATEDJ	Date - Create	Descending
3	CREATETM	Create Time	Descending

Business Unit Address Num A

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	AN8	Address Number	Ascending
3	SHAN	Address Number - Ship To	Ascending
4	ITM	Item Number - Short	Ascending
5	RLSDJ	Date - Release	Ascending
6	RLSTM	Time - Release	Ascending

Business Unit Address Num B

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	AN8	Address Number	Ascending
3	SHAN	Address Number - Ship To	Ascending
4	ITM	Item Number - Short	Ascending
5	EDTCTDJ	Date - EDI Transaction Create	Ascending
6	EDTCTTM	EDI Transaction Create Time	Ascending

Business Unit Address Num C

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	AN8	Address Number	Ascending
3	SHAN	Address Number - Ship To	Ascending
4	ITM	Item Number - Short	Ascending
5	RSDJ	Date - Promised Delivery	Ascending
6	RSDT	Promised Delivery Time	Ascending

Business Unit Address Num D

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	AN8	Address Number	Ascending
3	SHAN	Address Number - Ship To	Ascending
4	ITM	Item Number - Short	Ascending
5	RQSJ	Date - Requested Ship	Ascending
6	RSHT	Requested Ship Time	Ascending

Business Unit Address Num E

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	AN8	Address Number	Ascending
3	SHAN	Address Number - Ship To	Ascending
4	ITM	Item Number - Short	Ascending
5	CREATEDJ	Date - Create	Ascending
6	CREATETM	Create Time	Ascending

Demand ID Shipment Number

Element	Alias	Description	Sequence
1	DEID	Demand Unique Key ID	Ascending
2	SHPN	Shipment Number	Ascending
3	CREATEDJ	Date - Create	Descending
4	CREATETM	Create Time	Descending

Dmd UKID Create Date +

Element	Alias	Description	Sequence
1	UKID	Unique Key ID (Internal)	Ascending
2	CREATEDJ	Date - Create	Descending
3	CREATETM	Create Time	Descending

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

116 COLUMNS | 8 INDEXES | 920 | 40R | F40R41 TABLE

TOP 920 | 40R | F40R41 COLUMNS

TOP 920 | 40R | F40R41 INDEXES

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

116 COLUMNS | 8 INDEXES | 920 | 40R | F40R41 TABLE

TOP920 | 40R | F40R41 COLUMNS

TOP920 | 40R | F40R41 INDEXES

TOP 920 | 40R | F40R41 COLUMNS

TOP 920 | 40R | F40R41 INDEXES