	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 | 1 INDEXES | 920 | 07 | F06720 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
07: Payroll
1	920	F06720	JE	220	1	W-2/1099 Processing Control	Extra Features Files	07: Payroll	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 JEVERS, JEDTEY, JEYR, JEPQTR, JEW2TP, JEW2TI, JETAXX, JETIS, JESSDL, JEMDDL, JEPRID, JET1DL, JET2DL, JETAPD, JEMMFI, JEDEVN, JEW2LC, JEW2NF, JEW2PS, JEW2FI, JEW2AW, JEW22S, JEW2AC, JEWBST, JERAST, JEFPST, JEMMST, JECWST, JECCST, JEST17, JEW2S, JEW2CS, JEW3S, JEW3CS, JER2S, JER2CS, JER3S, JER3CS, JEM99S, JER99S, JES96S, JESEQC, JEPA8, JEAN8T, JEAN8N, JEWAN8, JEAN8D, JEW2P1, JEW2P2, JEW2P3, JEW2P4, JEW2P5, JEW2P6, JEW2P7, JEW2P8, JEW2P9, JEW2P0, JEW201, JEW202, JEW203, JEW204, JEW205, JEW206, JEW207, JEW208, JEW209, JEW210, JEW211, JEW212, JEW213, JEW214, JEW215, JEW216, JEW217, JEW218, JEW219, JEW220, JEW221, JEW222, JEW223, JEW224, JEW225, JEW226, JEW227, JEW228, JEW229, JEW230, JEW231, JEW232, JEW233, JEW234, JEW235, JEW236, JEW237, JEW238, JEW239, JEW240, JEW241, JEW242, JEW243, JEW244, JEW245, JEW246, JEW247, JEW248, JEW249, JEW250, JEW251, JEW252, JEW253, JEW254, JEW255, JEW256, JEW257, JEW258, JEW259, JEW260, JEHC01, JEHC02, JEHC03, JEHC04, JEHC05, JEHC06, JEHC07, JEHC08, JEHC09, JEHC10, JEEE01, JEEE02, JEEE03, JEEE04, JEEE05, JEEE06, JEEE07, JEEE08, JEEE09, JEEE10, JEEE11, JEEE12, JEEE13, JEEE14, JEEE15, JEEE16, JEEE17, JEEE18, JEEE19, JEEE20, JEEE21, JEEE22, JEEE23, JEEE24, JEEE25, JEEE26, JEEE27, JEEE28, JEEE29, JEEE30, JEEE31, JEEE32, JEEE33, JEEE34, JEEE35, JEEE36, JEEE37, JEEE38, JEEE39, JEEE40, JEEE41, JEEE42, JEEE43, JEEE44, JEEE45, JEEE46, JEEE47, JEEE48, JEEE49, JEEE50, JEOF01, JEOF02, JEOF03, JEOF04, JEOF05, JEOF06, JEOF07, JEOF08, JEOF09, JEOF10, JEOF11, JEOF12, JEOF13, JEOF14, JEOF15, JEOF16, JEOF17, JEOF18, JEOF19, JEOF20, JEW41S, JER241, JEM941, JER941, JEWS01, JEWS02, JEWS03, JEWS04, JEWS05, JEWS06, JEWS07, JEWS08, JEWS09, JEWS10, JEWS11, JEWS12, JEWS13, JEWS14, JEWS15, JERNUM, JEUSER, JEPID, JEUPMJ FROM F06720

TOP 920 | 07 | F06720 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	JEVERS	Version History	String	Generic Edit	10	0	Allow NULL?
2	JEDTEY	Date - YR	Numeric	Generic Edit	2	0	Allow NULL?
3	JEYR	Year - Calendar Year	Numeric	Generic Edit	2	0	Allow NULL?
4	JEPQTR	Quarter	Character	UDC (07 QU)	1	0	Allow NULL?
5	JEW2TP	W2/T4 Workfile Build Processing Types	Character	UDC (06 WP)	1	0	Allow NULL?
6	JEW2TI	Code - W2 Type of Information	Character	UDC	1	0	Allow NULL?
7	JETAXX	Tax Identification Number	String	Generic Edit	20	0	Allow NULL?
8	JETIS	Tax Identification Summation	Character	UDC (05 YN)	1	0	Allow NULL?
9	JESSDL	Limit on FICA Dollars	Numeric	Generic Edit	15	2	Allow NULL?
10	JEMDDL	Limit on MEDICARE Dollars	Numeric	Generic Edit	15	2	Allow NULL?
11	JEPRID	Payroll ID	Numeric	Generic Edit	5	0	Allow NULL?
12	JET1DL	Limit on Tier I Dollars	Numeric	Generic Edit	15	2	Allow NULL?
13	JET2DL	Limit on Tier II Dollars	Numeric	Generic Edit	15	2	Allow NULL?
14	JETAPD	Tape Density	Numeric	UDC (07 TB)	4	0	Allow NULL?
15	JEMMFI	Magnetic Media File Id	String	Generic Edit	10	0	Allow NULL?
16	JEDEVN	Device Name	String	Generic Edit	10	0	Allow NULL?
17	JEW2LC	Copies - Laser	Numeric	Generic Edit	4	0	Allow NULL?
18	JEW2NF	W2 Name Format	Character	Generic Edit	1	0	Allow NULL?
19	JEW2PS	Yes or No - Print Benefit Stmts.	Character	UDC (05 YN)	1	0	Allow NULL?
20	JEW2FI	Yes or No - Print Federal Info.	Character	Generic Edit	1	0	Allow NULL?
21	JEW2AW	Yes or No - Allocate Federal Wage	Character	UDC (05 YN)	1	0	Allow NULL?
22	JEW22S	Yes or No - Print 2 States	Character	UDC (05 YN)	1	0	Allow NULL?
23	JEW2AC	Yes or No - W2 Accelerated Submission	Character	UDC (05 YN)	1	0	Allow NULL?
24	JEWBST	Status - W2 Workfile Build	Character	UDC	1	0	Allow NULL?
25	JERAST	Status - Audit Report	Character	UDC	1	0	Allow NULL?
26	JEFPST	Status - Form Print	Character	UDC	1	0	Allow NULL?
27	JEMMST	Status - Magnetic Media	Character	UDC	1	0	Allow NULL?
28	JECWST	Status - Workfile Clear	Character	UDC	1	0	Allow NULL?
29	JECCST	Status - W2C Workfile Build	Character	Generic Edit	1	0	Allow NULL?
30	JEST17	Status - Benefit Statement	Character	UDC	1	0	Allow NULL?
31	JEW2S	Status - W2 Print	Character	UDC	1	0	Allow NULL?
32	JEW2CS	Status - W2C Print	Character	UDC	1	0	Allow NULL?
33	JEW3S	Status - W3 Print	Character	UDC	1	0	Allow NULL?
34	JEW3CS	Status - W3C Print	Character	UDC	1	0	Allow NULL?
35	JER2S	Status - 499R-2 Form	Character	UDC	1	0	Allow NULL?
36	JER2CS	Status - 499R-2c Form	Character	UDC	1	0	Allow NULL?
37	JER3S	Status - 499R-3 Form	Character	UDC	1	0	Allow NULL?
38	JER3CS	Status - 499R-3c Form	Character	UDC	1	0	Allow NULL?
39	JEM99S	Status - 1099 Misc. Status us	Character	UDC	1	0	Allow NULL?
40	JER99S	Status - 1099 R Status	Character	UDC	1	0	Allow NULL?
41	JES96S	Status - 1096 Status	Character	UDC	1	0	Allow NULL?
42	JESEQC	Sequence Code	Character	UDC (07 SR)	1	0	Allow NULL?
43	JEPA8	Address Number - Parent	Numeric	Generic Edit	8	0	Allow NULL?
44	JEAN8T	Address Number - Transmitter	Numeric	Generic Edit	8	0	Allow NULL?
45	JEAN8N	Address Number - Tape Return	Numeric	Generic Edit	8	0	Allow NULL?
46	JEWAN8	Address Number - Insurance Company	Numeric	Generic Edit	8	0	Allow NULL?
47	JEAN8D	Address Number - Contact Person	Numeric	Generic Edit	8	0	Allow NULL?
48	JEW2P1	Date - Last Printed 1	Date	Generic Edit	6	0
49	JEW2P2	Date - Last Printed 2	Date	Generic Edit	6	0
50	JEW2P3	Date - Last Printed 3	Date	Generic Edit	6	0
51	JEW2P4	Date - Last Printed 4	Date	Generic Edit	6	0
52	JEW2P5	Date - Last Printed 5	Date	Generic Edit	6	0
53	JEW2P6	Date - Last Printed 6	Date	Generic Edit	6	0
54	JEW2P7	Date - Last Printed 7	Date	Generic Edit	6	0
55	JEW2P8	Date - Last Printed 8	Date	Generic Edit	6	0
56	JEW2P9	Date - Last Printed 9	Date	Generic Edit	6	0
57	JEW2P0	Date - Last Printed 0	Date	Generic Edit	6	0
58	JEW201	Included Pay Type Table 01	String	UDC (06 IP)	3	0	Allow NULL?
59	JEW202	Included Pay Type Table 02	String	UDC (06 IP)	3	0	Allow NULL?
60	JEW203	Included Pay Type Table 03	String	UDC (06 IP)	3	0	Allow NULL?
61	JEW204	Included Pay Type Table 04	String	UDC (06 IP)	3	0	Allow NULL?
62	JEW205	Included Pay Type Table 05	String	UDC (06 IP)	3	0	Allow NULL?
63	JEW206	Included Pay Type Table 06	String	UDC (06 IP)	3	0	Allow NULL?
64	JEW207	Included Pay Type Table 07	String	UDC (06 IP)	3	0	Allow NULL?
65	JEW208	Included Pay Type Table 08	String	UDC (06 IP)	3	0	Allow NULL?
66	JEW209	Included Pay Type Table 09	String	UDC (06 IP)	3	0	Allow NULL?
67	JEW210	Included Pay Type Table 10	String	UDC (06 IP)	3	0	Allow NULL?
68	JEW211	Included Pay Type Table 11	String	UDC (06 IP)	3	0	Allow NULL?
69	JEW212	Included Pay Type Table 12	String	UDC (06 IP)	3	0	Allow NULL?
70	JEW213	Included Pay Type Table 13	String	UDC (06 IP)	3	0	Allow NULL?
71	JEW214	Included Pay Type Table 14	String	UDC (06 IP)	3	0	Allow NULL?
72	JEW215	Included Pay Type Table 15	String	UDC (06 IP)	3	0	Allow NULL?
73	JEW216	Included Pay Type Table 16	String	UDC (06 IP)	3	0	Allow NULL?
74	JEW217	Included Pay Type Table 17	String	UDC (06 IP)	3	0	Allow NULL?
75	JEW218	Included Pay Type Table 18	String	UDC (06 IP)	3	0	Allow NULL?
76	JEW219	Included Pay Type Table 19	String	UDC (06 IP)	3	0	Allow NULL?
77	JEW220	Included Pay Type Table 20	String	UDC (06 IP)	3	0	Allow NULL?
78	JEW221	Included Pay Type Table 21	String	UDC (06 IP)	3	0	Allow NULL?
79	JEW222	Included Pay Type Table 22	String	UDC (06 IP)	3	0	Allow NULL?
80	JEW223	Included Pay Type Table 23	String	UDC (06 IP)	3	0	Allow NULL?
81	JEW224	Included Pay Type Table 24	String	UDC (06 IP)	3	0	Allow NULL?
82	JEW225	Included Pay Type Table 25	String	UDC (06 IP)	3	0	Allow NULL?
83	JEW226	Included Pay Type Table 26	String	UDC (06 IP)	3	0	Allow NULL?
84	JEW227	Included Pay Type Table 27	String	UDC (06 IP)	3	0	Allow NULL?
85	JEW228	Included Pay Type Table 28	String	UDC (06 IP)	3	0	Allow NULL?
86	JEW229	Included Pay Type Table 29	String	UDC (06 IP)	3	0	Allow NULL?
87	JEW230	Included Pay Type Table 30	String	UDC (06 IP)	3	0	Allow NULL?
88	JEW231	Included Pay Type Table 31	String	UDC (06 IP)	3	0	Allow NULL?
89	JEW232	Included Pay Type Table 32	String	UDC (06 IP)	3	0	Allow NULL?
90	JEW233	Included Pay Type Table 33	String	UDC (06 IP)	3	0	Allow NULL?
91	JEW234	Included Pay Type Table 34	String	UDC (06 IP)	3	0	Allow NULL?
92	JEW235	Included Pay Type Table 35	String	UDC (06 IP)	3	0	Allow NULL?
93	JEW236	Included Pay Type Table 36	String	UDC (06 IP)	3	0	Allow NULL?
94	JEW237	Included Pay Type Table 37	String	UDC (06 IP)	3	0	Allow NULL?
95	JEW238	Included Pay Type Table 38	String	UDC (06 IP)	3	0	Allow NULL?
96	JEW239	Included Pay Type Table 39	String	UDC (06 IP)	3	0	Allow NULL?
97	JEW240	Included Pay Type Table 40	String	UDC (06 IP)	3	0	Allow NULL?
98	JEW241	Included Pay Type Table 41	String	UDC (06 IP)	3	0	Allow NULL?
99	JEW242	Included Pay Type Table 42	String	UDC (06 IP)	3	0	Allow NULL?
100	JEW243	Included Pay Type Table 43	String	UDC (06 IP)	3	0	Allow NULL?
101	JEW244	Included Pay Type Table 44	String	UDC (06 IP)	3	0	Allow NULL?
102	JEW245	Included Pay Type Table 45	String	UDC (06 IP)	3	0	Allow NULL?
103	JEW246	Included Pay Type Table 46	String	UDC (06 IP)	3	0	Allow NULL?
104	JEW247	Included Pay Type Table 47	String	UDC (06 IP)	3	0	Allow NULL?
105	JEW248	Included Pay Type Table 48	String	UDC (06 IP)	3	0	Allow NULL?
106	JEW249	Included Pay Type Table 49	String	UDC (06 IP)	3	0	Allow NULL?
107	JEW250	Included Pay Type Table 50	String	UDC (06 IP)	3	0	Allow NULL?
108	JEW251	Included Pay Type Table 51	String	UDC (06 IP)	3	0	Allow NULL?
109	JEW252	Included Pay Type Table 52	String	UDC (06 IP)	3	0	Allow NULL?
110	JEW253	Included Pay Type Table 53	String	UDC (06 IP)	3	0	Allow NULL?
111	JEW254	Included Pay Type Table 54	String	UDC (06 IP)	3	0	Allow NULL?
112	JEW255	Included Pay Type Table 55	String	UDC (06 IP)	3	0	Allow NULL?
113	JEW256	Included Pay Type Table 56	String	UDC (06 IP)	3	0	Allow NULL?
114	JEW257	Included Pay Type Table 57	String	UDC (06 IP)	3	0	Allow NULL?
115	JEW258	Included Pay Type Table 58	String	UDC (06 IP)	3	0	Allow NULL?
116	JEW259	Included Pay Type Table 59	String	UDC (06 IP)	3	0	Allow NULL?
117	JEW260	Included Pay Type Table 60	String	UDC (06 IP)	3	0	Allow NULL?
118	JEHC01	Company - Home1	String	Generic Edit	5	0	Allow NULL?
119	JEHC02	Company - Home2	String	Generic Edit	5	0	Allow NULL?
120	JEHC03	Company - Home3	String	Generic Edit	5	0	Allow NULL?
121	JEHC04	Company - Home4	String	Generic Edit	5	0	Allow NULL?
122	JEHC05	Company - Home5	String	Generic Edit	5	0	Allow NULL?
123	JEHC06	Company - Home6	String	Generic Edit	5	0	Allow NULL?
124	JEHC07	Company - Home7	String	Generic Edit	5	0	Allow NULL?
125	JEHC08	Company - Home8	String	Generic Edit	5	0	Allow NULL?
126	JEHC09	Company - Home9	String	Generic Edit	5	0	Allow NULL?
127	JEHC10	Company - Home10	String	Generic Edit	5	0	Allow NULL?
128	JEEE01	Address Number - Payroll1	Numeric	Generic Edit	8	0	Allow NULL?
129	JEEE02	Address Number - Payroll2	Numeric	Generic Edit	8	0	Allow NULL?
130	JEEE03	Address Number - Payroll3	Numeric	Generic Edit	8	0	Allow NULL?
131	JEEE04	Address Number - Payroll4	Numeric	Generic Edit	8	0	Allow NULL?
132	JEEE05	Address Number - Payroll5	Numeric	Generic Edit	8	0	Allow NULL?
133	JEEE06	Address Number - Payroll6	Numeric	Generic Edit	8	0	Allow NULL?
134	JEEE07	Address Number - Payroll7	Numeric	Generic Edit	8	0	Allow NULL?
135	JEEE08	Address Number - Payroll8	Numeric	Generic Edit	8	0	Allow NULL?
136	JEEE09	Address Number - Payroll9	Numeric	Generic Edit	8	0	Allow NULL?
137	JEEE10	Address Number - Payroll10	Numeric	Generic Edit	8	0	Allow NULL?
138	JEEE11	Address Number - Payroll11	Numeric	Generic Edit	8	0	Allow NULL?
139	JEEE12	Address Number - Payroll12	Numeric	Generic Edit	8	0	Allow NULL?
140	JEEE13	Address Number - Payroll13	Numeric	Generic Edit	8	0	Allow NULL?
141	JEEE14	Address Number - Payroll14	Numeric	Generic Edit	8	0	Allow NULL?
142	JEEE15	Address Number - Payroll15	Numeric	Generic Edit	8	0	Allow NULL?
143	JEEE16	Address Number - Payroll16	Numeric	Generic Edit	8	0	Allow NULL?
144	JEEE17	Address Number - Payroll17	Numeric	Generic Edit	8	0	Allow NULL?
145	JEEE18	Address Number - Payroll18	Numeric	Generic Edit	8	0	Allow NULL?
146	JEEE19	Address Number - Payroll19	Numeric	Generic Edit	8	0	Allow NULL?
147	JEEE20	Address Number - Payroll20	Numeric	Generic Edit	8	0	Allow NULL?
148	JEEE21	Address Number - Payroll21	Numeric	Generic Edit	8	0	Allow NULL?
149	JEEE22	Address Number - Payroll22	Numeric	Generic Edit	8	0	Allow NULL?
150	JEEE23	Address Number - Payroll23	Numeric	Generic Edit	8	0	Allow NULL?
151	JEEE24	Address Number - Payroll24	Numeric	Generic Edit	8	0	Allow NULL?
152	JEEE25	Address Number - Payroll25	Numeric	Generic Edit	8	0	Allow NULL?
153	JEEE26	Address Number - Payroll26	Numeric	Generic Edit	8	0	Allow NULL?
154	JEEE27	Address Number - Payroll27	Numeric	Generic Edit	8	0	Allow NULL?
155	JEEE28	Address Number - Payroll28	Numeric	Generic Edit	8	0	Allow NULL?
156	JEEE29	Address Number - Payroll29	Numeric	Generic Edit	8	0	Allow NULL?
157	JEEE30	Address Number - Payroll30	Numeric	Generic Edit	8	0	Allow NULL?
158	JEEE31	Address Number - Payroll31	Numeric	Generic Edit	8	0	Allow NULL?
159	JEEE32	Address Number - Payroll32	Numeric	Generic Edit	8	0	Allow NULL?
160	JEEE33	Address Number - Payroll33	Numeric	Generic Edit	8	0	Allow NULL?
161	JEEE34	Address Number - Payroll34	Numeric	Generic Edit	8	0	Allow NULL?
162	JEEE35	Address Number - Payroll35	Numeric	Generic Edit	8	0	Allow NULL?
163	JEEE36	Address Number - Payroll36	Numeric	Generic Edit	8	0	Allow NULL?
164	JEEE37	Address Number - Payroll37	Numeric	Generic Edit	8	0	Allow NULL?
165	JEEE38	Address Number - Payroll38	Numeric	Generic Edit	8	0	Allow NULL?
166	JEEE39	Address Number - Payroll39	Numeric	Generic Edit	8	0	Allow NULL?
167	JEEE40	Address Number - Payroll40	Numeric	Generic Edit	8	0	Allow NULL?
168	JEEE41	Address Number - Payroll41	Numeric	Generic Edit	8	0	Allow NULL?
169	JEEE42	Address Number - Payroll42	Numeric	Generic Edit	8	0	Allow NULL?
170	JEEE43	Address Number - Payroll43	Numeric	Generic Edit	8	0	Allow NULL?
171	JEEE44	Address Number - Payroll44	Numeric	Generic Edit	8	0	Allow NULL?
172	JEEE45	Address Number - Payroll45	Numeric	Generic Edit	8	0	Allow NULL?
173	JEEE46	Address Number - Payroll46	Numeric	Generic Edit	8	0	Allow NULL?
174	JEEE47	Address Number - Payroll47	Numeric	Generic Edit	8	0	Allow NULL?
175	JEEE48	Address Number - Payroll48	Numeric	Generic Edit	8	0	Allow NULL?
176	JEEE49	Address Number - Payroll49	Numeric	Generic Edit	8	0	Allow NULL?
177	JEEE50	Address Number - Payroll50	Numeric	Generic Edit	8	0	Allow NULL?
178	JEOF01	Option Flag 01	Character	UDC (05 YN)	1	0	Allow NULL?
179	JEOF02	Option Flag 02	Character	UDC (05 YN)	1	0	Allow NULL?
180	JEOF03	Option Flag 03	Character	UDC (05 YN)	1	0	Allow NULL?
181	JEOF04	Option Flag 04	Character	UDC (05 YN)	1	0	Allow NULL?
182	JEOF05	Option Flag 05	Character	UDC (05 YN)	1	0	Allow NULL?
183	JEOF06	Option Flag 06	Character	Generic Edit	1	0	Allow NULL?
184	JEOF07	Option Flag 07	Character	Generic Edit	1	0	Allow NULL?
185	JEOF08	Option Flag 08	Character	Generic Edit	1	0	Allow NULL?
186	JEOF09	Option Flag 09	Character	Generic Edit	1	0	Allow NULL?
187	JEOF10	Option Flag 10	Character	Generic Edit	1	0	Allow NULL?
188	JEOF11	Option Flag 11	Character	Generic Edit	1	0	Allow NULL?
189	JEOF12	Option Flag 12	Character	Generic Edit	1	0	Allow NULL?
190	JEOF13	Option Flag 13	Character	Generic Edit	1	0	Allow NULL?
191	JEOF14	Option Flag 14	Character	Generic Edit	1	0	Allow NULL?
192	JEOF15	Option Flag 15	Character	Generic Edit	1	0	Allow NULL?
193	JEOF16	Option Flag 16	Character	Generic Edit	1	0	Allow NULL?
194	JEOF17	Option Flag 17	Character	Generic Edit	1	0	Allow NULL?
195	JEOF18	Option Flag 18	Character	Generic Edit	1	0	Allow NULL?
196	JEOF19	Option Flag 19	Character	Generic Edit	1	0	Allow NULL?
197	JEOF20	Option Flag 20	Character	Generic Edit	1	0	Allow NULL?
198	JEW41S	Option - Print Sub-Total W2	Character	UDC (05 YN)	1	0	Allow NULL?
199	JER241	Option - Print Sub-Total 499R-2	Character	Generic Edit	1	0	Allow NULL?
200	JEM941	Option - Print Sub-Total 1099M	Character	Generic Edit	1	0	Allow NULL?
201	JER941	Option - Print Sub-Total 1099R	Character	Generic Edit	1	0	Allow NULL?
202	JEWS01	Sequence Code 01	String	UDC (06 SQ)	4	0	Allow NULL?
203	JEWS02	Sequence Code 02	String	UDC (06 SQ)	4	0	Allow NULL?
204	JEWS03	Sequence Code 03	String	UDC (06 SQ)	4	0	Allow NULL?
205	JEWS04	Sequence Code 04	String	UDC (06 SQ)	4	0	Allow NULL?
206	JEWS05	Sequence Code 05	String	UDC (06 SQ)	4	0	Allow NULL?
207	JEWS06	Sequence Code 06	String	UDC (06 SQ)	4	0	Allow NULL?
208	JEWS07	Sequence Code 07	String	UDC (06 SQ)	4	0	Allow NULL?
209	JEWS08	Sequence Code 08	String	UDC (06 SQ)	4	0	Allow NULL?
210	JEWS09	Sequence Code 09	String	UDC (06 SQ)	4	0	Allow NULL?
211	JEWS10	Sequence Code 10	String	UDC (06 SQ)	4	0	Allow NULL?
212	JEWS11	Sequence Code 11	String	UDC (06 SQ)	4	0	Allow NULL?
213	JEWS12	Sequence Code 12	String	UDC (06 SQ)	4	0	Allow NULL?
214	JEWS13	Sequence Code 13	String	UDC (06 SQ)	4	0	Allow NULL?
215	JEWS14	Sequence Code 14	String	UDC (06 SQ)	4	0	Allow NULL?
216	JEWS15	Sequence Code 15	String	UDC (06 SQ)	4	0	Allow NULL?
217	JERNUM	Number of Reports to Run	Numeric	Generic Edit	3	0	Allow NULL?
218	JEUSER	User ID	String	Generic Edit	10	0	Allow NULL?
219	JEPID	Program ID	String	Generic Edit	10	0	Allow NULL?
220	JEUPMJ	Date - Updated	Date	Generic Edit	6	0

TOP 920 | 07 | F06720 INDEXES

Number

Description

PayrollId (Primary/Unique)

Element	Alias	Description	Sequence
1	PRID	Payroll 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

220 COLUMNS | 1 INDEXES | 920 | 07 | F06720 TABLE

TOP 920 | 07 | F06720 COLUMNS

TOP 920 | 07 | F06720 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 | 1 INDEXES | 920 | 07 | F06720 TABLE

TOP920 | 07 | F06720 COLUMNS

TOP920 | 07 | F06720 INDEXES

TOP 920 | 07 | F06720 COLUMNS

TOP 920 | 07 | F06720 INDEXES