	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

135 columns | 920 | EXDJ

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP01: Address Book
1	F01505	Tier Descriptions	6	TD	EXDJ	Date - Expired	Date	Generic Edit	6	0
TOP09E: Expense Reimbursment
2	F09E108	Policy Edit Rules	8	PR	EXDJ	Date - Expired	Date	Generic Edit	6	0
TOP37: Quality Management
3	F37014	Test Result Conversions	5	RC	EXDJ	Date - Expired	Date	Generic Edit	6	0
4	F37015	Test Result Conversion Tables	6	CT	EXDJ	Date - Expired	Date	Generic Edit	6	0
5	F40318	Preference Profile - Quality Management	6	QC	EXDJ	Date - Expired	Date	Generic Edit	6	0
TOP38: Agreement Management
6	F38010	Agreement Master	17	DN	EXDJ	Date - Expired	Date	Generic Edit	6	0
7	F38011	Agreement Quantities	15	DF	EXDJ	Date - Expired	Date	Generic Edit	6	0
8	F38012	Product Source/Destination Master	20	DP	EXDJ	Date - Expired	Date	Generic Edit	6	0
9	F38013	Agreement Quantities Schedule	7	DQ	EXDJ	Date - Expired	Date	Generic Edit	6	0
10	F38014	Agreement Formulas and Factors	22	DR	EXDJ	Date - Expired	Date	Generic Edit	6	0
TOP40: Inventory/OP Base
11	F4015	Order Templates	12	OT	EXDJ	Date - Expired	Date	Generic Edit	6	0
12	F4016	Print Messages	4	TU	EXDJ	Date - Expired	Date	Generic Edit	6	0
13	F40301	Preference Profile - Payment Terms	6	PT	EXDJ	Date - Expired	Date	Generic Edit	6	0
14	F40301R	Preference Resolution Ledger - Payment Terms	8	PT	EXDJ	Date - Expired	Date	Generic Edit	6	0
15	F40302	Preference Profile - Unit of Measure	6	PU	EXDJ	Date - Expired	Date	Generic Edit	6	0
16	F40302R	Preference Resolution Ledger - Pricing Unit Of Measure	8	PU	EXDJ	Date - Expired	Date	Generic Edit	6	0
17	F40303	Preference Profile - Revenue Cost Center	6	RV	EXDJ	Date - Expired	Date	Generic Edit	6	0
18	F40303R	Preference Resolution Ledger - Revenue Business Unit	8	RV	EXDJ	Date - Expired	Date	Generic Edit	6	0
19	F40304	Preference Profile - End Use	6	PE	EXDJ	Date - Expired	Date	Generic Edit	6	0
20	F40304R	Preference Resolution Ledger - End Use	8	PE	EXDJ	Date - Expired	Date	Generic Edit	6	0
21	F40305	Preference Profile - Print Messages	6	RM	EXDJ	Date - Expired	Date	Generic Edit	6	0
22	F40305R	Preference Resolution Ledger - Print Messages	8	RM	EXDJ	Date - Expired	Date	Generic Edit	6	0
23	F40306	Preference Profile - Inventory Sourcing	6	SR	EXDJ	Date - Expired	Date	Generic Edit	6	0
24	F40307	Preference Profile - Product Allocations	6	LA	EXDJ	Date - Expired	Date	Generic Edit	6	0
25	F40308	Preference Profile - Grade and Potency	6	GS	EXDJ	Date - Expired	Date	Generic Edit	6	0
26	F40308R	Preference Resolution Ledger - Grade and Potency	8	GS	EXDJ	Date - Expired	Date	Generic Edit	6	0
27	F40309	Preference Profile - Delivery Date	6	DY	EXDJ	Date - Expired	Date	Generic Edit	6	0
28	F40309R	Preference Resolution Ledger - Delivery Date	8	DY	EXDJ	Date - Expired	Date	Generic Edit	6	0
29	F40310	Preference Profile - Line of Business	6	LB	EXDJ	Date - Expired	Date	Generic Edit	6	0
30	F40310R	Preference Resolution Ledger - Line Of Business	8	LB	EXDJ	Date - Expired	Date	Generic Edit	6	0
31	F40311	Preference Profile - Price Code 1	6	P1	EXDJ	Date - Expired	Date	Generic Edit	6	0
32	F40311R	Preference Resolution Ledger - User Defined Price Code #1	8	P1	EXDJ	Date - Expired	Date	Generic Edit	6	0
33	F40312	Preference Profile - Price Code 2	6	P2	EXDJ	Date - Expired	Date	Generic Edit	6	0
34	F40312R	Preference Resolution Ledger - User Defined Price Code #2	8	P2	EXDJ	Date - Expired	Date	Generic Edit	6	0
35	F40313	Preference Profile - Price Code 3	6	P3	EXDJ	Date - Expired	Date	Generic Edit	6	0
36	F40313R	Preference Resolution Ledger - User Defined Price Code #3	8	P3	EXDJ	Date - Expired	Date	Generic Edit	6	0
37	F40314	Preference Profile - Price Adjustment Schedule	6	PJ	EXDJ	Date - Expired	Date	Generic Edit	6	0
38	F40314R	Preference Resolution Ledger - Price Adjustment Schedule	8	PJ	EXDJ	Date - Expired	Date	Generic Edit	6	0
39	F40315	Preference Profile - Invoice Cycling	6	PI	EXDJ	Date - Expired	Date	Generic Edit	6	0
40	F40315R	Preference Resolution Ledger - Invoice Cycle	8	PI	EXDJ	Date - Expired	Date	Generic Edit	6	0
41	F40316	Preference Profile - Order Preparation	6	OP	EXDJ	Date - Expired	Date	Generic Edit	6	0
42	F40316R	Preference Resolution Ledger - Order Preparation Days	8	OP	EXDJ	Date - Expired	Date	Generic Edit	6	0
43	F40318R	Preference Resolution Ledger - Quality Management	8	QC	EXDJ	Date - Expired	Date	Generic Edit	6	0
44	F40320	Preference Profile - Multi Shipping/Receiving Locations	6	LP	EXDJ	Date - Expired	Date	Generic Edit	6	0
45	F40320R	Preference Resolution Ledger - Multi ShiP/Rec Locations	7	LP	EXDJ	Date - Expired	Date	Generic Edit	6	0
46	F40329	Preference Profile - Document Distribution	6	DD	EXDJ	Date - Expired	Date	Generic Edit	6	0
47	F40330	Preference Profile - Document Set	6	DG	EXDJ	Date - Expired	Date	Generic Edit	6	0
48	F40331	Preference Profile - Options and Equipment	6	OE	EXDJ	Date - Expired	Date	Generic Edit	6	0
49	F40332	Preference Profile - Customer Freight	6	CF	EXDJ	Date - Expired	Date	Generic Edit	6	0
50	F40333	Preference Profile - Carrier	6	CA	EXDJ	Date - Expired	Date	Generic Edit	6	0
51	F40334	Preference Profile - Mode of Transport	6	MT	EXDJ	Date - Expired	Date	Generic Edit	6	0
52	F40338	Preference Profile - Payment Terms (Branch)	6	PT	EXDJ	Date - Expired	Date	Generic Edit	6	0
53	F40338R	Preference Resolution Ledger - Payment Terms (Branch)	8	PT	EXDJ	Date - Expired	Date	Generic Edit	6	0
54	F40339	Preference Profile - Product Allocations (Branch)	6	LA	EXDJ	Date - Expired	Date	Generic Edit	6	0
55	F40341	Preference Profile - Next Order Status	6	NS	EXDJ	Date - Expired	Date	Generic Edit	6	0
56	F40341R	Preference Resolution Ledger - Next Order Status	8	NS	EXDJ	Date - Expired	Date	Generic Edit	6	0
57	F40344	Preference Profile - Sales Commission	6	SA	EXDJ	Date - Expired	Date	Generic Edit	6	0
58	F40344R	Preference Resolution Ledger - Sales Commission	8	SA	EXDJ	Date - Expired	Date	Generic Edit	6	0
59	F40345	Preference Profile - Customer Currency	6	CR	EXDJ	Date - Expired	Date	Generic Edit	6	0
60	F40345R	Preference Resolution Ledger - Customer Currency	8	CR	EXDJ	Date - Expired	Date	Generic Edit	6	0
61	F40347	Preference Profile - Pricing UOM (Branch)	6	RI	EXDJ	Date - Expired	Date	Generic Edit	6	0
62	F40347R	Preference Resolution Ledger - Pricing UOM (Branch)	8	RI	EXDJ	Date - Expired	Date	Generic Edit	6	0
63	F40349	Preference Profile - Revenue Business Unit (Branch)	6	RV	EXDJ	Date - Expired	Date	Generic Edit	6	0
64	F40349R	Preference Resolution Ledger - Revenue Bus Unit (Branch)	8	RV	EXDJ	Date - Expired	Date	Generic Edit	6	0
65	F40350	Preference Profiles - Conatiner Deposit/Rental	6	OQ	EXDJ	Date - Expired	Date	Generic Edit	6	0
66	F40P01	Promotion Header File	7	PH	EXDJ	Date - Expired	Date	Generic Edit	6	0
67	F40P011	Promotion Deal Detail File	24	PD	EXDJ	Date - Expired	Date	Generic Edit	6	0
68	F40UI002	Supplier History Rebuild -workfile	12	UT	EXDJ	Date - Expired	Date	Generic Edit	6	0
69	F40UI17	Allocation Work File	16	ZG	EXDJ	Date - Expired	Date	Generic Edit	6	0
70	F4104	Item Cross Reference File	4	IV	EXDJ	Date - Expired	Date	Generic Edit	6	0
71	F4106	Item Base Price File	15	BP	EXDJ	Date - Expired	Date	Generic Edit	6	0
72	F4106NC	Base Price Extraction	21	SZ	EXDJ	Date - Expired	Date	Generic Edit	6	0
73	F49085	Scheduled Invoice Date	4	ID	EXDJ	Date - Expired	Date	Generic Edit	6	0
TOP41F: Apparel Management
74	FCW11	Item Base Price File Work File	14	WP	EXDJ	Date - Expired	Date	Generic Edit	6	0
75	FCW16	Work File F4016	6	WF	EXDJ	Date - Expired	Date	Generic Edit	6	0
76	FCW33	Price List Header	11	PH	EXDJ	Date - Expired	Date	Generic Edit	6	0
77	FCW70	Supplier Price/Catalog File - Header	7	CB	EXDJ	Date - Expired	Date	Generic Edit	6	0
78	FCW71	Supplier Price/Catalog File - Detail	29	CB	EXDJ	Date - Expired	Date	Generic Edit	6	0
79	FCW93	Copy to Outsource Operations for Style Items	14	ST	EXDJ	Date - Expired	Date	Generic Edit	6	0
TOP42: Sales Management
80	F42430	Customer Set	4	CS	EXDJ	Date - Expired	Date	Generic Edit	6	0
TOP42B: Sales Order Entry
81	F42440	Customer Segment Items	10	CS	EXDJ	Date - Expired	Date	Generic Edit	6	0
82	F42UI440	Customer Segment Items - Work File	11	CS	EXDJ	Date - Expired	Date	Generic Edit	6	0
TOP42I: Outbound Inventory Management
83	F42I06	Outbound Inventory Agreement Master Change History	18	OH	EXDJ	Date - Expired	Date	Generic Edit	6	0
84	F42I07	Outbound Inventory Agreement Details Change History	16	OQ	EXDJ	Date - Expired	Date	Generic Edit	6	0
TOP42W: Fulfilment Management
85	F4277760	Service Level Rule Setup	8	SR	EXDJ	Date - Expired	Date	Generic Edit	6	0
TOP43: Procurement
86	F41061	Supplier Price/Catalog File	18	CB	EXDJ	Date - Expired	Date	Generic Edit	6	0
87	F4340	Purchase Rebate Master File	6	RD	EXDJ	Date - Expired	Date	Generic Edit	6	0
TOP45: Advanced Pricing
88	F4070	Price Adjustment Schedule	11	SN	EXDJ	Date - Expired	Date	Generic Edit	6	0
89	F4070P	Price Adjustment Schedule Purge	12	SN	EXDJ	Date - Expired	Date	Generic Edit	6	0
90	F4072	Price Adjustment Detail	13	AD	EXDJ	Date - Expired	Date	Generic Edit	6	0
91	F4072P	Price Adjustment Detail Purge	14	AD	EXDJ	Date - Expired	Date	Generic Edit	6	0
92	F4072W	Price Adjustment Detail Work File	13	AD	EXDJ	Date - Expired	Date	Generic Edit	6	0
93	F4075	Price Variable Table	6	VB	EXDJ	Date - Expired	Date	Generic Edit	6	0
94	F4077	Rebate Thresholds	9	RT	EXDJ	Date - Expired	Date	Generic Edit	6	0
95	F4077P	Rebate Thresholds Purge	10	RT	EXDJ	Date - Expired	Date	Generic Edit	6	0
96	F4078	Rebate Transaction Summary	9	RH	EXDJ	Date - Expired	Date	Generic Edit	6	0
97	F4079	Rebate Transaction Detail	8	SV	EXDJ	Date - Expired	Date	Generic Edit	6	0
98	F4501	Master Schedule Adjustment	6	MS	EXDJ	Date - Expired	Date	Generic Edit	6	0
99	F4502	Free Goods Catalog	4	FG	EXDJ	Date - Expired	Date	Generic Edit	6	0
100	F4511W	Pricing Structure View	50	AP	EXDJ	Date - Expired	Date	Generic Edit	6	0
101	F4551	Basket Master Detail	5	BD	EXDJ	Date - Expired	Date	Generic Edit	6	0
102	F45520	Price List Header	6	PH	EXDJ	Date - Expired	Date	Generic Edit	6	0
103	F45715	Adjustment Balances	11	AB	EXDJ	Date - Expired	Date	Generic Edit	6	0
104	F4572	Live Promotions X-Reference by Cost Type	8	XR	EXDJ	Date - Expired	Date	Generic Edit	6	0
105	F4572Z1	Live Promotions Interface - Inbound / Outbound	22	LP	EXDJ	Date - Expired	Date	Generic Edit	6	0
106	F4572ZP	Purge Live Promotions Interface	22	PG	EXDJ	Date - Expired	Date	Generic Edit	6	0
107	F4574	Key Reference Table	19	KR	EXDJ	Date - Expired	Date	Generic Edit	6	0
108	F4575	Ship and Debit History	40	AH	EXDJ	Date - Expired	Date	Generic Edit	6	0
109	F4575TMP	Ship and Debit History - Temp Table	40	AH	EXDJ	Date - Expired	Date	Generic Edit	6	0
110	F4576Z1	Ship and Debit Claims Unedited Transaction Table	118	Z1	EXDJ	Date - Expired	Date	Generic Edit	6	0
TOP46: Warehouse Management
111	F4625	Label Next Numbers	2	LN	EXDJ	Date - Expired	Date	Generic Edit	6	0
TOP47: Electronic Commerce
112	F47082	EDI Price Sales Catalog Detail - Inbound	71	FY	EXDJ	Date - Expired	Date	Generic Edit	6	0
113	F4780	Address Cross-Reference	4	AX	EXDJ	Date - Expired	Date	Generic Edit	6	0
TOP49: Transportation Management
114	F490052	Generate Tracking Segment Next Number	5	YG	EXDJ	Date - Expired	Date	Generic Edit	6	0
115	F49015	Vehicle Status	4	ST	EXDJ	Date - Expired	Date	Generic Edit	6	0
116	F49020	Vehicle/Staff License Information	9	VL	EXDJ	Date - Expired	Date	Generic Edit	6	0
117	F49025	Connected Vehicles (Conversion from World File)	8	CV	EXDJ	Date - Expired	Date	Generic Edit	6	0
118	F49030	Vehicle Equipment (Conversion from World File)	5	VE	EXDJ	Date - Expired	Date	Generic Edit	6	0
119	F49040	Vehicle Staff (Conversion from World File)	5	VS	EXDJ	Date - Expired	Date	Generic Edit	6	0
120	F49041	Depot/Vehicle Staff	4	VS	EXDJ	Date - Expired	Date	Generic Edit	6	0
121	F49160	Document Next Number	6	NN	EXDJ	Date - Expired	Date	Generic Edit	6	0
122	F49302	Vehicle Equipment	5	VE	EXDJ	Date - Expired	Date	Generic Edit	6	0
123	F4935	Connected Vehicle Header	3	VH	EXDJ	Date - Expired	Date	Generic Edit	6	0
124	F4936	Connected Vehicle Detail	7	CW	EXDJ	Date - Expired	Date	Generic Edit	6	0
125	F4950	Routing Entries	33	RT	EXDJ	Date - Expired	Date	Generic Edit	6	0
126	F49501	Intermodal Detail Routing Entries	19	RD	EXDJ	Date - Expired	Date	Generic Edit	6	0
127	F4956	Option and Equipment Inclusions/Exclusions	6	IX	EXDJ	Date - Expired	Date	Generic Edit	6	0
128	F4972	Rate Detail	12	RX	EXDJ	Date - Expired	Date	Generic Edit	6	0
129	F4974	RateWare XL Rate Constants	24	RW	EXDJ	Date - Expired	Date	Generic Edit	6	0
130	F4977	Rate Parameters	20	MR	EXDJ	Date - Expired	Date	Generic Edit	6	0
TOP75C: China
131	F75C4106	Chinese Free Goods VAT base price - F75C4106 - 41	9	IB	EXDJ	Date - Expired	Date	Generic Edit	6	0
TOP75I: India
132	F75I072	Tax Rules Setup - IND - 45	7	TS	EXDJ	Date - Expired	Date	Generic Edit	6	0
TOP89: Conversion Programs
133	F40344A	Temporay Preference Profile - Sales Commission	6	SA	EXDJ	Date - Expired	Date	Generic Edit	6	0
134	F4072TEM	Price Adjustment Detail - Temp for Upgrade	15	AD	EXDJ	Date - Expired	Date	Generic Edit	6	0
TOPH92: Interactive Engine/OL
135	F00165T	Media Object Conversion Table	12	GD	EXDJ	Date - Expired	Date	Generic Edit	6	0

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

135 columns | 920 | EXDJ