	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

254 COLUMNS | 15 INDEXES | 812 | 42 | F4211 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
42: Sales Management
1	812	F4211	SD	254	15	Sales Order Detail File	Transaction 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 SDKCOO, SDDOCO, SDDCTO, SDLNID, SDSFXO, SDMCU, SDCO, SDOKCO, SDOORN, SDOCTO, SDOGNO, SDRKCO, SDRORN, SDRCTO, SDRLLN, SDDMCT, SDDMCS, SDAN8, SDSHAN, SDPA8, SDDRQJ, SDTRDJ, SDPDDJ, SDADDJ, SDIVD, SDCNDJ, SDDGL, SDRSDJ, SDPEFJ, SDPPDJ, SDVR01, SDVR02, SDITM, SDLITM, SDAITM, SDLOCN, SDLOTN, SDFRGD, SDTHGD, SDFRMP, SDTHRP, SDEXDP, SDDSC1, SDDSC2, SDLNTY, SDNXTR, SDLTTR, SDEMCU, SDRLIT, SDKTLN, SDCPNT, SDRKIT, SDKTP, SDSRP1, SDSRP2, SDSRP3, SDSRP4, SDSRP5, SDPRP1, SDPRP2, SDPRP3, SDPRP4, SDPRP5, SDUOM, SDUORG, SDSOQS, SDSOBK, SDSOCN, SDSONE, SDUOPN, SDQTYT, SDQRLV, SDCOMM, SDOTQY, SDUPRC, SDAEXP, SDAOPN, SDPROV, SDTPC, SDAPUM, SDLPRC, SDUNCS, SDECST, SDCSTO, SDTCST, SDINMG, SDPTC, SDRYIN, SDDTBS, SDTRDC, SDFUN2, SDASN, SDPRGR, SDCLVL, SDCADC, SDKCO, SDDOC, SDDCT, SDODOC, SDODCT, SDOKC, SDPSN, SDDELN, SDTAX1, SDTXA1, SDEXR1, SDATXT, SDPRIO, SDRESL, SDBACK, SDSBAL, SDAPTS, SDLOB, SDEUSE, SDDTYS, SDNTR, SDVEND, SDCARS, SDMOT, SDROUT, SDSTOP, SDZON, SDCNID, SDFRTH, SDSHCM, SDSHCN, SDSERN, SDUOM1, SDPQOR, SDUOM2, SDSQOR, SDUOM4, SDITWT, SDWTUM, SDITVL, SDVLUM, SDRPRC, SDORPR, SDORP, SDCMGP, SDGLC, SDCTRY, SDFY, SDSO01, SDSO02, SDSO03, SDSO04, SDSO05, SDSO06, SDSO07, SDSO08, SDSO09, SDSO10, SDSO11, SDSO12, SDSO13, SDSO14, SDSO15, SDACOM, SDCMCG, SDRCD, SDGRWT, SDGWUM, SDSBL, SDSBLT, SDLCOD, SDUPC1, SDUPC2, SDUPC3, SDSWMS, SDUNCD, SDCRMD, SDCRCD, SDCRR, SDFPRC, SDFUP, SDFEA, SDFUC, SDFEC, SDURCD, SDURDT, SDURAT, SDURAB, SDURRF, SDTORG, SDUSER, SDPID, SDJOBN, SDUPMJ, SDTDAY, SDSO16, SDSO17, SDSO18, SDSO19, SDSO20, SDIR01, SDIR02, SDIR03, SDIR04, SDIR05, SDSOOR, SDVR03, SDDEID, SDPSIG, SDRLNU, SDPMDT, SDRLTM, SDRLDJ, SDDRQT, SDADTM, SDOPTT, SDPDTT, SDPSTM, SDXDCK, SDXPTY, SDDUAL, SDBSC, SDCBSC, SDCORD, SDDVAN, SDPEND, SDRFRV, SDMCLN, SDSHPN, SDRSDT, SDPRJM, SDOSEQ, SDMERL, SDHOLD, SDHDBU, SDDMBU, SDBCRC, SDODLN, SDOPDJ, SDXKCO, SDXORN, SDXCTO, SDXLLN, SDXSFX, SDPOE, SDPMTO, SDANBY, SDPMTN, SDNUMB, SDAAID, SDSPATTN, SDPRAN8, SDPRCIDLN, SDCCIDLN, SDSHCCIDLN, SDOPPID, SDOSTP, SDUKID, SDCATNM FROM F4211

TOP 812 | 42 | F4211 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	SDKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
2	SDDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
3	SDDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
4	SDLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
5	SDSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
6	SDMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
7	SDCO	Company	String	Generic Edit	5	0	Allow NULL?
8	SDOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
9	SDOORN	Original Order Number	String	Generic Edit	8	0	Allow NULL?
10	SDOCTO	Original Order Type	String	UDC (00 DT)	2	0	Allow NULL?
11	SDOGNO	Original Line Number	Numeric	Generic Edit	7	3	Allow NULL?
12	SDRKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
13	SDRORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
14	SDRCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
15	SDRLLN	Related PO/SO Line Number	Numeric	Generic Edit	7	3	Allow NULL?
16	SDDMCT	Agreement Number - Distribution	String	Generic Edit	12	0	Allow NULL?
17	SDDMCS	Agreement Supplement - Distribution	Numeric	Generic Edit	3	0	Allow NULL?
18	SDAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
19	SDSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
20	SDPA8	Address Number - Parent	Numeric	Generic Edit	8	0	Allow NULL?
21	SDDRQJ	Date - Requested	Date	Generic Edit	6	0
22	SDTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
23	SDPDDJ	Date - Scheduled Pick	Date	Generic Edit	6	0
24	SDADDJ	Date - Actual Ship Date	Date	Generic Edit	6	0
25	SDIVD	Date - Invoice	Date	Generic Edit	6	0
26	SDCNDJ	Date - Cancel	Date	Generic Edit	6	0
27	SDDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
28	SDRSDJ	Date - Promised Delivery	Date	Generic Edit	6	0
29	SDPEFJ	Date - Price Effective Date	Date	Generic Edit	6	0
30	SDPPDJ	Date - Promised Shipment	Date	Generic Edit	6	0
31	SDVR01	Reference	String	Generic Edit	25	0	Allow NULL?
32	SDVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
33	SDITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
34	SDLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
35	SDAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
36	SDLOCN	Location	String	Generic Edit	20	0	Allow NULL?
37	SDLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
38	SDFRGD	From Grade	String	UDC (40 LG)	3	0	Allow NULL?
39	SDTHGD	Thru Grade	String	UDC (40 LG)	3	0	Allow NULL?
40	SDFRMP	From Potency	Numeric	Generic Edit	7	3	Allow NULL?
41	SDTHRP	Thru Potency	Numeric	Generic Edit	7	3	Allow NULL?
42	SDEXDP	Days Before Expiration	Numeric	Generic Edit	5	0	Allow NULL?
43	SDDSC1	Description	String	Generic Edit	30	0	Allow NULL?
44	SDDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
45	SDLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
46	SDNXTR	Status Code - Next	String	UDC (40 AT)	3	0	Allow NULL?
47	SDLTTR	Status Code - Last	String	UDC (40 AT)	3	0	Allow NULL?
48	SDEMCU	Business Unit - Header	String	Generic Edit	12	0	Allow NULL?
49	SDRLIT	Item Number - Related (Kit)	String	Generic Edit	8	0	Allow NULL?
50	SDKTLN	Kit Master Line Number	Numeric	Generic Edit	6	3	Allow NULL?
51	SDCPNT	Component Line Number	Numeric	Generic Edit	4	1	Allow NULL?
52	SDRKIT	Related Kit Component	Numeric	Generic Edit	8	0	Allow NULL?
53	SDKTP	Number of Component Per Parent	Numeric	Generic Edit	15	2	Allow NULL?
54	SDSRP1	Sales Rpt 01 - Product Family	String	UDC (41 S1)	3	0	Allow NULL?
55	SDSRP2	Sales Rpt 02 - Family Section	String	UDC (41 S2)	3	0	Allow NULL?
56	SDSRP3	Sales Category Code 3	String	UDC (41 S3)	3	0	Allow NULL?
57	SDSRP4	Sales Category Code 4	String	UDC (41 S4)	3	0	Allow NULL?
58	SDSRP5	Sales Category Code 5	String	UDC (41 S5)	3	0	Allow NULL?
59	SDPRP1	Commodity Class	String	UDC (41 P1)	3	0	Allow NULL?
60	SDPRP2	Commodity Sub Class	String	UDC (41 P2)	3	0	Allow NULL?
61	SDPRP3	Supplier Rebate Code	String	UDC (41 P3)	3	0	Allow NULL?
62	SDPRP4	Master Planning Family	String	UDC (41 P4)	3	0	Allow NULL?
63	SDPRP5	Purchasing Category Code 5	String	UDC (41 P5)	3	0	Allow NULL?
64	SDUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
65	SDUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2	Allow NULL?
66	SDSOQS	Quantity Shipped	Numeric	Generic Edit	15	2	Allow NULL?
67	SDSOBK	Units - Qty Backordered/Held	Numeric	Generic Edit	15	2	Allow NULL?
68	SDSOCN	Units - Quantity Canceled/Scrapped	Numeric	Generic Edit	15	2	Allow NULL?
69	SDSONE	Units - Future Quantity Committed	Numeric	Generic Edit	15	2	Allow NULL?
70	SDUOPN	Units - Open	Numeric	Generic Edit	15	2	Allow NULL?
71	SDQTYT	Units - Shipped to Date	Numeric	Generic Edit	15	2	Allow NULL?
72	SDQRLV	Units - Relieved	Numeric	Generic Edit	15	2	Allow NULL?
73	SDCOMM	Committed (H/S)	Character	UDC (H42 CP)	1	0	Allow NULL?
74	SDOTQY	Other Quantity (1/2)	Character	UDC	1	0	Allow NULL?
75	SDUPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
76	SDAEXP	Amount - Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
77	SDAOPN	Amount - Open	Numeric	Generic Edit	15	2	Allow NULL?
78	SDPROV	Price Override Code	Character	Generic Edit	1	0	Allow NULL?
79	SDTPC	Temporary Price (Y/N)	Character	Generic Edit	1	0	Allow NULL?
80	SDAPUM	Unit of Measure - Entered for Unit Price	String	UDC (00 UM)	2	0	Allow NULL?
81	SDLPRC	Amount - List Price	Numeric	Generic Edit	15	4	Allow NULL?
82	SDUNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
83	SDECST	Amount - Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
84	SDCSTO	Cost Override Code	Character	Generic Edit	1	0	Allow NULL?
85	SDTCST	Extended Cost - Transfer	Numeric	Generic Edit	15	4	Allow NULL?
86	SDINMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
87	SDPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
88	SDRYIN	Payment Instrument	Character	UDC (00 PY)	1	0	Allow NULL?
89	SDDTBS	Based on Date	Character	UDC (42 BD)	1	0	Allow NULL?
90	SDTRDC	Discount - Trade	Numeric	Generic Edit	7	3	Allow NULL?
91	SDFUN2	Trade Discount (Old)	Numeric	Generic Edit	15	4	Allow NULL?
92	SDASN	Price and Adjustment Schedule	String	UDC (40 AS)	8	0	Allow NULL?
93	SDPRGR	Item Price Group	String	UDC (40 PI)	8	0	Allow NULL?
94	SDCLVL	Pricing Category Level	String	Generic Edit	3	0	Allow NULL?
95	SDCADC	Discount % - Cash	Numeric	Generic Edit	7	3	Allow NULL?
96	SDKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
97	SDDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
98	SDDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
99	SDODOC	Document - Original	Numeric	Generic Edit	8	0	Allow NULL?
100	SDODCT	Document Type - Original	String	UDC (00 DT)	2	0	Allow NULL?
101	SDOKC	Document Company - Original	String	Generic Edit	5	0	Allow NULL?
102	SDPSN	Pick Slip Number	Numeric	Generic Edit	8	0	Allow NULL?
103	SDDELN	Delivery Number	Numeric	Generic Edit	8	0	Allow NULL?
104	SDTAX1	Sales Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
105	SDTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
106	SDEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
107	SDATXT	Associated Text	Character	Generic Edit	1	0	Allow NULL?
108	SDPRIO	Priority - Processing	Character	UDC (H40 PR)	1	0	Allow NULL?
109	SDRESL	Printed Code	Character	Generic Edit	1	0	Allow NULL?
110	SDBACK	Backorders Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
111	SDSBAL	Substitutes Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
112	SDAPTS	Partial Line Shipments Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
113	SDLOB	Line of Business	String	UDC (40 LB)	3	0	Allow NULL?
114	SDEUSE	End Use	String	UDC (40 EU)	3	0	Allow NULL?
115	SDDTYS	Duty Status	String	UDC (40 DS)	2	0	Allow NULL?
116	SDNTR	Nature of Transaction	String	UDC (00 NT)	2	0	Allow NULL?
117	SDVEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0	Allow NULL?
118	SDCARS	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
119	SDMOT	Mode of Transport	String	UDC (00 TM)	3	0	Allow NULL?
120	SDROUT	Route Code	String	UDC (42 RT)	3	0	Allow NULL?
121	SDSTOP	Stop Code	String	UDC (42 SP)	3	0	Allow NULL?
122	SDZON	Zone Number	String	UDC (40 ZN)	3	0	Allow NULL?
123	SDCNID	Container I.D.	String	Generic Edit	20	0	Allow NULL?
124	SDFRTH	Freight Handling Code	String	UDC (42 FR)	3	0	Allow NULL?
125	SDSHCM	Shipping Commodity Class	String	UDC (41 E)	3	0	Allow NULL?
126	SDSHCN	Shipping Conditions Code	String	UDC (41 C)	3	0	Allow NULL?
127	SDSERN	Serial Number - Lot	String	Generic Edit	30	0	Allow NULL?
128	SDUOM1	Unit of Measure - Primary	String	UDC (00 UM)	2	0	Allow NULL?
129	SDPQOR	Units - Primary Quantity Ordered	Numeric	Generic Edit	15	2	Allow NULL?
130	SDUOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
131	SDSQOR	Units - Secondary Quantity Ordered	Numeric	Generic Edit	15	2	Allow NULL?
132	SDUOM4	Unit of Measure - Pricing	String	UDC (00 UM)	2	0	Allow NULL?
133	SDITWT	Unit Weight	Numeric	Generic Edit	15	4	Allow NULL?
134	SDWTUM	Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
135	SDITVL	Unit Volume	Numeric	Generic Edit	15	4	Allow NULL?
136	SDVLUM	Volume Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
137	SDRPRC	Reprice (Basket Price) Category	String	UDC (40 PI)	8	0	Allow NULL?
138	SDORPR	Order Reprice Category	String	UDC (40 PI)	8	0	Allow NULL?
139	SDORP	Order Repriced Indicator	Character	Generic Edit	1	0	Allow NULL?
140	SDCMGP	Costing Method - Inventory	String	Generic Edit	2	0	Allow NULL?
141	SDGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
142	SDCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
143	SDFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
144	SDSO01	Inter Branch Sales	Character	Generic Edit	1	0	Allow NULL?
145	SDSO02	On Hand Updated	Character	Generic Edit	1	0	Allow NULL?
146	SDSO03	Configurator Print Flag	Character	Generic Edit	1	0	Allow NULL?
147	SDSO04	Sales Order Status 04	Character	Generic Edit	1	0	Allow NULL?
148	SDSO05	Substitute Item Indicator	Character	Generic Edit	1	0	Allow NULL?
149	SDSO06	Preference Commitment Indicator	Character	Generic Edit	1	0	Allow NULL?
150	SDSO07	Ship date (PDDJ) overridden	Character	Generic Edit	1	0	Allow NULL?
151	SDSO08	Price Adjustment Line Indicator	Character	Generic Edit	1	0	Allow NULL?
152	SDSO09	Price Adj. History Indicator	Character	Generic Edit	1	0	Allow NULL?
153	SDSO10	Preference Production Allocation	Character	Generic Edit	1	0	Allow NULL?
154	SDSO11	Transfer/Direct Ship/Intercompany Flag	Character	Generic Edit	1	0	Allow NULL?
155	SDSO12	Deferred entries flag	Character	Generic Edit	1	0	Allow NULL?
156	SDSO13	Euro Conversion Status Flag	Character	Generic Edit	1	0	Allow NULL?
157	SDSO14	Sales Order Status 14	Character	Generic Edit	1	0	Allow NULL?
158	SDSO15	Sales Order Status 15	Character	Generic Edit	1	0	Allow NULL?
159	SDACOM	Apply Commission (Y/N)	Character	Generic Edit	1	0	Allow NULL?
160	SDCMCG	Commission Category	String	Generic Edit	8	0	Allow NULL?
161	SDRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
162	SDGRWT	Gross Weight	Numeric	Generic Edit	15	4	Allow NULL?
163	SDGWUM	Gross Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
164	SDSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
165	SDSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
166	SDLCOD	Code - Location Tax Status	String	UDC (46 LT)	2	0	Allow NULL?
167	SDUPC1	Price Code 1	String	UDC (40 P1)	2	0	Allow NULL?
168	SDUPC2	Price Code 2	String	UDC (40 P2)	2	0	Allow NULL?
169	SDUPC3	Price Code 3	String	UDC (40 P3)	2	0	Allow NULL?
170	SDSWMS	Status - In Warehouse	Character	Generic Edit	1	0	Allow NULL?
171	SDUNCD	Work Order Freeze Code	Character	UDC (H00 UN)	1	0	Allow NULL?
172	SDCRMD	Send Method	Character	UDC (00 SM)	1	0	Allow NULL?
173	SDCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
174	SDCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
175	SDFPRC	Amount - List Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
176	SDFUP	Amount - Foreign Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
177	SDFEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
178	SDFUC	Amount - Foreign Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
179	SDFEC	Amount - Foreign Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
180	SDURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
181	SDURDT	User Reserved Date	Date	Generic Edit	6	0
182	SDURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
183	SDURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
184	SDURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
185	SDTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
186	SDUSER	User ID	String	Generic Edit	10	0	Allow NULL?
187	SDPID	Program ID	String	Generic Edit	10	0	Allow NULL?
188	SDJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
189	SDUPMJ	Date - Updated	Date	Generic Edit	6	0
190	SDTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
191	SDSO16	Manufacturing Variance Accounting Flag	Character	Generic Edit	1	0	Allow NULL?
192	SDSO17	Sales Order Status 17	Character	Generic Edit	1	0	Allow NULL?
193	SDSO18	Sales Order Status 18	Character	Generic Edit	1	0	Allow NULL?
194	SDSO19	Sales Order Status 19	Character	Generic Edit	1	0	Allow NULL?
195	SDSO20	Sales Order Status 20	Character	Generic Edit	1	0	Allow NULL?
196	SDIR01	Integration Reference 01	String	Generic Edit	30	0	Allow NULL?
197	SDIR02	Integration Reference 02	String	Generic Edit	30	0	Allow NULL?
198	SDIR03	Integration Reference 03	String	Generic Edit	30	0	Allow NULL?
199	SDIR04	Integration Reference 04	String	Generic Edit	30	0	Allow NULL?
200	SDIR05	Integration Reference 05	String	Generic Edit	30	0	Allow NULL?
201	SDSOOR	Source of Order	Integer	Generic Edit	11	0	Allow NULL?
202	SDVR03	Reference	String	Generic Edit	25	0	Allow NULL?
203	SDDEID	Demand Unique Key ID	Numeric	Generic Edit	15	0	Allow NULL?
204	SDPSIG	Pull Signal	String	Generic Edit	30	0	Allow NULL?
205	SDRLNU	Release Number	String	Generic Edit	10	0	Allow NULL?
206	SDPMDT	Scheduled Shipment Time	Numeric	Generic Edit	6	0	Allow NULL?
207	SDRLTM	Time - Release	Numeric	Generic Edit	6	0	Allow NULL?
208	SDRLDJ	Date - Release	Date	Generic Edit	6	0
209	SDDRQT	Requested Delivery Time	Numeric	Generic Edit	6	0	Allow NULL?
210	SDADTM	Actual Shipment Time	Numeric	Generic Edit	6	0	Allow NULL?
211	SDOPTT	Time - Original Promised Delivery	Numeric	Generic Edit	6	0	Allow NULL?
212	SDPDTT	Time - Scheduled Pick	Numeric	Generic Edit	6	0	Allow NULL?
213	SDPSTM	Time - Future Time 2	Numeric	Generic Edit	6	0	Allow NULL?
214	SDXDCK	Cross-Docking Flag	Character	Generic Edit	1	0	Allow NULL?
215	SDXPTY	Cross Docking Priority for Sales Orders	Numeric	Generic Edit	15	0	Allow NULL?
216	SDDUAL	Dual Unit Of Measure Item	Character	Generic Edit	1	0	Allow NULL?
217	SDBSC	Buying Segment Code	String	UDC (42B BS)	10	0	Allow NULL?
218	SDCBSC	Current Buying Segment Code	String	UDC (42B BS)	10	0	Allow NULL?
219	SDCORD	Change Order Number	Numeric	Generic Edit	3	0	Allow NULL?
220	SDDVAN	Address Number - Deliver To	Numeric	Generic Edit	8	0	Allow NULL?
221	SDPEND	Pending Approval Flag	Character	Generic Edit	1	0	Allow NULL?
222	SDRFRV	Revision Reason	String	UDC (42 RR)	3	0	Allow NULL?
223	SDMCLN	Matrix Control Line Number	Numeric	Generic Edit	6	3	Allow NULL?
224	SDSHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
225	SDRSDT	Promised Delivery Time	Numeric	Generic Edit	6	0	Allow NULL?
226	SDPRJM	Project Number	Numeric	Generic Edit	8	0	Allow NULL?
227	SDOSEQ	Sequence Number	Numeric	Generic Edit	4	0	Allow NULL?
228	SDMERL	Item Revision Level	String	Generic Edit	3	0	Allow NULL?
229	SDHOLD	Hold Orders Code	String	UDC (42 HC)	2	0	Allow NULL?
230	SDHDBU	Business Unit - Header	String	Generic Edit	12	0	Allow NULL?
231	SDDMBU	Business Unit - Demand	String	Generic Edit	12	0	Allow NULL?
232	SDBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
233	SDODLN	Document Line Number - Original	Numeric	Generic Edit	7	3	Allow NULL?
234	SDOPDJ	Date - Original Promised Delivery	Date	Generic Edit	6	0
235	SDXKCO	Cross Dock Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
236	SDXORN	Cross Dock Order No	Numeric	Generic Edit	8	0	Allow NULL?
237	SDXCTO	Cross Dock Order Type	String	UDC (00 DT)	2	0	Allow NULL?
238	SDXLLN	Cross Dock Line Number	Numeric	Generic Edit	6	3	Allow NULL?
239	SDXSFX	Cross Dock Order Suffix	String	Generic Edit	3	0	Allow NULL?
240	SDPOE	Port of Entry or Exit	String	UDC (40 PE)	6	0	Allow NULL?
241	SDPMTO	Payment Terms Override Code	Character	Generic Edit	1	0	Allow NULL?
242	SDANBY	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
243	SDPMTN	Promotion ID	String	Generic Edit	12	0	Allow NULL?
244	SDNUMB	Asset Item Number	Numeric	Generic Edit	8	0	Allow NULL?
245	SDAAID	Parent Number	Numeric	Generic Edit	8	0	Allow NULL?
246	SDSPATTN	Ship To Attention	String	Generic Edit	50	0	Allow NULL?
247	SDPRAN8	Partner Address Number	Numeric	Generic Edit	8	0	Allow NULL?
248	SDPRCIDLN	Partner Contact Line Number ID	Numeric	Generic Edit	5	0	Allow NULL?
249	SDCCIDLN	Customer Contact Line Number ID	Numeric	Generic Edit	5	0	Allow NULL?
250	SDSHCCIDLN	Ship To Cust Contact Line Num ID	Numeric	Generic Edit	5	0	Allow NULL?
251	SDOPPID	Opportunity Number	Numeric	Generic Edit	15	0	Allow NULL?
252	SDOSTP	Organization Structure Type	String	UDC (01 TS)	3	0	Allow NULL?
253	SDUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
254	SDCATNM	Catalog Name	String	Generic Edit	30	0	Allow NULL?

TOP 812 | 42 | F4211 INDEXES

Number

Description

Order Number 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

Order Type Next Status +B

Element	Alias	Description	Sequence
1	DCTO	Order Type	Ascending
2	NXTR	Status Code - Next	Ascending
3	LNTY	Line Type	Ascending

Address Number

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending

Ship To

Element	Alias	Description	Sequence
1	SHAN	Address Number - Ship To	Ascending

Pick Slip Number

Element	Alias	Description	Sequence
1	PSN	Pick Slip Number	Ascending

Short Item Branch

Element	Alias	Description	Sequence
1	ITM	Item Number - Short	Ascending
2	MCU	Business Unit	Ascending
3	PDDJ	Date - Scheduled Pick	Ascending
4	PDTT	Time - Scheduled Pick	Ascending

Address No Short Item +C

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	ITM	Item Number - Short	Ascending
3	UOM	Unit of Measure as Input	Ascending
4	CRCD	Currency Code - From	Ascending
5	OTQY	Other Quantity (1/2)	Ascending
6	DCTO	Order Type	Ascending
7	DOCO	Document (Order No Invoice etc.)	Ascending

ShipmentNumber

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

Short Item Branch +D

Element	Alias	Description	Sequence
1	ITM	Item Number - Short	Ascending
2	MCU	Business Unit	Ascending
3	DRQJ	Date - Requested	Ascending

Original Order No Type Co

Element	Alias	Description	Sequence
1	OORN	Original Order Number	Ascending
2	OCTO	Original Order Type	Ascending
3	OKCO	Document Company (Original Order)	Ascending

Cross Dock Order No Type Co +

Element	Alias	Description	Sequence
1	XORN	Cross Dock Order No	Ascending
2	XCTO	Cross Dock Order Type	Ascending
3	XKCO	Cross Dock Order Company (Order Number)	Ascending
4	XSFX	Cross Dock Order Suffix	Ascending
5	XLLN	Cross Dock Line Number	Ascending
6	XPTY	Cross Docking Priority for Sales Orders	Ascending

Branch Sold To +S

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	AN8	Address Number	Ascending
3	SHAN	Address Number - Ship To	Ascending
4	PPDJ	Date - Promised Shipment	Ascending
5	PMDT	Scheduled Shipment Time	Ascending
6	VR01	Reference	Ascending

Demand ID

Element	Alias	Description	Sequence
1	DEID	Demand Unique Key ID	Ascending

Invoice Number Type Company

Element	Alias	Description	Sequence
1	DOC	Document (Voucher Invoice etc.)	Ascending
2	DCT	Document Type	Ascending
3	KCO	Document Company	Ascending

Order Number Variance

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	SO16	Manufacturing Variance Accounting Flag	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

254 COLUMNS | 15 INDEXES | 812 | 42 | F4211 TABLE

TOP 812 | 42 | F4211 COLUMNS

TOP 812 | 42 | F4211 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

254 COLUMNS | 15 INDEXES | 812 | 42 | F4211 TABLE

TOP812 | 42 | F4211 COLUMNS

TOP812 | 42 | F4211 INDEXES

TOP 812 | 42 | F4211 COLUMNS

TOP 812 | 42 | F4211 INDEXES