	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

48 tables920 | 04

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
04: Accounts Payable
1	920	F0030W	AX	2	1	Bank Account/Supplier Number Worktable	Regular Work Files	04: Accounts Payable	Business Data
2	920	F0401M	A6	3	1	Multiple Vendor Bank Account Status	Secondary Master Files	04: Accounts Payable	Business Data
3	920	F0401T	VT	20	1	Supplier Master - Voucher Match Automation File	Extra Features Files	04: Accounts Payable
4	920	F0401Z1T	VT	24	1	Supplier Master - Voucher Match Automation Tag File	Extra Features Files	04: Accounts Payable
5	920	F0411	RP	147	15	Accounts Payable Ledger	Transaction Files	04: Accounts Payable	Business Data
6	920	F0411A	RP	142	1	WF - 'As Of' Accounts Payable Ledger	Regular Work Files	04: Accounts Payable	Business Data
7	920	F0411P	RP	147	1	Purge - Accounts Payable Ledger	Purge Files	04: Accounts Payable	Business Data
8	920	F0411SW	SS	11	1	Supplier Ledger Summary Work Table	Files	04: Accounts Payable
9	920	F0411X	CM	12	1	CM Voucher Cross Reference	Files	04: Accounts Payable	Business Data
10	920	F0411Z1	VL	182	1	Voucher Transactions - Batch Upload	Batch Input Files	04: Accounts Payable	Business Data
11	920	F0411Z1T	VT	33	2	Voucher Transactions Batch Upload - Voucher Match Automation	Extra Features Files	04: Accounts Payable
12	920	F0411Z3	SZ	196	2	F0411 Interoperability Table	Batch Input Files	04: Accounts Payable	Business Data
13	920	F0413	RM	44	11	Accounts Payable - Matching Document	Transaction Files	04: Accounts Payable	Business Data
14	920	F0413A	RM	44	1	WF - 'As Of' Accounts Payable Payment Register	Regular Work Files	04: Accounts Payable	Business Data
15	920	F0413P	RM	44	1	Purge - Accounts Payable Matching Documents	Purge Files	04: Accounts Payable	Business Data
16	920	F0413Z1	SY	65	2	F0413 Interoperability Table	Batch Input Files	04: Accounts Payable	Business Data
17	920	F0414	RN	53	8	Accounts Payable Matching Document Detail	Transaction Files	04: Accounts Payable	Business Data
18	920	F0414A	RN	54	2	WF - 'As Of' Accounts Payable Payment Detail	Regular Work Files	04: Accounts Payable	Business Data
19	920	F0414P	RN	53	1	Purge - Accounts Payable Matching Document Detail	Purge Files	04: Accounts Payable	Business Data
20	920	F0414Z1	SZ	73	2	F0414 Interoperability Table	Work Files	04: Accounts Payable	Business Data
21	920	F0415	KJ	14	1	A/P Payments - Check Sequencing	Extra Features Files	04: Accounts Payable	Business Data
22	920	F0417	KB	15	1	A/P Payments - Default Print and Update	Extra Features Files	04: Accounts Payable	Business Data
23	920	F0417M	KB	3	1	Multiple Vendor Bank Account Types	Secondary Master Files	04: Accounts Payable	Business Data
24	920	F04257W2	KE	4	1	Payments Window Worktable	Work Files	04: Accounts Payable	Business Data
25	920	F0450	PC	18	2	Payee Control	History Files	04: Accounts Payable	Business Data
26	920	F04514	G1	28	1	1099 Merged Worktables (F045141:F045143)	Regular Work Files	04: Accounts Payable	Business Data
27	920	F045141	G1	28	1	1099 G/L Worktable	Regular Work Files	04: Accounts Payable	Business Data
28	920	F045143	G1	28	1	1099 A/P Worktable	Regular Work Files	04: Accounts Payable	Business Data
29	920	F045145	G2	12	1	1099 Securities Identification File	Files	04: Accounts Payable
30	920	F04514WF	KR	18	1	K Record Workfile	Files	04: Accounts Payable
31	920	F04515OW	G1	2	1	1099 Electronic Media	Work Files	04: Accounts Payable	Business Data
32	920	F0457	KM	26	1	A/P Payment Tape	Master Files	04: Accounts Payable	Business Data
33	920	F04571	KH	39	1	A/P Payment Processing - Header	Work Files	04: Accounts Payable	Business Data
34	920	F04572	KK	61	4	A/P Payment Processing - Summary	Work Files	04: Accounts Payable	Business Data
35	920	F04572OW	KN	4	1	A/P Payment Tape	Work Files	04: Accounts Payable	Business Data
36	920	F04573	KI	54	3	A/P Payment Processing - Detail	Work Files	04: Accounts Payable	Business Data
37	920	F04614	CT	15	2	T5018 Tax File	Files	04: Accounts Payable
38	920	F046141	CU	13	2	T5018 Tax Workfile	Files	04: Accounts Payable
39	920	F046UI01	CV	6	5	T5018 Tax Workfile	Files	04: Accounts Payable
40	920	F0474N1	QB	10	2	A/P Enterprise Info. - Sweden BGI/BGU	Secondary Master Files	04: Accounts Payable	Business Data
41	920	F0474N2	QD	22	1	A/P Enterprise Info. - Norway DNB	Secondary Master Files	04: Accounts Payable	Business Data
42	920	F0474N3	QC	13	2	Supplier Inf. Foreigen Payments Sweden	Secondary Master Files	04: Accounts Payable	Business Data
43	920	F0490	GC	2	1	A/P 'As Of' Date Worktable	Work Files	04: Accounts Payable	Business Data
44	920	F04UI004	RP	7	1	Integrity Report Worktable	Work Files	04: Accounts Payable	Business Data
45	920	F04UI006	G1	6	5	1099 Worktable User Index	Work Files	04: Accounts Payable	Business Data
46	920	F09UI005	GL	57	1	Tax Offsets User Index	Work Files	04: Accounts Payable	Business Data
47	920	F09UI006	TD	68	1	Tax (F0018) Replica	Work Files	04: Accounts Payable	Business Data
48	920	F7404S1	SW	3	1	Swiss SOG Payment Format Order Number	History Files	04: Accounts Payable	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

48 tables920 | 04