	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	F9671	SD	Software Update Detail Table
7	F4102	IB	Item Branch File
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	F4111	IL	Item Ledger File
10	F4311	PD	Purchase Order Detail File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0006	MC	Business Unit Master
5	F0411	RP	Accounts Payable Ledger
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

110 COLUMNS | 9 INDEXES | 920 | 40R | F40R11 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
40R: Demand Scheduling
1	920	F40R11	DD	110	9	Demand Detail	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 DDUKID, DDDEID, DDMCU, DDAN8, DDSHAN, DDDVAN, DDITM, DDDETYP, DDDEPER, DDCRTSOSTS, DDRLSNO, DDRLSDJ, DDRLSTM, DDRQSJ, DDERQSHPDJ, DDRSHT, DDRQSHPQTY, DDUOM, DDRSDJ, DDRSDT, DDHZED, DDHZSD, DDASBLNFD, DDASBLNLOC, DDASBNO, DDDMDBTHNO, DDCSGSHPNO, DDGCNT, DDCUMID, DDTXTREFNO, DDREQFRQ, DDCSTDMDPT, DDREQTYP, DDCSTORDNO, DDDKID, DDENDJOBSQ, DDPSJOBNO, DDHZCLSNO, DDJOBSQ, DDKBSNO, DDKBENO, DDLABORHR, DDCIRV, DDYEAR1, DDPTRLSSTS, DDCSTPODJ, DDCSTPOTM, DDCSTPOLIN, DDCSTPO, DDTPUR, DDQTYBYPOS, DDSOCN, DDPSIG, DDRSVLNFD, DDSTSSQIND, DDEDTCTDJ, DDEDTCTTM, DDOGDMDQTY, DDEDTMSGNM, DDEDTMSGSB, DDEDTMSGTP, DDTRSRTE, DDTRSRTSFX, DDUCARTNO, DDVINNO, DDPENDDLT, DDSDID, DDNETVC, DDNETVCNTF, DDCRTCLID, DDDMD06, DDDMD07, DDDMD08, DDDMD09, DDDMD10, DDDMDREF1, DDDMDREF2, DDCTLNUM, DDURCD, DDURDT, DDURAT, DDURAB, DDURRF, DDUSER, DDPID, DDJOBN, DDUPMJ, DDTDAY, DDCARDNO, DDDELBATCH, DDCIRVQ, DDPRODTYPE, DDRTORSQ, DDRTGDAT, DDRTGTIM, DDDMDREF3, DDDMDREF4, DDDMDREF5, DDDMDREF6, DDDMDREF7, DDDMDREF8, DDDMDREF9, DDDMDREF10, DDSCAC, DDATMCN, DDOFFLNDT, DDENGTAG1, DDENGTAGR1, DDENGTAG2, DDENGTAGR2 FROM F40R11

TOP 920 | 40R | F40R11 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	DDUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
2	DDDEID	Demand Unique Key ID	Numeric	Generic Edit	15	0	Allow NULL?
3	DDMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
4	DDAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
5	DDSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
6	DDDVAN	Address Number - Deliver To	Numeric	Generic Edit	8	0	Allow NULL?
7	DDITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
8	DDDETYP	Demand Type	String	UDC (40R DT)	2	0	Allow NULL?
9	DDDEPER	Demand Period	String	UDC (40R PD)	2	0	Allow NULL?
10	DDCRTSOSTS	Status Code - Updated by Create Schedule	Character	Generic Edit	1	0	Allow NULL?
11	DDRLSNO	Release Number	String	Generic Edit	10	0	Allow NULL?
12	DDRLSDJ	Date - Release	Date	Generic Edit	6	0
13	DDRLSTM	Time - Release	Numeric	Generic Edit	6	0	Allow NULL?
14	DDRQSJ	Date - Requested Ship	Date	Generic Edit	6	0
15	DDERQSHPDJ	Date - Ending Requested Ship	Date	Generic Edit	6	0
16	DDRSHT	Requested Ship Time	Numeric	Generic Edit	6	0	Allow NULL?
17	DDRQSHPQTY	Requested Ship Quantity	Numeric	Generic Edit	15	0	Allow NULL?
18	DDUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
19	DDRSDJ	Date - Promised Delivery	Date	Generic Edit	6	0
20	DDRSDT	Promised Delivery Time	Numeric	Generic Edit	6	0	Allow NULL?
21	DDHZED	Horizon End Date	Date	Generic Edit	6	0
22	DDHZSD	Horizon Start Date	Date	Generic Edit	6	0
23	DDASBLNFD	Assembly Line Feed	String	Generic Edit	10	0	Allow NULL?
24	DDASBLNLOC	Assembly Line Location	String	Generic Edit	6	0	Allow NULL?
25	DDASBNO	Assembly Number	String	Generic Edit	15	0	Allow NULL?
26	DDDMDBTHNO	Demand Batch Number	Numeric	Generic Edit	15	0	Allow NULL?
27	DDCSGSHPNO	Consignee Shipment Number	String	Generic Edit	35	0	Allow NULL?
28	DDGCNT	Contract Number	String	Generic Edit	12	0	Allow NULL?
29	DDCUMID	CUM ID	Numeric	Generic Edit	15	0	Allow NULL?
30	DDTXTREFNO	Text Reference Number	String	Generic Edit	15	0	Allow NULL?
31	DDREQFRQ	Requirement Frequency	String	Generic Edit	3	0	Allow NULL?
32	DDCSTDMDPT	Customer Demand Pattern	String	Generic Edit	3	0	Allow NULL?
33	DDREQTYP	Requirement Type	String	Generic Edit	3	0	Allow NULL?
34	DDCSTORDNO	Customer Order Number	String	Generic Edit	15	0	Allow NULL?
35	DDDKID	Dock ID	String	Generic Edit	20	0	Allow NULL?
36	DDENDJOBSQ	Ending Job Sequence Number	String	Generic Edit	15	0	Allow NULL?
37	DDPSJOBNO	Production Sequencing Job Number	String	Generic Edit	15	0	Allow NULL?
38	DDHZCLSNO	Hazardous Goods Classification	String	Generic Edit	15	0	Allow NULL?
39	DDJOBSQ	Job Sequence Number	String	Generic Edit	15	0	Allow NULL?
40	DDKBSNO	Kanban Start Number	String	Generic Edit	15	0	Allow NULL?
41	DDKBENO	Kanban End Number	String	Generic Edit	15	0	Allow NULL?
42	DDLABORHR	Labor Hours	Numeric	Generic Edit	15	0	Allow NULL?
43	DDCIRV	Item Revision Level - Customer/Supplier	String	Generic Edit	20	0	Allow NULL?
44	DDYEAR1	Model Year 1	Numeric	Generic Edit	4	0	Allow NULL?
45	DDPTRLSSTS	Code - Part Release Status	String	Generic Edit	2	0	Allow NULL?
46	DDCSTPODJ	Date - Customer PO	Date	Generic Edit	6	0
47	DDCSTPOTM	Customer PO Time	Numeric	Generic Edit	6	0	Allow NULL?
48	DDCSTPOLIN	Customer PO Line	String	Generic Edit	5	0	Allow NULL?
49	DDCSTPO	Customer PO	String	Generic Edit	30	0	Allow NULL?
50	DDTPUR	Transaction Set Purpose	String	UDC (47 PU)	2	0	Allow NULL?
51	DDQTYBYPOS	Quantity by Position	Numeric	Generic Edit	15	0	Allow NULL?
52	DDSOCN	Units - Quantity Canceled/Scrapped	Numeric	Generic Edit	15	0	Allow NULL?
53	DDPSIG	Pull Signal	String	Generic Edit	30	0	Allow NULL?
54	DDRSVLNFD	Reserve Line Feed	String	Generic Edit	10	0	Allow NULL?
55	DDSTSSQIND	Status Sequence Indicator	String	Generic Edit	3	0	Allow NULL?
56	DDEDTCTDJ	Date - EDI Transaction Create	Date	Generic Edit	6	0
57	DDEDTCTTM	EDI Transaction Create Time	Numeric	Generic Edit	6	0	Allow NULL?
58	DDOGDMDQTY	Original Demand Quantity	Numeric	Generic Edit	15	0	Allow NULL?
59	DDEDTMSGNM	EDI Transaction/Message Name	String	Generic Edit	10	0	Allow NULL?
60	DDEDTMSGSB	EDI Transaction/Message Name Subset	String	Generic Edit	3	0	Allow NULL?
61	DDEDTMSGTP	EDI Transaction/Message Name Type	String	Generic Edit	3	0	Allow NULL?
62	DDTRSRTE	Transportation Route	String	Generic Edit	15	0	Allow NULL?
63	DDTRSRTSFX	Transportation Route Suffix	String	Generic Edit	15	0	Allow NULL?
64	DDUCARTNO	Ultimate Customer's Article Number	String	Generic Edit	15	0	Allow NULL?
65	DDVINNO	Vehicle Identification Number	String	Generic Edit	20	0	Allow NULL?
66	DDPENDDLT	Option - Pending Delete	Character	Generic Edit	1	0	Allow NULL?
67	DDSDID	Supplemental Data ID	Numeric	Generic Edit	8	0	Allow NULL?
68	DDNETVC	Net Variance	Numeric	Generic Edit	7	3	Allow NULL?
69	DDNETVCNTF	Option - Net Variance Notification	Character	Generic Edit	1	0	Allow NULL?
70	DDCRTCLID	Critical ID	String	UDC (40R CI)	2	0	Allow NULL?
71	DDDMD06	Category Code - Demand 06	String	UDC (40R 06)	3	0	Allow NULL?
72	DDDMD07	Category Code - Demand 07	String	UDC (40R 07)	3	0	Allow NULL?
73	DDDMD08	Category Code - Demand 08	String	UDC (40R 08)	3	0	Allow NULL?
74	DDDMD09	Category Code - Demand 09	String	UDC (40R 09)	3	0	Allow NULL?
75	DDDMD10	Category Code - Demand 10	String	UDC (40R 10)	3	0	Allow NULL?
76	DDDMDREF1	Demand Reference 1	String	Generic Edit	35	0	Allow NULL?
77	DDDMDREF2	Demand Reference 2	String	Generic Edit	35	0	Allow NULL?
78	DDCTLNUM	Control Number	String	Generic Edit	35	0	Allow NULL?
79	DDURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
80	DDURDT	User Reserved Date	Date	Generic Edit	6	0
81	DDURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
82	DDURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
83	DDURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
84	DDUSER	User ID	String	Generic Edit	10	0	Allow NULL?
85	DDPID	Program ID	String	Generic Edit	10	0	Allow NULL?
86	DDJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
87	DDUPMJ	Date - Updated	Date	Generic Edit	6	0
88	DDTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
89	DDCARDNO	Card Number	String	UDC (40R CD)	4	0	Allow NULL?
90	DDDELBATCH	Delivery Batch Number	String	Generic Edit	6	0	Allow NULL?
91	DDCIRVQ	Item Revision Level Qualifier	String	UDC (40R IQ)	2	0	Allow NULL?
92	DDPRODTYPE	Product Type	String	Generic Edit	30	0	Allow NULL?
93	DDRTORSQ	Routing Order Sequence Number	String	Generic Edit	30	0	Allow NULL?
94	DDRTGDAT	Routing Date	Date	Generic Edit	6	0
95	DDRTGTIM	Routing Time	Numeric	Generic Edit	6	0	Allow NULL?
96	DDDMDREF3	Demand Reference 3	String	Generic Edit	35	0	Allow NULL?
97	DDDMDREF4	Demand Reference 4	String	Generic Edit	35	0	Allow NULL?
98	DDDMDREF5	Demand Reference 5	String	Generic Edit	35	0	Allow NULL?
99	DDDMDREF6	Demand Reference 6	String	Generic Edit	35	0	Allow NULL?
100	DDDMDREF7	Demand Reference 7	String	Generic Edit	35	0	Allow NULL?
101	DDDMDREF8	Demand Reference 8	String	Generic Edit	35	0	Allow NULL?
102	DDDMDREF9	Demand Reference 9	String	Generic Edit	35	0	Allow NULL?
103	DDDMDREF10	Demand Reference 10	String	Generic Edit	35	0	Allow NULL?
104	DDSCAC	Standard Carrier Alpha Code	String	Generic Edit	4	0	Allow NULL?
105	DDATMCN	Authorization To Meet Competition Number	Numeric	Generic Edit	6	0	Allow NULL?
106	DDOFFLNDT	Off Line Date	Date	Generic Edit	6	0
107	DDENGTAG1	Engineering Tag 1	String	Generic Edit	15	0	Allow NULL?
108	DDENGTAGR1	Engineering Tag Reason Code 1	String	UDC (40R EN)	2	0	Allow NULL?
109	DDENGTAG2	Engineering Tag 2	String	Generic Edit	15	0	Allow NULL?
110	DDENGTAGR2	Engineering Tag Reason Code 2	String	UDC (40R EN)	2	0	Allow NULL?

TOP 920 | 40R | F40R11 INDEXES

Number

Description

Demand Unique Key ID (Primary/Unique)

Element	Alias	Description	Sequence
1	DEID	Demand Unique Key ID	Ascending

CUM ID

Element	Alias	Description	Sequence
1	CUMID	CUM ID	Ascending

Business Unit Address Num + (Unique)

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
7	DETYP	Demand Type	Ascending
8	DEPER	Demand Period	Ascending
9	CSTPO	Customer PO	Ascending
10	PSIG	Pull Signal	Ascending
11	PSJOBNO	Production Sequencing Job Number	Ascending
12	JOBSQ	Job Sequence Number	Ascending

Demand Batch Number

Element	Alias	Description	Sequence
1	DMDBTHNO	Demand Batch Number	Ascending

Supplemental Dmd ID

Element	Alias	Description	Sequence
1	SDID	Supplemental Data ID	Ascending

Txn Msg Name Business Unit +

Element	Alias	Description	Sequence
1	EDTMSGNM	EDI Transaction/Message Name	Ascending
2	MCU	Business Unit	Ascending
3	AN8	Address Number	Ascending
4	SHAN	Address Number - Ship To	Ascending
5	ITM	Item Number - Short	Ascending

Dmd UKID Release Date +

Element	Alias	Description	Sequence
1	UKID	Unique Key ID (Internal)	Ascending
2	RLSDJ	Date - Release	Descending
3	RLSTM	Time - Release	Descending

Unique Key ID

Element	Alias	Description	Sequence
1	UKID	Unique Key ID (Internal)	Ascending

Demand Type Sold To +

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

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

110 COLUMNS | 9 INDEXES | 920 | 40R | F40R11 TABLE

TOP 920 | 40R | F40R11 COLUMNS

TOP 920 | 40R | F40R11 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

110 COLUMNS | 9 INDEXES | 920 | 40R | F40R11 TABLE

TOP920 | 40R | F40R11 COLUMNS

TOP920 | 40R | F40R11 INDEXES

TOP 920 | 40R | F40R11 COLUMNS

TOP 920 | 40R | F40R11 INDEXES