	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

1 column | 812 | W246 | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP07: Payroll
1	F06720	W-2/1099 Processing Control	103	JE	W246	Included Pay Type Table 46	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 / IP (Basis Table Codes) stock values

	Value	Description	Hard Coded
1		.	N
2	01B	Amounts added to Box 1	N
3	03B	Amounts added to Box 3	N
4	05B	Amounts added to Box 5	N
5	10B	Amounts reported in Box 10	N
6	11B	Amounts reported in Box 11	N
7	12B	Amounts reported in Box 12	N
8	13B	Amounts reported in Box 13	N
9	14	Employment Income Before Ded.	N
10	14B	Amounts reported in Box 14	N
11	14T	Tier I Amounts	N
12	16	Canada/Quebec Pension Plan	N
13	16A	Pension or Superannuation	N
14	17B	Amounts added bo Box 17	N
15	18	Employee's UI Premiums	N
16	18A	Lump-sum payments	N
17	20	Reg. Retirement Savings Plan	N
18	20A	Self-employed commissions	N
19	20B	Amounts added to Box 20	N
20	21B	Amounts added to Box 21	N
21	22	Income Tax Deducted	N
22	22A	Income Tax Included	N
23	24	UI Insurable Earnings	N
24	24A	Annuities	N
25	26	CPP/QPP Pensionable Earnings	N
26	26A	Retiring Allowances	N
27	28A	Other Income	N
28	30	Housing, Board and Lodging	N
29	30A	Patronage allocations	N
30	32	Travel In a Prescribed Area	N
31	32A	Registered pension plan	N
32	34	Personal Use of Employers Auto	N
33	34A	Pension Adjustments	N
34	36	Low/No Interest Loans	N
35	38	Stock Option Benefits	N
36	40	Other TXBl Allowances/Benefits	N
37	40T	Alberta	N
38	42	Self-Employment Commissions	N
39	44	Union Dues	N
40	46	Charitable Donations	N
41	48	Payments to a DPSP	N
42	4TP	Step Progression Pay Tapes Tbl	N
43	52	Pension Adjustment	N
44	A	Employment Income	N
45	AB	Alberta	N
46	ALC	Allocated Tips	N
47	B	Employees QPP Contributions	N
48	BC	British Columbia	N
49	C	Employees UIC Contributions	N
50	C01	Colorado - Exclude Sick Pay	N
51	CA	California	N
52	CO	Colorado	N
53	COD	Coda Amounts	N
54	COM	Commission Amounts	N
55	CON	Concession Amounts	N
56	COU	Amounts added to Box 20	N
57	D	Reg. Pension Plan Contribution	N
58	DEP	Dependent Care	N
59	DFC	Defferred Compensation	N
60	E	Quebec Income Tax Withheld	N
61	ECT	Employee Contribution Amounts	N
62	EPP	109 Excess Golden Parachute	N
63	F	Union Dues	N
64	FL	Florida	N
65	FRB	Fringe Benefits	N
66	G	QPP Pensionable Earnings	N
67	GRD	Gross Distribution Amounts	N
68	GTL	Group Term Life	N
69	H	Food and Lodging	N
70	I	User of Employer's Car	N
71	IL	Illinois	N
72	J	Private Health Plan	N
73	K	Trips Within a Prescribed Area	N
74	L	Other Benefits	N
75	LOC	Amounts added to Box 20	N
76	M	Commissions	N
77	MB	Manitoba	N
78	MHC	Medical & Health Care Amounts	N
79	MIN	Tipped Employee Minimum Wage	N
80	MO	Missouri	N
81	N	Charitable Donations	N
82	N41	Gross Income	N
83	N42	Non-resident tax withheld	N
84	NB	New Brunswick	N
85	NEC	Non-Employee Comp. Amounts	N
86	NF	Newfoundland	N
87	NM	Next Method for Progression	N
88	NQ4	NR4 Special Handling Test	N
89	NQP	Non-Qualified Plan Amounts	N
90	NS	Nova Scotia	N
91	NT	Northwest Territories	N
92	NY	New York	N
93	O	Other Taxable Benefits	N
94	OH	Ohio	N
95	ON	Ontario	N
96	OTH	Other Income	N
97	P	Multi-Employer Insurance	N
98	PA	Pennsylvania	N
99	PNS	Pension Pay Amounts	N
100	Q	Deferred Salary or Wages	N
101	QC	Quebec	N
102	R	Tax Exempt Inc./Status Indian	N
103	R2	Releve 2-Footnote	N
104	R2A	Life Annuity payments	N
105	R2B	Benefits	N
106	R2C	Other Payments	N
107	R2D	Refund of RRSP	N
108	R2E	Amt Received prior to death	N
109	R2F	Refund of undeducted	N
110	R2G	Amount received upon revocatio	N
111	R2H	Other income from an RRSP/RRIF	N
112	R2I	Amt giving entitlement	N
113	R2J	Quebec Income Tax	N
114	R2K	Tax-paid amounts	N
115	REM	Reimbursed Expense Amounts	N
116	RET	Retirement Fund Amounts	N
117	RPP	Registered Pension Plan	N
118	RTD	Rent Amounts	N
119	RTS	Rent Amounts	N
120	RYT	Royality Amounts	N
121	S	Tips	N
122	SCH	School District Tax	N
123	SCW	School District Wages	N
124	SK	Saskatchewan	N
125	SPY	Substitute Payment Amounts	N
126	STP	Step Progression Pay Types	N
127	T4A	T4A Footnote	N
128	TPS	3rd Party Sick	N
129	TX	Texas	N
130	VA	Virginia	N
131	WA	Washington State	N
132	WAF	Washington State - Water Rates	N
133	WY	Wyoming	N
134	XSL	Group Term Life	N
135	YT	Yukon Territory	N
136	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

1 column | 812 | W246 | STOCK UDC

TOPUDC 06 / IP (Basis Table Codes) stock values