	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

92 columns | 920 | ASN | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0401Z1	Supplier Master - Batch Upload	80	VO	ASN	Price and Adjustment Schedule	String	UDC	8	0
TOP01: Address Book
2	F0401	Supplier Master	77	A6	ASN	Price and Adjustment Schedule	String	UDC	8	0
TOP03: Accounts Receivable
3	F03012	Customer Master by Line of Business	133	AI	ASN	Price and Adjustment Schedule	String	UDC	8	0
4	F03012Z1	Customer Master LOB-Batch Table	141	VO	ASN	Price and Adjustment Schedule	String	UDC	8	0
TOP38: Agreement Management
5	F38011	Agreement Quantities	17	DF	ASN	Price and Adjustment Schedule	String	UDC	8	0
6	F38014	Agreement Formulas and Factors	10	DR	ASN	Price and Adjustment Schedule	String	UDC	8	0
TOP40: Inventory/OP Base
7	F4001Z	Batch Receiver File - Order Headings	55	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
8	F4011Z	Batch Receiver File - Order Details	108	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
9	F40314	Preference Profile - Price Adjustment Schedule	14	PJ	ASN	Price and Adjustment Schedule	String	UDC	8	0
10	F40314R	Preference Resolution Ledger - Price Adjustment Schedule	16	PJ	ASN	Price and Adjustment Schedule	String	UDC	8	0
11	F40UI74	Price Adjustment History Work File	17	AW	ASN	Price and Adjustment Schedule	String	UDC	8	0
12	F4201Z1	Sales Order Header Unedited Transaction File	44	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
13	F4211Z1	Sales Order Detail Unedited Transaction File	105	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
TOP41: Inventory Management
14	F4130	Consignment Master Header (FUTURE)	9	MH	ASN	Price and Adjustment Schedule	String	UDC	8	0
15	F4131	Consignment Master Detail (FUTURE)	9	MD	ASN	Price and Adjustment Schedule	String	UDC	8	0
TOP42: Sales Management
16	F4074	Price Adjustment Ledger File	11	AL	ASN	Price and Adjustment Schedule	String	UDC	8	0
17	F4201	Sales Order Header File	31	SH	ASN	Price and Adjustment Schedule	String	UDC	8	0
18	F42019	Sales Order Header History File	31	SH	ASN	Price and Adjustment Schedule	String	UDC	8	0
19	F4211	Sales Order Detail File	92	SD	ASN	Price and Adjustment Schedule	String	UDC	8	0
20	F42119	Sales Order History File	92	SD	ASN	Price and Adjustment Schedule	String	UDC	8	0
21	F42199	S.O. Detail Ledger File	92	SL	ASN	Price and Adjustment Schedule	String	UDC	8	0
22	F42UI01	SO Header Cache File (MBF)	36	ZH	ASN	Price and Adjustment Schedule	String	UDC	8	0
23	F42UI11	SO Detail Cache File (MBF)	75	ZD	ASN	Price and Adjustment Schedule	String	UDC	8	0
24	F42UI521	Pick Slips Detail File	83	S9	ASN	Price and Adjustment Schedule	String	UDC	8	0
25	F470371T	Tag for F470371- EDI shipping Notice Detail - Outbound	7	UZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
TOP42B: Sales Order Entry
26	F42420	Audit Log Transaction	59	AL	ASN	Price and Adjustment Schedule	String	UDC	8	0
TOP42I: Outbound Inventory Management
27	F42I07	Outbound Inventory Agreement Details Change History	18	OQ	ASN	Price and Adjustment Schedule	String	UDC	8	0
TOP43: Procurement
28	F4301	Purchase Order Header	30	PH	ASN	Price and Adjustment Schedule	String	UDC	8	0
29	F4301Z	PO Header Work File	34	PA	ASN	Price and Adjustment Schedule	String	UDC	8	0
30	F4301Z1	Purchase Order Header Unedited Transaction Table	43	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
31	F43080	Approvals Fields Constants	88	PD	ASN	Price and Adjustment Schedule	String	UDC	8	0
32	F4311	Purchase Order Detail File	82	PD	ASN	Price and Adjustment Schedule	String	UDC	8	0
33	F4311Z	Purchase Order Generator File	86	PW	ASN	Price and Adjustment Schedule	String	UDC	8	0
34	F4311Z1	Purchase Order Detail Unedited Transaction Table	95	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
35	F43121	Purchase Order Receiver File	140	PR	ASN	Price and Adjustment Schedule	String	UDC	8	0
36	F43121Z	Receiver workfile	179	PW	ASN	Price and Adjustment Schedule	String	UDC	8	0
37	F43199	P.O. Detail Ledger File - Flexible Version	82	OL	ASN	Price and Adjustment Schedule	String	UDC	8	0
TOP43C: Contracts
38	F43C10	Contract Block	28	CB	ASN	Price and Adjustment Schedule	String	UDC	8	0
39	F43C100	Contract Block Profile	50	BP	ASN	Price and Adjustment Schedule	String	UDC	8	0
40	F43C11	Contract Detail	30	CD	ASN	Price and Adjustment Schedule	String	UDC	8	0
41	F43C110	Contract Harvest Profile	40	DP	ASN	Price and Adjustment Schedule	String	UDC	8	0
TOP45: Advanced Pricing
42	F4070	Price Adjustment Schedule	1	SN	ASN	Price and Adjustment Schedule	String	UDC	8	0
43	F4070P	Price Adjustment Schedule Purge	2	SN	ASN	Price and Adjustment Schedule	String	UDC	8	0
44	F4501	Master Schedule Adjustment	4	MS	ASN	Price and Adjustment Schedule	String	UDC	8	0
45	F4510	Price Workbench Query Header	13	PW	ASN	Price and Adjustment Schedule	String	UDC	8	0
46	F4511W	Pricing Structure View	92	AP	ASN	Price and Adjustment Schedule	String	UDC	8	0
47	F45520	Price List Header	10	PH	ASN	Price and Adjustment Schedule	String	UDC	8	0
48	F4574	Key Reference Table	52	KR	ASN	Price and Adjustment Schedule	String	UDC	8	0
49	F4575	Ship and Debit History	8	AH	ASN	Price and Adjustment Schedule	String	UDC	8	0
50	F4575TMP	Ship and Debit History - Temp Table	8	AH	ASN	Price and Adjustment Schedule	String	UDC	8	0
51	F4576Z1	Ship and Debit Claims Unedited Transaction Table	107	Z1	ASN	Price and Adjustment Schedule	String	UDC	8	0
TOP47: Electronic Commerce
52	F47011	EDI Purchase Order Header - Inbound	50	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
53	F47012	EDI Purchase Order Detail - Inbound	109	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
54	F47016	EDI Purchase Order Header - Outbound	45	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
55	F47017	EDI Purchase Order Detail - Outbound	96	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
56	F47021	EDI P.O. Acknowledgment Header - Inbound	45	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
57	F47022	EDI P.O. Acknowledgment Detail - Inbound	96	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
58	F47026	EDI P.O. Acknowledgment Header - Outbound	46	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
59	F47027	EDI P.O. Acknowledgment Detail - Outbound	109	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
60	F47032T	EDI Shipping Notice Detail- Inbound Tag	2	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
61	F47041	EDI Invoice Header - Inbound	41	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
62	F47042	EDI Invoice Detail - Inbound	42	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
63	F47046	EDI Invoice Header (Sales) - Outbound	46	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
64	F47047	EDI Invoice Detail (Sales) - Outbound	109	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
65	F470473	EDI Invoice Detail Charges	12	S7	ASN	Price and Adjustment Schedule	String	UDC	8	0
66	F47071	EDI Receiving Advice Header - Inbound	46	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
67	F47072	EDI Receiving Advice Detail - Inbound	97	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
68	F47076	EDI Receiving Advice Header - Outbound	46	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
69	F47077	EDI Receiving Advice Detail - Outbound	97	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
70	F47091	EDI Request for Quote Header - Inbound	50	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
71	F47092	EDI Request for Quote Detail - Inbound	109	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
72	F47096	EDI Request for Quote Header - Outbound	45	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
73	F47097	EDI Request for Quote Detail - Outbound	96	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
74	F47101	EDI Response to RFQ Header - Inbound	45	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
75	F47102	EDI Response to RFQ Detail - Inbound	96	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
76	F47106	EDI Response to RFQ Header - Outbound	46	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
77	F47107	EDI Response to RFQ Detail - Outbound	109	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
78	F47131	EDI Purchase Order Change Header - Inbound	47	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
79	F47132	EDI Purchase Order Change Detail - Inbound	110	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
80	F47136	EDI Purchase Order Change Header - Outbound	45	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
81	F47137	EDI Purchase Order Change Detail - Outbound	97	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
82	F47141	EDI P.O. Change Acknowledgment Header - Inbound	46	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
83	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	98	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
84	F47146	EDI P.O. Change Acknowledgment Header - Outbound	47	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
85	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	111	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
86	F47156	EDI Shipping Schedule Header - Outbound	48	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
87	F47157	EDI Shipping Schedule Detail - Outbound	103	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
TOP54R: Rental Management
88	F54R099	Rental Contract Header Ledger	54	HL	ASN	Price and Adjustment Schedule	String	UDC	8	0
89	F54R10	Rental Contract Header	52	CH	ASN	Price and Adjustment Schedule	String	UDC	8	0
90	F54R11	Rental Contract Detail	86	CD	ASN	Price and Adjustment Schedule	String	UDC	8	0
91	F54R199	Rental Contract Detail Ledger	82	DL	ASN	Price and Adjustment Schedule	String	UDC	8	0
TOP89: Conversion Programs
92	F43199A	Temp F43199 for ERP 9.0 Upgrade	82	OL	ASN	Price and Adjustment Schedule	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 / AS (Schedule Name) stock values

	Value	Description	Special Handling Code	Hard Coded
1		.		Y
2	3480	SHIP AND DEBIT 2
3	4343	Ship and Debit Agreement 4343
4	ADVANCE	Preference Schedule	1
5	ADVPREF	Advanced Preference Schedule	1
6	ADVPREF2	Advanced Preference #2	1
7	BRAZIL	Brazil Co. Pricing Schedule
8	D2	Euro conversion
9	DMDSCH	Demand Schedule	1
10	FG	Free Goods
11	FMDEMO	Fulfillment Demo Schedule	1	Y
12	GLOBAL	Global Pricing
13	GRPSCHED	Grape Adjustment Schedule
14	MFG	Manufacturing
15	MMMM	mmmm	1
16	NATDIST	National Distributor		N
17	NATIONAL	National Pricing
18	POPSCH	Pay on Proceeds Schedule		N
19	PURCHSCH	Purchasing Catalog Schedule
20	SAMPLEAS	Sample Adjustment Schedule
21	SCHCALL	Schedule for calls
22	SCHCLM	Schedule for Claims
23	SCHCON	Schedule for Contracts
24	SCHSVO	Schedule for S&WM Serv. Ord.		N
25	SPRING	Spring Sale (Exercises)		N
26	WHLSDIST	Wholesale/Distributor

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

92 columns | 920 | ASN | STOCK UDC

TOPUDC 40 / AS (Schedule Name) stock values