	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

49 columns | 812 | 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: OW 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	F06166	Pay Check History Tax Ledger	5	YV	PTAX	Tax Type	String	UDC	2	0
15	F06166A	Tax Ledger (Additional)	5	YV	PTAX	Tax Type	String	UDC	2	0
16	F06350I	WF - Paycheck (Interims)	31	Y4	PTAX	Tax Type	String	UDC	2	0
17	F06490	Payroll/Accounts Payable Ledger Detail	13	JR	PTAX	Tax Type	String	UDC	2	0
18	F068500	941 - Federal Tax History	3	YZ	PTAX	Tax Type	String	UDC	2	0
19	F0701731	Compensation Overrides	2	YC	PTAX	Tax Type	String	UDC	2	0
20	F0701732	Additional Tax Overrides	3	AO	PTAX	Tax Type	String	UDC	2	0
21	F0701734	Prior Head Tax from a Previous Employer	4	Y3	PTAX	Tax Type	String	UDC	2	0
22	F07186	Stub Information History Table	11	Y8	PTAX	Tax Type	String	UDC	2	0
23	F0724	Burden Distribution File	7	YS	PTAX	Tax Type	String	UDC	2	0
24	F07241	Burden Distribution File	7	YS	PTAX	Tax Type	String	UDC	2	0
25	F07352	Stub Information File	11	Y2	PTAX	Tax Type	String	UDC	2	0
26	F07353	Tax Detail File	4	Y3	PTAX	Tax Type	String	UDC	2	0
27	F07490	Payroll - Accounts Payable Detail (One World)	12	JR	PTAX	Tax Type	String	UDC	2	0
28	F077011	Tax History Integrity (Temp)	9	Y$	PTAX	Tax Type	String	UDC	2	0
29	F07811	Negative Amount Workfile	7	JE	PTAX	Tax Type	String	UDC	2	0
30	F07824	Company State/Local Control Table	10	JD	PTAX	Tax Type	String	UDC	2	0
31	F07831	Employee State/Local Control Table	10	YB	PTAX	Tax Type	String	UDC	2	0
32	F07940	Set Vertex Tax Table	1	YY	PTAX	Tax Type	String	UDC	2	0
33	F07992	Payroll Tax History Conversion Data	4	YQ	PTAX	Tax Type	String	UDC	2	0
TOP08: Human Resources
34	F083303	Benefit Statement Cross Reference Detail	6	CR	PTAX	Tax Type	String	UDC	2	0
TOP08AD: ADP Integration
35	F051374	ADP Employee Tax Withholding/Override Instructions	10	AD	PTAX	Tax Type	String	UDC	2	0
TOP48S: Service Billing
36	F4812	Billing Detail Workfile	37	WD	PTAX	Tax Type	String	UDC	2	0
37	F4812H	Billing Workfile - History	37	WD	PTAX	Tax Type	String	UDC	2	0
38	F4812HS	Billing Workfile History Purged Save	37	WD	PTAX	Tax Type	String	UDC	2	0
39	F48SUI01	Billing Detail Print Workfile	37	WD	PTAX	Tax Type	String	UDC	2	0
TOP52: Contract Billing
40	F5214	Billing Line - Component Code Cross Reference Table	9	A4	PTAX	Tax Type	String	UDC	2	0
41	F5215	Component Billing Line Cross Reference Details	11	A5	PTAX	Tax Type	String	UDC	2	0
TOP75A: Australia - Reporting System Only
42	F75A0003	Australia/New Zealand tax calculation rules	21	ZR	PTAX	Tax Type	String	UDC	2	0
TOP75Z: New Zealand - Reporting System Only
43	F75Z0009	New Zealand Tax Detail Work File	4	TX	PTAX	Tax Type	String	UDC	2	0
44	F75Z0010	New Zealand Tax Detail Tag Table	4	TD	PTAX	Tax Type	String	UDC	2	0
TOP77: Payroll (Canadian)
45	F06176	Unemployment Insurance History File	12	YS	PTAX	Tax Type	String	UDC	2	0
46	F0713	Tax History	4	YZ	PTAX	Tax Type	String	UDC	2	0
47	F0713SAV	Backup Copy of F0713 For Tax Ledger Repost	4	YZ	PTAX	Tax Type	String	UDC	2	0
48	F0716	Pay Check History Tax Ledger - Canadian DB	5	YV	PTAX	Tax Type	String	UDC	2	0
49	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	N
2	#P	PERS Group Code	N
3	#W	Withholding Tax	Y
4	$H	Accumulate Dollars & Hours	N
5	$O	Accumulate Dollars Only	N
6	$U	Do Not Accumulate Hrs or $	N
7	*	Non-Taxable	N
8	*F	Non-Taxable - SIT	N
9	*L	Non-Taxable - County	N
10	*M	Non-Taxable - City	N
11	*N	Non-Taxable - School	N
12	0	Not Assigned to Tax Input	N
13	1	Assigned to Tax Input	N
14	A	Federal Income Tax	N
15	B	Earned Income Credit (EIC)	N
16	B1	State Earned Income Credit	Y
17	C	Federal Unemployment	N
18	CA	Canada Federal Income Tax	N
19	CB	Canadian Pension Plan - emplee	N
20	CC	Canada Employ Ins. - empl'ee	N
21	CD	Canada Employ Ins. - empl'er	N
22	CE	Canadian Pension Plan - emplyr	N
23	CF	Provincial Income Tax	N
24	CG	Quebec Provincial Plan EE	N
25	CH	Quebec Provincial Pension CO.	N
26	CI	Exempt Hours - EI Exempt Hours	N
27	CJ	Provincial Parental Insurance	Y
28	CK	Provincial Parental Insurance	Y
29	D	Social Security Withheld	N
30	DT	Tip FICA W/H	N
31	E	Social Security Paid	N
32	ET	Tip FICA Pd.	N
33	EX	Extra Emolument	N
34	F	State Income Tax	N
35	G	State Unemployment	N
36	H	State Unemployment (SUI)	N
37	I	State Disability (SDI)	N
38	IV	Voluntary Dis. (VDI)	N
39	J	State Disability (SDI)	N
40	JV	Voluntary Dis. (VDI)	N
41	K	Occupational Head Tax	N
42	KP	Occupational Head Tax	Y
43	L	County Income Tax	N
44	LA	Lump Sum - A	N
45	LB	Lump Sum - B	N
46	LC	Lump Sum - C	N
47	LD	Lump Sum - D	Y
48	LE	Lump Sum - E	Y
49	M	City Income Tax	N
50	MH	Mental Health Tax	Y
51	MW	Minimum Wage	Y
52	N	School Tax	N
53	NH	School District Head Tax	Y
54	O	Supplemental Railroad Tax	N
55	P	Medicare Withheld	N
56	PT	Tip Medicare Withheld	N
57	Q	Medicare Paid	N
58	R	Tier I Withheld	N
59	RB	Tax Rebate	N
60	S	Tier I Paid	N
61	SL	Student Loan	N
62	ST	State Payroll Tax	N
63	T	Tier II Withheld	N
64	U	Tier II Paid	N
65	V	Tier III - RURT	N
66	W	Workers Compensation Ins.	N
67	X	RUIA - Unemployment Ins.	N
68	Y	Property Damage/Bodily Injury	N
69	Z	Weeks Worked	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

49 columns | 812 | PTAX | STOCK UDC

TOPUDC 06 / TX (Payroll Taxes) stock values