	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

72 COLUMNS | 2 INDEXES | 920 | 08 | F080436 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
08: Human Resources
1	920	F080436	VT	72	2	VETS-4212 Employment Report	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 VTSVER, VTACYV, VTTORO, VTTYOF, VTNMSC, VTTMEP, VTNMCY, VTAPC1, VTAPC2, VTCPTC, VTCNYP, VTSTYV, VTPCYV, VTNMPC, VTPHYV, VTEPCY, VTNAMH, VTAHL1, VTAHL2, VTCTHL, VTCYHL, VTSTHL, VTPCHL, VTNAIS, VTDUVT, VTEIDV, VTVTVV01, VTVTVV02, VTVTVV03, VTVTVV04, VTVTVV05, VTVTVV06, VTVTVV07, VTVTVV08, VTVTVV09, VTVTVV10, VTVTVV11, VTVTVV12, VTVTVV13, VTVTVV14, VTVTVV15, VTVTVV16, VTVTVV17, VTVTVV18, VTVTVV19, VTVTVV20, VTVTVV21, VTVTVV22, VTVTVV23, VTVTVV24, VTVTVV25, VTVTVV26, VTVTVV27, VTVTVV28, VTVTVV29, VTVTVV30, VTVTVV31, VTVTVV32, VTVTVV33, VTVTVV34, VTVTVV35, VTVTVV36, VTVTVV37, VTVTVV38, VTVTVV39, VTVTVV40, VTVTVV41, VTVTVV42, VTVTVV43, VTVTVV44, VTVTVVMX, VTVTVVMN FROM F080436

TOP 920 | 08 | F080436 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	VTSVER	Snapshot Version	String	Generic Edit	10	Allow NULL?
2	VTACYV	Assigned Company No.	String	Generic Edit	7	Allow NULL?
3	VTTORO	Type of Reporting Organization	Character	Generic Edit	1	Allow NULL?
4	VTTYOF	Type of Form	String	Generic Edit	3	Allow NULL?
5	VTNMSC	Number of MSC Locations	String	Generic Edit	8	Allow NULL?
6	VTTMEP	Twelve Month Ending Period	String	Generic Edit	10	Allow NULL?
7	VTNMCY	Name - Parent Company	String	Generic Edit	100	Allow NULL?
8	VTAPC1	Address Line 1 - Parent Company	String	Generic Edit	100	Allow NULL?
9	VTAPC2	Address Line 2 - Parent Company	String	Generic Edit	100	Allow NULL?
10	VTCPTC	City - Parent Company	String	Generic Edit	50	Allow NULL?
11	VTCNYP	County - Parent Company	String	Generic Edit	50	Allow NULL?
12	VTSTYV	State - Parent Company	String	Generic Edit	2	Allow NULL?
13	VTPCYV	Postal Code - Parent Company	String	Generic Edit	9	Allow NULL?
14	VTNMPC	Name - Parent Company Contact	String	Generic Edit	100	Allow NULL?
15	VTPHYV	Phone - Parent Company Contact	String	Generic Edit	20	Allow NULL?
16	VTEPCY	Email - Parent Company Contact	String	Generic Edit	100	Allow NULL?
17	VTNAMH	Name - Hiring Location	String	Generic Edit	100	Allow NULL?
18	VTAHL1	Address Line 1 - Hiring Location	String	Generic Edit	100	Allow NULL?
19	VTAHL2	Address Line 2 - Hiring Location	String	Generic Edit	100	Allow NULL?
20	VTCTHL	City - Hiring Location	String	Generic Edit	50	Allow NULL?
21	VTCYHL	County - Hiring Location	String	Generic Edit	50	Allow NULL?
22	VTSTHL	State - Hiring Location	String	Generic Edit	2	Allow NULL?
23	VTPCHL	Postal Code - Hiring Location	String	Generic Edit	9	Allow NULL?
24	VTNAIS	NAICS for Veterans Reports	String	Generic Edit	6	Allow NULL?
25	VTDUVT	DUNS for Veterans Reports	String	Generic Edit	9	Allow NULL?
26	VTEIDV	EIN for Veterans Reports	String	Generic Edit	9	Allow NULL?
27	VTVTVV01	Employee Count 01	Numeric	Generic Edit	8	Allow NULL?
28	VTVTVV02	Employee Count 02	Numeric	Generic Edit	8	Allow NULL?
29	VTVTVV03	Employee Count 03	Numeric	Generic Edit	8	Allow NULL?
30	VTVTVV04	Employee Count 04	Numeric	Generic Edit	8	Allow NULL?
31	VTVTVV05	Employee Count 05	Numeric	Generic Edit	8	Allow NULL?
32	VTVTVV06	Employee Count 06	Numeric	Generic Edit	8	Allow NULL?
33	VTVTVV07	Employee Count 07	Numeric	Generic Edit	8	Allow NULL?
34	VTVTVV08	Employee Count 08	Numeric	Generic Edit	8	Allow NULL?
35	VTVTVV09	Employee Count 09	Numeric	Generic Edit	8	Allow NULL?
36	VTVTVV10	Employee Count 10	Numeric	Generic Edit	8	Allow NULL?
37	VTVTVV11	Employee Count 11	Numeric	Generic Edit	8	Allow NULL?
38	VTVTVV12	Employee Count 12	Numeric	Generic Edit	8	Allow NULL?
39	VTVTVV13	Employee Count 13	Numeric	Generic Edit	8	Allow NULL?
40	VTVTVV14	Employee Count 14	Numeric	Generic Edit	8	Allow NULL?
41	VTVTVV15	Employee Count 15	Numeric	Generic Edit	8	Allow NULL?
42	VTVTVV16	Employee Count 16	Numeric	Generic Edit	8	Allow NULL?
43	VTVTVV17	Employee Count 17	Numeric	Generic Edit	8	Allow NULL?
44	VTVTVV18	Employee Count 18	Numeric	Generic Edit	8	Allow NULL?
45	VTVTVV19	Employee Count 19	Numeric	Generic Edit	8	Allow NULL?
46	VTVTVV20	Employee Count 20	Numeric	Generic Edit	8	Allow NULL?
47	VTVTVV21	Employee Count 21	Numeric	Generic Edit	8	Allow NULL?
48	VTVTVV22	Employee Count 22	Numeric	Generic Edit	8	Allow NULL?
49	VTVTVV23	Employee Count 23	Numeric	Generic Edit	8	Allow NULL?
50	VTVTVV24	Employee Count 24	Numeric	Generic Edit	8	Allow NULL?
51	VTVTVV25	Employee Count 25	Numeric	Generic Edit	8	Allow NULL?
52	VTVTVV26	Employee Count 26	Numeric	Generic Edit	8	Allow NULL?
53	VTVTVV27	Employee Count 27	Numeric	Generic Edit	8	Allow NULL?
54	VTVTVV28	Employee Count 28	Numeric	Generic Edit	8	Allow NULL?
55	VTVTVV29	Employee Count 29	Numeric	Generic Edit	8	Allow NULL?
56	VTVTVV30	Employee Count 30	Numeric	Generic Edit	8	Allow NULL?
57	VTVTVV31	Employee Count 31	Numeric	Generic Edit	8	Allow NULL?
58	VTVTVV32	Employee Count 32	Numeric	Generic Edit	8	Allow NULL?
59	VTVTVV33	Employee Count 33	Numeric	Generic Edit	8	Allow NULL?
60	VTVTVV34	Employee Count 34	Numeric	Generic Edit	8	Allow NULL?
61	VTVTVV35	Employee Count 35	Numeric	Generic Edit	8	Allow NULL?
62	VTVTVV36	Employee Count 36	Numeric	Generic Edit	8	Allow NULL?
63	VTVTVV37	Employee Count 37	Numeric	Generic Edit	8	Allow NULL?
64	VTVTVV38	Employee Count 38	Numeric	Generic Edit	8	Allow NULL?
65	VTVTVV39	Employee Count 39	Numeric	Generic Edit	8	Allow NULL?
66	VTVTVV40	Employee Count 40	Numeric	Generic Edit	8	Allow NULL?
67	VTVTVV41	Employee Count 41	Numeric	Generic Edit	8	Allow NULL?
68	VTVTVV42	Employee Count 42	Numeric	Generic Edit	8	Allow NULL?
69	VTVTVV43	Employee Count 43	Numeric	Generic Edit	8	Allow NULL?
70	VTVTVV44	Employee Count 44	Numeric	Generic Edit	8	Allow NULL?
71	VTVTVVMX	Maximum Number	Numeric	Generic Edit	8	Allow NULL?
72	VTVTVVMN	Minimum Number	Numeric	Generic Edit	8	Allow NULL?

TOP 920 | 08 | F080436 INDEXES

Number

Description

Version CompanyNo EndDate HL (Primary/Unique)

Element	Alias	Description	Sequence
1	SVER	Snapshot Version	Ascending
2	ACYV	Assigned Company No.	Ascending
3	TMEP	Twelve Month Ending Period	Ascending
4	NAMH	Name - Hiring Location	Ascending

Version CompanyNo EndDate Comp

Element	Alias	Description	Sequence
1	SVER	Snapshot Version	Ascending
2	ACYV	Assigned Company No.	Ascending
3	TMEP	Twelve Month Ending Period	Ascending
4	NMCY	Name - Parent Company	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

72 COLUMNS | 2 INDEXES | 920 | 08 | F080436 TABLE

TOP 920 | 08 | F080436 COLUMNS

TOP 920 | 08 | F080436 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

72 COLUMNS | 2 INDEXES | 920 | 08 | F080436 TABLE

TOP920 | 08 | F080436 COLUMNS

TOP920 | 08 | F080436 INDEXES

TOP 920 | 08 | F080436 COLUMNS

TOP 920 | 08 | F080436 INDEXES