	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

134 COLUMNS | 2 INDEXES | 910 | 08 | F080434B TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
08: Human Resources
1	910	F080434B	VE	134	2	Veterans Employment Reporting (VETS 100A)	Files	08: Human Resources

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 VESVER, VEPRNM, VEVRBY, VEWSST, VETPOS, VEDOCP, VECONAME, VECOMNT1, VEOFC, VETSKD1, VESTAC, VECUCD, VENEWVAL, VECOMNT2, VENME, VEWCPL, VECTAX, VENRSD, VECMPC, VEINSTY, VEADDN, VEETAX, VEEE01, VEEE02, VEEE03, VEEE04, VEEE05, VEEE06, VEEE07, VEEE08, VEEE09, VEEE10, VEEE11, VEEE12, VEEE13, VEEE14, VEEE15, VEEE16, VEEE17, VEEE18, VEEE19, VEEE20, VEEE21, VEEE22, VEEE23, VEEE24, VEEE25, VEEE26, VEEE27, VEEE28, VEEE29, VEEE30, VEEE31, VEEE32, VEEE33, VEEE34, VEEE35, VEEE36, VEEE37, VEEE38, VEEE39, VEEE40, VEEE41, VEEE42, VEEE43, VEEE44, VEEE45, VEEE46, VEEE47, VEEE48, VEEE49, VEEE50, VEBN01, VEBN02, VEBN03, VEBN04, VEBN05, VEBN06, VEBN07, VEBN08, VEBN09, VEBN10, VEBN11, VEBN12, VEBN13, VEN001, VEN002, VEN003, VEN004, VEN005, VEN006, VEN007, VEN008, VEN009, VEN010, VEDC01, VEDC02, VEDC03, VEDC04, VEDC05, VEDC06, VEDC07, VEDC08, VEDC09, VEAN8CM01, VEAN8CM02, VEAN8CM03, VEAN8CM04, VEAN8CM05, VEAN8CM06, VEAN8CM07, VEAN8CM08, VEAN8CM09, VEAN8CM10, VEAN8CM11, VEAN8CM12, VEAN8CM13, VEAN8CM14, VEAN8CM15, VEAN8CM16, VEAN8CM17, VEAN8CM18, VEAN8CM19, VEAN8CM20, VEANSM01, VEANSM02, VEANSM03, VEANSM04, VEANSM05, VEANSM06, VEANSM07, VEANSM08, VEANSM09, VEANSM10 FROM F080434B

TOP 910 | 08 | F080434B COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	VESVER	Snapshot Version	String	Generic Edit	10	Allow NULL?
2	VEPRNM	Preferred Name	String	Generic Edit	20	Allow NULL?
3	VEVRBY	Verified By	String	Generic Edit	8	Allow NULL?
4	VEWSST	Work State Supplemental Tax Type	Character	Generic Edit	1	Allow NULL?
5	VETPOS	Position Type	String	Generic Edit	3	Allow NULL?
6	VEDOCP	Document #- Predecessor	Numeric	Generic Edit	8	Allow NULL?
7	VECONAME	Company Name	String	Generic Edit	40	Allow NULL?
8	VECOMNT1	Comment	String	Generic Edit	40	Allow NULL?
9	VEOFC	OfficeNumber	String	Generic Edit	20	Allow NULL?
10	VETSKD1	Short Description	String	Generic Edit	20	Allow NULL?
11	VESTAC	State Return Code	String	Generic Edit	2	Allow NULL?
12	VECUCD	Course Code	String	UDC	10	Allow NULL?
13	VENEWVAL	New Value	String	Generic Edit	20	Allow NULL?
14	VECOMNT2	Comment	String	Generic Edit	40	Allow NULL?
15	VENME	Employee Name	String	Generic Edit	40	Allow NULL?
16	VEWCPL	Workers Comp Policy Number	String	Generic Edit	20	Allow NULL?
17	VECTAX	Tax Identification Number - County	String	Generic Edit	20	Allow NULL?
18	VENRSD	State Residence Status	String	UDC	2	Allow NULL?
19	VECMPC	Competency Code	String	Generic Edit	10	Allow NULL?
20	VEINSTY	Institution Code	String	UDC (05 IC)	10	Allow NULL?
21	VEADDN	Additional Name	String	Generic Edit	20	Allow NULL?
22	VEETAX	Tax Identification Number -Business Unit	String	Generic Edit	20	Allow NULL?
23	VEEE01	Address Number - Payroll1	Numeric	Generic Edit	8	Allow NULL?
24	VEEE02	Address Number - Payroll2	Numeric	Generic Edit	8	Allow NULL?
25	VEEE03	Address Number - Payroll3	Numeric	Generic Edit	8	Allow NULL?
26	VEEE04	Address Number - Payroll4	Numeric	Generic Edit	8	Allow NULL?
27	VEEE05	Address Number - Payroll5	Numeric	Generic Edit	8	Allow NULL?
28	VEEE06	Address Number - Payroll6	Numeric	Generic Edit	8	Allow NULL?
29	VEEE07	Address Number - Payroll7	Numeric	Generic Edit	8	Allow NULL?
30	VEEE08	Address Number - Payroll8	Numeric	Generic Edit	8	Allow NULL?
31	VEEE09	Address Number - Payroll9	Numeric	Generic Edit	8	Allow NULL?
32	VEEE10	Address Number - Payroll10	Numeric	Generic Edit	8	Allow NULL?
33	VEEE11	Address Number - Payroll11	Numeric	Generic Edit	8	Allow NULL?
34	VEEE12	Address Number - Payroll12	Numeric	Generic Edit	8	Allow NULL?
35	VEEE13	Address Number - Payroll13	Numeric	Generic Edit	8	Allow NULL?
36	VEEE14	Address Number - Payroll14	Numeric	Generic Edit	8	Allow NULL?
37	VEEE15	Address Number - Payroll15	Numeric	Generic Edit	8	Allow NULL?
38	VEEE16	Address Number - Payroll16	Numeric	Generic Edit	8	Allow NULL?
39	VEEE17	Address Number - Payroll17	Numeric	Generic Edit	8	Allow NULL?
40	VEEE18	Address Number - Payroll18	Numeric	Generic Edit	8	Allow NULL?
41	VEEE19	Address Number - Payroll19	Numeric	Generic Edit	8	Allow NULL?
42	VEEE20	Address Number - Payroll20	Numeric	Generic Edit	8	Allow NULL?
43	VEEE21	Address Number - Payroll21	Numeric	Generic Edit	8	Allow NULL?
44	VEEE22	Address Number - Payroll22	Numeric	Generic Edit	8	Allow NULL?
45	VEEE23	Address Number - Payroll23	Numeric	Generic Edit	8	Allow NULL?
46	VEEE24	Address Number - Payroll24	Numeric	Generic Edit	8	Allow NULL?
47	VEEE25	Address Number - Payroll25	Numeric	Generic Edit	8	Allow NULL?
48	VEEE26	Address Number - Payroll26	Numeric	Generic Edit	8	Allow NULL?
49	VEEE27	Address Number - Payroll27	Numeric	Generic Edit	8	Allow NULL?
50	VEEE28	Address Number - Payroll28	Numeric	Generic Edit	8	Allow NULL?
51	VEEE29	Address Number - Payroll29	Numeric	Generic Edit	8	Allow NULL?
52	VEEE30	Address Number - Payroll30	Numeric	Generic Edit	8	Allow NULL?
53	VEEE31	Address Number - Payroll31	Numeric	Generic Edit	8	Allow NULL?
54	VEEE32	Address Number - Payroll32	Numeric	Generic Edit	8	Allow NULL?
55	VEEE33	Address Number - Payroll33	Numeric	Generic Edit	8	Allow NULL?
56	VEEE34	Address Number - Payroll34	Numeric	Generic Edit	8	Allow NULL?
57	VEEE35	Address Number - Payroll35	Numeric	Generic Edit	8	Allow NULL?
58	VEEE36	Address Number - Payroll36	Numeric	Generic Edit	8	Allow NULL?
59	VEEE37	Address Number - Payroll37	Numeric	Generic Edit	8	Allow NULL?
60	VEEE38	Address Number - Payroll38	Numeric	Generic Edit	8	Allow NULL?
61	VEEE39	Address Number - Payroll39	Numeric	Generic Edit	8	Allow NULL?
62	VEEE40	Address Number - Payroll40	Numeric	Generic Edit	8	Allow NULL?
63	VEEE41	Address Number - Payroll41	Numeric	Generic Edit	8	Allow NULL?
64	VEEE42	Address Number - Payroll42	Numeric	Generic Edit	8	Allow NULL?
65	VEEE43	Address Number - Payroll43	Numeric	Generic Edit	8	Allow NULL?
66	VEEE44	Address Number - Payroll44	Numeric	Generic Edit	8	Allow NULL?
67	VEEE45	Address Number - Payroll45	Numeric	Generic Edit	8	Allow NULL?
68	VEEE46	Address Number - Payroll46	Numeric	Generic Edit	8	Allow NULL?
69	VEEE47	Address Number - Payroll47	Numeric	Generic Edit	8	Allow NULL?
70	VEEE48	Address Number - Payroll48	Numeric	Generic Edit	8	Allow NULL?
71	VEEE49	Address Number - Payroll49	Numeric	Generic Edit	8	Allow NULL?
72	VEEE50	Address Number - Payroll50	Numeric	Generic Edit	8	Allow NULL?
73	VEBN01	Batch Number	Numeric	Generic Edit	8	Allow NULL?
74	VEBN02	Batch Number	Numeric	Generic Edit	8	Allow NULL?
75	VEBN03	Batch Number	Numeric	Generic Edit	8	Allow NULL?
76	VEBN04	Batch Number	Numeric	Generic Edit	8	Allow NULL?
77	VEBN05	Batch Number	Numeric	Generic Edit	8	Allow NULL?
78	VEBN06	Batch Number	Numeric	Generic Edit	8	Allow NULL?
79	VEBN07	Batch Number	Numeric	Generic Edit	8	Allow NULL?
80	VEBN08	Batch Number	Numeric	Generic Edit	8	Allow NULL?
81	VEBN09	Batch Number	Numeric	Generic Edit	8	Allow NULL?
82	VEBN10	Batch Number	Numeric	Generic Edit	8	Allow NULL?
83	VEBN11	Batch Number	Numeric	Generic Edit	8	Allow NULL?
84	VEBN12	Batch Number	Numeric	Generic Edit	8	Allow NULL?
85	VEBN13	Batch Number	Numeric	Generic Edit	8	Allow NULL?
86	VEN001	Next Number Range 1	Numeric	Generic Edit	8	Allow NULL?
87	VEN002	Next Number Range 2	Numeric	Generic Edit	8	Allow NULL?
88	VEN003	Next Number 003	Numeric	Generic Edit	8	Allow NULL?
89	VEN004	Next Number 004	Numeric	Generic Edit	8	Allow NULL?
90	VEN005	Next Number 005	Numeric	Generic Edit	8	Allow NULL?
91	VEN006	Next Number 006	Numeric	Generic Edit	8	Allow NULL?
92	VEN007	Next Number 007	Numeric	Generic Edit	8	Allow NULL?
93	VEN008	Next Number 008	Numeric	Generic Edit	8	Allow NULL?
94	VEN009	Next Number 009	Numeric	Generic Edit	8	Allow NULL?
95	VEN010	Next Number 010	Numeric	Generic Edit	8	Allow NULL?
96	VEDC01	Order Number - Ship To Location 01	Numeric	Generic Edit	8	Allow NULL?
97	VEDC02	Order Number - Ship To Location 02	Numeric	Generic Edit	8	Allow NULL?
98	VEDC03	Order Number - Ship To Location 03	Numeric	Generic Edit	8	Allow NULL?
99	VEDC04	Order Number - Ship To Location 04	Numeric	Generic Edit	8	Allow NULL?
100	VEDC05	Order Number - Ship To Location 05	Numeric	Generic Edit	8	Allow NULL?
101	VEDC06	Order Number - Ship To Location 06	Numeric	Generic Edit	8	Allow NULL?
102	VEDC07	Order Number - Ship To Location 07	Numeric	Generic Edit	8	Allow NULL?
103	VEDC08	Order Number - Ship To Location 08	Numeric	Generic Edit	8	Allow NULL?
104	VEDC09	Order Number - Ship To Location 09	Numeric	Generic Edit	8	Allow NULL?
105	VEAN8CM01	Address Number - Community 01	Numeric	Generic Edit	8	Allow NULL?
106	VEAN8CM02	Address Number - Community 02	Numeric	Generic Edit	8	Allow NULL?
107	VEAN8CM03	Address Number - Community 03	Numeric	Generic Edit	8	Allow NULL?
108	VEAN8CM04	Address Number - Community 04	Numeric	Generic Edit	8	Allow NULL?
109	VEAN8CM05	Address Number - Community 05	Numeric	Generic Edit	8	Allow NULL?
110	VEAN8CM06	Address Number - Community 06	Numeric	Generic Edit	8	Allow NULL?
111	VEAN8CM07	Address Number - Community 07	Numeric	Generic Edit	8	Allow NULL?
112	VEAN8CM08	Address Number - Community 08	Numeric	Generic Edit	8	Allow NULL?
113	VEAN8CM09	Address Number - Community 09	Numeric	Generic Edit	8	Allow NULL?
114	VEAN8CM10	Address Number - Community 10	Numeric	Generic Edit	8	Allow NULL?
115	VEAN8CM11	Address Number - Community 11	Numeric	Generic Edit	8	Allow NULL?
116	VEAN8CM12	Address Number - Community 12	Numeric	Generic Edit	8	Allow NULL?
117	VEAN8CM13	Address Number - Community 13	Numeric	Generic Edit	8	Allow NULL?
118	VEAN8CM14	Address Number - Community 14	Numeric	Generic Edit	8	Allow NULL?
119	VEAN8CM15	Address Number - Community 15	Numeric	Generic Edit	8	Allow NULL?
120	VEAN8CM16	Address Number - Community 16	Numeric	Generic Edit	8	Allow NULL?
121	VEAN8CM17	Address Number - Community 17	Numeric	Generic Edit	8	Allow NULL?
122	VEAN8CM18	Address Number - Community 18	Numeric	Generic Edit	8	Allow NULL?
123	VEAN8CM19	Address Number - Community 19	Numeric	Generic Edit	8	Allow NULL?
124	VEAN8CM20	Address Number - Community 20	Numeric	Generic Edit	8	Allow NULL?
125	VEANSM01	Address Number - Sales Master 1	Numeric	Generic Edit	8	Allow NULL?
126	VEANSM02	Address Number - Sales Master 2	Numeric	Generic Edit	8	Allow NULL?
127	VEANSM03	Address Number - Sales Master 3	Numeric	Generic Edit	8	Allow NULL?
128	VEANSM04	Address Number - Sales Master 4	Numeric	Generic Edit	8	Allow NULL?
129	VEANSM05	Address Number - Sales Master 5	Numeric	Generic Edit	8	Allow NULL?
130	VEANSM06	Address Number - Sales Master 6	Numeric	Generic Edit	8	Allow NULL?
131	VEANSM07	Address Number - Sales Master 7	Numeric	Generic Edit	8	Allow NULL?
132	VEANSM08	Address Number - Sales Master 8	Numeric	Generic Edit	8	Allow NULL?
133	VEANSM09	Address Number - Sales Master 9	Numeric	Generic Edit	8	Allow NULL?
134	VEANSM10	Address Number - Sales Master 10	Numeric	Generic Edit	8	Allow NULL?

TOP 910 | 08 | F080434B INDEXES

Number

Description

Version CompanyNo EndDate BU (Primary/Unique)

Element	Alias	Description	Sequence
1	SVER	Snapshot Version	Ascending
2	PRNM	Preferred Name	Ascending
3	VRBY	Verified By	Ascending
4	NEWVAL	New Value	Ascending

Version CompNo EndDate CompNam

Element	Alias	Description	Sequence
1	SVER	Snapshot Version	Ascending
2	PRNM	Preferred Name	Ascending
3	VRBY	Verified By	Ascending
4	CONAME	Company Name	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 | 910 | 08 | F080434B TABLE

TOP 910 | 08 | F080434B COLUMNS

TOP 910 | 08 | F080434B 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 | 910 | 08 | F080434B TABLE

TOP910 | 08 | F080434B COLUMNS

TOP910 | 08 | F080434B INDEXES

TOP 910 | 08 | F080434B COLUMNS

TOP 910 | 08 | F080434B INDEXES