	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

82 columns | 812 | 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 File	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 File	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
TOP42: Sales Management
14	F4074	Price Adjustment Ledger File	11	AL	ASN	Price and Adjustment Schedule	String	UDC	8	0
15	F4201	Sales Order Header File	31	SH	ASN	Price and Adjustment Schedule	String	UDC	8	0
16	F42019	Sales Order Header History File	31	SH	ASN	Price and Adjustment Schedule	String	UDC	8	0
17	F4211	Sales Order Detail File	92	SD	ASN	Price and Adjustment Schedule	String	UDC	8	0
18	F42119	Sales Order History File	92	SD	ASN	Price and Adjustment Schedule	String	UDC	8	0
19	F42199	S.O. Detail Ledger File	92	SL	ASN	Price and Adjustment Schedule	String	UDC	8	0
20	F42UI01	SO Header Cache File (MBF)	36	ZH	ASN	Price and Adjustment Schedule	String	UDC	8	0
21	F42UI11	SO Detail Cache File (MBF)	75	ZD	ASN	Price and Adjustment Schedule	String	UDC	8	0
22	F42UI521	Pick Slips Detail File	83	S9	ASN	Price and Adjustment Schedule	String	UDC	8	0
23	F470371T	Tag for F470371- EDI shipping Notice Detail - Outbound	7	UZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
TOP42B: Sales Order Entry
24	F42420	Audit Log Transaction	59	AL	ASN	Price and Adjustment Schedule	String	UDC	8	0
TOP43: Procurement
25	F4301	Purchase Order Header	30	PH	ASN	Price and Adjustment Schedule	String	UDC	8	0
26	F4301Z	PO Header Work File	34	PA	ASN	Price and Adjustment Schedule	String	UDC	8	0
27	F4301Z1	Purchase Order Header Unedited Transaction Table	43	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
28	F43080	Approvals Fields Constants	88	PD	ASN	Price and Adjustment Schedule	String	UDC	8	0
29	F4311	Purchase Order Detail File	82	PD	ASN	Price and Adjustment Schedule	String	UDC	8	0
30	F4311Z	Purchase Order Generator File	86	PW	ASN	Price and Adjustment Schedule	String	UDC	8	0
31	F4311Z1	Purchase Order Detail Unedited Transaction Table	95	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
32	F43121	Purchase Order Receiver File	140	PR	ASN	Price and Adjustment Schedule	String	UDC	8	0
33	F43121Z	Receiver workfile	179	PW	ASN	Price and Adjustment Schedule	String	UDC	8	0
34	F43199	P.O. Detail Ledger File - Flexible Version	82	OL	ASN	Price and Adjustment Schedule	String	UDC	8	0
TOP43C: Contracts
35	F43C10	Contract Block	28	CB	ASN	Price and Adjustment Schedule	String	UDC	8	0
36	F43C11	Contract Detail	30	CD	ASN	Price and Adjustment Schedule	String	UDC	8	0
TOP45: Advanced Pricing
37	F4070	Price Adjustment Schedule	1	SN	ASN	Price and Adjustment Schedule	String	UDC	8	0
38	F4501	Master Schedule Adjustment	4	MS	ASN	Price and Adjustment Schedule	String	UDC	8	0
39	F4510	Price Workbench Query Header	13	PW	ASN	Price and Adjustment Schedule	String	UDC	8	0
40	F4511W	Pricing Structure View	92	AP	ASN	Price and Adjustment Schedule	String	UDC	8	0
41	F45520	Price List Header	10	PH	ASN	Price and Adjustment Schedule	String	UDC	8	0
42	F4574	Key Reference Table	52	KR	ASN	Price and Adjustment Schedule	String	UDC	8	0
43	F4575	Ship and Debit History	8	AH	ASN	Price and Adjustment Schedule	String	UDC	8	0
44	F4575TMP	Ship and Debit History - Temp Table	8	AH	ASN	Price and Adjustment Schedule	String	UDC	8	0
45	F4576Z1	Ship and Debit Claims Unedited Transaction Table	107	Z1	ASN	Price and Adjustment Schedule	String	UDC	8	0
TOP47: Electronic Commerce
46	F47011	EDI Purchase Order Header - Inbound	50	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
47	F47012	EDI Purchase Order Detail - Inbound	109	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
48	F47016	EDI Purchase Order Header - Outbound	45	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
49	F47017	EDI Purchase Order Detail - Outbound	96	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
50	F47021	EDI P.O. Acknowledgment Header - Inbound	45	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
51	F47022	EDI P.O. Acknowledgment Detail - Inbound	96	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
52	F47026	EDI P.O. Acknowledgment Header - Outbound	46	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
53	F47027	EDI P.O. Acknowledgment Detail - Outbound	109	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
54	F47032T	EDI Shipping Notice Detail- Inbound Tag	2	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
55	F47041	EDI Invoice Header - Inbound	41	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
56	F47042	EDI Invoice Detail - Inbound	42	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
57	F47046	EDI Invoice Header (Sales) - Outbound	46	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
58	F47047	EDI Invoice Detail (Sales) - Outbound	109	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
59	F470473	EDI Invoice Detail Charges	12	S7	ASN	Price and Adjustment Schedule	String	UDC	8	0
60	F47071	EDI Receiving Advice Header - Inbound	46	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
61	F47072	EDI Receiving Advice Detail - Inbound	97	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
62	F47076	EDI Receiving Advice Header - Outbound	46	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
63	F47077	EDI Receiving Advice Detail - Outbound	97	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
64	F47091	EDI Request for Quote Header - Inbound	50	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
65	F47092	EDI Request for Quote Detail - Inbound	109	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
66	F47096	EDI Request for Quote Header - Outbound	45	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
67	F47097	EDI Request for Quote Detail - Outbound	96	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
68	F47101	EDI Response to RFQ Header - Inbound	45	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
69	F47102	EDI Response to RFQ Detail - Inbound	96	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
70	F47106	EDI Response to RFQ Header - Outbound	46	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
71	F47107	EDI Response to RFQ Detail - Outbound	109	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
72	F47131	EDI Purchase Order Change Header - Inbound	47	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
73	F47132	EDI Purchase Order Change Detail - Inbound	110	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
74	F47136	EDI Purchase Order Change Header - Outbound	45	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
75	F47137	EDI Purchase Order Change Detail - Outbound	97	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
76	F47141	EDI P.O. Change Acknowledgment Header - Inbound	46	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
77	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	98	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
78	F47146	EDI P.O. Change Acknowledgment Header - Outbound	47	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
79	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	111	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
80	F47156	EDI Shipping Schedule Header - Outbound	48	SY	ASN	Price and Adjustment Schedule	String	UDC	8	0
81	F47157	EDI Shipping Schedule Detail - Outbound	103	SZ	ASN	Price and Adjustment Schedule	String	UDC	8	0
TOP89: Conversion Programs
82	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 (Adjustment Schedule Name) stock values

	Value	Description	Hard Coded
1	3480	SHIP AND DEBIT 2
2	4343	Ship and Debit Agreement 4343
3	BRAZIL	Brazil Co. Pricing Schedule
4	C	Customer Discount
5	CP	Customer + Product Discount
6	D2	Euro conversion
7	FG	Free Goods
8	MFG	Manufacturing
9	NATIONAL	National Pricing
10	P	Product discount
11	PURCHSCH	Purchasing Catalog Schedule
12	SCHCALL	Schedule for calls
13	SCHCLM	Schedule for Claims
14	SCHCON	Schedule for Contracts
15	SCHSVO	Schedule for CSMS Serv. Ord.
16	SPRING	Spring Sale (Exercises)	N
17	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

82 columns | 812 | ASN | STOCK UDC

TOPUDC 40 / AS (Adjustment Schedule Name) stock values