	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

220 COLUMNS | 2 INDEXES | 812 | 31 | F4801Z1 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
31: Shop Floor Control
1	812	F4801Z1	SY	220	2	Outbound Work Order Header	Transaction Files	31: Shop Floor Control	No

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, SYDCTO, SYRCD, SYDGL, SYLOTS, SYEXPR, SYLOT1, SYLOT2, SYDOCO, SYSFXO, SYRCTO, SYRORN, SYLNID, SYPTWO, SYPARS, SYTYPS, SYPRTS, SYDL01, SYSTCM, SYCO, SYMCU, SYMMCU, SYLOCN, SYAISL, SYBIN, SYSRST, SYDCG, SYSUB, SYAN8, SYANO, SYANSA, SYANPA, SYANP, SYDPL, SYANT, SYNAN8, SYTRDJ, SYSTRT, SYDRQJ, SYSTRX, SYDAP, SYDAT, SYPPDT, SYWR01, SYWR02, SYWR03, SYWR04, SYWR05, SYWR06, SYWR07, SYWR08, SYWR09, SYWR10, SYVR01, SYVR02, SYAMTO, SYSETC, SYBRT, SYPAYT, SYAMTC, SYHRSO, SYHRSC, SYAMTA, SYHRSA, SYITM, SYAITM, SYLITM, SYNUMB, SYAPID, SYUORG, SYSOBK, SYSOCN, SYSOQS, SYQTYT, SYUOM, SYSHNO, SYPBTM, SYTBM, SYTRT, SYSHTY, SYPEC, SYPPFG, SYBM, SYRTG, SYSPRT, SYUNCD, SYINDC, SYRESC, SYMOH, SYTDT, SYPOU, SYPC, SYLTLV, SYLTCM, SYCTS1, SYLOTN, SYLOTP, SYLOTG, SYRAT1, SYRAT2, SYDCT, SYSBLI, SYRKCO, SYBREV, SYRREV, SYDRWC, SYRTCH, SYPNRQ, SYREAS, SYPHSE, SYXDSP, SYBOMC, SYAAID, SYNTST, SYXRTO, SYESDN, SYACDN, SYSAID, SYMPOS, SYAPRT, SYAMLC, SYAMMC, SYAMOT, SYLBAM, SYMTAM, SYURCD, SYURDT, SYURAT, SYURAB, SYURRF, SYTORG, SYUSER, SYPID, SYJOBN, SYUPMJ, SYTDAY, SYLINE, SYMWDH, SYSHFT, SYSCSP, SYSRCN, SYLEDG, SYCTS4, SYCTS8, SYCTS7, SYAID, SYALSE, SYASID, SYATST, SYBSEQ, SYCHPR, SYCRCD, SYCRCE, SYCRCF, SYD5J, SYD6J, SYDRAW, SYDUAL, SYMPCE, SYMPRC, SYOBJ, SYOTAM, SYPRJM, SYPRRP, SYSHPP, SYSQOR, SYSRKF, SYSRNK, SYSSOQ, SYTRAF, SYUOM2, SYWR11, SYWR12, SYWR13, SYWR14, SYWR15, SYWR16, SYWR17, SYWR18, SYWR19, SYWR20, SYVFWO, SYPMTN, SYSEST, SYSEET, SYDSAVNAME, SYTIMEZONES, SYSEQN, SYPLMR, SYPLLB, SYPLOS, SYBGTC, SYTOEM, SYTOPL, SYPLSA, SYPLSU, SYESSA, SYESSU, SYACSA, SYACSU, SYOACM, SYRACM, SYLOTC, SYHPLF, SYXEVT, SYMCULT, SYWSCHF, SYDFMDP FROM F4801Z1

TOP 812 | 31 | F4801Z1 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	SYDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
15	SYRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
16	SYDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
17	SYLOTS	Lot Status Code	Character	UDC (41 L)	1	0	Allow NULL?
18	SYEXPR	Date - Expired	Date	Generic Edit	6	0
19	SYLOT1	Memo Lot 1	String	Generic Edit	30	0	Allow NULL?
20	SYLOT2	Memo Lot 2	String	Generic Edit	30	0	Allow NULL?
21	SYDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
22	SYSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
23	SYRCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
24	SYRORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
25	SYLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
26	SYPTWO	Peg to Work Order	Numeric	Generic Edit	8	0	Allow NULL?
27	SYPARS	Number - Parent WO Number	String	Generic Edit	8	0	Allow NULL?
28	SYTYPS	Type - W.O.	Character	UDC (00 TY)	1	0	Allow NULL?
29	SYPRTS	Priority - W.O.	Character	UDC (00 PR)	1	0	Allow NULL?
30	SYDL01	Description	String	Generic Edit	30	0	Allow NULL?
31	SYSTCM	Status - Comment	String	Generic Edit	30	0	Allow NULL?
32	SYCO	Company	String	Generic Edit	5	0	Allow NULL?
33	SYMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
34	SYMMCU	Branch	String	Generic Edit	12	0	Allow NULL?
35	SYLOCN	Location	String	Generic Edit	20	0	Allow NULL?
36	SYAISL	Aisle	String	Generic Edit	8	0	Allow NULL?
37	SYBIN	Bin	String	Generic Edit	8	0	Allow NULL?
38	SYSRST	Status Code W.O.	String	UDC (00 SS)	2	0	Allow NULL?
39	SYDCG	Date - Status Changed	Date	Generic Edit	6	0
40	SYSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
41	SYAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
42	SYANO	Address Number - Originator	Numeric	Generic Edit	8	0	Allow NULL?
43	SYANSA	Address Number - Manager	Numeric	Generic Edit	8	0	Allow NULL?
44	SYANPA	Supervisor	Numeric	Generic Edit	8	0	Allow NULL?
45	SYANP	Address Number - Assigned To	Numeric	Generic Edit	8	0	Allow NULL?
46	SYDPL	Date - W.O. Planned Completed	Date	Generic Edit	6	0
47	SYANT	Address Number - Inspector	Numeric	Generic Edit	8	0	Allow NULL?
48	SYNAN8	Next Address Number	Numeric	Generic Edit	8	0	Allow NULL?
49	SYTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
50	SYSTRT	Date - Start (Julian)	Date	Generic Edit	6	0
51	SYDRQJ	Date - Requested	Date	Generic Edit	6	0
52	SYSTRX	Date - Completion (Julian)	Date	Generic Edit	6	0
53	SYDAP	Date - Assigned to	Date	Generic Edit	6	0
54	SYDAT	Date - Assigned to Inspector	Date	Generic Edit	6	0
55	SYPPDT	Date - Paper Printed Date	Date	Generic Edit	6	0
56	SYWR01	Categories - Work Order 01	String	UDC (00 W1)	4	0	Allow NULL?
57	SYWR02	Categories - Work Order 02	String	UDC (00 W2)	3	0	Allow NULL?
58	SYWR03	Categories - Work Order 03	String	UDC (00 W3)	3	0	Allow NULL?
59	SYWR04	Categories - Work Order 04	String	UDC (00 W4)	3	0	Allow NULL?
60	SYWR05	Categories - Work Order 05	String	UDC (00 W5)	3	0	Allow NULL?
61	SYWR06	EnterpriseOne Consulting - Status	String	UDC (00 W6)	3	0	Allow NULL?
62	SYWR07	EnterpriseOne Consulting - Service Type	String	UDC (00 W7)	3	0	Allow NULL?
63	SYWR08	EnterpriseOne Consulting - Skill Type	String	UDC (00 W8)	3	0	Allow NULL?
64	SYWR09	E1 Consulting - Experience Level	String	UDC (00 W9)	3	0	Allow NULL?
65	SYWR10	Categories - Work Order 10	String	UDC (00 W0)	3	0	Allow NULL?
66	SYVR01	Reference	String	Generic Edit	25	0	Allow NULL?
67	SYVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
68	SYAMTO	Amount - Estimated	Numeric	Generic Edit	15	2	Allow NULL?
69	SYSETC	Crew Size	Numeric	Generic Edit	5	1	Allow NULL?
70	SYBRT	Revenue Rate Markup Override	Numeric	Generic Edit	15	2	Allow NULL?
71	SYPAYT	Pay/Deduction/Benefit Type	String	Generic Edit	5	0	Allow NULL?
72	SYAMTC	Amount - Change to Original Dollars	Numeric	Generic Edit	15	2	Allow NULL?
73	SYHRSO	Hours - Estimated	Numeric	Generic Edit	15	2	Allow NULL?
74	SYHRSC	Hours - Change to Original Hours	Numeric	Generic Edit	15	2	Allow NULL?
75	SYAMTA	Amount - Actual	Numeric	Generic Edit	15	2	Allow NULL?
76	SYHRSA	Hours - Actual	Numeric	Generic Edit	15	2	Allow NULL?
77	SYITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
78	SYAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
79	SYLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
80	SYNUMB	Asset Item Number	Numeric	Generic Edit	8	0	Allow NULL?
81	SYAPID	Unit or Tag Number	String	UDC	12	0	Allow NULL?
82	SYUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2	Allow NULL?
83	SYSOBK	Units - Qty Backordered/Held	Numeric	Generic Edit	15	2	Allow NULL?
84	SYSOCN	Units - Quantity Canceled/Scrapped	Numeric	Generic Edit	15	2	Allow NULL?
85	SYSOQS	Quantity Shipped	Numeric	Generic Edit	15	2	Allow NULL?
86	SYQTYT	Units - Shipped to Date	Numeric	Generic Edit	15	2	Allow NULL?
87	SYUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
88	SYSHNO	Message Number	String	Generic Edit	10	0	Allow NULL?
89	SYPBTM	Time - Beginning (HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
90	SYTBM	Type Bill of Material	String	UDC (40 TB)	3	0	Allow NULL?
91	SYTRT	Type of Routing	String	UDC (40 TR)	3	0	Allow NULL?
92	SYSHTY	WO Pick List Printed	Character	UDC (H00 SH)	1	0	Allow NULL?
93	SYPEC	Posting Edit	Character	UDC (H00 PE)	1	0	Allow NULL?
94	SYPPFG	Variance Flag	Character	UDC (H00 PP)	1	0	Allow NULL?
95	SYBM	Bill of Material (N)	Character	Generic Edit	1	0	Allow NULL?
96	SYRTG	Route Sheet (N)	Character	Generic Edit	1	0	Allow NULL?
97	SYSPRT	Work Order Flash Message	Character	UDC (00 WM)	1	0	Allow NULL?
98	SYUNCD	Work Order Freeze Code	Character	UDC (H00 UN)	1	0	Allow NULL?
99	SYINDC	Indented Code	Character	Generic Edit	1	0	Allow NULL?
100	SYRESC	Resequence Code	Numeric	Generic Edit	5	2	Allow NULL?
101	SYMOH	Amount - Miles or Hours (units)	Numeric	Generic Edit	15	2	Allow NULL?
102	SYTDT	Date - Scheduled Tickler	Date	Generic Edit	6	0
103	SYPOU	Amount - Memo Budget Changes	Numeric	Generic Edit	15	2	Allow NULL?
104	SYPC	Percent Complete	Numeric	Generic Edit	5	0	Allow NULL?
105	SYLTLV	Leadtime Level	Numeric	Generic Edit	5	0	Allow NULL?
106	SYLTCM	Leadtime Cumulative	Numeric	Generic Edit	5	0	Allow NULL?
107	SYCTS1	Hours - Unaccounted Direct Labor	Numeric	Generic Edit	15	2	Allow NULL?
108	SYLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
109	SYLOTP	Lot Potency	Numeric	Generic Edit	15	3	Allow NULL?
110	SYLOTG	Lot Grade	String	UDC (40 LG)	3	0	Allow NULL?
111	SYRAT1	Ratio _ Critical Ratio Priority 1	Numeric	Generic Edit	5	2	Allow NULL?
112	SYRAT2	Ratio - Critical Ratio Priority 2	Numeric	Generic Edit	5	2	Allow NULL?
113	SYDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
114	SYSBLI	Subledger Inactive Code	Character	UDC (00 SI)	1	0	Allow NULL?
115	SYRKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
116	SYBREV	Bill Revision Level	String	Generic Edit	3	0	Allow NULL?
117	SYRREV	Routing Revision Level	String	Generic Edit	3	0	Allow NULL?
118	SYDRWC	Drawing Change	Character	Generic Edit	1	0	Allow NULL?
119	SYRTCH	Routing Change	Character	Generic Edit	1	0	Allow NULL?
120	SYPNRQ	New Part Number	Character	Generic Edit	1	0	Allow NULL?
121	SYREAS	Reason for ECO	String	UDC (40 CR)	2	0	Allow NULL?
122	SYPHSE	Phase In	String	UDC (40 PH)	3	0	Allow NULL?
123	SYXDSP	Existing Disposition	String	UDC (40 ED)	3	0	Allow NULL?
124	SYBOMC	BOM Change	Character	Generic Edit	1	0	Allow NULL?
125	SYAAID	Parent Number	Numeric	Generic Edit	8	0	Allow NULL?
126	SYNTST	Next Status - W.O.	String	UDC (00 SS)	2	0	Allow NULL?
127	SYXRTO	Criticality - Work Order	Numeric	Generic Edit	4	0	Allow NULL?
128	SYESDN	Estimated Downtime Hours	Numeric	Generic Edit	5	2	Allow NULL?
129	SYACDN	Actual Downtime Hours	Numeric	Generic Edit	5	2	Allow NULL?
130	SYSAID	Service Address Number	Numeric	Generic Edit	8	0	Allow NULL?
131	SYMPOS	Meter Position	Numeric	Generic Edit	3	0	Allow NULL?
132	SYAPRT	Approval Type	String	UDC (48 AP)	3	0	Allow NULL?
133	SYAMLC	Amount - Estimated Labor	Numeric	Generic Edit	15	2	Allow NULL?
134	SYAMMC	Amount - Estimated Material	Numeric	Generic Edit	15	2	Allow NULL?
135	SYAMOT	Amount - Estimated Other	Numeric	Generic Edit	15	2	Allow NULL?
136	SYLBAM	Amount - Actual Labor	Numeric	Generic Edit	15	2	Allow NULL?
137	SYMTAM	Amount - Actual Material	Numeric	Generic Edit	15	2	Allow NULL?
138	SYURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
139	SYURDT	User Reserved Date	Date	Generic Edit	6	0
140	SYURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
141	SYURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
142	SYURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
143	SYTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
144	SYUSER	User ID	String	Generic Edit	10	0	Allow NULL?
145	SYPID	Program ID	String	Generic Edit	10	0	Allow NULL?
146	SYJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
147	SYUPMJ	Date - Updated	Date	Generic Edit	6	0
148	SYTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
149	SYLINE	Line/Cell Identifier	String	Generic Edit	12	0	Allow NULL?
150	SYMWDH	Month/Week/Day/Shift	Character	UDC (31 RP)	1	0	Allow NULL?
151	SYSHFT	Shift Code	Character	UDC (06 SH)	1	0	Allow NULL?
152	SYSCSP	Schedule Spread	Numeric	Generic Edit	2	0	Allow NULL?
153	SYSRCN	Serialized components	Character	UDC (31 SC)	1	0	Allow NULL?
154	SYLEDG	Cost Method	String	UDC (40 CM)	2	0	Allow NULL?
155	SYCTS4	Amount - Unaccounted Direct Labor	Numeric	Generic Edit	15	2	Allow NULL?
156	SYCTS8	Units - Unaccounted Scrap	Numeric	Generic Edit	15	2	Allow NULL?
157	SYCTS7	Amount - Unaccounted Scrap	Numeric	Generic Edit	15	2	Allow NULL?
158	SYAID	Account ID	String	Generic Edit	8	0	Allow NULL?
159	SYALSE	Alert Sensitive Task	Character	Generic Edit	1	0	Allow NULL?
160	SYASID	Serial Number	String	Generic Edit	25	0	Allow NULL?
161	SYATST	Date - Actual Start (Julian)	Date	Generic Edit	6	0
162	SYBSEQ	Sorszám - Buborék sorszám	Numeric	Generic Edit	5	0	Allow NULL?
163	SYCHPR	Charge Cost to Project Account	Character	Generic Edit	1	0	Allow NULL?
164	SYCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
165	SYCRCE	Currency Code - Source	String	Generic Edit	3	0	Allow NULL?
166	SYCRCF	Currency Code - Origin	String	Generic Edit	3	0	Allow NULL?
167	SYD5J	Date - Other 5	Date	Generic Edit	6	0
168	SYD6J	Date - Other 6	Date	Generic Edit	6	0
169	SYDRAW	Drawing Number	String	Generic Edit	20	0	Allow NULL?
170	SYDUAL	Dual Unit Of Measure Item	Character	Generic Edit	1	0	Allow NULL?
171	SYMPCE	Production Costs Exist	Character	UDC (00 ZO)	1	0	Allow NULL?
172	SYMPRC	Changes to Parts And Routings Allowed	Character	UDC (00 ZO)	1	0	Allow NULL?
173	SYOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
174	SYOTAM	Amount - Actual Other	Numeric	Generic Edit	15	2	Allow NULL?
175	SYPRJM	Project Number	Numeric	Generic Edit	8	0	Allow NULL?
176	SYPRRP	Direct Project Relationship	Character	Generic Edit	1	0	Allow NULL?
177	SYSHPP	Ship This Phase	Character	UDC (00 ZO)	1	0	Allow NULL?
178	SYSQOR	Units - Secondary Quantity Ordered	Numeric	Generic Edit	15	2	Allow NULL?
179	SYSRKF	Shrink Factor Method	Character	UDC (H40 SR)	1	0	Allow NULL?
180	SYSRNK	Shrink Factor	Numeric	Generic Edit	15	2	Allow NULL?
181	SYSSOQ	Secondary Quantity Completed	Numeric	Generic Edit	15	0	Allow NULL?
182	SYTRAF	Resources Assigned	Character	UDC (00 ZO)	1	0	Allow NULL?
183	SYUOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
184	SYWR11	Categories - Work Order 11	String	UDC (00 X1)	3	0	Allow NULL?
185	SYWR12	Categories - Work Order 12	String	UDC (00 X2)	3	0	Allow NULL?
186	SYWR13	Categories - Work Order 13	String	UDC (00 X3)	3	0	Allow NULL?
187	SYWR14	Categories - Work Order 14	String	UDC (00 X4)	3	0	Allow NULL?
188	SYWR15	Categories - Work Order 15	String	UDC (00 X5)	3	0	Allow NULL?
189	SYWR16	Categories - Work Order 16	String	UDC (00 X6)	3	0	Allow NULL?
190	SYWR17	Categories - Work Order 17	String	UDC (00 X7)	3	0	Allow NULL?
191	SYWR18	Categories - Work Order 18	String	UDC (00 X8)	3	0	Allow NULL?
192	SYWR19	Categories - Work Order 19	String	UDC (00 X9)	3	0	Allow NULL?
193	SYWR20	Categories - Work Order 20	String	UDC (00 X0)	3	0	Allow NULL?
194	SYVFWO	Firm Work Order	Character	Generic Edit	1	0	Allow NULL?
195	SYPMTN	Promotion ID	String	Generic Edit	12	0	Allow NULL?
196	SYSEST	Time - Scheduled Start (HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
197	SYSEET	Time - Scheduled End (HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
198	SYDSAVNAME	Daylight Savings Rule Name	String	UDC	10	0	Allow NULL?
199	SYTIMEZONES	Time Zone List	String	UDC (H91 TZ)	2	0	Allow NULL?
200	SYSEQN	Sequence Number	Numeric	Generic Edit	7	0	Allow NULL?
201	SYPLMR	Planned Material	Numeric	Generic Edit	15	2	Allow NULL?
202	SYPLLB	Planned Labor	Numeric	Generic Edit	15	2	Allow NULL?
203	SYPLOS	Planned Other	Numeric	Generic Edit	15	2	Allow NULL?
204	SYBGTC	Budgeted Cost	Numeric	Generic Edit	15	2	Allow NULL?
205	SYTOEM	Total Estimated	Numeric	Generic Edit	15	2	Allow NULL?
206	SYTOPL	Total Planned	Numeric	Generic Edit	15	2	Allow NULL?
207	SYPLSA	Planned Special Amount	Numeric	Generic Edit	15	2	Allow NULL?
208	SYPLSU	Planned Special Units	Numeric	Generic Edit	15	2	Allow NULL?
209	SYESSA	Estimated Special Amount	Numeric	Generic Edit	15	2	Allow NULL?
210	SYESSU	Estimated Special Units	Numeric	Generic Edit	15	2	Allow NULL?
211	SYACSA	Actual Special Amount	Numeric	Generic Edit	15	2	Allow NULL?
212	SYACSU	Actual Special Units	Numeric	Generic Edit	15	2	Allow NULL?
213	SYOACM	Amount Committed - Original	Numeric	Generic Edit	15	2	Allow NULL?
214	SYRACM	Amount Committed - Remaining	Numeric	Generic Edit	15	2	Allow NULL?
215	SYLOTC	Lot Status Code Expanded	String	Generic Edit	3	0	Allow NULL?
216	SYHPLF	Held Parts List Flag	Character	Generic Edit	1	0	Allow NULL?
217	SYXEVT	External Event Flag	Character	Generic Edit	1	0	Allow NULL?
218	SYMCULT	Lead Craft	String	Generic Edit	12	0	Allow NULL?
219	SYWSCHF	Maintenance Schedule Flag	Character	UDC (13 WS)	1	0	Allow NULL?
220	SYDFMDP	DFM Daily Plan	Character	Generic Edit	1	0	Allow NULL?

TOP 812 | 31 | F4801Z1 INDEXES

Number

Description

UserID Batch Transaction +A (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

OrderNo Line Transaction +B

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	EDLN	EDI - Line Number	Ascending
3	TYTN	Type - Transaction	Ascending
4	TNAC	Transaction Action	Ascending
5	DRIN	Direction Indicator	Ascending
6	EDDL	EDI - Detail Lines Processed	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

220 COLUMNS | 2 INDEXES | 812 | 31 | F4801Z1 TABLE

TOP 812 | 31 | F4801Z1 COLUMNS

TOP 812 | 31 | F4801Z1 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

220 COLUMNS | 2 INDEXES | 812 | 31 | F4801Z1 TABLE

TOP812 | 31 | F4801Z1 COLUMNS

TOP812 | 31 | F4801Z1 INDEXES

TOP 812 | 31 | F4801Z1 COLUMNS

TOP 812 | 31 | F4801Z1 INDEXES