	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 | BRLS | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP87: JDE Internal
1	F87SAR	SAR/Object Cross Reference	8	WS	BRLS	Base Release Number	String	UDC	10	0

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

TOPUDC 98 / RL (Software Version Release) stock values

	Value	Description	Hard Coded
1		A7.1 Base	N
2	*CURRENT	Current work in progress
3	*NEXTPTF	Next Corporate PTF
4	55IF	Prova ASU	N
5	A41	A4.1 Base
6	A41PTF1	A4.1 PTF 001
7	A42	A4.2 Base
8	A42PTF2	A4.2 PTF 002
9	A43	A4.3 Base
10	A51	A5.1 Base
11	A52	A5.2 Base
12	A61	A6.1 Base
13	A61PC000FB	A6.1 Unscheduled PTF	N
14	A62	A6.2 Base	N
15	A71	A7.1 Base
16	A71X	A7.1 Enhancements	N
17	A894	CRM 8.94 Direct Migration	N
18	A8941	CRM 8.9.4 Migration - Phase 1	N
19	A8942	CRM 8.9.4 Migration - Phase 2	N
20	A8943	CRM 8.9.4 Migration - Phase 3	N
21	A8945	CRM 8.9.4 Migration - Phase 5	N
22	A8946	CRM 8.9.4 Migration - Phase 6	N
23	A8947	CRM 8.9.4 Migration - Phase 7	N
24	B10	RELEASE 8.11	N
25	B714	B714 OneWorld	N
26	B731	B73.1 OneWorld	N
27	B7311	B73.1.1 OneWorld	N
28	B7312	B73.1.2 OneWorld	N
29	B732	B73.2 OneWorld	N
30	B7321	B73.2.1 OneWorld	N
31	B7322	B73.2.2 OneWorld	N
32	B733	B73.3 OneWorld	N
33	B7331	B73.3.1 OneWorld	N
34	B7332	B73.3.2 OneWorld	N
35	B7333	B73.3.3 OneWorld	N
36	B7333A3	ATEV3 ASU Atevnek	N
37	B7333A5	ATEV5 ASU Atevnek	N
38	B7333A6	ATEV6 ASU Atevbe	N
39	B7333A7	ATEV7 ASU Atevnek	N
40	B7333B12	BOLY12 ASU B?lynak	N
41	B7333B13	BOLY13 ASU B?lynak	N
42	B7333B14	BOLY14 ASU B?lynak	N
43	B7333B15	BOLY15 ASU B?lynak	N
44	B7333B16	BOLY16 ASU B?lynak	N
45	B7333B20	BOLY20 ASU B?lynak	N
46	B7333B21	BOLY21 ASU B?lynak	N
47	B7333B34	BOLY34ASU+NER B?lynak	N
48	B7333B35	BOLY35 ASU B?lynak	N
49	B7333B36	BOLY36 ASU B?lynak	N
50	B7333B37	BOLY37 ASU B?lynak	N
51	B7333B39	BOLY39 ASU B?lynak	N
52	B7333B4001	BOLY4001 ASU B?lynak	N
53	B7333B41	BOLY41 ASU B?lynak	N
54	B7333B42	BOLY42 ASU B?lynak	N
55	B7333B43	BOLY43 ASU B?lynak	N
56	B7333B45	BOLY45 ASU B?lynak	N
57	B7333B46	BOLY46 ASU B?lynak	N
58	B7333B47	BOLY47 ASU B?lynak	N
59	B7333B48	BOLY48 ASU B?lynak	N
60	B7333B50	BOLY50 ASU B?lynak	N
61	B7333BOLY	B?ly Software Update	N
62	B7333BOLY5	BOLY5 ASU B?lynak	N
63	B7333BOLY6	BOLY6 ASU B?lynak	N
64	B7333BOLY8	BOLY8 ASU B?lynak	N
65	B7333CAL	Calmeport	N
66	B7333DIST	DIST Software Update	N
67	B7333HB	HomeBuilder Update	N
68	B7333MFG	MFG Software Update	N
69	B7333S001	ASU Sv?jcba	N
70	B7333S04	SYN0004 ASU B?lynak	N
71	B7333S05	SYN0005 ASU	N
72	B7333S051	SYN00051 ASU	N
73	B7333S052	SYN00052 ASU	N
74	B7333S11	SYN00011 ASU	N
75	B7333S12	SYN00012 ASU	N
76	B7333S21	SYN00021 ASU	N
77	B7333S31	SYN00031 ASU	N
78	B7333SALES	Sales Software Update	N
79	B7333TAX	Tax Software Update	N
80	B7A	B7.1 OneWorld	N
81	B81	B8.1 OneWorld	N
82	B91	Release 8.10	N
83	E810	Release 8.10	N
84	E811	Release 8.11	N
85	E812	Release 8.12	N
86	SP1	8.11 SP1 Update	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 | BRLS | STOCK UDC

TOPUDC 98 / RL (Software Version Release) stock values