	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

102 columns | 910 | 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	F01161DW	Customer Alternate Address Export	13	DW	ADDS	State	String	UDC	3	0
9	F01161Z1	Batch - Alternative Address	25	LB	ADDS	State	String	UDC	3	0
10	F0117	Postal Codes	2	A8	ADDS	State	String	UDC	3	0
TOP05: Time Accounting and HRM Base
11	F054101	Employee Personal Profile Information History Table	19	EH	ADDS	State	String	UDC	3	0
12	F054101W	Employee Personal Profile Information Work Table	19	EP	ADDS	State	String	UDC	3	0
13	F054111	Employee Emergency Contact History Table	10	CH	ADDS	State	String	UDC	3	0
14	F054111W	Employee Emergency Contact Work Table	10	EC	ADDS	State	String	UDC	3	0
TOP05A: OW HR & PR Foundation
15	F05003	Verification of Employment Data	16	EV	ADDS	State	String	UDC	3	0
16	F060116Z	Unedited Quick Hire Transaction File	74	SZ	ADDS	State	String	UDC	3	0
TOP07: Payroll
17	F074001	New Hire Reporting Workfile - OneWorld Only	16	NH	ADDS	State	String	UDC	3	0
18	F07880	SUI Magnetic Media Workfile	12	YW	ADDS	State	String	UDC	3	0
19	F8907422	New Hire Detail File - Massachusetts (22)	7	MA	ADDS	State	String	UDC	3	0
20	F8907427	New Hire Detail File - Montana (27)	37	MT	ADDS	State	String	UDC	3	0
21	F8907428	New Hire Detail File - Nebraska(28)	14	NE	ADDS	State	String	UDC	3	0
22	F8907444	New Hire Detail File Transfer - Texas (44)	12	TX	ADDS	State	String	UDC	3	0
TOP08: Human Resources
23	F083305	Mail Merge Header/Detail	13	MM	ADDS	State	String	UDC	3	0
TOP08A: eRecruit
24	F08490	Recruitment Information	11	RI	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: Property 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
TOP54HS: Health & Safety Incident Mgt
63	F54HS01	Incident Master	29	S1	ADDS	State	String	UDC	3	0
64	F54HS01M	Incident Master Change History	32	I1	ADDS	State	String	UDC	3	0
65	F54HS02	Incident People	43	S2	ADDS	State	String	UDC	3	0
66	F54HS02M	Incident People Change History	46	I2	ADDS	State	String	UDC	3	0
67	F54HS03	Incident Equipment	19	S4	ADDS	State	String	UDC	3	0
68	F54HS03M	Incident Equipment Change History	22	I4	ADDS	State	String	UDC	3	0
TOP74: EMEA Localization
69	F74030	Bank ID - Italy	11	BA	ADDS	State	String	UDC	3	0
70	F7430031	Legal Document Address (Print Info) - COMM - 03B	14	PI	ADDS	State	String	UDC	3	0
TOP74Y: Italy - Reporting System Only
71	F74YUI01	Italy Legal Company WF - ITA - 74Y	12	LC	ADDS	State	String	UDC	3	0
TOP75A: Australia - Reporting System Only
72	F75A0010	Australian Employee Termination Details	60	A0	ADDS	State	String	UDC	3	0
73	F75A0220	Payment Summary Workfile	11	PS	ADDS	State	String	UDC	3	0
TOP75I: India
74	F75I100Q	TDS Form 26Q - WorkFile (Quarterly)	21	EF	ADDS	State	String	UDC	3	0
75	F75I100W	TDS Form 26 - WorkFile	21	EF	ADDS	State	String	UDC	3	0
76	F75I403	Stock Transfer Details	35	AB	ADDS	State	String	UDC	3	0
77	F75I403T	Temp Data for F75i403	35	AB	ADDS	State	String	UDC	3	0
TOP76A: Argentina
78	F76A8002	SICORE RG738 Withholding Entity - ARG - 04 - 76A	5	V3	ADDS	State	String	UDC	3	0
79	F76A82	A/P Payment Control Group File - ARG - 04 - 76A	30	C6	ADDS	State	String	UDC	3	0
TOP76B: Brazil - Reporting System Only
80	F76011	Address Book Brazilian Tag Table - 04	14	AI	ADDS	State	String	UDC	3	0
81	F76011P	Archive Address Book Brazilian Tag Table - 04	14	PR	ADDS	State	String	UDC	3	0
82	F7601B	Nota Fiscal Header - BRA - 42	24	FH	ADDS	State	String	UDC	3	0
83	F7608B	ICMS Tax Rates - 40	2	TB	ADDS	State	String	UDC	3	0
84	F76101B	Nota Fiscal - Header (Fiscal Books) - 42	25	QX	ADDS	State	String	UDC	3	0
85	F7611B	Nota Fiscal Detail - BRA - 42	51	FD	ADDS	State	String	UDC	3	0
86	F761BA	AS Fiscal file book - 09	54	FB	ADDS	State	String	UDC	3	0
87	F76B0770	ICMS Period Balance by State and Company	2	IC	ADDS	State	String	UDC	3	0
88	F76B105	GNRE Table - 42	7	QC	ADDS	State	String	UDC	3	0
89	F76B132	GIA City Code - 42	1	TC	ADDS	State	String	UDC	3	0
90	F76B70	Physical and Legal Person Table - IN68 - 42	14	FJ	ADDS	State	String	UDC	3	0
91	F76B8601	IN86-Work Table for Individuals and Legal Entities - 04	10	FJ	ADDS	State	String	UDC	3	0
TOP76H: Chile
92	F76H3B31	Legal Document Header (Print Info) - CHI - 03B - 76H	14	PI	ADDS	State	String	UDC	3	0
TOP79A: Greenhouse Gas Accounting
93	F79A09	GHG Energy Rates	26	ER	ADDS	State	String	UDC	3	0
94	F79A10	GHG Rates	30	ER	ADDS	State	String	UDC	3	0
95	F79A11	GHG Ledger	33	GR	ADDS	State	String	UDC	3	0
96	F79A11Z1	GHG Ledger - Batch File	51	GL	ADDS	State	String	UDC	3	0
97	F79A12	GHG Ledger Audit	34	GR	ADDS	State	String	UDC	3	0
98	F79A75	GHG Organization Name	10	GO	ADDS	State	String	UDC	3	0
99	F79AU11	GHG Ledger Work Table	36	GR	ADDS	State	String	UDC	3	0
TOPH90: ONEWORLD TOOLS
100	F012504	Focus Registration	11	FO	ADDS	State	String	UDC	3	0
TOPH91: Design Tools
101	F9801NEW	Employee Information - New Version	6	AA	ADDS	State	String	UDC	3	0
102	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

102 columns | 910 | ADDS | STOCK UDC

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