	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

134 COLUMNS | 2 INDEXES | 920 | 07 | F078510 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
07: Payroll
1	920	F078510	VR	134	2	ADP Quarterly Integrity Report	Files	07: Payroll

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 VRDTCD, VRAN8, VRDTEY, VREMPTYPE, VREV01, VRTARA, VRLTCY, VRVERS, VRTAXX, VRSSN, VRBW01, VRPTAX, VRTT01, VRSS01, VRTT02, VRSS02, VRTT03, VRSS03, VRTT04, VRSS04, VRTT05, VRSS05, VRTT06, VRSS06, VRTT07, VRSS07, VRTT08, VRSS08, VRLCM1, VRTT09, VRSS09, VRTT10, VRSS10, VRTT11, VRSS11, VRTT12, VRSS12, VRTT13, VRSS13, VRTT14, VRSS14, VRTT15, VRSS15, VRTT16, VRSS16, VRLCM2, VRTT17, VRSS17, VRTT18, VRSS18, VRTT19, VRSS19, VRTT20, VRSS20, VRTT21, VRSS21, VRTT22, VRSS22, VRTT23, VRSS23, VRTT24, VRSS24, VRLCM3, VRTT25, VRSS25, VRTT26, VRSS26, VRTT27, VRSS27, VRTT28, VRSS28, VRTT29, VRSS29, VRTT30, VRSS30, VRTT31, VRSS31, VRTT32, VRSS32, VRLCM4, VRTT33, VRSS33, VRTT34, VRSS34, VRTT35, VRSS35, VRTT36, VRSS36, VRTM01, VRSS37, VRTM02, VRSS38, VRTM03, VRSS39, VRTM04, VRSS40, VRLCR1, VRTM05, VRSS41, VRTM06, VRSS42, VRTM07, VRSS43, VRTM08, VRSS44, VRTM09, VRSS45, VRTM10, VRSS46, VRTM11, VRSS47, VRTM12, VRSS48, VRVC01, VREXP01, VRVC02, VREXP02, VRVC03, VREXP03, VRVC04, VREXP04, VRVC05, VREXP05, VRVC06, VREXP06, VRVC07, VREXP07, VRVC08, VREXP08, VRINT01, VRUPMJ, VRUPMT, VRJOBN, VRUSER FROM F078510

TOP 920 | 07 | F078510 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	VRDTCD	Date Code - Payroll	String	UDC (06 DC)	4	0	Allow NULL?
2	VRAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
3	VRDTEY	Date - YR	Numeric	Generic Edit	2	0	Allow NULL?
4	VREMPTYPE	Employee types-940 Quarterly Worksheet	Character	UDC (07 QW)	1	0	Allow NULL?
5	VREV01	J.D. EnterpriseOne Event Point 01	Character	Generic Edit	1	0	Allow NULL?
6	VRTARA	Tax Area (Work)	String	Generic Edit	10	0	Allow NULL?
7	VRLTCY	Local City Code	Numeric	Generic Edit	4	0	Allow NULL?
8	VRVERS	Version History	String	Generic Edit	10	0	Allow NULL?
9	VRTAXX	Tax Identification Number	String	Generic Edit	20	0	Allow NULL?
10	VRSSN	Employee Tax ID	String	Generic Edit	20	0	Allow NULL?
11	VRBW01	Pay - Gross 01	Numeric	Generic Edit	15	2	Allow NULL?
12	VRPTAX	Tax Type	String	UDC (06 TX)	2	0	Allow NULL?
13	VRTT01	Non-Taxable Authority Types 01	String	UDC (06 TX)	2	0	Allow NULL?
14	VRSS01	Amount - State Tax Distribution1	Numeric	Generic Edit	15	2	Allow NULL?
15	VRTT02	Non-Taxable Authority Types 02	String	UDC (06 TX)	2	0	Allow NULL?
16	VRSS02	Amount - State Tax Distribution2	Numeric	Generic Edit	15	2	Allow NULL?
17	VRTT03	Non-Taxable Authority Types 03	String	UDC (06 TX)	2	0	Allow NULL?
18	VRSS03	Amount - State Tax Distribution3	Numeric	Generic Edit	15	2	Allow NULL?
19	VRTT04	Non-Taxable Authority Types 04	String	UDC (06 TX)	2	0	Allow NULL?
20	VRSS04	Amount - State Tax Distribution4	Numeric	Generic Edit	15	2	Allow NULL?
21	VRTT05	Non-Taxable Authority Types 05	String	UDC (06 TX)	2	0	Allow NULL?
22	VRSS05	Amount - State Tax Distribution5	Numeric	Generic Edit	15	2	Allow NULL?
23	VRTT06	Non-Taxable Authority Types 06	String	UDC (06 TX)	2	0	Allow NULL?
24	VRSS06	Amount - State Tax Distribution6	Numeric	Generic Edit	15	2	Allow NULL?
25	VRTT07	Non-Taxable Authority Types 07	String	UDC (06 TX)	2	0	Allow NULL?
26	VRSS07	Amount - State Tax Distribution7	Numeric	Generic Edit	15	2	Allow NULL?
27	VRTT08	Non-Taxable Authority Types 08	String	UDC (06 TX)	2	0	Allow NULL?
28	VRSS08	Amount - State Tax Distribution8	Numeric	Generic Edit	15	2	Allow NULL?
29	VRLCM1	Local Method1	String	Generic Edit	2	0	Allow NULL?
30	VRTT09	Non-Taxable Authority Types 09	String	UDC (06 TX)	2	0	Allow NULL?
31	VRSS09	Amount - State Tax Distribution9	Numeric	Generic Edit	15	2	Allow NULL?
32	VRTT10	Non-Taxable Authority Types 10	String	UDC (06 TX)	2	0	Allow NULL?
33	VRSS10	Amount - State Tax Distribution10	Numeric	Generic Edit	15	2	Allow NULL?
34	VRTT11	Non-Taxable Authority Types 11	String	UDC (06 TX)	2	0	Allow NULL?
35	VRSS11	Amount - State Tax Distribution11	Numeric	Generic Edit	15	2	Allow NULL?
36	VRTT12	Non-Taxable Authority Types 12	String	UDC (06 TX)	2	0	Allow NULL?
37	VRSS12	Amount - State Tax Distribution12	Numeric	Generic Edit	15	2	Allow NULL?
38	VRTT13	Non-Taxable Authority Types 13	String	UDC (06 TX)	2	0	Allow NULL?
39	VRSS13	Amount - State Tax Distribution13	Numeric	Generic Edit	15	2	Allow NULL?
40	VRTT14	Non-Taxable Authority Types 14	String	UDC (06 TX)	2	0	Allow NULL?
41	VRSS14	Amount - State Tax Distribution14	Numeric	Generic Edit	15	2	Allow NULL?
42	VRTT15	Non-Taxable Authority Types 15	String	UDC (06 TX)	2	0	Allow NULL?
43	VRSS15	Amount - State Tax Distribution15	Numeric	Generic Edit	15	2	Allow NULL?
44	VRTT16	Non-Taxable Authority Types 16	String	UDC (06 TX)	2	0	Allow NULL?
45	VRSS16	Amount - State Tax Distribution16	Numeric	Generic Edit	15	2	Allow NULL?
46	VRLCM2	Local Method2	String	Generic Edit	2	0	Allow NULL?
47	VRTT17	Non-Taxable Authority Types 17	String	UDC (06 TX)	2	0	Allow NULL?
48	VRSS17	Amount - State Tax Distribution17	Numeric	Generic Edit	15	2	Allow NULL?
49	VRTT18	Non-Taxable Authority Types 18	String	UDC (06 TX)	2	0	Allow NULL?
50	VRSS18	Amount - State Tax Distribution18	Numeric	Generic Edit	15	2	Allow NULL?
51	VRTT19	Non-Taxable Authority Types 19	String	UDC (06 TX)	2	0	Allow NULL?
52	VRSS19	Amount - State Tax Distribution19	Numeric	Generic Edit	15	2	Allow NULL?
53	VRTT20	Non-Taxable Authority Types 20	String	UDC (06 TX)	2	0	Allow NULL?
54	VRSS20	Amount - State Tax Distribution20	Numeric	Generic Edit	15	2	Allow NULL?
55	VRTT21	Non-Taxable Authority Types 21	String	UDC (06 TX)	2	0	Allow NULL?
56	VRSS21	Amount - State Tax Distribution21	Numeric	Generic Edit	15	2	Allow NULL?
57	VRTT22	Non-Taxable Authority Types 22	String	UDC (06 TX)	2	0	Allow NULL?
58	VRSS22	Amount - State Tax Distribution22	Numeric	Generic Edit	15	2	Allow NULL?
59	VRTT23	Non-Taxable Authority Types 23	String	UDC (06 TX)	2	0	Allow NULL?
60	VRSS23	Amount - State Tax Distribution23	Numeric	Generic Edit	15	2	Allow NULL?
61	VRTT24	Non-Taxable Authority Types 24	String	UDC (06 TX)	2	0	Allow NULL?
62	VRSS24	Amount - State Tax Distribution24	Numeric	Generic Edit	15	2	Allow NULL?
63	VRLCM3	Local Method3	String	Generic Edit	2	0	Allow NULL?
64	VRTT25	Non-Taxable Authority Types 25	String	UDC (06 TX)	2	0	Allow NULL?
65	VRSS25	Amount - State Tax Distribution25	Numeric	Generic Edit	15	2	Allow NULL?
66	VRTT26	Non-Taxable Authority Types 26	String	UDC (06 TX)	2	0	Allow NULL?
67	VRSS26	Amount - State Tax Distribution26	Numeric	Generic Edit	15	2	Allow NULL?
68	VRTT27	Non-Taxable Authority Types 27	String	UDC (06 TX)	2	0	Allow NULL?
69	VRSS27	Amount - State Tax Distribution27	Numeric	Generic Edit	15	2	Allow NULL?
70	VRTT28	Non-Taxable Authority Types 28	String	UDC (06 TX)	2	0	Allow NULL?
71	VRSS28	Amount - State Tax Distribution28	Numeric	Generic Edit	15	2	Allow NULL?
72	VRTT29	Non-Taxable Authority Types 29	String	UDC (06 TX)	2	0	Allow NULL?
73	VRSS29	Amount - State Tax Distribution29	Numeric	Generic Edit	15	2	Allow NULL?
74	VRTT30	Non-Taxable Authority Types 30	String	UDC (06 TX)	2	0	Allow NULL?
75	VRSS30	Amount - State Tax Distribution30	Numeric	Generic Edit	15	2	Allow NULL?
76	VRTT31	Non-Taxable Authority Types 31	String	UDC (06 TX)	2	0	Allow NULL?
77	VRSS31	Amount - State Tax Distribution31	Numeric	Generic Edit	15	2	Allow NULL?
78	VRTT32	Non-Taxable Authority Types 32	String	UDC (06 TX)	2	0	Allow NULL?
79	VRSS32	Amount - State Tax Distribution32	Numeric	Generic Edit	15	2	Allow NULL?
80	VRLCM4	Local Method4	String	Generic Edit	2	0	Allow NULL?
81	VRTT33	Non-Taxable Authority Types 33	String	UDC (06 TX)	2	0	Allow NULL?
82	VRSS33	Amount - State Tax Distribution33	Numeric	Generic Edit	15	2	Allow NULL?
83	VRTT34	Non-Taxable Authority Types 34	String	UDC (06 TX)	2	0	Allow NULL?
84	VRSS34	Amount - State Tax Distribution34	Numeric	Generic Edit	15	2	Allow NULL?
85	VRTT35	Non-Taxable Authority Types 35	String	UDC (06 TX)	2	0	Allow NULL?
86	VRSS35	Amount - State Tax Distribution35	Numeric	Generic Edit	15	2	Allow NULL?
87	VRTT36	Non-Taxable Authority Types 36	String	UDC (06 TX)	2	0	Allow NULL?
88	VRSS36	Amount - State Tax Distribution36	Numeric	Generic Edit	15	2	Allow NULL?
89	VRTM01	Federal Additional Tax Method1	String	Generic Edit	2	0	Allow NULL?
90	VRSS37	Amount - State Tax Distribution37	Numeric	Generic Edit	15	2	Allow NULL?
91	VRTM02	Federal Additional Tax Method2	String	Generic Edit	2	0	Allow NULL?
92	VRSS38	Amount - State Tax Distribution38	Numeric	Generic Edit	15	2	Allow NULL?
93	VRTM03	Federal Additional Tax Method3	String	Generic Edit	2	0	Allow NULL?
94	VRSS39	Amount - State Tax Distribution39	Numeric	Generic Edit	15	2	Allow NULL?
95	VRTM04	Federal Additional Tax Method4	String	Generic Edit	2	0	Allow NULL?
96	VRSS40	Amount - State Tax Distribution40	Numeric	Generic Edit	15	2	Allow NULL?
97	VRLCR1	Local Return Code1	String	Generic Edit	2	0	Allow NULL?
98	VRTM05	Federal Additional Tax Method5	String	Generic Edit	2	0	Allow NULL?
99	VRSS41	Amount - State Tax Distribution41	Numeric	Generic Edit	15	2	Allow NULL?
100	VRTM06	Federal Additional Tax Method6	String	Generic Edit	2	0	Allow NULL?
101	VRSS42	Amount - State Tax Distribution42	Numeric	Generic Edit	15	2	Allow NULL?
102	VRTM07	Federal Additional Tax Method7	String	Generic Edit	2	0	Allow NULL?
103	VRSS43	Amount - State Tax Distribution43	Numeric	Generic Edit	15	2	Allow NULL?
104	VRTM08	Federal Additional Tax Method8	String	Generic Edit	2	0	Allow NULL?
105	VRSS44	Amount - State Tax Distribution44	Numeric	Generic Edit	15	2	Allow NULL?
106	VRTM09	Federal Additional Tax Method9	String	Generic Edit	2	0	Allow NULL?
107	VRSS45	Amount - State Tax Distribution45	Numeric	Generic Edit	15	2	Allow NULL?
108	VRTM10	Federal Additional Tax Method10	String	Generic Edit	2	0	Allow NULL?
109	VRSS46	Amount - State Tax Distribution46	Numeric	Generic Edit	15	2	Allow NULL?
110	VRTM11	Federal Additional Tax Method11	String	Generic Edit	2	0	Allow NULL?
111	VRSS47	Amount - State Tax Distribution47	Numeric	Generic Edit	15	2	Allow NULL?
112	VRTM12	Federal Additional Tax Method12	String	Generic Edit	2	0	Allow NULL?
113	VRSS48	Amount - State Tax Distribution48	Numeric	Generic Edit	15	2	Allow NULL?
114	VRVC01	Federal Additional Tax Return Code1	String	Generic Edit	2	0	Allow NULL?
115	VREXP01	Exemption Amount 1	Numeric	Generic Edit	15	2	Allow NULL?
116	VRVC02	Federal Additional Tax Return Code2	String	Generic Edit	2	0	Allow NULL?
117	VREXP02	Exemption Amount 2	Numeric	Generic Edit	15	2	Allow NULL?
118	VRVC03	Federal Additional Tax Return Code3	String	Generic Edit	2	0	Allow NULL?
119	VREXP03	Exemption Amount 3	Numeric	Generic Edit	15	2	Allow NULL?
120	VRVC04	Federal Additional Tax Return Code4	String	Generic Edit	2	0	Allow NULL?
121	VREXP04	Exemption Amount 4	Numeric	Generic Edit	15	2	Allow NULL?
122	VRVC05	Federal Additional Tax Return Code5	String	Generic Edit	2	0	Allow NULL?
123	VREXP05	Exemption Amount 5	Numeric	Generic Edit	15	2	Allow NULL?
124	VRVC06	Federal Additional Tax Return Code6	String	Generic Edit	2	0	Allow NULL?
125	VREXP06	Exemption Amount 6	Numeric	Generic Edit	15	2	Allow NULL?
126	VRVC07	Federal Additional Tax Return Code7	String	Generic Edit	2	0	Allow NULL?
127	VREXP07	Exemption Amount 7	Numeric	Generic Edit	15	2	Allow NULL?
128	VRVC08	Federal Additional Tax Return Code8	String	Generic Edit	2	0	Allow NULL?
129	VREXP08	Exemption Amount 8	Numeric	Generic Edit	15	2	Allow NULL?
130	VRINT01	Integer01 - EnterpriseOne	Integer	Generic Edit	4	0	Allow NULL?
131	VRUPMJ	Date - Updated	Date	Generic Edit	6	0
132	VRUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
133	VRJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
134	VRUSER	User ID	String	Generic Edit	10	0	Allow NULL?

TOP 920 | 07 | F078510 INDEXES

Number

Description

Primary (Primary/Unique)

Element	Alias	Description	Sequence
1	DTCD	Date Code - Payroll	Ascending
2	AN8	Address Number	Ascending
3	DTEY	Date - YR	Ascending
4	EMPTYPE	Employee types-940 Quarterly Worksheet	Ascending
5	EV01	J.D. EnterpriseOne Event Point 01	Ascending
6	TARA	Tax Area (Work)	Ascending
7	LTCY	Local City Code	Ascending
8	VERS	Version History	Ascending

Batch Version

Element	Alias	Description	Sequence
1	VERS	Version History	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

134 COLUMNS | 2 INDEXES | 920 | 07 | F078510 TABLE

TOP 920 | 07 | F078510 COLUMNS

TOP 920 | 07 | F078510 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

134 COLUMNS | 2 INDEXES | 920 | 07 | F078510 TABLE

TOP920 | 07 | F078510 COLUMNS

TOP920 | 07 | F078510 INDEXES

TOP 920 | 07 | F078510 COLUMNS

TOP 920 | 07 | F078510 INDEXES