	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

12 columns | 920 | WKSE | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP05A: PeopleSoft 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
7	F75A0006	Australian Employee Tax Overrides	29	ZE	WKSE	State - Working	String	UDC	3	0
8	F75A0401	Australia State Payroll Tax Thresholds and Rates	3	ZT	WKSE	State - Working	String	UDC	3	0
9	F75A0402	Australia State Payroll Tax Threshold Proration Formulas	1	ZF	WKSE	State - Working	String	UDC	3	0
10	F75A0405	Australia State Payroll Tax Eligible PDBs	2	ZP	WKSE	State - Working	String	UDC	3	0
11	F75A0406	Australia State Payroll Taxable Wages History	2	ZH	WKSE	State - Working	String	UDC	3	0
12	F75A0407	Australia State Payroll Tax Liability History	3	TL	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	80	Northern Territory	Y
19	81	Australian Capital Territory	Y
20	82	New South Wales	Y
21	83	Victoria	Y
22	84	Queensland	Y
23	85	South Australia	Y
24	86	Western Australia	Y
25	87	Tasmania	Y
26	AB	Alberta	N
27	AK	Alaska	N
28	AL	Alabama	N
29	AR	Arkansas	N
30	ATH	AL, Athens	N
31	AZ	Arizona	N
32	BC	British Columbia	N
33	BED	Ohio, Bethesda	N
34	BEO	Bethal	N
35	BTH	Bethesda	N
36	CA	California	N
37	CN	Canada	Y
38	CO	Colorado	N
39	COL	Ohio Columbus City Income Tax	N
40	CT	Connecticut	N
41	D	Denver City Tax	N
42	DAL	Texas, Dallas	N
43	DC	Dist. of Columbia	N
44	DE	Delaware	N
45	DEN	Colorado, Denver	N
46	DET	Detroit	N
47	E	Denver City Tax	N
48	FL	Florida	N
49	FTW	Kentucky, Fort Wright	N
50	GA	Georgia	N
51	GWV	Green wood village	N
52	HI	Hawaii	N
53	HO	Tx, Houston	N
54	IA	Iowa	N
55	ID	Idaho	N
56	IL	Illinois	N
57	IN	Indiana	N
58	KAN	Kansas City, Kansas	N
59	KCJ	Missouri, K C Jackson County	N
60	KCM	Missouri, Kansas City	N
61	KEN	Kentucky, Green County	N
62	KS	Kansas	N
63	KY	Kentucky	N
64	KYB	Kentucky, Bowling Green	N
65	KYC	Kentucky County	N
66	LA	Louisiana	N
67	LAT	Kansas, City of Latham	N
68	LAX	California, Los Angeles	N
69	LB	Labrador	N
70	MA	Massachusetts	N
71	MB	Manitoba	N
72	MD	Maryland	N
73	ME	Maine	N
74	MI	Michigan	N
75	MN	Minnesota	N
76	MNT	Montgomery County	N
77	MO	Missouri	N
78	MS	Mississippi	N
79	MT	Montana	N
80	NB	New Brunswick	N
81	NBC	Ca, Newport Beach	N
82	NC	North Carolina	N
83	ND	North Dakota	N
84	NE	Nebraska	N
85	NH	New Hampshire	N
86	NJ	New Jersey	N
87	NL	Newfoundland	Y
88	NM	New Mexico	N
89	NS	Nova Scotia	N
90	NT	Northwest Territory	N
91	NU	Nunavut	Y
92	NV	Nevada	N
93	NY	New York	N
94	NYC	New York City	N
95	NYL	NY override	N
96	OH	Ohio	N
97	OHA	Ohio - Aberdeen County	N
98	OHB	Ohio - Brown County	N
99	OK	Oklahoma	N
100	ON	Ontario	N
101	OR	Oregon	N
102	P01	PPIP Tax Rate Code	Y
103	PA	Pennsylvania	N
104	PAC	Penn. City	N
105	PAD	Paducah, Kentucky	N
106	PAN	Penn School Tax	N
107	PAO	Pennsylvania Occ Tax	N
108	PE	Prince Edward Island	N
109	PR	Puerto Rico	N
110	QC	Quebec	N
111	RI	Rhode Island	N
112	SC	South Carolina	N
113	SD	South Dakota	N
114	SF	Ca, San Mateo	N
115	SK	Saskatchewan	N
116	STL	Missouri, St Louis	N
117	TN	Tennessee	N
118	TU	Ok , Tulsa	N
119	TX	Texas	N
120	U01	Ca. EI Rate - Primary	N
121	U02	Ca. EI Rate - Secondary	N
122	UT	Utah	N
123	VA	Virginia	N
124	VT	Vermont	N
125	WA	Washington	N
126	WI	Wisconsin	N
127	WIN	Indiana, Winchester County	N
128	WV	West Virginia	N
129	WY	Wyoming	N
130	YRK	PA, City Of York	N
131	YT	Yukon Territory	N
132	ZZ	Other Areas	Y

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

12 columns | 920 | WKSE | STOCK UDC

TOPUDC 06 / SC (Statutory Code) stock values