	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

61 columns | 812 | PRGR | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP17C: Call Management
1	F17111	Base Warranty Defaults	11	BC	PRGR	Item Price Group	String	UDC	8	0
TOP40: Inventory/OP Base
2	F4011Z	Batch Receiver File - Order Details	109	SZ	PRGR	Item Price Group	String	UDC	8	0
3	F4012ZW	WF - Destination Quantity	42	SP	PRGR	Item Price Group	String	UDC	8	0
4	F4094	Item/Customer Key ID Master File	1	KI	PRGR	Item Price Group	String	UDC	8	0
5	F40941	Item Key ID Master File	1	IK	PRGR	Item Price Group	String	UDC	8	0
6	F4211Z1	Sales Order Detail Unedited Transaction File	106	SZ	PRGR	Item Price Group	String	UDC	8	0
TOP41: Inventory Management
7	F4101	Item Master	31	IM	PRGR	Item Price Group	String	UDC	8	0
8	F4101A	Item File	19	IM	PRGR	Item Price Group	String	UDC	8	0
9	F4101Z1	F4101 Item Master Unedited Transaction Table	46	SZ	PRGR	Item Price Group	String	UDC	8	0
10	F4102	Item Branch File	54	IB	PRGR	Item Price Group	String	UDC	8	0
11	F41UI001	Inventory Transactions Detail File	71	IT	PRGR	Item Price Group	String	UDC	8	0
TOP42: Sales Management
12	F4211	Sales Order Detail File	93	SD	PRGR	Item Price Group	String	UDC	8	0
13	F42119	Sales Order History File	93	SD	PRGR	Item Price Group	String	UDC	8	0
14	F42199	S.O. Detail Ledger File	93	SL	PRGR	Item Price Group	String	UDC	8	0
15	F42UI12	Sales Order Detail Cache 2 (MBF)	30	ZD	PRGR	Item Price Group	String	UDC	8	0
16	F42UI130	Commitment Work File	39	ZC	PRGR	Item Price Group	String	UDC	8	0
17	F42UI521	Pick Slips Detail File	84	S9	PRGR	Item Price Group	String	UDC	8	0
18	F42UI800	Sales Detail Work File - Sales Update	42	SD	PRGR	Item Price Group	String	UDC	8	0
19	F470371T	Tag for F470371- EDI shipping Notice Detail - Outbound	48	UZ	PRGR	Item Price Group	String	UDC	8	0
TOP42B: Sales Order Entry
20	F42420	Audit Log Transaction	60	AL	PRGR	Item Price Group	String	UDC	8	0
TOP43: Procurement
21	F43080	Approvals Fields Constants	89	PD	PRGR	Item Price Group	String	UDC	8	0
22	F4311	Purchase Order Detail File	83	PD	PRGR	Item Price Group	String	UDC	8	0
23	F4311Z	Purchase Order Generator File	87	PW	PRGR	Item Price Group	String	UDC	8	0
24	F4311Z1	Purchase Order Detail Unedited Transaction Table	96	SZ	PRGR	Item Price Group	String	UDC	8	0
25	F43199	P.O. Detail Ledger File - Flexible Version	83	OL	PRGR	Item Price Group	String	UDC	8	0
TOP45: Advanced Pricing
26	F4071	Price Adjustment Type	2	AT	PRGR	Item Price Group	String	UDC	8	0
27	F4094TEM	ICID Conversion X-Ref	2	TC	PRGR	Item Price Group	String	UDC	8	0
28	F4510	Price Workbench Query Header	6	PW	PRGR	Item Price Group	String	UDC	8	0
29	F4511W	Pricing Structure View	7	AP	PRGR	Item Price Group	String	UDC	8	0
30	F4550	Basket Master Header	1	BH	PRGR	Item Price Group	String	UDC	8	0
31	F4551	Basket Master Detail	1	BD	PRGR	Item Price Group	String	UDC	8	0
32	F4574	Key Reference Table	88	KR	PRGR	Item Price Group	String	UDC	8	0
33	F4575	Ship and Debit History	16	AH	PRGR	Item Price Group	String	UDC	8	0
34	F4575TMP	Ship and Debit History - Temp Table	16	AH	PRGR	Item Price Group	String	UDC	8	0
35	F4576	Ship and Debit Claims	17	AC	PRGR	Item Price Group	String	UDC	8	0
36	F4576TMP	Ship and Debit Claims- Temp Table	17	AC	PRGR	Item Price Group	String	UDC	8	0
37	F4576Z1	Ship and Debit Claims Unedited Transaction Table	30	Z1	PRGR	Item Price Group	String	UDC	8	0
TOP47: Electronic Commerce
38	F47012	EDI Purchase Order Detail - Inbound	110	SZ	PRGR	Item Price Group	String	UDC	8	0
39	F47017	EDI Purchase Order Detail - Outbound	97	SZ	PRGR	Item Price Group	String	UDC	8	0
40	F47022	EDI P.O. Acknowledgment Detail - Inbound	97	SZ	PRGR	Item Price Group	String	UDC	8	0
41	F47027	EDI P.O. Acknowledgment Detail - Outbound	110	SZ	PRGR	Item Price Group	String	UDC	8	0
42	F47032T	EDI Shipping Notice Detail- Inbound Tag	22	SZ	PRGR	Item Price Group	String	UDC	8	0
43	F47047	EDI Invoice Detail (Sales) - Outbound	110	SZ	PRGR	Item Price Group	String	UDC	8	0
44	F47072	EDI Receiving Advice Detail - Inbound	98	SZ	PRGR	Item Price Group	String	UDC	8	0
45	F47077	EDI Receiving Advice Detail - Outbound	98	SZ	PRGR	Item Price Group	String	UDC	8	0
46	F47092	EDI Request for Quote Detail - Inbound	110	SZ	PRGR	Item Price Group	String	UDC	8	0
47	F47097	EDI Request for Quote Detail - Outbound	97	SZ	PRGR	Item Price Group	String	UDC	8	0
48	F47102	EDI Response to RFQ Detail - Inbound	97	SZ	PRGR	Item Price Group	String	UDC	8	0
49	F47107	EDI Response to RFQ Detail - Outbound	110	SZ	PRGR	Item Price Group	String	UDC	8	0
50	F47132	EDI Purchase Order Change Detail - Inbound	111	SZ	PRGR	Item Price Group	String	UDC	8	0
51	F47137	EDI Purchase Order Change Detail - Outbound	98	SZ	PRGR	Item Price Group	String	UDC	8	0
52	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	99	SZ	PRGR	Item Price Group	String	UDC	8	0
53	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	112	SZ	PRGR	Item Price Group	String	UDC	8	0
54	F47157	EDI Shipping Schedule Detail - Outbound	104	SZ	PRGR	Item Price Group	String	UDC	8	0
TOP48S: Service Billing
55	F48096	Billing Rate / Mark up Table	22	WQ	PRGR	Item Price Group	String	UDC	8	0
56	F4812	Billing Detail Workfile	165	WD	PRGR	Item Price Group	String	UDC	8	0
57	F4812H	Billing Workfile - History	165	WD	PRGR	Item Price Group	String	UDC	8	0
58	F4812HS	Billing Workfile History Purged Save	165	WD	PRGR	Item Price Group	String	UDC	8	0
59	F48SUI01	Billing Detail Print Workfile	165	WD	PRGR	Item Price Group	String	UDC	8	0
TOP52: Contract Billing
60	F5212	T and M - Unit Price and Lumpsum Cross Reference Accounts	23	G5	PRGR	Item Price Group	String	UDC	8	0
TOP89: Conversion Programs
61	F43199A	Temp F43199 for ERP 9.0 Upgrade	83	OL	PRGR	Item Price Group	String	UDC	8	0

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

TOPUDC 40 / PI (Item Price Groups) stock values

	Value	Description	Special Handling Code	Hard Coded
1

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

61 columns | 812 | PRGR | STOCK UDC

TOPUDC 40 / PI (Item Price Groups) stock values