	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

145 COLUMNS | 4 INDEXES | 812 | 40 | F49211 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
40: Inventory/OP Base
1	812	F49211	UD	145	4	Sales Order Detail File - Tag File	Extra Features Files	42: Sales Management	AS400 Coexistence Tables

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 UDDOCO, UDDCTO, UDKCOO, UDLNID, UDVMCU, UDTRP, UDLOAD, UDDSGP, UDBPFG, UDDSTN, UDUM, UDDEFF, UDDUNC, UDFDUC, UDDREV, UDFDRV, UDANUM, UDSIDT, UDINCY, UDLDDT, UDLDTM, UDDCDT, UDPCQY, UDUOMC, UDTEMP, UDSTPU, UDDNTY, UDDNTP, UDDETP, UDDTPU, UDVCF, UDPRAS, UDCP01, UDIQTY, UDSTUM, UDBUM6, UDAMBR, UDBUM3, UDWGTR, UDBUM5, UDFRTV, UDFRTD, UDFRCC, UDFRVC, UDPVEH, UDRLNO, UDMCUR, UDFLTN, UDDSNN, UDARCT, UDSORG, UDELTM, UDPTNR, UDIAN8, UDPTC, UDDOC, UDDCT, UDKCO, UDCRR, UDCRCD, UDTXA1, UDEXR1, UDFRDM, UDFUPT, UDRINO, UDGLOC, UDAUTA, UDALPH, UDMET1, UDOPN1, UDPNR1, UDMET2, UDOPN2, UDPNR2, UDMET3, UDOPN3, UDPNR3, UDARDT, UDARTM, UDDPDT, UDDETM, UDDSTJ, UDSTM, UDEND, UDETM, UDTV01, UDTV02, UDTV03, UDTV04, UDTV05, UDTVCD, UDTVQT, UDTVDT, UDTVUM, UDUSER, UDPID, UDJOBN, UDUPMJ, UDTDAY, UDSBCK, UDEDCK, UDCMDM, UDBBCK, UDRQSJ, UDPSDJ, UDADLJ, UDSUB, UDSTTS, UDRATT, UDFUF1, UDFRTC, UDFRAT, UDAFT, UDOMCU, UDOBJ, UDLT, UDFAPP, UDDSPR, UDDSFT, UDDMT1, UDDMS1, UDCOT, UDCMGL, UDBALU, UDAPOT, UDACGD, UDANI, UDAID, UDOPOL, UDOPBO, UDOPID, UDOPCS, UDOPLL, UDOPMS, UDOPSS, UDOPBA, UDFXSR, UDOPMG, UDOPSG, UDOPYN, UDOPSU, UDPSJOBNO, UDJOBSQ, UDCARDNO, UDDELBATCH FROM F49211

TOP 812 | 40 | F49211 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	UDDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
2	UDDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
3	UDKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
4	UDLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
5	UDVMCU	Depot - Trip	String	Generic Edit	12	0	Allow NULL?
6	UDTRP	Trip Number	Numeric	Generic Edit	8	0	Allow NULL?
7	UDLOAD	Date - Scheduled Load	Date	Generic Edit	6	0
8	UDDSGP	Dispatch Group	String	UDC (41B DG)	3	0	Allow NULL?
9	UDBPFG	Bulk/Packed Flag	Character	UDC (41B BF)	1	0	Allow NULL?
10	UDDSTN	Distance	Numeric	Generic Edit	5	0	Allow NULL?
11	UDUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
12	UDDEFF	Deferred Entries Flag	Character	Generic Edit	1	0	Allow NULL?
13	UDDUNC	Amount - Deferred Cost	Numeric	Generic Edit	15	4	Allow NULL?
14	UDFDUC	Amount - Foreign Deferred Cost	Numeric	Generic Edit	15	4	Allow NULL?
15	UDDREV	Amount - Deferred Revenue	Numeric	Generic Edit	15	4	Allow NULL?
16	UDFDRV	Amount - Foreign Deferred Revenue	Numeric	Generic Edit	15	4	Allow NULL?
17	UDANUM	Number - AAI Table Number	Numeric	Generic Edit	4	0	Allow NULL?
18	UDSIDT	Scheduled Invoice Date	Date	Generic Edit	6	0
19	UDINCY	Invoice Cycle Code	String	UDC (40 CY)	3	0	Allow NULL?
20	UDLDDT	Load Confirm Date	Date	Generic Edit	6	0
21	UDLDTM	Time - Load	Numeric	Generic Edit	6	0	Allow NULL?
22	UDDCDT	Delivery Confirm Date	Date	Generic Edit	6	0
23	UDPCQY	Units - Primary Committed Quantity	Numeric	Generic Edit	15	2	Allow NULL?
24	UDUOMC	Unit of Measure - Committed Quantity	String	UDC (00 UM)	2	0	Allow NULL?
25	UDTEMP	Temperature	Numeric	Generic Edit	7	2	Allow NULL?
26	UDSTPU	Temperature Type	Character	UDC (41B TP)	1	0	Allow NULL?
27	UDDNTY	Density	Numeric	Generic Edit	7	2	Allow NULL?
28	UDDNTP	Density Type - At Standard Temperature	Character	UDC (41B DT)	1	0	Allow NULL?
29	UDDETP	Density Temperature	Numeric	Generic Edit	7	2	Allow NULL?
30	UDDTPU	Temperature Type	Character	UDC (41B TP)	1	0	Allow NULL?
31	UDVCF	Volume Correction Factor	Numeric	Generic Edit	7	4	Allow NULL?
32	UDPRAS	Price at Ambient/Standard/Weight (A S W)	Character	UDC (38 PR)	1	0	Allow NULL?
33	UDCP01	Sales Price Based On Date	Character	UDC (40 DB)	1	0	Allow NULL?
34	UDIQTY	Units - Invoice Quantity	Numeric	Generic Edit	15	2	Allow NULL?
35	UDSTUM	Quantity - Primary Stock Accounting Unit	Numeric	Generic Edit	15	2	Allow NULL?
36	UDBUM6	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
37	UDAMBR	Volume - Ambient	Numeric	Generic Edit	15	2	Allow NULL?
38	UDBUM3	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
39	UDWGTR	Weight Result	Numeric	Generic Edit	15	2	Allow NULL?
40	UDBUM5	Unit of Measure 5	String	UDC (00 UM)	2	0	Allow NULL?
41	UDFRTV	Supplier Freight Calculated	Character	Generic Edit	1	0	Allow NULL?
42	UDFRTD	Customer Freight Calculated	Character	Generic Edit	1	0	Allow NULL?
43	UDFRCC	Amount - Customer Freight Charge	Numeric	Generic Edit	15	4	Allow NULL?
44	UDFRVC	Amount - Supplier Freight Charge	Numeric	Generic Edit	15	4	Allow NULL?
45	UDPVEH	Primary Vehicle Id	String	Generic Edit	12	0	Allow NULL?
46	UDRLNO	Registration/License Number	String	Generic Edit	13	0	Allow NULL?
47	UDMCUR	Business Unit - A/R Default	String	Generic Edit	12	0	Allow NULL?
48	UDFLTN	Flight Number	String	Generic Edit	8	0	Allow NULL?
49	UDDSNN	Destination	String	Generic Edit	5	0	Allow NULL?
50	UDARCT	Aircraft Type	String	Generic Edit (49 AT)	5	0	Allow NULL?
51	UDSORG	Origin	String	Generic Edit	15	0	Allow NULL?
52	UDELTM	Time - Elapsed	Numeric	Generic Edit	6	0	Allow NULL?
53	UDPTNR	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
54	UDIAN8	Address Number - Bond Issued	Numeric	Generic Edit	8	0	Allow NULL?
55	UDPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
56	UDDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
57	UDDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
58	UDKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
59	UDCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
60	UDCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
61	UDTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
62	UDEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
63	UDFRDM	International/Domestic Flag	Character	Generic Edit	1	0	Allow NULL?
64	UDFUPT	Fueling Port	String	UDC (49 FP)	3	0	Allow NULL?
65	UDRINO	Registration/Identification Number	String	Generic Edit	15	0	Allow NULL?
66	UDGLOC	Delivery Location	String	Generic Edit	15	0	Allow NULL?
67	UDAUTA	Authorization Name	String	Generic Edit	30	0	Allow NULL?
68	UDALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
69	UDMET1	Meter Ticket 1	String	Generic Edit	10	0	Allow NULL?
70	UDOPN1	Units - Beginning Throughput Qty. 1	Numeric	Generic Edit	15	0	Allow NULL?
71	UDPNR1	Closing Reading 1	Numeric	Generic Edit	15	0	Allow NULL?
72	UDMET2	Meter Ticket 2	String	Generic Edit	10	0	Allow NULL?
73	UDOPN2	Units - Beginning Throughput Qty. 2	Numeric	Generic Edit	15	0	Allow NULL?
74	UDPNR2	Closing Reading 2	Numeric	Generic Edit	15	0	Allow NULL?
75	UDMET3	Meter Ticket 3	String	Generic Edit	10	0	Allow NULL?
76	UDOPN3	Units - Beginning Throughput Qty. 3	Numeric	Generic Edit	15	0	Allow NULL?
77	UDPNR3	Closing Reading 3	Numeric	Generic Edit	15	0	Allow NULL?
78	UDARDT	Date - Arrival	Date	Generic Edit	6	0
79	UDARTM	Time - Arrival	Numeric	Generic Edit	6	0	Allow NULL?
80	UDDPDT	Date - Departure	Date	Generic Edit	6	0
81	UDDETM	Time - Departure	Numeric	Generic Edit	6	0	Allow NULL?
82	UDDSTJ	Date - Start Job(Julian)	Date	Generic Edit	6	0
83	UDSTM	Time - Start (HH/MM)	Numeric	Generic Edit	4	0	Allow NULL?
84	UDEND	Date - Ending	Date	Generic Edit	6	0
85	UDETM	Time - End (HH/MM)	Numeric	Generic Edit	4	0	Allow NULL?
86	UDTV01	Sales Detail Line Origin	Character	Generic Edit	1	0	Allow NULL?
87	UDTV02	Future Use 02	Character	Generic Edit	1	0	Allow NULL?
88	UDTV03	Future Use 03	Character	Generic Edit	1	0	Allow NULL?
89	UDTV04	Future Use 04	Character	Generic Edit	1	0	Allow NULL?
90	UDTV05	Future Use 05	Character	Generic Edit	1	0	Allow NULL?
91	UDTVCD	Future Use Code	String	Generic Edit	2	0	Allow NULL?
92	UDTVQT	Future Use Quantity	Numeric	Generic Edit	15	0	Allow NULL?
93	UDTVDT	Future Use Date	Date	Generic Edit	6	0
94	UDTVUM	Future Use Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
95	UDUSER	User ID	String	Generic Edit	10	0	Allow NULL?
96	UDPID	Program ID	String	Generic Edit	10	0	Allow NULL?
97	UDJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
98	UDUPMJ	Date - Updated	Date	Generic Edit	6	0
99	UDTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
100	UDSBCK	Check Sell By Date	Character	Generic Edit	1	0	Allow NULL?
101	UDEDCK	Check Expiration Date	Character	Generic Edit	1	0	Allow NULL?
102	UDCMDM	Commitment Date Method	Character	UDC (H40 CD)	1	0	Allow NULL?
103	UDBBCK	Check Best Before Date	Character	Generic Edit	1	0	Allow NULL?
104	UDRQSJ	Date - Requested Ship	Date	Generic Edit	6	0
105	UDPSDJ	Date - Future Date 2	Date	Generic Edit	6	0
106	UDADLJ	Date - Actual Delivery	Date	Generic Edit	6	0
107	UDSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
108	UDSTTS	Line Status	String	Generic Edit	2	0	Allow NULL?
109	UDRATT	Rate Type - Freight/Misc	Character	Generic Edit	1	0	Allow NULL?
110	UDFUF1	AIA Document Flag	Character	UDC (H40 FU)	1	0	Allow NULL?
111	UDFRTC	Freight Calculated (Y/N)	Character	Generic Edit	1	0	Allow NULL?
112	UDFRAT	Rate Code - Frieght/Misc	String	UDC (41 RT)	10	0	Allow NULL?
113	UDAFT	Apply Freight - Y/N	Character	Generic Edit	1	0	Allow NULL?
114	UDOMCU	Project Business Unit	String	Generic Edit	12	0	Allow NULL?
115	UDOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
116	UDLT	Ledger Types	String	UDC (09 LT)	2	0	Allow NULL?
117	UDFAPP	Discount Application Type	Character	Generic Edit	1	0	Allow NULL?
118	UDDSPR	Discount Factor	Numeric	Generic Edit	7	4	Allow NULL?
119	UDDSFT	Discount Factor Type - $ or % (D/P)	Character	UDC (H41 DS)	1	0	Allow NULL?
120	UDDMT1	Agreement Number - Distr. (secondary)	String	Generic Edit	12	0	Allow NULL?
121	UDDMS1	Agreement Supplement - Dist. (Secondary)	Numeric	Generic Edit	3	0	Allow NULL?
122	UDCOT	Conditions of Transport	String	UDC (00 TC)	3	0	Allow NULL?
123	UDCMGL	Commitment Method	Character	UDC (H40 CM)	1	0	Allow NULL?
124	UDBALU	Contract Balances Updated Y/N	Character	Generic Edit	1	0	Allow NULL?
125	UDAPOT	Actual Potency	Numeric	Generic Edit	7	3	Allow NULL?
126	UDACGD	Actual Grade	String	UDC (40 LG)	3	0	Allow NULL?
127	UDANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
128	UDAID	Account ID	String	Generic Edit	8	0	Allow NULL?
129	UDOPOL	OP Original Line Number	Numeric	Generic Edit	6	3	Allow NULL?
130	UDOPBO	OP Business Objective	String	UDC (34A BO)	30	0	Allow NULL?
131	UDOPID	OP Scenario ID	String	Generic Edit	30	0	Allow NULL?
132	UDOPCS	OP Cost	Numeric	Generic Edit	15	4	Allow NULL?
133	UDOPLL	OP Partial Ship Line Items	Character	Generic Edit	1	0	Allow NULL?
134	UDOPMS	OP Allow Multi Source	Character	Generic Edit	1	0	Allow NULL?
135	UDOPSS	OP Allow Substitutes	Character	Generic Edit	1	0	Allow NULL?
136	UDOPBA	OP Allow Backorders	Character	Generic Edit	1	0	Allow NULL?
137	UDFXSR	Fix Source Location	Character	Generic Edit	1	0	Allow NULL?
138	UDOPMG	OP Multi Source Group	String	Generic Edit	30	0	Allow NULL?
139	UDOPSG	OP Shipping Group	String	Generic Edit	30	0	Allow NULL?
140	UDOPYN	OP Promise Line (Y/N)	Character	Generic Edit	1	0	Allow NULL?
141	UDOPSU	OP Allow Split UOM	Character	Generic Edit	1	0	Allow NULL?
142	UDPSJOBNO	Production Sequencing Job Number	String	Generic Edit	15	0	Allow NULL?
143	UDJOBSQ	Job Sequence Number	String	Generic Edit	15	0	Allow NULL?
144	UDCARDNO	Card Number	String	UDC (40R CD)	4	0	Allow NULL?
145	UDDELBATCH	Delivery Batch Number	String	Generic Edit	6	0	Allow NULL?

TOP 812 | 40 | F49211 INDEXES

Number

Description

Order No Order Type A (Primary/Unique)

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	LNID	Line Number	Ascending

Shipment Number

Element	Alias	Description	Sequence
1	PTNR	Shipment Number	Ascending

Order Type

Element	Alias	Description	Sequence
1	DCTO	Order Type	Ascending

CompanyKeyOrderNo

Element	Alias	Description	Sequence
1	KCOO	Order Company (Order Number)	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

145 COLUMNS | 4 INDEXES | 812 | 40 | F49211 TABLE

TOP 812 | 40 | F49211 COLUMNS

TOP 812 | 40 | F49211 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

145 COLUMNS | 4 INDEXES | 812 | 40 | F49211 TABLE

TOP812 | 40 | F49211 COLUMNS

TOP812 | 40 | F49211 INDEXES

TOP 812 | 40 | F49211 COLUMNS

TOP 812 | 40 | F49211 INDEXES