	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

115 COLUMNS | 2 INDEXES | 920 | 42B | F42420 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
42B: Sales Order Entry
1	920	F42420	AL	115	2	Audit Log Transaction	Files	42B: Sales Order Entry	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 ALKCOO, ALDOCO, ALDCTO, ALLNID, ALCORD, ALUPMJ, ALTDAY, ALUSER, ALRFRV, ALAPSR, ALAPPV, ALAPPJ, ALATIM, ALSFXO, ALMCU, ALLITM, ALUORG, ALUOM, ALUPRC, ALAEXP, ALFUP, ALFEA, ALLOCN, ALLOTN, ALDRQJ, ALDSC1, ALLTTR, ALNXTR, ALUOM4, ALSOQS, ALSOBK, ALSOCN, ALPDDJ, ALPPDJ, ALCNDJ, ALRSDJ, ALUNCS, ALECST, ALFUC, ALFEC, ALPRP5, ALVEND, ALSHAN, ALDSC2, ALTAX1, ALWTUM, ALITWT, ALRYIN, ALINMG, ALMOT, ALDTYS, ALCARS, ALLOB, ALEUSE, ALEMCU, ALUPC1, ALUPC2, ALUPC3, ALASN, ALPRGR, ALPTC, ALPRIO, ALRCD, ALCADC, ALGLPT, ALSBL, ALSBLT, ALSRP1, ALSRP2, ALSRP3, ALSRP4, ALSRP5, ALAFT, ALSHCM, ALSHCN, ALFRAT, ALROUT, ALSTOP, ALZON, ALITVL, ALVLUM, ALACOM, ALEXR1, ALTXA1, ALSQOR, ALUOM2, ALMCLN, ALXDCK, ALXPTY, ALDRQT, ALPDTT, ALOPTT, ALADTM, ALPMDT, ALPSTM, ALRLNU, ALPSIG, ALRLDJ, ALRLTM, ALXKCO, ALXORN, ALXCTO, ALXLLN, ALXSFX, ALPID, ALSPATTN, ALPRAN8, ALPRCIDLN, ALCCIDLN, ALSHCCIDLN, ALOPPID, ALOSTP, ALUKID, ALCATNM, ALOSCORE FROM F42420

TOP 920 | 42B | F42420 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	ALKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
2	ALDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
3	ALDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
4	ALLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
5	ALCORD	Change Order Number	Numeric	Generic Edit	3	0	Allow NULL?
6	ALUPMJ	Date - Updated	Date	Generic Edit	6	0
7	ALTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
8	ALUSER	User ID	String	Generic Edit	10	0	Allow NULL?
9	ALRFRV	Revision Reason	String	UDC (42 RR)	3	0	Allow NULL?
10	ALAPSR	Approval Status	Character	Generic Edit	1	0	Allow NULL?
11	ALAPPV	Approver	String	Generic Edit	10	0	Allow NULL?
12	ALAPPJ	Date - Approval (Julian)	Date	Generic Edit	6	0
13	ALATIM	Time - Approval	Numeric	Generic Edit	6	0	Allow NULL?
14	ALSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
15	ALMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
16	ALLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
17	ALUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	0	Allow NULL?
18	ALUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
19	ALUPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
20	ALAEXP	Amount - Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
21	ALFUP	Amount - Foreign Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
22	ALFEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
23	ALLOCN	Location	String	Generic Edit	20	0	Allow NULL?
24	ALLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
25	ALDRQJ	Date - Requested	Date	Generic Edit	6	0
26	ALDSC1	Description	String	Generic Edit	30	0	Allow NULL?
27	ALLTTR	Status Code - Last	String	UDC (40 AT)	3	0	Allow NULL?
28	ALNXTR	Status Code - Next	String	UDC (40 AT)	3	0	Allow NULL?
29	ALUOM4	Unit of Measure - Pricing	String	UDC (00 UM)	2	0	Allow NULL?
30	ALSOQS	Quantity Shipped	Numeric	Generic Edit	15	0	Allow NULL?
31	ALSOBK	Units - Qty Backordered/Held	Numeric	Generic Edit	15	0	Allow NULL?
32	ALSOCN	Units - Quantity Canceled/Scrapped	Numeric	Generic Edit	15	0	Allow NULL?
33	ALPDDJ	Date - Scheduled Pick	Date	Generic Edit	6	0
34	ALPPDJ	Date - Promised Shipment	Date	Generic Edit	6	0
35	ALCNDJ	Date - Cancel	Date	Generic Edit	6	0
36	ALRSDJ	Date - Promised Delivery	Date	Generic Edit	6	0
37	ALUNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
38	ALECST	Amount - Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
39	ALFUC	Amount - Foreign Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
40	ALFEC	Amount - Foreign Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
41	ALPRP5	Purchasing Category Code 5	String	UDC (41 P5)	3	0	Allow NULL?
42	ALVEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0	Allow NULL?
43	ALSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
44	ALDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
45	ALTAX1	Sales Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
46	ALWTUM	Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
47	ALITWT	Unit Weight	Numeric	Generic Edit	15	4	Allow NULL?
48	ALRYIN	Payment Instrument	Character	UDC (00 PY)	1	0	Allow NULL?
49	ALINMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
50	ALMOT	Mode of Transport	String	UDC (00 TM)	3	0	Allow NULL?
51	ALDTYS	Duty Status	String	UDC (40 DS)	2	0	Allow NULL?
52	ALCARS	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
53	ALLOB	Line of Business	String	UDC (40 LB)	3	0	Allow NULL?
54	ALEUSE	End Use	String	UDC (40 EU)	3	0	Allow NULL?
55	ALEMCU	Business Unit - Header	String	Generic Edit	12	0	Allow NULL?
56	ALUPC1	Price Code 1	String	UDC (40 P1)	2	0	Allow NULL?
57	ALUPC2	Price Code 2	String	UDC (40 P2)	2	0	Allow NULL?
58	ALUPC3	Price Code 3	String	UDC (40 P3)	2	0	Allow NULL?
59	ALASN	Price and Adjustment Schedule	String	UDC (40 AS)	8	0	Allow NULL?
60	ALPRGR	Item Price Group	String	UDC (40 PI)	8	0	Allow NULL?
61	ALPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
62	ALPRIO	Priority - Processing	Character	UDC (H40 PR)	1	0	Allow NULL?
63	ALRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
64	ALCADC	Discount % - Cash	Numeric	Generic Edit	7	3	Allow NULL?
65	ALGLPT	Category - G/L	String	UDC (41 9)	4	0	Allow NULL?
66	ALSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
67	ALSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
68	ALSRP1	Sales Catalog Section	String	UDC (41 S1)	3	0	Allow NULL?
69	ALSRP2	Sub Section	String	UDC (41 S2)	3	0	Allow NULL?
70	ALSRP3	Sales Category Code 3	String	UDC (41 S3)	3	0	Allow NULL?
71	ALSRP4	Sales Category Code 4	String	UDC (41 S4)	3	0	Allow NULL?
72	ALSRP5	Sales Category Code 5	String	UDC (41 S5)	3	0	Allow NULL?
73	ALAFT	Apply Freight - Y/N	Character	Generic Edit	1	0	Allow NULL?
74	ALSHCM	Shipping Commodity Class	String	UDC (41 E)	3	0	Allow NULL?
75	ALSHCN	Shipping Conditions Code	String	UDC (41 C)	3	0	Allow NULL?
76	ALFRAT	Rate Code - Frieght/Misc	String	UDC (41 RT)	10	0	Allow NULL?
77	ALROUT	Route Code	String	UDC (42 RT)	3	0	Allow NULL?
78	ALSTOP	Stop Code	String	UDC (42 SP)	3	0	Allow NULL?
79	ALZON	Zone Number	String	UDC (40 ZN)	3	0	Allow NULL?
80	ALITVL	Unit Volume	Numeric	Generic Edit	15	4	Allow NULL?
81	ALVLUM	Volume Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
82	ALACOM	Apply Commission (Y/N)	Character	Generic Edit	1	0	Allow NULL?
83	ALEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
84	ALTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
85	ALSQOR	Units - Secondary Quantity Ordered	Numeric	Generic Edit	15	0	Allow NULL?
86	ALUOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
87	ALMCLN	Matrix Control Line Number	Numeric	Generic Edit	6	3	Allow NULL?
88	ALXDCK	Cross-Docking Flag	Character	Generic Edit	1	0	Allow NULL?
89	ALXPTY	Cross Docking Priority for Sales Orders	Numeric	Generic Edit	15	0	Allow NULL?
90	ALDRQT	Requested Delivery Time	Numeric	Generic Edit	6	0	Allow NULL?
91	ALPDTT	Time - Scheduled Pick	Numeric	Generic Edit	6	0	Allow NULL?
92	ALOPTT	Time - Original Promised Delivery	Numeric	Generic Edit	6	0	Allow NULL?
93	ALADTM	Actual Shipment Time	Numeric	Generic Edit	6	0	Allow NULL?
94	ALPMDT	Scheduled Shipment Time	Numeric	Generic Edit	6	0	Allow NULL?
95	ALPSTM	Time - Future Time 2	Numeric	Generic Edit	6	0	Allow NULL?
96	ALRLNU	Release Number	String	Generic Edit	10	0	Allow NULL?
97	ALPSIG	Pull Signal	String	Generic Edit	30	0	Allow NULL?
98	ALRLDJ	Date - Release	Date	Generic Edit	6	0
99	ALRLTM	Time - Release	Numeric	Generic Edit	6	0	Allow NULL?
100	ALXKCO	Cross Dock Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
101	ALXORN	Cross Dock Order No	Numeric	Generic Edit	8	0	Allow NULL?
102	ALXCTO	Cross Dock Order Type	String	UDC (00 DT)	2	0	Allow NULL?
103	ALXLLN	Cross Dock Line Number	Numeric	Generic Edit	6	3	Allow NULL?
104	ALXSFX	Cross Dock Order Suffix	String	Generic Edit	3	0	Allow NULL?
105	ALPID	Program ID	String	Generic Edit	10	0	Allow NULL?
106	ALSPATTN	Ship To Attention	String	Generic Edit	50	0	Allow NULL?
107	ALPRAN8	Partner Address Number	Numeric	Generic Edit	8	0	Allow NULL?
108	ALPRCIDLN	Partner Contact Line Number ID	Numeric	Generic Edit	5	0	Allow NULL?
109	ALCCIDLN	Customer Contact Line Number ID	Numeric	Generic Edit	5	0	Allow NULL?
110	ALSHCCIDLN	Ship To Cust Contact Line Num ID	Numeric	Generic Edit	5	0	Allow NULL?
111	ALOPPID	Opportunity Number	Numeric	Generic Edit	15	0	Allow NULL?
112	ALOSTP	Organization Structure Type	String	UDC (01 TS)	3	0	Allow NULL?
113	ALUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
114	ALCATNM	Catalog Name	String	Generic Edit	30	0	Allow NULL?
115	ALOSCORE	Sales Order Score	Numeric	Generic Edit	15	3	Allow NULL?

TOP 920 | 42B | F42420 INDEXES

Number

Description

Order Co Order No A+ (Primary/Unique)

Element	Alias	Description	Sequence
1	KCOO	Order Company (Order Number)	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	DCTO	Order Type	Ascending
4	LNID	Line Number	Ascending
5	CORD	Change Order Number	Ascending
6	UPMJ	Date - Updated	Ascending
7	TDAY	Time of Day	Ascending
8	USER	User ID	Ascending

Order Co Order B+

Element	Alias	Description	Sequence
1	KCOO	Order Company (Order Number)	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	DCTO	Order Type	Ascending
4	CORD	Change Order Number	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

115 COLUMNS | 2 INDEXES | 920 | 42B | F42420 TABLE

TOP 920 | 42B | F42420 COLUMNS

TOP 920 | 42B | F42420 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

115 COLUMNS | 2 INDEXES | 920 | 42B | F42420 TABLE

TOP920 | 42B | F42420 COLUMNS

TOP920 | 42B | F42420 INDEXES

TOP 920 | 42B | F42420 COLUMNS

TOP 920 | 42B | F42420 INDEXES