	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

58 columns | 920 | PTAX | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP05: Time Accounting and HRM Base
1	F0627	Workers Compensation Summary History	3	JH	PTAX	Tax Type	String	UDC	2	0
2	F069016	Payroll Tax Area Profile	4	YP	PTAX	Tax Type	String	UDC	2	0
3	F069016T	Payroll Tax Area Profile - Tag File	2	YP	PTAX	Tax Type	String	UDC	2	0
4	F069086	Payroll Corporate Tax Identification	3	YI	PTAX	Tax Type	String	UDC	2	0
5	F069117	Tax Authority Tax Exemption File	2	YB	PTAX	Tax Type	String	UDC	2	0
6	F069226	Unemployment Insurance Rates	3	YH	PTAX	Tax Type	String	UDC	2	0
7	F06926	Tax Area/ Vendor Cross Reference	2	Y#	PTAX	Tax Type	String	UDC	2	0
TOP05A: PeopleSoft HR & PR Foundation
8	F06345	Historical Payroll Register	30	JL	PTAX	Tax Type	String	UDC	2	0
TOP05T: Time Entry
9	F0624	Burden Distribution File	4	J#	PTAX	Tax Type	String	UDC	2	0
10	F06241	Burden Distribution File	4	J#	PTAX	Tax Type	String	UDC	2	0
TOP06: Payroll (old) - Obsolete-do not reuse
11	F06017	Employee Tax Exceptions/Overrides	8	YA	PTAX	Tax Type	String	UDC	2	0
TOP07: Payroll
12	F06136	Tax History	4	YZ	PTAX	Tax Type	String	UDC	2	0
13	F06136A	Tax Summary (Additional)	4	YZ	PTAX	Tax Type	String	UDC	2	0
14	F06136B	Tax Summary (PA ACT 32)	4	YZ	PTAX	Tax Type	String	UDC	2	0
15	F06166	Pay Check History Tax Ledger	5	YV	PTAX	Tax Type	String	UDC	2	0
16	F06166A	Tax Ledger (Additional)	5	YV	PTAX	Tax Type	String	UDC	2	0
17	F06166B	Tax Ledger (PA ACT 32)	5	YV	PTAX	Tax Type	String	UDC	2	0
18	F06350I	WF - Paycheck (Interims)	31	Y4	PTAX	Tax Type	String	UDC	2	0
19	F06490	Payroll/Accounts Payable Ledger Detail	13	JR	PTAX	Tax Type	String	UDC	2	0
20	F068500	941 - Federal Tax History	3	YZ	PTAX	Tax Type	String	UDC	2	0
21	F0701731	Compensation Overrides	2	YC	PTAX	Tax Type	String	UDC	2	0
22	F0701732	Additional Tax Overrides	3	AO	PTAX	Tax Type	String	UDC	2	0
23	F0701734	Prior Head Tax from a Previous Employer	4	Y3	PTAX	Tax Type	String	UDC	2	0
24	F0701735	Pretax Deduction Overrides	2	YC	PTAX	Tax Type	String	UDC	2	0
25	F07186	Stub Information History Table	11	Y8	PTAX	Tax Type	String	UDC	2	0
26	F0724	Burden Distribution File	7	YS	PTAX	Tax Type	String	UDC	2	0
27	F07241	Burden Distribution File	7	YS	PTAX	Tax Type	String	UDC	2	0
28	F07352	Stub Information File	11	Y2	PTAX	Tax Type	String	UDC	2	0
29	F07353	Tax Detail File	4	Y3	PTAX	Tax Type	String	UDC	2	0
30	F07490	Payroll - Accounts Payable Detail (One World)	12	JR	PTAX	Tax Type	String	UDC	2	0
31	F077011	Tax History Integrity (Temp)	9	Y$	PTAX	Tax Type	String	UDC	2	0
32	F077011A	Tax History Integrity Additional (Temp)	9	Y$	PTAX	Tax Type	String	UDC	2	0
33	F077011B	Tax Integrity (PA Act32)	9	Y3	PTAX	Tax Type	String	UDC	2	0
34	F07811	Negative Amount Workfile	7	JE	PTAX	Tax Type	String	UDC	2	0
35	F07824	Company State/Local Control Table	10	JD	PTAX	Tax Type	String	UDC	2	0
36	F07831	Employee State/Local Control Table	10	YB	PTAX	Tax Type	String	UDC	2	0
37	F078504	Vertex Geo Code to ADP Code	3	VA	PTAX	Tax Type	String	UDC	2	0
38	F078510	ADP Quarterly Integrity Report	12	VR	PTAX	Tax Type	String	UDC	2	0
39	F07940	Set Vertex Tax Table	1	YY	PTAX	Tax Type	String	UDC	2	0
40	F07992	Payroll Tax History Conversion Data	4	YQ	PTAX	Tax Type	String	UDC	2	0
TOP08: Human Resources
41	F083303	Benefit Statement Cross Reference Detail	6	CR	PTAX	Tax Type	String	UDC	2	0
TOP08AD: ADP Integration
42	F051374	ADP Employee Tax Withholding/Override Instructions	10	AD	PTAX	Tax Type	String	UDC	2	0
TOP48S: Service Billing
43	F4812	Billing Detail Workfile	37	WD	PTAX	Tax Type	String	UDC	2	0
44	F4812H	Billing Workfile History	37	WD	PTAX	Tax Type	String	UDC	2	0
45	F4812HS	Billing Workfile History Purged Save	37	WD	PTAX	Tax Type	String	UDC	2	0
46	F48SUI01	Billing Detail Print Workfile	37	WD	PTAX	Tax Type	String	UDC	2	0
TOP52: Contract Billing
47	F5214	Component Code/Burden Cross Reference Table	9	A4	PTAX	Tax Type	String	UDC	2	0
48	F5215	Component/Burden Billing Line Cross Reference Details	11	A5	PTAX	Tax Type	String	UDC	2	0
TOP75A: Australia
49	F75A0003	Australia/New Zealand tax calculation rules	21	ZR	PTAX	Tax Type	String	UDC	2	0
50	F75A0500	AU Bonus and Back Pay Tax Workfile	6	BP	PTAX	Tax Type	String	UDC	2	0
51	F75A0501	AU Bonus and Back Pay Tax History	6	TH	PTAX	Tax Type	String	UDC	2	0
TOP75Z: New Zealand
52	F75Z0009	New Zealand Tax Detail Work File	4	TX	PTAX	Tax Type	String	UDC	2	0
53	F75Z0010	New Zealand Tax Detail Tag Table	4	TD	PTAX	Tax Type	String	UDC	2	0
TOP77: Payroll (Canadian)
54	F06176	Unemployment Insurance History File	12	YS	PTAX	Tax Type	String	UDC	2	0
55	F0713	Tax History	4	YZ	PTAX	Tax Type	String	UDC	2	0
56	F0713SAV	Backup Copy of F0713 For Tax Ledger Repost	4	YZ	PTAX	Tax Type	String	UDC	2	0
57	F0716	Pay Check History Tax Ledger - Canadian DB	5	YV	PTAX	Tax Type	String	UDC	2	0
58	F77703	Payroll History Audit Report - Worktable	4	AR	PTAX	Tax Type	String	UDC	2	0

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

TOPUDC 06 / TX (Payroll Taxes) stock values

	Value	Description	Hard Coded
1		Default	Y
2	#P	PERS Group Code	Y
3	#S	NZ Student Loan	N
4	#W	Withholding Tax	Y
5	$1	Accumulate Dollar & Hour - AWE	Y
6	$2	Accumulate Dollars Only - AWE	Y
7	$3	Accum Dollar & Hour - OWP/ADP	Y
8	$4	Accum Dollars Only - OWP/ADP	Y
9	$5	Accum Dollar & Hour - AWE/ADP	Y
10	$6	Accum Dollars Only - AWE/ADP	Y
11	$7	Accumulate Dollar & Hour - ADP	Y
12	$8	Accumulate Dollars Only - ADP	Y
13	$H	Accum Dollars & Hours - All	Y
14	$O	Accumulate Dollars Only - All	Y
15	$U	Do Not Accumulate Hrs or $	Y
16	*	Non-Taxable	Y
17	*F	Non-Taxable - SIT	Y
18	*L	Non-Taxable - County	Y
19	*M	Non-Taxable - City	Y
20	*N	Non-Taxable - School	Y
21	0	Not Assigned to Tax Input	Y
22	1	Assigned to Tax Input	Y
23	A	Federal Income Tax	Y
24	B	Earned Income Credit (EIC)	Y
25	B1	State Earned Income Credit	Y
26	C	Federal Unemployment	Y
27	CA	Canada Federal Income Tax	Y
28	CB	Canadian Pension Plan - emplee	Y
29	CC	Canada Employ Ins. - employee	Y
30	CD	Canada Employ Ins. - employer	Y
31	CE	Canadian Pension Plan - emplyr	Y
32	CF	Provincial Income Tax	Y
33	CG	Quebec Provincial Plan EE	Y
34	CH	Quebec Provincial Pension CO.	Y
35	CI	Exempt Hours - EI Exempt Hours	Y
36	CJ	Provincial Parental Insurance	Y
37	CK	Provincial Parental Insurance	Y
38	D	Social Security Withheld	Y
39	DT	Tip FICA W/H	Y
40	E	Social Security Paid	Y
41	ET	Tip FICA Pd.	Y
42	EX	Extra Emolument	Y
43	F	State Income Tax	Y
44	F1	State Special 1	Y
45	F2	State Special 2	Y
46	G	State Unemployment	Y
47	G1	State Misc 1	Y
48	G2	State Misc 2	Y
49	GM	State Misc	Y
50	H	State Unemployment (SUI)	Y
51	H1	State Misc 1	Y
52	H2	State Misc 2	Y
53	HM	State Misc	Y
54	I	State Disability (SDI)	Y
55	IV	Voluntary Dis. (VDI)	Y
56	J	State Disability (SDI)	Y
57	JV	Voluntary Dis. (VDI)	Y
58	K	Occupational Head Tax	Y
59	KP	Occupational Head Tax	Y
60	KR	Occupational Head Tax	Y
61	L	County Income Tax	Y
62	LA	Lump Sum - A	Y
63	LB	Lump Sum - B	Y
64	LC	Lump Sum - C	Y
65	LD	Lump Sum - D	Y
66	LE	Lump Sum - E	Y
67	LR	County MCTMT	Y
68	M	City Income Tax	Y
69	MH	Mental Health Tax	Y
70	MR	City Income Tax	Y
71	MW	Minimum Wage	Y
72	N	School Tax	Y
73	NH	School District Head Tax	Y
74	O	Supplemental Railroad Tax	Y
75	P	Medicare Withheld	Y
76	PT	Tip Medicare Withheld	Y
77	Q	Medicare Paid	Y
78	R	Tier I Withheld	Y
79	RB	Tax Rebate	Y
80	S	Tier I Paid	Y
81	SB	Student Loan Borrowers Ded	Y
82	SC	Student Loan Commissioner Ded	Y
83	SL	Student Loan	Y
84	ST	State Payroll Tax	Y
85	T	Tier II Withheld	Y
86	U	Tier II Paid	Y
87	V	Tier III - RURT	Y
88	W	Workers Compensation Ins.	Y
89	X	RUIA - Unemployment Ins.	Y
90	Y	Property Damage/Bodily Injury	Y
91	Z	Weeks Worked	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

58 columns | 920 | PTAX | STOCK UDC

TOPUDC 06 / TX (Payroll Taxes) stock values