	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

103 columns | 812 | RCTO | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F00092	Supplemental Data	13	T3	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP12: Fixed Assets
2	F1217	Equipment Master Extension	17	WR	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
3	F1217P	Equipment Master Extension Purge Table	17	WR	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
4	F1217Z1	Unedited Equipment Tag Transactions	30	WR	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
5	F1217Z2	Unedited Equipment Tag Transactions	30	WR	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP17: Customer Service Management
6	F3111Z2	Warranty Claim/Supplier Recovery processing	29	WP	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
7	F3112Z2	Warranty Claim/Supplier Recovery processing	78	WL	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
8	F4801Z2	Warranty Claim/Supplier Recovery processing	23	WS	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP17C: Call Management
9	F1755	Customer Call Master	77	ZA	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP31: Shop Floor Control
10	F3111	Work Order Parts List	16	WM	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
11	F3111S	Purge - Shop Floor Parts List	16	WM	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
12	F3111Z1	Outbound Work Order Parts List	29	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
13	F3112	Work Order Routing	66	WL	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
14	F3112S	Purge Shop Floor Control Routing Instructions	66	WL	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
15	F3112Z1	Outbound Work Order Routings	78	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
16	F3118	Shortage Maintenance Master File	12	WN	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
17	F31UI006	Line Scheduling Workbench - Work File	38	LS	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
18	F4801S	Purge - Work Order Master file	4	WA	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
19	F4801Z1	Outbound Work Order Header	23	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP31P: Engineer To Order
20	F31P10	Project Quote Header	22	PQ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
21	F31P11	Project Quote Detail	31	QP	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP34: Requirements Planning
22	F3412	MPS/MRP/DRP Lower Level Requirements File	12	MW	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP37: Quality Management
23	F3711	Test Results	5	TR	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
24	F3711Z1	Test Results Unedited Transaction Table	18	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
25	F37900	Certificate of Analysis (COA) Extract	5	TR	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP40: Inventory/OP Base
26	F4001Z	Batch Receiver File - Order Headings	35	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
27	F40051	Return Material Authorization	2	RD	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
28	F40052	Return Material Authorization Defaults	1	RV	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
29	F4011Z	Batch Receiver File - Order Details	27	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
30	F4201Z1	Sales Order Header Unedited Transaction File	25	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
31	F4211Z1	Sales Order Detail Unedited Transaction File	27	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP41: Inventory Management
32	F4118	Container Deposit File	10	CN	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
33	F41181	Container Transaction File	21	CM	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP42: Sales Management
34	F4201	Sales Order Header File	12	SH	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
35	F42019	Sales Order Header History File	12	SH	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
36	F4211	Sales Order Detail File	14	SD	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
37	F42119	Sales Order History File	14	SD	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
38	F42199	S.O. Detail Ledger File	14	SL	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
39	F42565	Invoice Print File	39	IW	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
40	F42UI01	SO Header Cache File (MBF)	17	ZH	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
41	F42UI11	SO Detail Cache File (MBF)	18	ZD	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
42	F42UI520	Pick Slips Header File	36	S8	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
43	F42UI521	Pick Slips Detail File	14	S9	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP43: Procurement
44	F4301	Purchase Order Header	11	PH	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
45	F4301Z	PO Header Work File	15	PA	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
46	F4301Z1	Purchase Order Header Unedited Transaction Table	24	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
47	F43080	Approvals Fields Constants	24	PD	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
48	F4311	Purchase Order Detail File	14	PD	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
49	F4311Z	Purchase Order Generator File	18	PW	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
50	F4311Z1	Purchase Order Detail Unedited Transaction Table	27	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
51	F43199	P.O. Detail Ledger File - Flexible Version	14	OL	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
52	F43UI50D	PO Print Detail Work File	46	PW	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
53	F43UI50H	PO Print Header Work File	41	PA	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP43E: Requisition Self Service
54	F43E121	eRequisition Receiver file	10	ER	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP43Q: Strategic Sourcing
55	F43Q50	Analyze Event Header	14	AV	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP45: Advanced Pricing
56	F4079	Rebate Transaction Detail	21	SV	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
57	F4576Z1	Ship and Debit Claims Unedited Transaction Table	131	Z1	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP47: Electronic Commerce
58	F47011	EDI Purchase Order Header - Inbound	30	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
59	F47012	EDI Purchase Order Detail - Inbound	28	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
60	F47016	EDI Purchase Order Header - Outbound	26	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
61	F47017	EDI Purchase Order Detail - Outbound	28	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
62	F47021	EDI P.O. Acknowledgment Header - Inbound	26	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
63	F47022	EDI P.O. Acknowledgment Detail - Inbound	28	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
64	F47026	EDI P.O. Acknowledgment Header - Outbound	27	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
65	F47027	EDI P.O. Acknowledgment Detail - Outbound	28	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
66	F47031	EDI Shipping Notice Header - Inbound	27	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
67	F47032	EDI Shipping Notice Detail - Inbound	31	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
68	F47037	EDI Shipping Notice Detail - Outbound	31	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
69	F470371	EDI Shipping Notice Detail - Outbound	31	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
70	F47046	EDI Invoice Header (Sales) - Outbound	27	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
71	F47047	EDI Invoice Detail (Sales) - Outbound	28	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
72	F47071	EDI Receiving Advice Header - Inbound	27	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
73	F47072	EDI Receiving Advice Detail - Inbound	29	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
74	F47076	EDI Receiving Advice Header - Outbound	27	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
75	F47077	EDI Receiving Advice Detail - Outbound	29	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
76	F47091	EDI Request for Quote Header - Inbound	30	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
77	F47092	EDI Request for Quote Detail - Inbound	28	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
78	F47096	EDI Request for Quote Header - Outbound	26	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
79	F47097	EDI Request for Quote Detail - Outbound	28	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
80	F47101	EDI Response to RFQ Header - Inbound	26	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
81	F47102	EDI Response to RFQ Detail - Inbound	28	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
82	F47106	EDI Response to RFQ Header - Outbound	27	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
83	F47107	EDI Response to RFQ Detail - Outbound	28	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
84	F47131	EDI Purchase Order Change Header - Inbound	27	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
85	F47132	EDI Purchase Order Change Detail - Inbound	29	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
86	F47136	EDI Purchase Order Change Header - Outbound	26	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
87	F47137	EDI Purchase Order Change Detail - Outbound	29	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
88	F47141	EDI P.O. Change Acknowledgment Header - Inbound	27	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
89	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	30	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
90	F47146	EDI P.O. Change Acknowledgment Header - Outbound	28	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
91	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	30	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
92	F47156	EDI Shipping Schedule Header - Outbound	27	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
93	F47157	EDI Shipping Schedule Detail - Outbound	28	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP48: Work Order Processing
94	F4801	Work Order Master File	4	WA	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
95	F48092	WO Supplemental DB User Defined	11	W8	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
96	F48UI001	X4801 Master Business Function Workfile	7	WA	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP89: Conversion Programs
97	F43199A	Temp F43199 for ERP 9.0 Upgrade	14	OL	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOPF31: Lean Transactions
98	FF31111	Lean Transaction Parts List	19	PL	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
99	FF31111S	Purge - Lean Transaction Parts List	19	PR	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
100	FF31112	Routing Transaction Table	63	EH	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
101	FF31112S	Purge - Routing Transaction Table	63	ET	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
102	FF31113	Lean Transaction Labor Detail	36	LD	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
103	FF31113S	Purge - Lean Transaction Labor Detail	36	LR	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0

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

TOPUDC 00 / DT (Document Type - All Documents) stock values

	Value	Description	Hard Coded
1	$P	Security Withholdings	Y
2	$Q	General SUSS	Y
3	%	Percentage Journal Entry	N
4	AJ	Service Billing Adjustments	Y
5	AR	Asset Revaluation	Y
6	AS	Asset Split	N
7	AT	Asset Transfer	N
8	BA	Billing Adjustments	Y
9	BF	Balance Forward/Summarize	N
10	CA	Credit Note for Aftercare	N
11	CC	Credit-Contract & Loyalty Supp	N
12	CG	Lot Grade Change	N
13	CP	Lot Potency Change	N
14	CQ	Credit Note - Quarterly Bonus	N
15	CT	Credit Note - Targeted Bonus	N
16	CW	Credit Note for Warranty	N
17	DP	Depreciation Journal	N
18	DR	Job Cost Draw Splits	Y
19	EU	Service Billing Revenue	Y
20	EX	Currency Conversion Offsets	N
21	IQ	Inventory Quantity Only	Y
22	IX	Recalculate Average Cost	N
23	IZ	Lot Hold/Release	N
24	JA	Budget or Cost Allocation	N
25	JB	Joint Interest Billing	N
26	JC	Job Cost % Complete	N
27	JD	JIB Detail Owner Entries	N
28	JE	Journal Entry	N
29	JF	Journals Brought Forward	N
30	JK	A/P Redistribute Payments	Y
31	JM	AR VAT Redistribution	Y
32	JP	Subscription Sales	N
33	JQ	Sub. Sales Net Ledger	N
34	JR	Subscription Sales Commissions	N
35	JT	Accrued Property Taxes	N
36	JV	A/P Redistribute Prepayments	Y
37	JX	Foreign Currency Revaluation	N
38	JZ	Cash Basis Journal Entry	N
39	NP	Partial NSF	Y
40	O	Ordering Document Types	N
41	O4	Purchase Order -Transportation	N
42	OA	Do Not Use	Y
43	OB	Blanket Order	N
44	OC	Construction Work Order	N
45	OD	Direct Ship Order	N
46	OE	Do Not Use--Exchange Rate Var.	N
47	OI	Interoperability Direct P.O.	N
48	OK	Purchase Intercompany Order	N
49	OM	Purchase Order RMA	N
50	OO	Outside Operations
51	OP	Purchase Order	N
52	OQ	Purchase Quote or Bid	N
53	OS	Subcontract	N
54	OU	Requisition Self Service	Y
55	OY	EDI Purchase Order Quote
56	P1	A/P Drafts	N
57	P7	Alternate Currency Payment	N
58	PA	Credit Note Reimbursements	N
59	PB	BACS Electronic Funds Transfer	N
60	PE	Change to Voucher Amount	N
61	PG	Gain/Loss on Exchange Rate	N
62	PI	Physical Inventory	N
63	PK	Automated Check	N
64	PL	Voucher Logging	N
65	PM	Manual Voucher	N
66	PN	Manual Check	N
67	PO	Void Check	N
68	PR	Recurring Voucher	N
69	PT	Electronic Funds Transfer	N
70	PW	Withholding
71	PY	Payment Order - EDI Only
72	R	Receivables	N
73	R1	A/R Drafts	N
74	R2	Contract Billing	N
75	R5	Deduction	Y
76	R6	RMA - Sales Order	Y
77	R7	Alternate Currency Receipt	N
78	RA	Adjustment	N
79	RB	Chargeback	N
80	RC	Cash Receipts	N
81	RE	Change to Invoice Amount	N
82	RF	Finance Charge	N
83	RG	Gain/Loss on Exchange Rate	N
84	RK	Cash Receipts Check	N
85	RO	Reversing or Void Entry	N
86	RQ	Chargeback Amount Created	N
87	RR	Recurring Invoice	N
88	RS	Spread Adjustments	N
89	RU	Unapplied Cash	N
90	RV	Non-sufficient Funds	N
91	RW	Balance Forward	N
92	RY	Cash Receipts - EDI Only
93	SB	Blanket Sales Order	N
94	SC	Actual Rate Schedule	N
95	SD	Direct Ship	N
96	SF	Free Goods	N
97	SI	Interbranch Sales	N
98	SQ	Sales Quote	N
99	SS	Do Not Use--Summary Records	N
100	SY	EDI Sales Order Quote	N
101	SZ	EDI Sales Order	N
102	TM	Enterprise Treasury Management	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

103 columns | 812 | RCTO | STOCK UDC

TOPUDC 00 / DT (Document Type - All Documents) stock values