	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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

40 tables920 | 70

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
70: Multi-National Products
1	920	F700000	FC	7	1	Functionalities By Country - COMM - 70	Files	70: Multi-National Products
2	920	F700002	L1	6	1	Legal Document Types Tag File - COMM - 00	Files	70: Multi-National Products
3	920	F700003	LC	2	1	Company Country by Legal Document Type - COMM - 70	Files	70: Multi-National Products
4	920	F7000100	AF	9	1	Header Localization Additional Data	Files	70: Multi-National Products
5	920	F7000110	DA	17	3	Detail Localization Additional Data	Files	70: Multi-National Products
6	920	F7000120	OD	7	1	Base Object / Tag Table Definition	Files	70: Multi-National Products
7	920	F700018	TE	14	1	Generic VAT - Informed Taxes by Report - COMM - 70	Files	70: Multi-National Products
8	920	F700030	IB	9	1	International Bank Account Number - COMM - 70	Files	04: Accounts Payable
9	920	F700050	BC	10	1	Bank Connection for Legal Documents - COMM - 00	Files	70: Multi-National Products
10	920	F700100	SC	9	1	Suspended VAT Setup by Country - COMM - 70	Files	70: Multi-National Products
11	920	F700101	GL	9	2	Suspended VAT - GLOffset - COMM - 70	Files	70: Multi-National Products
12	920	F700102	TE	8	2	Suspended VAT - Tax Explanation Code - COMM - 70	Files	70: Multi-National Products
13	920	F700103	EM	10	2	Suspended VAT - Exception Method - COMM - 70	Files	70: Multi-National Products
14	920	F7001100	LA	60	1	Localizations Additional Fields AB - 01	Files	70: Multi-National Products
15	920	F7003B11	LA	63	1	Localizations Additional Fields Customer Ledger - 01	Files	70: Multi-National Products
16	920	F700411	LA	64	1	Localizations Additional Fields Accounts Payable Ledger - 04	Files	70: Multi-National Products
17	920	F7009001	CA	21	2	Chart of Accounts by Level	Files	70: Multi-National Products
18	920	F700911	GA	17	1	GL Invoice Number	Files	70: Multi-National Products
19	920	F702018	TA	24	2	Taxes by Sales Order Line - COMM - 42	Files	70: Multi-National Products
20	920	F702033	D1	14	1	Sales Document Line Tag File - COMM - 42	Files	70: Multi-National Products
21	920	F703030	H1	10	1	Legal Document Header Tag File - COMM - 03B	Files	70: Multi-National Products
22	920	F703036	B1	11	1	Legal Document Bank Connection - COMM - 03B	Files	70: Multi-National Products
23	920	F703037	CI	13	1	Legal Document Contact Information - COMM - 03B	Files	70: Multi-National Products
24	920	F703B11	AR	11	1	AR Invoice Number	Files	70: Multi-National Products
25	920	F703B1Z1	AZ	11	1	Sales EDI Invoice Number	Files	70: Multi-National Products
26	920	F704001	PT	66	4	Payment WH Info TEMP - COMM - 04	Files	70: Multi-National Products
27	920	F704002	PF	64	5	Payment WH Info - COMM - 04	Files	70: Multi-National Products
28	920	F704002P	PF	64	5	Payment WH Info Purge - COMM - 04	Files	70: Multi-National Products
29	920	F704003	PD	24	4	Payment Done - Accum - COMM - 04	Files	70: Multi-National Products
30	920	F704008	LA	59	1	Localizations Additional Fields Tax Area - 04	Files	70: Multi-National Products
31	920	F70404	Z7	28	1	G/L Registration Balance - 09	Balance Files	70: Multi-National Products	Business Data
32	920	F704100	VA	34	2	Suspended VAT AP - COMM - 70	Files	70: Multi-National Products
33	920	F704101	IM	22	1	Generic Item Master Add Info - 70	Files	70: Multi-National Products
34	920	F704101A	LA	60	1	Localizations Additional Fields Item Master - 01	Files	70: Multi-National Products
35	920	F704102	IB	23	1	Generic Item Branch Add Info - 70	Files	70: Multi-National Products
36	920	F704200	FV	30	3	Final VAT AP - COMM - 70	Files	70: Multi-National Products
37	920	F704201	LA	62	1	Localizations Additional Fields Sales Order - 01	Files	70: Multi-National Products
38	920	F704220	AP	11	1	AP Invoice Number	Files	70: Multi-National Products
39	920	F707111	TB	14	1	Text Processor Detail Table - 70	Transaction Files	70: Multi-National Products
40	920	F70XMLZ1	SY	50	2	XML Transaction Interfase	Files	70: Multi-National Products

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

40 tables920 | 70