	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	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

7 columns | 812 | WKSE | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP05A: OW HR & PR Foundation
1	F060116	Employee Master Information	17	YA	WKSE	State - Working	String	UDC	3	0
2	F0601161	Point-In-Time Employee Master	19	PT	WKSE	State - Working	String	UDC	3	0
3	F060116W	EE Master Request File	17	YA	WKSE	State - Working	String	UDC	3	0
TOP07: Payroll
4	F074001	New Hire Reporting Workfile - OneWorld Only	46	NH	WKSE	State - Working	String	UDC	3	0
5	F07880	SUI Magnetic Media Workfile	18	YW	WKSE	State - Working	String	UDC	3	0
6	F8907428	New Hire Detail File - Nebraska(28)	18	NE	WKSE	State - Working	String	UDC	3	0
TOP75A: Australia - Reporting System Only
7	F75A0006	Australian Employee Tax Overrides	29	ZE	WKSE	State - Working	String	UDC	3	0

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 06 / SC (Statutory Code) stock values

	Value	Description	Hard Coded
1		Federal (and default)	N
2	*AR	Additional Local Residence Tax	N
3	*AT	Additional Tax (Canada)	N
4	*CC	Child Care Deduction (Canada)	N
5	*CR	Override CPP Rate (Canada)	N
6	*CX	CPP Exemption (Canada)	N
7	*FR	Federal Override Rate (Canada)	N
8	*FS	Federal Supplemental Override	N
9	*K3	Additional Tax Credits(Canada)	N
10	*NC	Net Tax Credit Equival(Canada)	N
11	*PA	Add'l Province Inc Tax(Canada)	N
12	*PD	Provincial Deduction (Canada)	N
13	*PR	Prov. Override Rate (Canada)	N
14	*PX	Prov. Add'l Deduction (Canada)	N
15	*RD	Residential Deduction (Canada)	N
16	*SS	State Supplemental Override	N
17	31	Home State - New York	N
18	AB	Alberta	N
19	AK	Alaska	N
20	AL	Alabama	N
21	AR	Arkansas	N
22	ATH	AL, Athens	N
23	AZ	Arizona	N
24	BC	British Columbia	N
25	BED	Ohio, Bethesda	N
26	BEO	Bethal	N
27	BTH	Bethesda	N
28	CA	California	N
29	CAN	Ohio, Canton	N
30	CN	Canada	Y
31	CO	Colorado	N
32	COL	Ohio Columbus City Income Tax	N
33	CT	Connecticut	N
34	D	Denver City Tax	N
35	DAL	Texas, Dallas	N
36	DC	Dist. of Columbia	N
37	DE	Delaware	N
38	DEN	Colorado, Denver	N
39	DET	Detroit	N
40	E	Denver City Tax	N
41	FL	Florida	N
42	FTW	Kentucky, Fort Wright	N
43	GA	Georgia	N
44	GRN	Ohio, Greenville	N
45	GWV	Green wood village	N
46	HI	Hawaii	N
47	HO	Tx, Houston	N
48	IA	Iowa	N
49	ID	Idaho	N
50	IL	Illinois	N
51	IN	Indiana	N
52	INM	In, Marion	N
53	KAN	Kansas City, Kansas	N
54	KCJ	Missouri, K C Jackson County	N
55	KCM	Missouri, Kansas City	N
56	KEN	Kentucky, Green County	N
57	KS	Kansas	N
58	KY	Kentucky	N
59	KYB	Kentucky, Bowling Green	N
60	KYC	Kentucky County	N
61	LA	Louisiana	N
62	LAT	Kansas, City of Latham	N
63	LAX	California, Los Angeles	N
64	LB	Labrador	N
65	LEX	Kentucky, Lexington	N
66	MA	Massachusetts	N
67	MB	Manitoba	N
68	MD	Maryland	N
69	ME	Maine	N
70	MI	Michigan	N
71	MN	Minnesota	N
72	MNT	Montgomery County	N
73	MO	Missouri	N
74	MS	Mississippi	N
75	MT	Montana	N
76	NB	New Brunswick	N
77	NBC	Ca, Newport Beach	N
78	NC	North Carolina	N
79	ND	North Dakota	N
80	NE	Nebraska	N
81	NF	Newfoundland	N
82	NH	New Hampshire	N
83	NJ	New Jersey	N
84	NL	Newfoundland	Y
85	NM	New Mexico	N
86	NS	Nova Scotia	N
87	NT	Northwest Territory	N
88	NU	Nunavut	Y
89	NV	Nevada	N
90	NY	New York	N
91	NYC	New York City	N
92	NYL	NY override	N
93	OH	Ohio	N
94	OHA	Ohio - Aberdeen County	N
95	OHB	Ohio - Brown County	N
96	OK	Oklahoma	N
97	ON	Ontario	N
98	OR	Oregon	N
99	P01	PPIP Tax Rate Code	Y
100	PA	Pennsylvania	N
101	PAC	Penn. City	N
102	PAD	Paducah, Kentucky	N
103	PAN	Penn School Tax	N
104	PAO	Pennsylvania Occ Tax	N
105	PE	Prince Edward Island	N
106	PR	Puerto Rico	N
107	QC	Quebec	N
108	RI	Rhode Island	N
109	SC	South Carolina	N
110	SD	South Dakota	N
111	SF	Ca, San Mateo	N
112	SK	Saskatchewan	N
113	STL	Missouri, St Louis	N
114	TN	Tennessee	N
115	TU	Ok , Tulsa	N
116	TX	Texas	N
117	U01	Ca. EI Rate - Primary	N
118	U02	Ca. EI Rate - Secondary	N
119	UT	Utah	N
120	VA	Virginia	N
121	VT	Vermont	N
122	WA	Washington	N
123	WI	Wisconsin	N
124	WIN	Indiana, Winchester County	N
125	WV	West Virginia	N
126	WY	Wyoming	N
127	YRK	PA, City Of York	N
128	YT	Yukon Territory	N
129	ZZ	Other Areas	N

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

7 columns | 812 | WKSE | STOCK UDC

TOPUDC 06 / SC (Statutory Code) stock values