	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 | 3 INDEXES | 910 | 40 | F4201Z1 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
40: Inventory/OP Base
1	910	F4201Z1	SY	145	3	Sales Order Header Unedited Transaction File	Transaction Files	42: Sales Management	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 SYEDUS, SYEDBT, SYEDTN, SYEDLN, SYEDCT, SYTYTN, SYEDFT, SYEDDT, SYDRIN, SYEDDL, SYEDSP, SYPNID, SYTNAC, SYKCOO, SYDOCO, SYDCTO, SYSFXO, SYMCU, SYCO, SYOKCO, SYOORN, SYOCTO, SYRKCO, SYRORN, SYRCTO, SYAN8, SYSHAN, SYPA8, SYDRQJ, SYTRDJ, SYPDDJ, SYOPDJ, SYADDJ, SYCNDJ, SYPEFJ, SYPPDJ, SYVR01, SYVR02, SYDEL1, SYDEL2, SYINMG, SYPTC, SYRYIN, SYASN, SYPRGP, SYTRDC, SYPCRT, SYTXA1, SYEXR1, SYTXCT, SYATXT, SYPRIO, SYBACK, SYSBAL, SYHOLD, SYPLST, SYINVC, SYNTR, SYANBY, SYCARS, SYMOT, SYCOT, SYROUT, SYSTOP, SYZON, SYCNID, SYFRTH, SYAFT, SYFUF1, SYFRTC, SYMORD, SYRCD, SYFUF2, SYOTOT, SYTOTC, SYWUMD, SYVUMD, SYAUTN, SYCACT, SYCEXP, SYSBLI, SYCRMD, SYCRRM, SYCRCD, SYCRR, SYLNGP, SYFAP, SYFCST, SYORBY, SYTKBY, SYURCD, SYURDT, SYURAT, SYURAB, SYURRF, SYUSER, SYPID, SYJOBN, SYUPMJ, SYTDAY, SYIR01, SYIR02, SYIR03, SYIR04, SYIR05, SYVR03, SYSOOR, SYPMDT, SYRSDT, SYPSTM, SYPDTT, SYOPTT, SYDRQT, SYADTM, SYADLJ, SYPBAN, SYITAN, SYFTAN, SYDVAN, SYDOC1, SYDCT4, SYCORD, SYBSC, SYBCRC, SYAUFT, SYAUFI, SYOPBO, SYOPTC, SYOPLD, SYOPBK, SYOPSB, SYOPPS, SYOPPL, SYOPMS, SYOPSS, SYOPBA, SYOPLL, SYPRAN8, SYPRCIDLN, SYOPPID, SYCCIDLN, SYSDATTN, SYSHCCIDLN, SYSPATTN, SYOTIND FROM F4201Z1

TOP 910 | 40 | F4201Z1 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	SYEDUS	EDI - User ID	String	Generic Edit	10	0	Allow NULL?
2	SYEDBT	EDI - Batch Number	String	Generic Edit	15	0	Allow NULL?
3	SYEDTN	EDI - Transaction Number	String	Generic Edit	22	0	Allow NULL?
4	SYEDLN	EDI - Line Number	Numeric	Generic Edit	7	3	Allow NULL?
5	SYEDCT	EDI - Document Type	String	Generic Edit	2	0	Allow NULL?
6	SYTYTN	Type - Transaction	String	UDC (00 TT)	8	0	Allow NULL?
7	SYEDFT	EDI - Translation Format	String	Generic Edit	10	0	Allow NULL?
8	SYEDDT	EDI - Transmission Date	Date	Generic Edit	6	0
9	SYDRIN	Direction Indicator	Character	UDC (00 DN)	1	0	Allow NULL?
10	SYEDDL	EDI - Detail Lines Processed	Numeric	Generic Edit	5	0	Allow NULL?
11	SYEDSP	EDI - Successfully Processed	Character	Generic Edit	1	0	Allow NULL?
12	SYPNID	Trading Partner ID	String	Generic Edit	15	0	Allow NULL?
13	SYTNAC	Transaction Action	String	UDC (00 TA)	2	0	Allow NULL?
14	SYKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
15	SYDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
16	SYDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
17	SYSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
18	SYMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
19	SYCO	Company	String	Generic Edit	5	0	Allow NULL?
20	SYOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
21	SYOORN	Original Order Number	String	Generic Edit	8	0	Allow NULL?
22	SYOCTO	Original Order Type	String	UDC (00 DT)	2	0	Allow NULL?
23	SYRKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
24	SYRORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
25	SYRCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
26	SYAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
27	SYSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
28	SYPA8	Address Number - Parent	Numeric	Generic Edit	8	0	Allow NULL?
29	SYDRQJ	Date - Requested	Date	Generic Edit	6	0
30	SYTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
31	SYPDDJ	Date - Scheduled Pick	Date	Generic Edit	6	0
32	SYOPDJ	Date - Original Promised Delivery	Date	Generic Edit	6	0
33	SYADDJ	Date - Actual Ship Date	Date	Generic Edit	6	0
34	SYCNDJ	Date - Cancel	Date	Generic Edit	6	0
35	SYPEFJ	Date - Price Effective Date	Date	Generic Edit	6	0
36	SYPPDJ	Date - Promised Shipment	Date	Generic Edit	6	0
37	SYVR01	Reference	String	Generic Edit	25	0	Allow NULL?
38	SYVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
39	SYDEL1	Delivery Instructions Line 1	String	Generic Edit	30	0	Allow NULL?
40	SYDEL2	Delivery Instructions Line 2	String	Generic Edit	30	0	Allow NULL?
41	SYINMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
42	SYPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
43	SYRYIN	Payment Instrument	Character	UDC (00 PY)	1	0	Allow NULL?
44	SYASN	Price and Adjustment Schedule	String	UDC (40 AS)	8	0	Allow NULL?
45	SYPRGP	Pricing Group	String	UDC (40 PC)	8	0	Allow NULL?
46	SYTRDC	Discount - Trade	Numeric	Generic Edit	7	3	Allow NULL?
47	SYPCRT	Percent - Retainage	Numeric	Generic Edit	7	3	Allow NULL?
48	SYTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
49	SYEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
50	SYTXCT	Certificate Tax Exemption	String	Generic Edit	20	0	Allow NULL?
51	SYATXT	Associated Text	Character	Generic Edit	1	0	Allow NULL?
52	SYPRIO	Priority - Processing	Character	UDC (H40 PR)	1	0	Allow NULL?
53	SYBACK	Backorders Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
54	SYSBAL	Substitutes Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
55	SYHOLD	Hold Orders Code	String	UDC (42 HC)	2	0	Allow NULL?
56	SYPLST	Price Pick List (Y/N)	Character	Generic Edit	1	0	Allow NULL?
57	SYINVC	Invoice Copies	Numeric	Generic Edit	2	0	Allow NULL?
58	SYNTR	Nature of Transaction	String	UDC (00 NT)	2	0	Allow NULL?
59	SYANBY	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
60	SYCARS	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
61	SYMOT	Mode of Transport	String	UDC (00 TM)	3	0	Allow NULL?
62	SYCOT	Conditions of Transport	String	UDC (00 TC)	3	0	Allow NULL?
63	SYROUT	Route Code	String	UDC (42 RT)	3	0	Allow NULL?
64	SYSTOP	Stop Code	String	UDC (42 SP)	3	0	Allow NULL?
65	SYZON	Zone Number	String	UDC (40 ZN)	3	0	Allow NULL?
66	SYCNID	Container I.D.	String	Generic Edit	20	0	Allow NULL?
67	SYFRTH	Freight Handling Code	String	UDC (42 FR)	3	0	Allow NULL?
68	SYAFT	Apply Freight - Y/N	Character	Generic Edit	1	0	Allow NULL?
69	SYFUF1	AIA Document Flag	Character	UDC (H40 FU)	1	0	Allow NULL?
70	SYFRTC	Freight Calculated (Y/N)	Character	Generic Edit	1	0	Allow NULL?
71	SYMORD	Merge Orders (Y/N)	Character	Generic Edit	1	0	Allow NULL?
72	SYRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
73	SYFUF2	Post Quantities	Character	Generic Edit	1	0	Allow NULL?
74	SYOTOT	Amount - Order Gross	Numeric	Generic Edit	15	2	Allow NULL?
75	SYTOTC	Amount - Total Cost	Numeric	Generic Edit	15	2	Allow NULL?
76	SYWUMD	Unit of Measure - Weight Display	String	UDC (00 UM)	2	0	Allow NULL?
77	SYVUMD	Unit of Measure - Volume Display	String	UDC (00 UM)	2	0	Allow NULL?
78	SYAUTN	Authorization Number - Credit Approval	String	Generic Edit	10	0	Allow NULL?
79	SYCACT	Account Number - Credit/Bank	String	Generic Edit	25	0	Allow NULL?
80	SYCEXP	Date - Expired (Julian)	Date	Generic Edit	6	0
81	SYSBLI	Subledger Inactive Code	Character	UDC (00 SI)	1	0	Allow NULL?
82	SYCRMD	Send Method	Character	UDC (00 SM)	1	0	Allow NULL?
83	SYCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
84	SYCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
85	SYCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
86	SYLNGP	Language	String	UDC (01 LP)	2	0	Allow NULL?
87	SYFAP	Amount - Foreign Open	Numeric	Generic Edit	15	2	Allow NULL?
88	SYFCST	Amount - Foreign Total Cost	Numeric	Generic Edit	15	2	Allow NULL?
89	SYORBY	Ordered By	String	Generic Edit	10	0	Allow NULL?
90	SYTKBY	Order Taken By	String	Generic Edit	10	0	Allow NULL?
91	SYURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
92	SYURDT	User Reserved Date	Date	Generic Edit	6	0
93	SYURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
94	SYURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
95	SYURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
96	SYUSER	User ID	String	Generic Edit	10	0	Allow NULL?
97	SYPID	Program ID	String	Generic Edit	10	0	Allow NULL?
98	SYJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
99	SYUPMJ	Date - Updated	Date	Generic Edit	6	0
100	SYTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
101	SYIR01	Integration Reference 01	String	Generic Edit	30	0	Allow NULL?
102	SYIR02	Integration Reference 02	String	Generic Edit	30	0	Allow NULL?
103	SYIR03	Integration Reference 03	String	Generic Edit	30	0	Allow NULL?
104	SYIR04	Integration Reference 04	String	Generic Edit	30	0	Allow NULL?
105	SYIR05	Integration Reference 05	String	Generic Edit	30	0	Allow NULL?
106	SYVR03	Reference	String	Generic Edit	25	0	Allow NULL?
107	SYSOOR	Source of Order	Integer	Generic Edit	11	0	Allow NULL?
108	SYPMDT	Scheduled Shipment Time	Numeric	Generic Edit	6	0	Allow NULL?
109	SYRSDT	Promised Delivery Time	Numeric	Generic Edit	6	0	Allow NULL?
110	SYPSTM	Time - Future Time 2	Numeric	Generic Edit	6	0	Allow NULL?
111	SYPDTT	Time - Scheduled Pick	Numeric	Generic Edit	6	0	Allow NULL?
112	SYOPTT	Time - Original Promised Delivery	Numeric	Generic Edit	6	0	Allow NULL?
113	SYDRQT	Requested Delivery Time	Numeric	Generic Edit	6	0	Allow NULL?
114	SYADTM	Actual Shipment Time	Numeric	Generic Edit	6	0	Allow NULL?
115	SYADLJ	Date - Actual Delivery	Date	Generic Edit	6	0
116	SYPBAN	Address Number - Paid By	Numeric	Generic Edit	8	0	Allow NULL?
117	SYITAN	Address Number - Invoiced To	Numeric	Generic Edit	8	0	Allow NULL?
118	SYFTAN	Address Number - Forwarded To	Numeric	Generic Edit	8	0	Allow NULL?
119	SYDVAN	Address Number - Deliver To	Numeric	Generic Edit	8	0	Allow NULL?
120	SYDOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
121	SYDCT4	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
122	SYCORD	Change Order Number	Numeric	Generic Edit	3	0	Allow NULL?
123	SYBSC	Buying Segment Code	String	UDC (42B BS)	10	0	Allow NULL?
124	SYBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
125	SYAUFT	Address Number to use for Tax	Character	UDC (42B UA)	1	0	Allow NULL?
126	SYAUFI	Address Number to use for Transportation	Character	UDC (42B UA)	1	0	Allow NULL?
127	SYOPBO	OP Business Objective	String	UDC (34A BO)	30	0	Allow NULL?
128	SYOPTC	OP Total Cost	Numeric	Generic Edit	15	4	Allow NULL?
129	SYOPLD	OP Latest Line Date	Date	Generic Edit	6	0
130	SYOPBK	OP Number of Backorders	Numeric	Generic Edit	15	0	Allow NULL?
131	SYOPSB	OP Number of Substitutes	Numeric	Generic Edit	15	0	Allow NULL?
132	SYOPPS	OP Promised Status	String	Generic Edit	30	0	Allow NULL?
133	SYOPPL	OP Partial Order Shipment	Character	Generic Edit	1	0	Allow NULL?
134	SYOPMS	OP Allow Multi Source	Character	Generic Edit	1	0	Allow NULL?
135	SYOPSS	OP Allow Substitutes	Character	Generic Edit	1	0	Allow NULL?
136	SYOPBA	OP Allow Backorders	Character	Generic Edit	1	0	Allow NULL?
137	SYOPLL	OP Partial Ship Line Items	Character	Generic Edit	1	0	Allow NULL?
138	SYPRAN8	Partner Address Number	Numeric	Generic Edit	8	0	Allow NULL?
139	SYPRCIDLN	Partner Contact Line Number ID	Numeric	Generic Edit	5	0	Allow NULL?
140	SYOPPID	Opportunity Number	Numeric	Generic Edit	15	0	Allow NULL?
141	SYCCIDLN	Customer Contact Line Number ID	Numeric	Generic Edit	5	0	Allow NULL?
142	SYSDATTN	Sold To Attention	String	Generic Edit	50	0	Allow NULL?
143	SYSHCCIDLN	Ship To Cust Contact Line Num ID	Numeric	Generic Edit	5	0	Allow NULL?
144	SYSPATTN	Ship To Attention	String	Generic Edit	50	0	Allow NULL?
145	SYOTIND	Order Type Indicator	Character	Generic Edit	1	0	Allow NULL?

TOP 910 | 40 | F4201Z1 INDEXES

Number

Description

User ID Batch Number + + (Primary/Unique)

Element	Alias	Description	Sequence
1	EDUS	EDI - User ID	Ascending
2	EDBT	EDI - Batch Number	Ascending
3	EDTN	EDI - Transaction Number	Ascending
4	EDLN	EDI - Line Number	Ascending

OpportunityId Order Type Ind

Element	Alias	Description	Sequence
1	OPPID	Opportunity Number	Ascending
2	OTIND	Order Type Indicator	Ascending

Doc Number Doc Type +

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	EDUS	EDI - User ID	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 | 3 INDEXES | 910 | 40 | F4201Z1 TABLE

TOP 910 | 40 | F4201Z1 COLUMNS

TOP 910 | 40 | F4201Z1 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 | 3 INDEXES | 910 | 40 | F4201Z1 TABLE

TOP910 | 40 | F4201Z1 COLUMNS

TOP910 | 40 | F4201Z1 INDEXES

TOP 910 | 40 | F4201Z1 COLUMNS

TOP 910 | 40 | F4201Z1 INDEXES