	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

72 columns | 920 | FEA

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP17: Customer Service Management
1	F1721	Contract Detail	75	CD	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
TOP32: Configuration Management
2	F3215	Configurator Component Table	23	CC	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
3	F32159	Configurator Component History Table	23	CH	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
4	F3216	Configurator Price/Cost Table	13	PC	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
5	F32169	Configurator Price/Cost History	13	KB	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
TOP40: Inventory/OP Base
6	F4011Z	Batch Receiver File - Order Details	211	SZ	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
7	F4211Z1	Sales Order Detail Unedited Transaction File	190	SZ	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
TOP40G: Grower Management
8	F40G95	Pay On Proceeds Log File	14	PP	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
TOP42: Sales Management
9	F4211	Sales Order Detail File	177	SD	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
10	F42119	Sales Order History File	177	SD	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
11	F42199	S.O. Detail Ledger File	177	SL	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
12	F42UI11	SO Detail Cache File (MBF)	112	ZD	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
13	F42UI521	Pick Slips Detail File	121	S9	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
14	F42UI800	Sales Detail Work File - Sales Update	22	SD	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
TOP42B: Sales Order Entry
15	F42420	Audit Log Transaction	22	AL	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
TOP42I: Outbound Inventory Management
16	F42I015	Outbound Inventory Agreement Transaction File	28	OI	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
TOP42X: In-Memory Sales Advisor
17	F42X010W	Line Advisor Work File	11	US	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
18	F42X050W	Order Level Upsell Candidate Items	18	CI	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
TOP43: Procurement
19	F43080	Approvals Fields Constants	169	PD	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
20	F4311	Purchase Order Detail File	169	PD	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
21	F4311Z	Purchase Order Generator File	173	PW	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
22	F4311Z1	Purchase Order Detail Unedited Transaction Table	182	SZ	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
23	F43147	Freight Distribution Workfile	30	FD	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
24	F4314Z	Voucher Match Selection File	70	PN	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
25	F4316	Purchase Order Multiple Account File	40	P3	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
26	F43199	P.O. Detail Ledger File - Flexible Version	169	OL	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
27	F4343	Purchase Rebate History	24	RH	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
28	F43UI50D	PO Print Detail Work File	43	PW	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
TOP43E: Requisition Self Service
29	F43E11	Requisition Detail	28	RD	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
30	F43E16	Requisition Multiple Account File	32	P3	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
31	F43E20	Shopping Cart Detail	14	SC	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
32	F43E20WF	eReq - Shopping Cart Work File	17	SW	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
TOP44H: Homebuilder Management
33	F44H611	Bid Details	71	BD	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
34	F44H611W	Bid Details Work File	75	BW	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
35	F44H711	Lot Start Workfile	86	SW	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
36	F44H711Z	HB Lot Start Unedited Transaction File	99	SZ	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
37	F44H71W1	Lot Start Generation Workfile	86	GW	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
38	F44H73W1	Lot Start - P.O. / Committment Generation Work File	56	CG	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
TOP45: Advanced Pricing
39	F4576Z1	Ship and Debit Claims Unedited Transaction Table	156	Z1	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
TOP46: Warehouse Management
40	F4942Z1	Work File for F4942	34	SY	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
TOP47: Electronic Commerce
41	F47012	EDI Purchase Order Detail - Inbound	212	SZ	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
42	F47017	EDI Purchase Order Detail - Outbound	172	SZ	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
43	F47022	EDI P.O. Acknowledgment Detail - Inbound	172	SZ	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
44	F47027	EDI P.O. Acknowledgment Detail - Outbound	212	SZ	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
45	F47032	EDI Shipping Notice Detail - Inbound	112	SZ	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
46	F47037	EDI Shipping Notice Detail - Outbound	161	SZ	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
47	F470371	EDI Shipping Notice Detail - Outbound	180	SZ	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
48	F47042	EDI Invoice Detail - Inbound	72	SZ	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
49	F47044	EDI Invoice Summary - Inbound	37	SW	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
50	F47047	EDI Invoice Detail (Sales) - Outbound	212	SZ	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
51	F47072	EDI Receiving Advice Detail - Inbound	173	SZ	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
52	F47077	EDI Receiving Advice Detail - Outbound	173	SZ	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
53	F47092	EDI Request for Quote Detail - Inbound	212	SZ	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
54	F47097	EDI Request for Quote Detail - Outbound	172	SZ	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
55	F47102	EDI Response to RFQ Detail - Inbound	172	SZ	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
56	F47107	EDI Response to RFQ Detail - Outbound	211	SZ	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
57	F47132	EDI Purchase Order Change Detail - Inbound	213	SZ	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
58	F47137	EDI Purchase Order Change Detail - Outbound	173	SZ	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
59	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	174	SZ	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
60	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	214	SZ	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
61	F47157	EDI Shipping Schedule Detail - Outbound	195	SZ	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
62	F47UI001	ASN Extract Work File	39	SZ	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
TOP48S: Service Billing
63	F4812	Billing Detail Workfile	159	WD	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
64	F4812H	Billing Workfile History	159	WD	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
65	F4812HS	Billing Workfile History Purged Save	159	WD	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
66	F48SUI01	Billing Detail Print Workfile	159	WD	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
TOP49: Transportation Management
67	F4941	Shipment Routing Steps	37	RS	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
68	F4942	Shipment Detail	21	IS	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
69	F49633	Load In-Transit Confirmed Quantities	27	IQ	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
70	F49634	Load In-Transit Confirmed Quantities Detail	18	QD	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
TOP75T: Taiwan
71	F75T42W	Work file with union of F4211 and F42119	40	SW	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2
TOP89: Conversion Programs
72	F43199A	Temp F43199 for ERP 9.0 Upgrade	169	OL	FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2

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

72 columns | 920 | FEA