	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

80 columns | 812 | 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	F004201	Prepayment Transaction Table	27	PT	ADDS	State	String	UDC	3	0
TOP01: Address Book
5	F0101Z2	Address Book - Interoperability	94	SZ	ADDS	State	String	UDC	3	0
6	F0116	Address by Date	11	AL	ADDS	State	String	UDC	3	0
7	F01161	Alternate Address	12	WL	ADDS	State	String	UDC	3	0
8	F01161Z1	Batch - Alternative Address	25	LB	ADDS	State	String	UDC	3	0
9	F0117	Postal Code Transactions	2	A8	ADDS	State	String	UDC	3	0
TOP05: Time Accounting and HRM Base
10	F054101	Employee Personal Profile Information History Table	19	EH	ADDS	State	String	UDC	3	0
11	F054101W	Employee Personal Profile Information Work Table	19	EP	ADDS	State	String	UDC	3	0
12	F054111	Employee Emergency Contact History Table	10	CH	ADDS	State	String	UDC	3	0
13	F054111W	Employee Emergency Contact Work Table	10	EC	ADDS	State	String	UDC	3	0
TOP05A: OW HR & PR Foundation
14	F05003	Verification of Employment Data	16	EV	ADDS	State	String	UDC	3	0
15	F060116Z	Unedited Quick Hire Transaction File	74	SZ	ADDS	State	String	UDC	3	0
TOP07: Payroll
16	F074001	New Hire Reporting Workfile - OneWorld Only	16	NH	ADDS	State	String	UDC	3	0
17	F07880	SUI Magnetic Media Workfile	12	YW	ADDS	State	String	UDC	3	0
18	F8907422	New Hire Detail File - Massachusetts (22)	7	MA	ADDS	State	String	UDC	3	0
19	F8907427	New Hire Detail File - Montana (27)	37	MT	ADDS	State	String	UDC	3	0
20	F8907428	New Hire Detail File - Nebraska(28)	14	NE	ADDS	State	String	UDC	3	0
21	F8907444	New Hire Detail File Transfer - Texas (44)	12	TX	ADDS	State	String	UDC	3	0
TOP08: Human Resources
22	F083305	Mail Merge Header/Detail	13	MM	ADDS	State	String	UDC	3	0
TOP08A: eRecruit
23	F08490	Recruitment Information	11	RI	ADDS	State	String	UDC	3	0
TOP08AD: ADP Integration
24	F05137	ADP Employee Master Information	58	AD	ADDS	State	String	UDC	3	0
TOP08B: Benefits Administration
25	F0833WF	Benefit Statement Work file	10	WF	ADDS	State	String	UDC	3	0
TOP12: Fixed Assets
26	F1201	Asset Master File	62	FA	ADDS	State	String	UDC	3	0
27	F1201P	Asset Master Purge Table	62	FA	ADDS	State	String	UDC	3	0
28	F1201Z1	Unedited Asset Master Transactions	74	FA	ADDS	State	String	UDC	3	0
TOP13: Plant/Equipment Management
29	F1206	Equipment License Master	3	FH	ADDS	State	String	UDC	3	0
30	F1206P	Equipment License Master Purge Table	3	FH	ADDS	State	String	UDC	3	0
TOP13C: Condition-Base Maintenance
31	F1310	Condition-Based Alerts	52	CA	ADDS	State	String	UDC	3	0
32	F1310Z1	Unedited Condition-Based Alerts	66	CB	ADDS	State	String	UDC	3	0
TOP15: Property Management
33	F1507	Unit Master File	19	NH	ADDS	State	String	UDC	3	0
TOP17C: Call Management
34	F17311	Installed Base Location Details	19	LD	ADDS	State	String	UDC	3	0
TOP31B: Blend Management
35	F31B01	Winery Master	7	WI	ADDS	State	String	UDC	3	0
TOP40: Inventory/OP Base
36	F4006	Order Address Information	13	OA	ADDS	State	String	UDC	3	0
37	F4006Z	Batch Order Receiver - Order Address Information	13	OY	ADDS	State	String	UDC	3	0
38	F40333	Preference Profile - Carrier	17	CA	ADDS	State	String	UDC	3	0
39	F40334	Preference Profile - Mode of Transport	16	MT	ADDS	State	String	UDC	3	0
40	F4215	Shipment Header	36	XH	ADDS	State	String	UDC	3	0
TOP40G: Grower Management
41	F40G03	Grower Harvest	30	GH	ADDS	State	String	UDC	3	0
42	F40G0300	Grower Harvest Update Profile	48	HU	ADDS	State	String	UDC	3	0
TOP44H: Homebuilder Management
43	F44H201	Lot Master	5	LM	ADDS	State	String	UDC	3	0
44	F44H201H	Lot Master History	6	LM	ADDS	State	String	UDC	3	0
45	F44H201Z	HB Lot Master Unedited Transaction File	18	SZ	ADDS	State	String	UDC	3	0
46	F44H501H	Lot Sales History	171	LS	ADDS	State	String	UDC	3	0
TOP47: Electronic Commerce
47	F47037	EDI Shipping Notice Detail - Outbound	211	SZ	ADDS	State	String	UDC	3	0
48	F470561	EDI Payment Order Bank N and A - Outbound	12	D2	ADDS	State	String	UDC	3	0
49	F470561W	EDI Payment Order Bank N and A - Work	11	D2	ADDS	State	String	UDC	3	0
50	F470562	EDI Payment Order Vendor N and A - Outbound	30	D4	ADDS	State	String	UDC	3	0
51	F470562W	EDI Payment Order Vendor N and A - Work	30	D4	ADDS	State	String	UDC	3	0
52	F470563	EDI Payment Order Payee N and A - Outbound	30	D5	ADDS	State	String	UDC	3	0
53	F470563W	EDI Payment Order Payee N and A - Work	30	D5	ADDS	State	String	UDC	3	0
54	F4706	EDI Order Address Information	23	ZA	ADDS	State	String	UDC	3	0
55	F47081	EDI Price Sales Catalog Header - Inbound	26	FV	ADDS	State	String	UDC	3	0
TOP49: Transportation Management
56	F4950	Routing Entries	10	RT	ADDS	State	String	UDC	3	0
57	F4951	Carrier Zone Definitions	6	ZN	ADDS	State	String	UDC	3	0
58	F4960	Load Header	10	TM	ADDS	State	String	UDC	3	0
59	F4981	Freight Audit History	55	FH	ADDS	State	String	UDC	3	0
TOP74: EMEA Localization
60	F74030	Bank ID - Italy	11	BA	ADDS	State	String	UDC	3	0
61	F7430031	Legal Document Address (Print Info) - COMM - 03B	14	PI	ADDS	State	String	UDC	3	0
TOP75A: Australia - Reporting System Only
62	F75A0010	Australian Employee Termination Details	60	A0	ADDS	State	String	UDC	3	0
63	F75A0220	Payment Summary Workfile	11	PS	ADDS	State	String	UDC	3	0
TOP76A: Argentina
64	F76A8002	SICORE RG738 Withholding Entity	5	V3	ADDS	State	String	UDC	3	0
65	F76A82	A/P Payment Control Group File - ARG - 04 - 76A	30	C6	ADDS	State	String	UDC	3	0
TOP76B: Brazil - Reporting System Only
66	F76011	Address Book Brazilian Tag File	14	AI	ADDS	State	String	UDC	3	0
67	F76011P	Archive Address Book Brazilian Tag Table - 04	14	PR	ADDS	State	String	UDC	3	0
68	F7601B	Nota Fiscal Header - Brazil	24	FH	ADDS	State	String	UDC	3	0
69	F7608B	ICMS Tax Rates	2	TB	ADDS	State	String	UDC	3	0
70	F76101B	Nota Fiscal - Header (Fiscal Books) - 42	25	QX	ADDS	State	String	UDC	3	0
71	F7611B	Nota Fiscal Detail - Brazil	51	FD	ADDS	State	String	UDC	3	0
72	F761BA	AS Fiscal file book	54	FB	ADDS	State	String	UDC	3	0
73	F76B105	GNRE Table - 42	7	QC	ADDS	State	String	UDC	3	0
74	F76B132	GIA City Code - 42	1	TC	ADDS	State	String	UDC	3	0
75	F76B70	Physical and Legal Person Table - IN68 - 42	14	FJ	ADDS	State	String	UDC	3	0
76	F76B8601	IN86-Work Table for Individuals and Legal Entities - 04	10	FJ	ADDS	State	String	UDC	3	0
TOP76H: Chile
77	F76H3B31	Legal Document Header (Print Info) - CHI - 03B - 76H	14	PI	ADDS	State	String	UDC	3	0
TOPH90: ONEWORLD TOOLS
78	F012504	Focus Registration	11	FO	ADDS	State	String	UDC	3	0
TOPH91: Design Tools
79	F9801NEW	Employee Information - New Version	6	AA	ADDS	State	String	UDC	3	0
80	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	Special Handling Code	Hard Coded
1	*	All States		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

80 columns | 812 | ADDS | STOCK UDC

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