	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

63 columns | 920 | NXTR | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP34X: In-Memory Planning Advisor
1	F34X200W	Planning Details Supply/Demand Work Table	92	SD	NXTR	Status Code - Next	String	UDC	3	0
TOP40: Inventory/OP Base
2	F4011Z	Batch Receiver File - Order Details	62	SZ	NXTR	Status Code - Next	String	UDC	3	0
3	F4012ZW	WF - Destination Quantity	10	SP	NXTR	Status Code - Next	String	UDC	3	0
4	F4013Z	Kit Components Batch File	21	KS	NXTR	Status Code - Next	String	UDC	3	0
5	F40203	Order Activity Rules	7	FS	NXTR	Status Code - Next	String	UDC	3	0
6	F40341	Preference Profile - Next Order Status	17	NS	NXTR	Status Code - Next	String	UDC	3	0
7	F40341R	Preference Resolution Ledger - Next Order Status	19	NS	NXTR	Status Code - Next	String	UDC	3	0
8	F4211Z1	Sales Order Detail Unedited Transaction File	59	SZ	NXTR	Status Code - Next	String	UDC	3	0
TOP41F: Apparel Management
9	FCW20	Matrix Work File	115	WX	NXTR	Status Code - Next	String	UDC	3	0
10	FCW31	Proposal Order Line Details	27	LV	NXTR	Status Code - Next	String	UDC	3	0
11	FCW64	WO Receipts Matrix Entry Work File	178	WX	NXTR	Status Code - Next	String	UDC	3	0
12	FCW91	Work File for RCW02	7	C9	NXTR	Status Code - Next	String	UDC	3	0
TOP42: Sales Management
13	F4211	Sales Order Detail File	46	SD	NXTR	Status Code - Next	String	UDC	3	0
14	F42119	Sales Order History File	46	SD	NXTR	Status Code - Next	String	UDC	3	0
15	F42199	S.O. Detail Ledger File	46	SL	NXTR	Status Code - Next	String	UDC	3	0
16	F42UI11	SO Detail Cache File (MBF)	45	ZD	NXTR	Status Code - Next	String	UDC	3	0
17	F42UI521	Pick Slips Detail File	42	S9	NXTR	Status Code - Next	String	UDC	3	0
18	F42UI800	Sales Detail Work File - Sales Update	28	SD	NXTR	Status Code - Next	String	UDC	3	0
TOP42B: Sales Order Entry
19	F42420	Audit Log Transaction	28	AL	NXTR	Status Code - Next	String	UDC	3	0
TOP42W: Fulfilment Management
20	F427UI01	Release Fulfillment Work File	16	RF	NXTR	Status Code - Next	String	UDC	3	0
TOP43: Procurement
21	F43080	Approvals Fields Constants	55	PD	NXTR	Status Code - Next	String	UDC	3	0
22	F43092Z1	Receipt Routing Unedited Transaction Table	51	SZ	NXTR	Status Code - Next	String	UDC	3	0
23	F4311	Purchase Order Detail File	47	PD	NXTR	Status Code - Next	String	UDC	3	0
24	F4311Z	Purchase Order Generator File	51	PW	NXTR	Status Code - Next	String	UDC	3	0
25	F4311Z1	Purchase Order Detail Unedited Transaction Table	60	SZ	NXTR	Status Code - Next	String	UDC	3	0
26	F43121	Purchase Order Receiver File	24	PR	NXTR	Status Code - Next	String	UDC	3	0
27	F43121Z	Receiver workfile	85	PW	NXTR	Status Code - Next	String	UDC	3	0
28	F43121Z1	Receipts Unedited Transaction Table	41	SZ	NXTR	Status Code - Next	String	UDC	3	0
29	F4314Z	Voucher Match Selection File	123	PN	NXTR	Status Code - Next	String	UDC	3	0
30	F43199	P.O. Detail Ledger File - Flexible Version	47	OL	NXTR	Status Code - Next	String	UDC	3	0
31	F43632Z	Open Purchase Order by Item Work File	26	OI	NXTR	Status Code - Next	String	UDC	3	0
TOP43S: JSSS/Supplier Self Service
32	F43001	Procurement Self-Service Transaction Log	22	SA	NXTR	Status Code - Next	String	UDC	3	0
TOP44H: Homebuilder Management
33	F44H001	HomeBuilder Constants	17	HC	NXTR	Status Code - Next	String	UDC	3	0
34	F44H0011	HomeBuilder Constants Lot Start Documents	6	LD	NXTR	Status Code - Next	String	UDC	3	0
35	F44H611	Bid Details	39	BD	NXTR	Status Code - Next	String	UDC	3	0
36	F44H611W	Bid Details Work File	43	BW	NXTR	Status Code - Next	String	UDC	3	0
37	F44H73W1	Lot Start - P.O. / Committment Generation Work File	41	CG	NXTR	Status Code - Next	String	UDC	3	0
TOP46: Warehouse Management
38	F46200	Bulk Pick Requests	18	BR	NXTR	Status Code - Next	String	UDC	3	0
39	F46200PU	Bulk Pick Requests - Purged	18	BR	NXTR	Status Code - Next	String	UDC	3	0
TOP47: Electronic Commerce
40	F47012	EDI Purchase Order Detail - Inbound	63	SZ	NXTR	Status Code - Next	String	UDC	3	0
41	F47017	EDI Purchase Order Detail - Outbound	61	SZ	NXTR	Status Code - Next	String	UDC	3	0
42	F47022	EDI P.O. Acknowledgment Detail - Inbound	61	SZ	NXTR	Status Code - Next	String	UDC	3	0
43	F47027	EDI P.O. Acknowledgment Detail - Outbound	63	SZ	NXTR	Status Code - Next	String	UDC	3	0
44	F47037	EDI Shipping Notice Detail - Outbound	63	SZ	NXTR	Status Code - Next	String	UDC	3	0
45	F470371	EDI Shipping Notice Detail - Outbound	71	SZ	NXTR	Status Code - Next	String	UDC	3	0
46	F47047	EDI Invoice Detail (Sales) - Outbound	63	SZ	NXTR	Status Code - Next	String	UDC	3	0
47	F47072	EDI Receiving Advice Detail - Inbound	62	SZ	NXTR	Status Code - Next	String	UDC	3	0
48	F47077	EDI Receiving Advice Detail - Outbound	62	SZ	NXTR	Status Code - Next	String	UDC	3	0
49	F47092	EDI Request for Quote Detail - Inbound	63	SZ	NXTR	Status Code - Next	String	UDC	3	0
50	F47097	EDI Request for Quote Detail - Outbound	61	SZ	NXTR	Status Code - Next	String	UDC	3	0
51	F47102	EDI Response to RFQ Detail - Inbound	61	SZ	NXTR	Status Code - Next	String	UDC	3	0
52	F47107	EDI Response to RFQ Detail - Outbound	63	SZ	NXTR	Status Code - Next	String	UDC	3	0
53	F47132	EDI Purchase Order Change Detail - Inbound	64	SZ	NXTR	Status Code - Next	String	UDC	3	0
54	F47137	EDI Purchase Order Change Detail - Outbound	62	SZ	NXTR	Status Code - Next	String	UDC	3	0
55	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	63	SZ	NXTR	Status Code - Next	String	UDC	3	0
56	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	65	SZ	NXTR	Status Code - Next	String	UDC	3	0
57	F47157	EDI Shipping Schedule Detail - Outbound	65	SZ	NXTR	Status Code - Next	String	UDC	3	0
TOP75I: India
58	F75I701	Bill of Entry - Header	87	QH	NXTR	Status Code - Next	String	UDC	3	0
TOP75T: Taiwan
59	F75T42W	Work file with union of F4211 and F42119	21	SW	NXTR	Status Code - Next	String	UDC	3	0
TOP76B: Brazil
60	F7611B	Nota Fiscal Detail - BRA - 42	100	FD	NXTR	Status Code - Next	String	UDC	3	0
61	F761BA	AS Fiscal file book - 09	79	FB	NXTR	Status Code - Next	String	UDC	3	0
62	F76B090	NF-e Next Status Setup - BRA - 76B	4	NS	NXTR	Status Code - Next	String	UDC	3	0
TOP89: Conversion Programs
63	F43199A	Temp F43199 for ERP 9.0 Upgrade	47	OL	NXTR	Status Code - Next	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		.	Y
2	05	PRP Order, Pre-Quote Accept	N
3	1	Purchasing Activities---------	N
4	100	Enter Purchase Requisition	Y
5	110	Approved/MRP Requisition	Y
6	120	Print Purchase Requisition	Y
7	130	Generate PO from Requisition	Y
8	140	Enter Request for Bid/Quote	N
9	160	Print Request for Bid/Quote	N
10	161	Send EDI Request for Quote	N
11	180	Enter Supplier Bid	N
12	200	Print Bid/Quote Confirmation	N
13	210	Enter Blanket Purchase Order	Y
14	215	Release Blanket Order	Y
15	216	Preliminary Order Created	Y
16	220	Enter Purchase Order	Y
17	225	Rejected Order	Y
18	230	Approval Process	Y
19	240	Print Purchase Order Proof	N
20	245	Awaiting Acknowledgement	Y
21	250	Approve Shipment/Load	Y
22	260	Approve Purchase Order Proof	N
23	280	Print Purchase Order	Y
24	281	Send EDI Purchase Order	N
25	282	Receive EDI P O Acknowledgment	N
26	300	Record Supplier Acknowledgemen	Y
27	320	Enter Change Order	N
28	325	Order Revised by Ack.	Y
29	340	Approve Change Order	N
30	360	Print Change Order	N
31	361	Send EDI Purchase Order Change	N
32	362	Receive EDI Change Ack.	Y
33	370	Record Supplier Shipment	Y
34	380	Print Purchase Receiver	Y
35	381	Application Certificate	N
36	400	Record Purchase Receipt	Y
37	410	Back Ordered	N
38	420	Release from Inspection	N
39	425	Freight, Insurance & Expenses	N
40	430	Close Nota Fiscal	N
41	440	Record Matching Voucher	N
42	499	Canceled Line	N
43	5	Selling Activities------------	N
44	500	Enter Quote/Blanket Order	Y
45	515	Release Quote/Blanket to Order	Y
46	520	Enter Order/Receive EDI Order	Y
47	521	Review EDI/Uploaded Order	Y
48	522	Correct EDI Order	Y
49	523	Send EDI Change Acknowledgemen	Y
50	524	In Fulfillment	N
51	525	Print Acknowledgement / Send E	Y
52	527	Approve Shipment/Load	N
53	530	Work Order Created	Y
54	535	In Warehouse	Y
55	536	Approve Shipment	N
56	537	Print Control Pick	Y
57	540	Print Pick	Y
58	542	Print Loading Note	N
59	545	Pick Confirmation	Y
60	550	Print Shipping Documents	N
61	555	Pack Confirmation	Y
62	559	Waiting Purchase Order Receipt	Y
63	56*	Transportation Confirmed	Y
64	560	Ship Confirmation	Y
65	561	Send EDI Response to RFQ	N
66	562	Print Packing List/Invoice	Y
67	563	Print Packing List/Invoice	Y
68	564	Delivery Document Selection	N
69	565	Print Delivery Notes	Y
70	570	Print Bill of Lading	Y
71	571	Send EDI Advanced Ship Notice	N
72	572	Receive EDI Receiving Advice	N
73	573	Delivery Confirm	N
74	574	Normal Generate XML	N
75	575	Cycle Billing	Y
76	576	Send EDI Advanced Ship Notice	Y
77	577	Receive EDI Receiving Advice	Y
78	578	EDI Receiving Advice Reject	Y
79	579	Pending Revenue Recognition	Y
80	580	Print Invoices	Y
81	581	Send EDI Invoice	N
82	585	Print Interbranch Invoice	Y
83	590	Print Pre-Invoice Proof	N
84	595	Generate Nota Fiscal	N
85	597	Freight, Insurance & Expenses	N
86	598	Print Nota Fiscal	N
87	600	Invoice Journal	N
88	610	Print G/L Sales Recap-Detail	N
89	615	Print G/L Sales Recap-Summary	N
90	617	Generate Tax Lines	N
91	620	Sales Update	Y
92	625	End of Month Repricing	N
93	800	Direct Ship Acknowledgement	N
94	810	Print Sales Invoice	N
95	831	Invoice Error	N
96	832	Shipment Note Error	N
97	900	Backorder in S/O Entry	N
98	902	Backorder in Commitments	N
99	904	Backorder in Ship. Conf.	N
100	909	Backorder in Transportation	N
101	910	Added in Price Adjustments	N
102	912	Added in Commitments	N
103	913	Added in Pick Confirmation	N
104	914	Added in Ship. Conf.	N
105	915	Added as Replacement Item	N
106	916	Added as Subst/Associated Item	N
107	917	Added as Promotional Item	Y
108	918	Added in Transpo Arrange Impor	Y
109	919	Added in Transportation	N
110	920	Added in Order Repricing	N
111	922	Added in Work Order Generation	N
112	924	Added In Freight Update	Y
113	925	Added in Transpo Confirm Impor	Y
114	926	Added in Fulfillment Release	N
115	980	Canceled in Order Entry	N
116	981	Canceled in Fulfillment Releas	N
117	982	Canceled in Commitments	N
118	983	Canceled in Pick Confirmation	N
119	984	Canceled in Ship. Conf.	N
120	985	Canceled by Replacement	N
121	986	Canceled by Substitution	N
122	987	Canceled by Price Recalc.	N
123	988	Canceled in Update	N
124	989	Canceled in Transportation	N
125	990	Cancelled by Promotional Item	Y
126	991	Cancelled due to BOM	Y
127	995	Unapproved Load	Y
128	996	Cancelled Nota Fiscal	Y
129	997	Cancelled Nota Fiscal after ru	Y
130	998	Reversed Nota Fiscal	N
131	999	Complete - Ready to Purge	Y

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

63 columns | 920 | NXTR | STOCK UDC

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