	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

33 columns | 920 | DOC1

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP17: Customer Service Management
1	F1720	Contract Header	5	CH	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
2	F1721	Contract Detail	6	CD	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
TOP37: Quality Management
3	F3703	Non-Conforming Material	14	QE	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
TOP40: Inventory/OP Base
4	F4001Z	Batch Receiver File - Order Headings	132	SY	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
5	F40051	Return Material Authorization	69	RD	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
6	F4108	Lot Master	59	IO	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
7	F4201Z1	Sales Order Header Unedited Transaction File	120	SY	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
TOP41: Inventory Management
8	F41UI001	Inventory Transactions Detail File	240	IT	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
TOP41F: Apparel Management
9	FCW22	Lot Master Work File	59	WL	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
TOP42: Sales Management
10	F4201	Sales Order Header File	108	SH	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
11	F42019	Sales Order Header History File	108	SH	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
12	F42565	Invoice Print File	170	IW	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
13	F42UI01	SO Header Cache File (MBF)	146	ZH	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
TOP43: Procurement
14	F4301	Purchase Order Header	86	PH	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
15	F4301Z	PO Header Work File	102	PA	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
16	F4301Z1	Purchase Order Header Unedited Transaction Table	102	SY	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
TOP44H: Homebuilder Management
17	F4450	Lot Proceed Header (World)	89	JD	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
18	F4456	Lot Proceed Entry (World)	89	JI	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
TOP47: Electronic Commerce
19	F47011	EDI Purchase Order Header - Inbound	120	SY	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
20	F47026	EDI P.O. Acknowledgment Header - Outbound	108	SY	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
21	F47036	EDI Shipping Notice Header - Outbound	44	SY	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
22	F47046	EDI Invoice Header (Sales) - Outbound	109	SY	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
23	F47091	EDI Request for Quote Header - Inbound	120	SY	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
24	F47106	EDI Response to RFQ Header - Outbound	108	SY	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
25	F47131	EDI Purchase Order Change Header - Inbound	117	SY	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
26	F47146	EDI P.O. Change Acknowledgment Header - Outbound	109	SY	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
TOP75I: India
27	F75I2213	Setoff Temp Table	14	TT	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
28	F75I2241	WorkFile for VAT/CST Receivables	13	VC	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
29	F75I403	Stock Transfer Details	33	AB	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
30	F75I403T	Temp Data for F75i403	17	AB	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
31	F75I4213	Setoff Report Data -IND -00	22	SO	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
TOP76A: Argentina
32	F76A005	CAI - Invoice range for Preprinters - ARG - 03B	5	RH	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0
TOP90CG: CRM Case Management
33	F90CG503	Case Association Table	5	CA	DOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	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

33 columns | 920 | DOC1