	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

10 columns | 920 | RTNM | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP49: Transportation Management
1	F4945	Shipment Charges	7	SC	RTNM	Rate Name	String	UDC	10	0
2	F4970	Freight Rate Schedule	3	FT	RTNM	Rate Name	String	UDC	10	0
3	F4971	Freight Rate Definition	2	RD	RTNM	Rate Name	String	UDC	10	0
4	F4972	Rate Detail	1	RX	RTNM	Rate Name	String	UDC	10	0
5	F49721	Spot Quote Detail	1	QS	RTNM	Rate Name	String	UDC	10	0
6	F4973	Rate Structure Definition	1	TL	RTNM	Rate Name	String	UDC	10	0
7	F4974	RateWare XL Rate Constants	2	RW	RTNM	Rate Name	String	UDC	10	0
8	F4977	Rate Parameters	2	MR	RTNM	Rate Name	String	UDC	10	0
9	F4981	Freight Audit History	25	FH	RTNM	Rate Name	String	UDC	10	0
TOP89: Conversion Programs
10	F49711	OBSOLETE - Freight Rate Definition - Tag File	1	RV	RTNM	Rate Name	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 49 / CN (Rate Name) stock values

	Value	Description	Hard Coded
1		.	N
2	100WT	100 Wt Postal Code Structure	N
3	100WTM	100 Wt Postal Code Min Struct	N
4	AFTHRS	After Hours Pickup/Delivery	N
5	CFM	Confirmation Call	N
6	CFMVBL	Confirmation-Verbal	N
7	COD	Collect on Delivery	N
8	CUSTOMS	Customs Fee	N
9	DISTANCE	Distance Based Freight	N
10	DRAYAGE	Drayage Charges	N
11	EURORAIL	Euro Rail Rates	N
12	EX2ND	Express Second Day	N
13	EXDOC	Export Document Fee	N
14	EXHUN	Express Hundred Wt-Standard	N
15	EXHUN2ND	Express Hundred Wt-Second Day	N
16	EXHUN2NDM	Express Hundred 2nd Minimums	N
17	EXHUNM	Express Hundred Std Minimums	N
18	EXHUNOVN	Express Hundred Wt-Overnight	N
19	EXHUNOVNM	Express Hundred Ovn Minimums	N
20	EXOVN	Express Overnight	N
21	EXPKG	Express Package Structure	N
22	EXSD	Express Same Day	N
23	EXV	Excess Value Charges	N
24	FAX	FAX Proof of Delivery	N
25	FRTFRD	International Freight Forward	N
26	HOL	Holiday Pickup/Delivery	N
27	IFFCUST	Intl' Freight Fwd Custom Fee	N
28	IFFEXDOC	Intl' Freight Fwd Exp Doc Fee	N
29	INBLTL	Inbound LTL Rate	N
30	INRTE	Rate is In Route	N
31	INS	Inside Delivery/Pickup Service	N
32	INTLOCEAN	International Ocean Freight	N
33	LGS	Liftgate Service	N
34	LMFLAT	Le Mans Flat Rates	N
35	LMPORT	Le Mans TL Port Rates	N
36	LMUNIT	Le Mans Unit Rates	N
37	NPD	Notification Prior to Delivery	N
38	NWRAIL	NW Rail	N
39	ORD	Order Notify	N
40	PCLTL	Less than Load by Postal Code	N
41	PCLTLCLIP	Less than Load Clipped	N
42	PCLTLM	Less than Load PC Minimums	N
43	PCTL	Truckload by Postal Code	N
44	PCTLM	Truckload PC Minimums	N
45	PICKUP	Pickup Charge	N
46	PICKUPR	Residential Pickup Charge	N
47	PRF	Protect From Freezing	N
48	PRORATE	Prorate Payable Charges	N
49	RES	Residential Delivery/Pickup	N
50	SAT	Saturday Pickup/Delivery	N
51	SHPNTFY	Shipment Notification	N
52	SIG	Signature Required	N
53	SUN	Sunday Pickup/Delivery	N
54	UNSCHED	Unscheduled Deliveries	N
55	USRAIL	US Rail Rates	N
56	WP	Western Parcel Structure	N
57	WP2ND	Western Parcel Second Day	N
58	WPGND	Western Parcel Ground	N
59	WPHUN2ND	Western Parcel Hundred 2nd Day	N
60	WPHUNGND	Western Parcel Hundred Ground	N
61	WPINTCWACT	Western Parcel Intl' CW Act	N
62	WPINTCWDIM	Western Parcel Intl' CW Dim	N
63	WPINTMIN	Western Parcel Intl' Minimums	N
64	WPINTPCACT	Western Parcel Intl' Piece Act	N
65	WPINTPCDIM	Western Parcel Intl' Piece Dim	N
66	ZONE	Zone Based Freight	N
67	ZONEMIN	Minimum Zone Charge	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

10 columns | 920 | RTNM | STOCK UDC

TOPUDC 49 / CN (Rate Name) stock values