	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

52 columns | 812 | LTTR | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP40: Inventory/OP Base
1	F4011Z	Batch Receiver File - Order Details	63	SZ	LTTR	Status Code - Last	String	UDC	3	0
2	F4012ZW	WF - Destination Quantity	11	SP	LTTR	Status Code - Last	String	UDC	3	0
3	F4013Z	Kit Components Batch File	20	KS	LTTR	Status Code - Last	String	UDC	3	0
4	F40300R	Preference Resolution History - Master	16	PM	LTTR	Status Code - Last	String	UDC	3	0
5	F40341	Preference Profile - Next Order Status	16	NS	LTTR	Status Code - Last	String	UDC	3	0
6	F40341R	Preference Resolution Ledger - Next Order Status	18	NS	LTTR	Status Code - Last	String	UDC	3	0
7	F4211Z1	Sales Order Detail Unedited Transaction File	60	SZ	LTTR	Status Code - Last	String	UDC	3	0
TOP42: Sales Management
8	F4211	Sales Order Detail File	47	SD	LTTR	Status Code - Last	String	UDC	3	0
9	F42119	Sales Order History File	47	SD	LTTR	Status Code - Last	String	UDC	3	0
10	F42199	S.O. Detail Ledger File	47	SL	LTTR	Status Code - Last	String	UDC	3	0
11	F42UI11	SO Detail Cache File (MBF)	46	ZD	LTTR	Status Code - Last	String	UDC	3	0
12	F42UI521	Pick Slips Detail File	43	S9	LTTR	Status Code - Last	String	UDC	3	0
13	F42UI800	Sales Detail Work File - Sales Update	29	SD	LTTR	Status Code - Last	String	UDC	3	0
TOP42B: Sales Order Entry
14	F42420	Audit Log Transaction	27	AL	LTTR	Status Code - Last	String	UDC	3	0
TOP43: Procurement
15	F43080	Approvals Fields Constants	56	PD	LTTR	Status Code - Last	String	UDC	3	0
16	F43092Z1	Receipt Routing Unedited Transaction Table	50	SZ	LTTR	Status Code - Last	String	UDC	3	0
17	F4311	Purchase Order Detail File	48	PD	LTTR	Status Code - Last	String	UDC	3	0
18	F4311Z	Purchase Order Generator File	52	PW	LTTR	Status Code - Last	String	UDC	3	0
19	F4311Z1	Purchase Order Detail Unedited Transaction Table	61	SZ	LTTR	Status Code - Last	String	UDC	3	0
20	F43121	Purchase Order Receiver File	25	PR	LTTR	Status Code - Last	String	UDC	3	0
21	F43121Z1	Receipts Unedited Transaction Table	42	SZ	LTTR	Status Code - Last	String	UDC	3	0
22	F4314Z	Voucher Match Selection File	124	PN	LTTR	Status Code - Last	String	UDC	3	0
23	F43199	P.O. Detail Ledger File - Flexible Version	48	OL	LTTR	Status Code - Last	String	UDC	3	0
TOP44H: Homebuilder Management
24	F44H001	HomeBuilder Constants	18	HC	LTTR	Status Code - Last	String	UDC	3	0
25	F44H0011	HomeBuilder Constants Lot Start Documents	7	LD	LTTR	Status Code - Last	String	UDC	3	0
26	F44H611	Bid Details	40	BD	LTTR	Status Code - Last	String	UDC	3	0
27	F44H611W	Bid Details Work File	44	BW	LTTR	Status Code - Last	String	UDC	3	0
28	F44H73W1	Lot Start - P.O. / Committment Generation Work File	40	CG	LTTR	Status Code - Last	String	UDC	3	0
TOP46: Warehouse Management
29	F46200	Bulk Pick Requests	17	BR	LTTR	Status Code - Last	String	UDC	3	0
30	F46200PU	Bulk Pick Requests - Purged	17	BR	LTTR	Status Code - Last	String	UDC	3	0
TOP46L: License Plating
31	F46LUI01	Assign/Remove Items To LP Work File	40	WF	LTTR	Status Code - Last	String	UDC	3	0
TOP47: Electronic Commerce
32	F47012	EDI Purchase Order Detail - Inbound	64	SZ	LTTR	Status Code - Last	String	UDC	3	0
33	F47017	EDI Purchase Order Detail - Outbound	62	SZ	LTTR	Status Code - Last	String	UDC	3	0
34	F47022	EDI P.O. Acknowledgment Detail - Inbound	62	SZ	LTTR	Status Code - Last	String	UDC	3	0
35	F47027	EDI P.O. Acknowledgment Detail - Outbound	64	SZ	LTTR	Status Code - Last	String	UDC	3	0
36	F47037	EDI Shipping Notice Detail - Outbound	64	SZ	LTTR	Status Code - Last	String	UDC	3	0
37	F470371	EDI Shipping Notice Detail - Outbound	72	SZ	LTTR	Status Code - Last	String	UDC	3	0
38	F47047	EDI Invoice Detail (Sales) - Outbound	64	SZ	LTTR	Status Code - Last	String	UDC	3	0
39	F47072	EDI Receiving Advice Detail - Inbound	63	SZ	LTTR	Status Code - Last	String	UDC	3	0
40	F47077	EDI Receiving Advice Detail - Outbound	63	SZ	LTTR	Status Code - Last	String	UDC	3	0
41	F47092	EDI Request for Quote Detail - Inbound	64	SZ	LTTR	Status Code - Last	String	UDC	3	0
42	F47097	EDI Request for Quote Detail - Outbound	62	SZ	LTTR	Status Code - Last	String	UDC	3	0
43	F47102	EDI Response to RFQ Detail - Inbound	62	SZ	LTTR	Status Code - Last	String	UDC	3	0
44	F47107	EDI Response to RFQ Detail - Outbound	64	SZ	LTTR	Status Code - Last	String	UDC	3	0
45	F47132	EDI Purchase Order Change Detail - Inbound	65	SZ	LTTR	Status Code - Last	String	UDC	3	0
46	F47137	EDI Purchase Order Change Detail - Outbound	63	SZ	LTTR	Status Code - Last	String	UDC	3	0
47	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	64	SZ	LTTR	Status Code - Last	String	UDC	3	0
48	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	66	SZ	LTTR	Status Code - Last	String	UDC	3	0
49	F47157	EDI Shipping Schedule Detail - Outbound	66	SZ	LTTR	Status Code - Last	String	UDC	3	0
TOP76B: Brazil - Reporting System Only
50	F7611B	Nota Fiscal Detail - Brazil	101	FD	LTTR	Status Code - Last	String	UDC	3	0
51	F761BA	AS Fiscal file book	80	FB	LTTR	Status Code - Last	String	UDC	3	0
TOP89: Conversion Programs
52	F43199A	Temp F43199 for ERP 9.0 Upgrade	48	OL	LTTR	Status Code - Last	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 40 / AT (Activity/Status Codes) stock values

	Value	Description	Hard Coded
1		Blank Activity/Status 40/AT	N
2	1	Purchasing Activities---------	N
3	100	Enter Purchase Requisition	N
4	110	Approved/MRP Requisition	N
5	120	Print Purchase Requisition	N
6	130	Generate PO from Requisition	N
7	140	Enter Request for Bid/Quote	N
8	160	Print Request for Bid/Quote	N
9	161	Send EDI Request for Quote	N
10	180	Enter Supplier Bid	N
11	200	Print Bid/Quote Confirmation	N
12	210	Enter Blanket Purchase Order	N
13	212	Blanket Order Print	N
14	215	Release Blanket Order	N
15	216	Order Outside Purchasing	N
16	220	Enter Purchase Order	N
17	225	Rejected Order	N
18	230	Approval Process #1	N
19	240	Print Purchase Order Proof	N
20	250	Approve Shipment/Load	N
21	260	Approve Purchase Order Proof	N
22	280	Print Purchase Order	N
23	281	Send EDI Purchase Order	N
24	282	Receive EDI P O Acknowledgment	N
25	300	Record Supplier Acknowledgment	N
26	320	Enter Change Order	N
27	325	Order Revised by Acknowledge	N
28	340	Approve Change Order	N
29	360	Print Change Order	N
30	361	Send EDI Purchase Order Change	N
31	362	Receive EDI PO Change Ack.	N
32	370	Record Supp. Ship/Frt Update	N
33	380	Print Purchase Receiver	N
34	381	Application/Certificate	N
35	400	Record Purchase Receipt	N
36	410	Back Ordered	N
37	420	Release from Inspection	N
38	425	Freight, Insurance & Expenses	N
39	430	Close Nota Fiscal	N
40	440	Record Matching Voucher	N
41	499	Canceled Line	N
42	5	Selling Activities------------	N
43	500	Enter Quote/Blanket Order	Y
44	515	Release Quote/Blanket to Order	Y
45	520	Enter Sales Order	N
46	521	Send EDI Order Acknowledgment	N
47	522	Correct EDI Order	Y
48	523	Send EDI PO Change Ack.	N
49	525	Trip Maintenance	N
50	527	Approve Shipment/Load	N
51	530	Print Control Pickslip	N
52	535	In Warehouse Management	N
53	537	Print Control Pick	Y
54	540	Print Pickslips	N
55	542	Print Loading Note	N
56	545	Picking Confirmation	N
57	550	Print Shipping Documents	N
58	555	Pack Confirmation	N
59	559	Waiting Purchase Order Receipt	Y
60	560	Shipment Confirmation	N
61	561	Send EDI Response to RFQ	N
62	563	Print Packing List/Invoice	Y
63	564	Delivery Document Selection	N
64	565	Print Delivery Documents	N
65	570	Bill of Lading	N
66	571	Send EDI Advanced Ship Notice	N
67	572	Receive EDI Receiving Advice	N
68	573	Delivery Confirm	N
69	575	Billable Freight	N
70	576	Payable Freight	N
71	577	Print Shipment Note	N
72	578	Cycle Billing	N
73	579	EDI Receiving Advice - Reject	N
74	580	Print Invoices	N
75	581	Send EDI Invoice	N
76	585	Print Interbranch Invoice	N
77	590	Print Pre-Invoice Proof	N
78	595	Generate Nota Fiscal	N
79	597	Freight, Insurance & Expenses	N
80	598	Print Nota Fiscal	N
81	600	Invoice Journal	N
82	610	Print G/L Sales Recap-Detail	N
83	615	Print G/L Sales Recap-Summary	N
84	617	Generate Tax Lines	N
85	625	End of Month Repricing	N
86	800	Direct Ship Acknowledgement	N
87	810	Print Sales Invoice	N
88	831	Invoice Error	N
89	832	Shipment Note Error	N
90	900	Backorder in S/O Entry	N
91	902	Backorder in Commitments	N
92	904	Backorder in Ship. Conf.	N
93	909	Backorder in Transportation	N
94	910	Added in Price Adjustments	N
95	912	Added in Commitments	N
96	913	Added in Pick Confirmation	N
97	914	Added in Ship. Conf.	N
98	915	Added as Replacement Item	N
99	916	Added as Subst/Associated Item	N
100	917	Added as Promotional Item	Y
101	919	Added in Transportation	N
102	920	Added in Order Repricing	N
103	922	Added in Work Order Generation	N
104	924	Added In Freight Updte	Y
105	980	Canceled in Order Entry	N
106	982	Canceled in Commitments	N
107	983	Canceled in Pick Confirmation	N
108	984	Canceled in Ship. Conf.	N
109	985	Canceled by Replacement	N
110	986	Canceled by Substitution	N
111	987	Canceled by Price Recalc.	N
112	988	Canceled in Update	N
113	989	Canceled in Transportation	N
114	990	Cancelled by Promotional Item	Y
115	995	Unapproved Load	Y
116	996	Cancelled Nota Fiscal	Y
117	997	Cancelled Nota Fiscal after ru	Y
118	998	Reversed Nota Fiscal	N
119	999	Complete - Ready to Purge	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

52 columns | 812 | LTTR | STOCK UDC

TOPUDC 40 / AT (Activity/Status Codes) stock values