	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

104 columns | 920 | ADDS | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0006	Business Unit Master	9	MC	ADDS	State	String	UDC	3	0
2	F0006S	Date Effective Business Unit Master	11	MC	ADDS	State	String	UDC	3	0
3	F0006Z1	Cost Center Unedited Transaction Table	22	SZ	ADDS	State	String	UDC	3	0
4	F0006Z2	Business Unit Master Z File	22	SZ	ADDS	State	String	UDC	3	0
5	F004201	Prepayment Transaction Table	27	PT	ADDS	State	String	UDC	3	0
TOP01: Address Book
6	F0101Z2	Address Book - Interoperability	94	SZ	ADDS	State	String	UDC	3	0
7	F0116	Address by Date	11	AL	ADDS	State	String	UDC	3	0
8	F01161	Alternate Address	12	WL	ADDS	State	String	UDC	3	0
9	F01161DW	Customer Alternate Address Export	13	DW	ADDS	State	String	UDC	3	0
10	F01161Z1	Batch - Alternative Address	25	LB	ADDS	State	String	UDC	3	0
11	F0117	Postal Codes	2	A8	ADDS	State	String	UDC	3	0
TOP05: Time Accounting and HRM Base
12	F054101	Employee Personal Profile Information History Table	19	EH	ADDS	State	String	UDC	3	0
13	F054101W	Employee Personal Profile Information Work Table	19	EP	ADDS	State	String	UDC	3	0
14	F054111	Employee Emergency Contact History Table	10	CH	ADDS	State	String	UDC	3	0
15	F054111W	Employee Emergency Contact Work Table	10	EC	ADDS	State	String	UDC	3	0
TOP05A: PeopleSoft HR & PR Foundation
16	F05003	Verification of Employment Data	16	EV	ADDS	State	String	UDC	3	0
17	F060116Z	Unedited Quick Hire Transaction File	74	SZ	ADDS	State	String	UDC	3	0
TOP07: Payroll
18	F074001	New Hire Reporting Workfile - OneWorld Only	16	NH	ADDS	State	String	UDC	3	0
19	F07880	SUI Magnetic Media Workfile	12	YW	ADDS	State	String	UDC	3	0
20	F8907422	New Hire Detail File - Massachusetts (22)	7	MA	ADDS	State	String	UDC	3	0
21	F8907427	New Hire Detail File - Montana (27)	37	MT	ADDS	State	String	UDC	3	0
22	F8907428	New Hire Detail File - Nebraska(28)	14	NE	ADDS	State	String	UDC	3	0
23	F8907444	New Hire Detail File Transfer - Texas (44)	12	TX	ADDS	State	String	UDC	3	0
TOP08: Human Resources
24	F083305	Mail Merge Header/Detail	13	MM	ADDS	State	String	UDC	3	0
TOP08AD: ADP Integration
25	F05137	ADP Employee Master Information	58	AD	ADDS	State	String	UDC	3	0
TOP08B: Benefits Administration
26	F0833WF	Benefit Statement Work file	10	WF	ADDS	State	String	UDC	3	0
TOP12: Fixed Assets
27	F1201	Asset Master File	62	FA	ADDS	State	String	UDC	3	0
28	F1201P	Asset Master Purge Table	62	FA	ADDS	State	String	UDC	3	0
29	F1201Z1	Unedited Asset Master Transactions	74	FA	ADDS	State	String	UDC	3	0
TOP13: Plant/Equipment Management
30	F1206	Equipment License Master	3	FH	ADDS	State	String	UDC	3	0
31	F1206P	Equipment License Master Purge Table	3	FH	ADDS	State	String	UDC	3	0
TOP13C: Condition-Base Maintenance
32	F1310	Condition-Based Alerts	52	CA	ADDS	State	String	UDC	3	0
33	F1310Z1	Unedited Condition-Based Alerts	66	CB	ADDS	State	String	UDC	3	0
TOP15: Real Estate Management
34	F1507	Unit Master	19	NH	ADDS	State	String	UDC	3	0
TOP17C: Call Management
35	F17311	Equipment Master Location Details	19	LD	ADDS	State	String	UDC	3	0
TOP31B: Blend Management
36	F31B01	Winery Master	7	WI	ADDS	State	String	UDC	3	0
TOP40: Inventory/OP Base
37	F4006	Order Address Information	13	OA	ADDS	State	String	UDC	3	0
38	F4006Z	Batch Order Receiver - Order Address Information	13	OY	ADDS	State	String	UDC	3	0
39	F40333	Preference Profile - Carrier	17	CA	ADDS	State	String	UDC	3	0
40	F40334	Preference Profile - Mode of Transport	16	MT	ADDS	State	String	UDC	3	0
41	F4215	Shipment Header	36	XH	ADDS	State	String	UDC	3	0
TOP40G: Grower Management
42	F40G03	Grower Harvest	32	GH	ADDS	State	String	UDC	3	0
43	F40G0300	Grower Harvest Update Profile	48	HU	ADDS	State	String	UDC	3	0
TOP44H: Homebuilder Management
44	F44H201	Lot Master	5	LM	ADDS	State	String	UDC	3	0
45	F44H201H	Lot Master History	6	LM	ADDS	State	String	UDC	3	0
46	F44H201Z	HB Lot Master Unedited Transaction File	18	SZ	ADDS	State	String	UDC	3	0
47	F44H501H	Lot Sales History	171	LS	ADDS	State	String	UDC	3	0
TOP47: Electronic Commerce
48	F47037	EDI Shipping Notice Detail - Outbound	211	SZ	ADDS	State	String	UDC	3	0
49	F470561	EDI Payment Order Bank N & A - Outbound	12	D2	ADDS	State	String	UDC	3	0
50	F470561W	EDI Payment Order Bank N & A - Work	11	D2	ADDS	State	String	UDC	3	0
51	F470562	EDI Payment Order Vendor N & A - Outbound	30	D4	ADDS	State	String	UDC	3	0
52	F470562W	EDI Payment Order Vendor N & A - Work	30	D4	ADDS	State	String	UDC	3	0
53	F470563	EDI Payment Order Payee N & A - Outbound	30	D5	ADDS	State	String	UDC	3	0
54	F470563W	EDI Payment Order Payee N & A - Work	30	D5	ADDS	State	String	UDC	3	0
55	F4706	EDI Order Address Information	23	ZA	ADDS	State	String	UDC	3	0
56	F47081	EDI Price Sales Catalog Header - Inbound	26	FV	ADDS	State	String	UDC	3	0
TOP49: Transportation Management
57	F4950	Routing Entries	10	RT	ADDS	State	String	UDC	3	0
58	F4951	Carrier Zone Definitions	6	ZN	ADDS	State	String	UDC	3	0
59	F4960	Load Header	10	TM	ADDS	State	String	UDC	3	0
60	F4981	Freight Audit History	55	FH	ADDS	State	String	UDC	3	0
61	F49T50	Order Release Location Staging	19	LO	ADDS	State	String	UDC	3	0
62	F49T80	Locations Staging Table	15	LC	ADDS	State	String	UDC	3	0
TOP51X: In-Memory Project Management
63	F51X10	Project Advisor Console Worktable	63	EX	ADDS	State	String	UDC	3	0
TOP54HS: Health & Safety Incident Mgt
64	F54HS01	Incident Master	29	S1	ADDS	State	String	UDC	3	0
65	F54HS01M	Incident Master Change History	32	I1	ADDS	State	String	UDC	3	0
66	F54HS02	Incident People	44	S2	ADDS	State	String	UDC	3	0
67	F54HS02M	Incident People Change History	47	I2	ADDS	State	String	UDC	3	0
68	F54HS03	Incident Equipment	19	S4	ADDS	State	String	UDC	3	0
69	F54HS03M	Incident Equipment Change History	22	I4	ADDS	State	String	UDC	3	0
TOP74: EMEA Localization
70	F74030	Bank ID - Italy	11	BA	ADDS	State	String	UDC	3	0
71	F7430031	Legal Document Address (Print Info) - COMM - 03B	14	PI	ADDS	State	String	UDC	3	0
TOP74Y: Italy
72	F74YUI01	Italy Legal Company WF - ITA - 74Y	12	LC	ADDS	State	String	UDC	3	0
TOP75A: Australia
73	F75A0010	Australian Employee Termination Details	60	A0	ADDS	State	String	UDC	3	0
74	F75A0220	Payment Summary Workfile	11	PS	ADDS	State	String	UDC	3	0
TOP75I: India
75	F75I100Q	TDS Form 26Q - WorkFile (Quarterly)	21	EF	ADDS	State	String	UDC	3	0
76	F75I100W	TDS Form 26 - WorkFile	21	EF	ADDS	State	String	UDC	3	0
77	F75I403	Stock Transfer Details	35	AB	ADDS	State	String	UDC	3	0
78	F75I403T	Temp Data for F75i403	35	AB	ADDS	State	String	UDC	3	0
TOP76A: Argentina
79	F76A8002	SICORE RG738 Withholding Entity - ARG - 04 - 76A	5	V3	ADDS	State	String	UDC	3	0
80	F76A82	A/P Payment Control Group File - ARG - 04 - 76A	30	C6	ADDS	State	String	UDC	3	0
TOP76B: Brazil
81	F76011	Address Book Brazilian Tag Table - 04	14	AI	ADDS	State	String	UDC	3	0
82	F76011P	Archive Address Book Brazilian Tag Table - 04	14	PR	ADDS	State	String	UDC	3	0
83	F7601B	Nota Fiscal Header - BRA - 42	24	FH	ADDS	State	String	UDC	3	0
84	F7608B	ICMS Tax Rates - 40	2	TB	ADDS	State	String	UDC	3	0
85	F76101B	Nota Fiscal - Header (Fiscal Books) - 42	25	QX	ADDS	State	String	UDC	3	0
86	F7611B	Nota Fiscal Detail - BRA - 42	51	FD	ADDS	State	String	UDC	3	0
87	F761BA	AS Fiscal file book - 09	54	FB	ADDS	State	String	UDC	3	0
88	F76B0770	ICMS Period Balance by State and Company	2	IC	ADDS	State	String	UDC	3	0
89	F76B105	GNRE Table - 42	7	QC	ADDS	State	String	UDC	3	0
90	F76B132	GIA City Code - 42	1	TC	ADDS	State	String	UDC	3	0
91	F76B19	IBPT Tax information -76B	4	TF	ADDS	State	String	UDC	3	0
92	F76B70	Physical and Legal Person Table - IN68 - 42	14	FJ	ADDS	State	String	UDC	3	0
93	F76B8601	IN86-Work Table for Individuals and Legal Entities - 04	10	FJ	ADDS	State	String	UDC	3	0
TOP76H: Chile
94	F76H3B31	Legal Document Header (Print Info) - CHI - 03B - 76H	14	PI	ADDS	State	String	UDC	3	0
TOP79A: Greenhouse Gas Accounting
95	F79A09	GHG Energy Rates	26	ER	ADDS	State	String	UDC	3	0
96	F79A10	GHG Rates	30	ER	ADDS	State	String	UDC	3	0
97	F79A11	GHG Ledger	33	GR	ADDS	State	String	UDC	3	0
98	F79A11Z1	GHG Ledger - Batch File	51	GL	ADDS	State	String	UDC	3	0
99	F79A12	GHG Ledger Audit	34	GR	ADDS	State	String	UDC	3	0
100	F79A75	GHG Organization Name	10	GO	ADDS	State	String	UDC	3	0
101	F79AU11	GHG Ledger Work Table	36	GR	ADDS	State	String	UDC	3	0
TOPH90: EnterpriseOne TOOLS
102	F012504	Focus Registration	11	FO	ADDS	State	String	UDC	3	0
TOPH91: Design Tools
103	F9801NEW	Employee Information - New Version	6	AA	ADDS	State	String	UDC	3	0
104	F9801OLD	Employee Information - Old Version	5	AA	ADDS	State	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 00 / S (State & Province Codes) stock values

	Value	Description	Hard Coded
1		.	N
2	*	All States	N
3	AB	Alberta
4	AI	Arctic Islands
5	AK	Alaska
6	AL	Alabama
7	AM	Amazonas	N
8	AR	Arkansas
9	AU	Australia
10	AZ	Arizona
11	BC	British Columbia
12	CA	California
13	CN	Canada
14	CO	Colorado
15	CT	Connecticut
16	CZ	Canal Zone
17	DC	District of Columbia
18	DE	Delaware
19	DF	Distrito Federal	N
20	FL	Florida
21	GA	Georgia
22	HI	Hawaii
23	IA	Iowa
24	ID	Idaho
25	IL	Illinois
26	IN	Indiana
27	KS	Kansas
28	KY	Kentucky
29	LA	Louisiana
30	MA	Massachusetts
31	MB	Manitoba
32	MD	Maryland
33	ME	Maine
34	MI	Michigan
35	MN	Minnesota
36	MO	Missouri
37	MS	Mississippi
38	MT	Montana
39	MX	Estado de Mexico	N
40	NB	New Brunswick
41	NC	North Carolina
42	ND	North Dakota
43	NE	Nebraska
44	NF	Newfoundland
45	NH	New Hampshire
46	NJ	New Jersey
47	NL	Nuevo Leon	N
48	NM	New Mexico
49	NS	Nova Scotia
50	NSW	New South Wales	Y
51	NT	Northwest Territory
52	NU	Nunavut	N
53	NV	Nevada
54	NY	New York
55	NZ	New Zealand
56	OH	Ohio
57	OK	Oklahoma
58	ON	Ontario
59	OR	Oregon
60	PA	Pennsylvania
61	PE	Prince Edward Island
62	PR	Puerto Rico
63	QC	Quebec	N
64	RI	Rhode Island
65	RJ	Rio de Janiero	N
66	RS	Rio Grande do Sul	N
67	SA	South Australia	Y
68	SC	South Carolina
69	SD	South Dakota
70	SK	Saskatchewan
71	SP	Sao Paulo	N
72	TAS	Tasmania	Y
73	TN	Tennessee
74	TX	Texas
75	UT	Utah
76	VA	Virginia
77	VI	Virgin Islands
78	VIC	Victoria	Y
79	VT	Vermont
80	WA	Washington
81	WI	Wisconsin
82	WV	West Virginia
83	WY	Wyoming
84	YT	Yukon Territory
85	ZZ	Other Areas

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

104 columns | 920 | ADDS | STOCK UDC

TOPUDC 00 / S (State & Province Codes) stock values