	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

3 columns | 920 | ZW04 | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP74: EMEA Localization
1	F7404572	Detail Payment Instructions for German Payments	10	KL	ZW04	Code Number - Z1 Record 'W' element 04	Numeric	UDC	3	0
2	F7404573	Detail Payment Instructions EXT. for German Payments	16	KI	ZW04	Code Number - Z1 Record 'W' element 04	Numeric	UDC	3	0
TOP74D: Germany
3	F74030G	Germany-Bank Transit Number Master - Addtl Informatio - 04	12	AY	ZW04	Code Number - Z1 Record 'W' element 04	Numeric	UDC	3	0

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 74 / 30 (Code Number) stock values

	Value	Description	Special Handling Code	Hard Coded
1	000	.	N	N
2	014	Transp by domes air carrier	N	N
3	015	Transp by foreign air carr	N	N
4	016	Transp by oth carrrier	N	N
5	017	Trav exp resid fore trav:agen	N	N
6	020	Transp by foreign carr	N	N
7	201	Cargo of inland ship - Rev	N	N
8	205	Air cargo-Revof dom air carri	N	N
9	210	Sea cargo as Germ imports-exp	N	N
10	220	Sea cargo as Germ exports-Exp	N	N
11	230	Cargo of inland ship - Exp	N	N
12	240	Ground cargo	N	N
13	243	Air cargo-Exp of dom air carri	N	N
14	244	Air cargo-Exp to fore air carr	N	N
15	245	Transp by pipeline	N	N
16	250	Addit serv on Germ trans trade	N	N
17	260	Transp f oth reas(fairs goods)	N	N
18	270	Air cargos-Exp	N	N
19	271	Cargos-Exp to foreign carr	N	N
20	310	Sea shipp (gen cost)	N	N
21	320	Inland shipp,road cargo traffi	N	N
22	330	Resid firms in fore trade exp	N	N
23	360	Air carriers	N	N
24	361	Air carr exp for goods deliver	N	N
25	362	Inl shipp&road cargo exp(fuel)	N	N
26	400	Life insurance	N	N
27	410	Transp insu for impor	N	N
28	411	Transp insu for expor	N	N
29	420	Oth insu dealings	N	N
30	440	Life insurance	N	N
31	441	Trans insu for imp+exports	N	N
32	442	Other insurance	N	N
33	443	Life insurance	N	N
34	444	Transp insu for Germ imp+expor	N	N
35	445	Other insurance	N	N
36	450	Run off deal-premium paym	N	N
37	451	Flow in deal-damag paym	N	N
38	501	Artistic,copyright,designs	N	N
39	502	Patents,licenses,proced	N	N
40	503	Oth rights(trademark,franch)	N	N
41	510	TV(prod costs,salaries)	N	N
42	511	Research&dev services	N	N
43	512	Engineering&other tech servi	N	N
44	513	Electr data proc servic	N	N
45	514	Free-lance tasks	N	N
46	516	Commerc,proced,admin service	N	N
47	517	Staff leasing-proport labo cos	N	N
48	518	Communic services	N	N
49	519	Oth compens for indepen work	N	N
50	521	Compens for assisted work	N	N
51	522	Exp for compa pension,retireme	N	N
52	523	Commissions	N	N
53	530	Subsidies to branch office	N	N
54	531	Overhead of branch office	N	N
55	533	Financ services	N	N
56	534	Disposal services	N	N
57	540	Advertis for fairs	N	N
58	560	Repair of boats,air carr	N	N
59	561	Repair of buildings	N	N
60	562	Repair of imp/exp goods	N	N
61	570	Exp to non-res f construc here	N	N
62	580	Exp for construc abroad	N	N
63	591	Postal,parcel,courier serv	N	N
64	594	Rent/Operat leasing	N	N
65	595	Oth services	N	N
66	598	Purch of import goods	N	N
67	600	Exchange of goods	N	N
68	601	Turnover tax at import	N	N
69	610	Exchange of services	N	N
70	720	Reparation paym	N	N
71	725	Remission of debt of publ offi	N	N
72	727	Debt remission	N	N
73	730	Equalization of paym	N	N
74	731	Subventions,donat	N	N
75	740	Transf to/fro internatl org	N	N
76	750	Exp to dev aid by federation	N	N
77	751	Exp to dev aid by church offic	N	N
78	752	Exp to dev aid by oth(founda)	N	N
79	753	Exp to dev aid by provinces	N	N
80	760	Fed exp for oth transf	N	N
81	761	Exp of provinc for transfer	N	N
82	762	Rev/forward of income tax	N	N
83	763	Rev/forwa of capital yields	N	N
84	764	Rev/forwa VAT	N	N
85	765	Rev/forwa trade tax	N	N
86	810	Exp to non-res public authori	N	N
87	850	Inheritanc,dowry paym	N	N
88	851	Financ aid,free grants	N	N
89	852	Paym from instit o priv dev ai	N	N
90	854	Indemnity,fines	N	N
91	861	Transfer back of foreign labor	N	N
92	900	Oth payments	N	N
93	997	Other exch of goods	N	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

3 columns | 920 | ZW04 | STOCK UDC

TOPUDC 74 / 30 (Code Number) stock values