	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

38 tables920 | 01

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
01: Address Book
1	920	F0101	AB	95	15	Address Book Master	Master Files	01: Address Book
2	920	F0101Z2	SZ	125	1	Address Book - Interoperability	Batch Input Files	01: Address Book	Business Data
3	920	F01090	A1	16	1	Supplemental Database - Core	Extra Features Files	01: Address Book	Business Data
4	920	F01092	A2	10	4	Supplemental Database - Code	Extra Features Files	01: Address Book	Business Data
5	920	F01093	A3	7	2	Supplemental Database - Narrative	Extra Features Files	01: Address Book	Business Data
6	920	F0111	WW	53	3	Address Book - Who's Who	Secondary Master Files	01: Address Book	Business Data
7	920	F01112	CP	20	2	Related Person	Secondary Master Files	01: Address Book	Business Data
8	920	F01112Z1	PB	33	1	Batch - Related Person	Batch Input Files	01: Address Book	Business Data
9	920	F0111Z1	BW	68	2	Batch Who's Who Information	PC Download/Batch Edit Files	01: Address Book	Business Data
10	920	F01138	DS	31	1	AB Data Permission List Definitions	Extra Features Files	01: Address Book
11	920	F0114	AT	4	1	Address Book Memo/Text Information	Secondary Master Files	01: Address Book	Business Data
12	920	F0115	WP	17	2	Address Book - Phone Numbers	Secondary Master Files	01: Address Book	Business Data
13	920	F01151	EA	18	2	Electronic Address	Secondary Master Files	01: Address Book	Business Data
14	920	F01151Z1	EB	31	1	Batch - Electronic Address	Batch Input Files	01: Address Book	Business Data
15	920	F0115Z1	PI	29	1	Phones - Interoperability	Files	01: Address Book
16	920	F0116	AL	21	1	Address by Date	Master Files	01: Address Book	Business Data
17	920	F01161	WL	22	1	Alternate Address	Secondary Master Files	01: Address Book	Business Data
18	920	F01161DW	DW	22	1	Customer Alternate Address Export	Files	01: Address Book
19	920	F01161Z1	LB	35	1	Batch - Alternative Address	Batch Input Files	01: Address Book	Business Data
20	920	F0117	A8	13	3	Postal Codes	Master Files	01: Address Book	Business Data
21	920	F0118	A7	13	2	Postal Code Address	Files	01: Address Book	Business Data
22	920	F011901	CS	17	2	Contacts Subscriptions Table	Files	01: Address Book
23	920	F01301	AM	59	3	Activity Master	Files	01: Address Book
24	920	F01301D	AD	60	8	Activity Detail	Files	01: Address Book
25	920	F01301W	AW	50	1	Mobile Client Deleted Activities	Files	01: Address Book
26	920	F01302	AD	4	1	Activity -- Deleted IDs for Sync	Files	01: Address Book
27	920	F01311	CC	31	2	Centralized Calendar Master	Files	01: Address Book
28	920	F01315	CC	13	3	Calendar Associations	Files	01: Address Book
29	920	F01321	RM	15	1	Recurrence Master	Files	01: Address Book
30	920	F01331	RE	12	2	Recurrence Exclusion	Files	01: Address Book
31	920	F01401	AP	13	1	Action Plan	Files	01: Address Book
32	920	F01411	AC	17	1	Action Plan Activity	Files	01: Address Book
33	920	F0150	MA	13	8	Address Organization Structure Master	Extra Features Files	01: Address Book	Business Data
34	920	F01501	PR	14	3	Enhanced Parent Child	Secondary Master Files	01: Address Book	Business Data
35	920	F01505	TD	10	4	Tier Descriptions	Files	01: Address Book	Business Data
36	920	F01815	AS	4	2	AB Word Search Master	Extra Features Files	01: Address Book	Business Data
37	920	F01816	AO	2	1	Address Book Search Word Occurrence	Extra Features Files	01: Address Book	Business Data
38	920	F0401	A6	80	1	Supplier Master	Master Files	01: Address Book	Business Data

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

38 tables920 | 01