	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

44 columns | 920 | AST | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F4096	Sales Flex Accounting	2	FA	AST	Price Adjustment Name	String	UDC	8	0
TOP40: Inventory/OP Base
2	F40721	Preference Values Detail	2	PV	AST	Price Adjustment Name	String	UDC	8	0
3	F40UI74	Price Adjustment History Work File	18	AW	AST	Price Adjustment Name	String	UDC	8	0
TOP42: Sales Management
4	F4074	Price Adjustment Ledger File	12	AL	AST	Price Adjustment Name	String	UDC	8	0
5	F42565	Invoice Print File	189	IW	AST	Price Adjustment Name	String	UDC	8	0
TOP42X: In-Memory Sales Advisor
6	F42X041W	Order Upsell Item Group Opportunities WF	2	BR	AST	Price Adjustment Name	String	UDC	8	0
TOP45: Advanced Pricing
7	F4070	Price Adjustment Schedule	4	SN	AST	Price Adjustment Name	String	UDC	8	0
8	F4070P	Price Adjustment Schedule Purge	5	SN	AST	Price Adjustment Name	String	UDC	8	0
9	F4071	Price Adjustment Type	1	AT	AST	Price Adjustment Name	String	UDC	8	0
10	F4071P	Price Adjustment Type Purge	2	AT	AST	Price Adjustment Name	String	UDC	8	0
11	F4072	Price Adjustment Detail	1	AD	AST	Price Adjustment Name	String	UDC	8	0
12	F4072P	Price Adjustment Detail Purge	2	AD	AST	Price Adjustment Name	String	UDC	8	0
13	F4072W	Price Adjustment Detail Work File	1	AD	AST	Price Adjustment Name	String	UDC	8	0
14	F4073	Free Goods Master File	1	FG	AST	Price Adjustment Name	String	UDC	8	0
15	F4073P	Free Goods Master File Purge	2	FG	AST	Price Adjustment Name	String	UDC	8	0
16	F4077	Rebate Thresholds	1	RT	AST	Price Adjustment Name	String	UDC	8	0
17	F4077P	Rebate Thresholds Purge	2	RT	AST	Price Adjustment Name	String	UDC	8	0
18	F4078	Rebate Transaction Summary	6	RH	AST	Price Adjustment Name	String	UDC	8	0
19	F4079	Rebate Transaction Detail	6	SV	AST	Price Adjustment Name	String	UDC	8	0
20	F4510	Price Workbench Query Header	7	PW	AST	Price Adjustment Name	String	UDC	8	0
21	F4511W	Pricing Structure View	6	AP	AST	Price Adjustment Name	String	UDC	8	0
22	F45715	Adjustment Balances	1	AB	AST	Price Adjustment Name	String	UDC	8	0
23	F4572	Live Promotions X-Reference by Cost Type	13	XR	AST	Price Adjustment Name	String	UDC	8	0
24	F4573	Free Goods Reference File	11	RF	AST	Price Adjustment Name	String	UDC	8	0
25	F4574	Key Reference Table	20	KR	AST	Price Adjustment Name	String	UDC	8	0
26	F4575	Ship and Debit History	9	AH	AST	Price Adjustment Name	String	UDC	8	0
27	F4575TMP	Ship and Debit History - Temp Table	9	AH	AST	Price Adjustment Name	String	UDC	8	0
28	F4576	Ship and Debit Claims	8	AC	AST	Price Adjustment Name	String	UDC	8	0
29	F4576TMP	Ship and Debit Claims- Temp Table	8	AC	AST	Price Adjustment Name	String	UDC	8	0
30	F4576Z1	Ship and Debit Claims Unedited Transaction Table	21	Z1	AST	Price Adjustment Name	String	UDC	8	0
31	F4580	Price Matrix Definition	2	MX	AST	Price Adjustment Name	String	UDC	8	0
TOP47: Electronic Commerce
32	F470473	EDI Invoice Detail Charges	13	S7	AST	Price Adjustment Name	String	UDC	8	0
TOP70: Multi-National Products
33	F702018	Taxes by Sales Order Line - COMM - 42	19	TA	AST	Price Adjustment Name	String	UDC	8	0
TOP74: EMEA Localization
34	F7420034	Price Adjustment (Print Info) - COMM - 42	7	PI	AST	Price Adjustment Name	String	UDC	8	0
TOP75I: India
35	F75I006	O2C Tax Set up-IND-00	1	TS	AST	Price Adjustment Name	String	UDC	8	0
36	F75I017	Sales Order Tag File IND 42	5	SO	AST	Price Adjustment Name	String	UDC	8	0
37	F75I309	Personal Consumption - CENVAT setoff - IND - 41	33	CS	AST	Price Adjustment Name	String	UDC	8	0
38	F75I324	Work File for ARE1 ARE3 IND 42	5	Q3	AST	Price Adjustment Name	String	UDC	8	0
39	F75I354	Excise ARE3 Tag file for Form Header IND 42	5	QW	AST	Price Adjustment Name	String	UDC	8	0
40	F75I385	RG23D Register - Issues - IND - 42	21	ED	AST	Price Adjustment Name	String	UDC	8	0
41	F75I4223	Sales Tax Summary/Detail	25	SD	AST	Price Adjustment Name	String	UDC	8	0
42	F75I731	Service Tax A/R File - IND - 03B	5	ST	AST	Price Adjustment Name	String	UDC	8	0
TOP76H: Chile
43	F76H3B35	Price Adjustment (Print Info) - CHI - 03B - 76H	7	PI	AST	Price Adjustment Name	String	UDC	8	0
TOP89: Conversion Programs
44	F4072TEM	Price Adjustment Detail - Temp for Upgrade	1	AD	AST	Price Adjustment Name	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 / TY (Adjustment/Preference Name) stock values

	Value	Description	Special Handling Code	Hard Coded
1		.		N
2	3480	ship and debit
3	ACKNOTFY	Acknowledgement Notification	2
4	ADDPRICE	Additional Price Search UOM
5	ADJCALL	Adjustment for Calls
6	ADJCALL2	Adj. Calls - method of pricing
7	ADJCLM	Adjustment for Claims
8	ADJCON	Contract Adjustment
9	ADJSVOB	Adjustment Serv. Order Billing
10	ADVLOT1	adv lots ship ascending	2
11	ASNTRACK	ASN Tracking Workflow	2
12	BITEM	Bike Item Promotion		N
13	BPROMO	Bike Promotion		N
14	BREGION	Bike Regional Discounts		N
15	BRIX	Brix Adjustment
16	BSKTREPC	Basket level reprice
17	BVOL	Bike Volume Discounts		N
18	CARRIER	Carrier	2	N
19	CATVOLUM	Catalog quantity discount
20	COMISION	Accrue sales commissions
21	COMODITY	Variable price table, formula
22	COMPLEX	Complex Cat Code Discount		N
23	CTNLABEL	Carton Label	2
24	CTRMAX	Contract Maximum
25	CTRMIN	Contract Minimum
26	CUSFRT	Customer Freight	2
27	DEAL	Inventory liquidation
28	DELDATE	Delivery Date	2
29	DETAILS	Order Detail Defaults	2
30	DOCSET	Document Set	2
31	EDIASN	EDI Advanced Ship Notice	2
32	ELECCMRC	EDI Transaction Discount
33	ELECTRO	Sport drink markup		N
34	ELECTRO1	Concentrate markup		N
35	ENHBSKT	Enhanced Basket		N
36	EXTEND	Extended Terms	2
37	FMALLOC	Fulfillment Entry	2
38	FMEMAIL	Fulfillment Email Notification	2
39	FMREQDT	Requested Date Priority	2
40	FOREDATE	Create Schedule Forecast Dates	2
41	FREEFRT	Free Freight
42	FREEGOOD	Give away related goods
43	FREIGHT	Freight charge by weight
44	GENMTREF	Generic Matching Refernce	2
45	GPM	Gross Profit Margin Target	2
46	GPMARGIN	Gross Profit Margin
47	GRADE	Grade & Potency	2
48	HEADER	Order Header Defaults	2
49	HOLIDAY	Limited time offer
50	INVCOMIT	Inventory Commitment	2
51	LABEL	Labels	2
52	LABELSN	Label Serial Numbers	2
53	MAT	Matrix Adjustment
54	MIN	Minimum Adjustment
55	MISSCONF	Inventory Missing Confirmation	2
56	MOG	Material Other than Grapes
57	MOT	Mode of Transport	2
58	MSGNOTFY	Message Notification	2
59	MTXGRAPE	Grape Matrix
60	MULTUOM	Multiple UOMs
61	NEWPROD	New Product Promotion
62	NEXTSTAT	Next Order Status	2
63	NVTOL	Net Variance Tolerance	2
64	OPTEQUIP	Options and Equipment	2
65	ORDERDET	Item Clearance		N
66	ORDRPRC	Order level reprice
67	PREPDAYS	Order Prep Days	2
68	PRINTMSG	Print Messages	2
69	PROCADJ	Pay on Proceeds Adjustment
70	PRODUCT	Product line promotion		N
71	PROMCODE	Inventory Promise Code	2
72	PROMO	Item Promotion
73	PROMOTE	OEM promotion
74	PROREB	Procurement Rebate
75	REBATE	Rebate
76	REGIONAL	Regional Competition
77	REGSALES	Regional Sales Territory		N
78	RELATEUP	Related Items Upselling
79	REPASSE	Repasse Discount (Brazil)	PREPAS	N
80	RNDSTDPK	Round to Standard Pack	2
81	ROUND	Rounding Rule		N
82	ROYALTY	Accrue Manuf. License Fee
83	SAD3200	Ship and Debit Agreement 3200
84	SAD3201	Ship and Debit Agreement 3201
85	SALESCOM	Sales Commission	2
86	SAMPLEAD	Sample Adjustment		N
87	SCHFEN	Create Schedule Fences	2
88	SEASONAL	Shift timing of demand
89	SHIP	ship and debit
90	SLIDE	Sliding Rate Adjustment
91	SPDATE	Sales Price Based on Date	2
92	SPECIAL	Special discount on items		N
93	SPOSREB	Supplier Proof of Sale Rebate
94	TIERREB	Tiered Rebate
95	VOLINC	Volume Incentive Deal
96	VOLUME	Quantity Discount
97	VOLUPSEL	Volume Based Upsell
98	WSRCLM	Warranty/Supplier Rec. Claim

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

44 columns | 920 | AST | STOCK UDC

TOPUDC 40 / TY (Adjustment/Preference Name) stock values