	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

40 tables812 | 04

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
04: Accounts Payable
1	812	F0030W	AX	2	1	Bank Account/Supplier Number Workfile	Regular Work Files	04: Accounts Payable	AS400 Coexistence Tables
2	812	F0401M	A6	3	1	Multiple Vendor Bank Account Status	Secondary Master Files	04: Accounts Payable	AS400 Coexistence Tables
3	812	F0411	RP	142	15	Accounts Payable Ledger	Transaction Files	04: Accounts Payable	AS400 Coexistence Tables
4	812	F0411A	RP	142	1	WF - As Of - Accounts Payable Ledger	Regular Work Files	04: Accounts Payable	AS400 Coexistence Tables
5	812	F0411P	RP	142	1	Purge - Accounts Payable Ledger	Purge Files	04: Accounts Payable	AS400 Coexistence Tables
6	812	F0411Z1	VL	178	1	Voucher Transactions - Batch File	Batch Input Files	04: Accounts Payable	AS400 Coexistence Tables
7	812	F0411Z3	SZ	196	2	F0411 Interoperability Table	Batch Input Files	04: Accounts Payable	No
8	812	F0413	RM	44	10	Accounts Payable - Matching Document	Transaction Files	04: Accounts Payable	AS400 Coexistence Tables
9	812	F0413A	RM	44	1	WF - As Of - Accounts Payable Payment Register	Regular Work Files	04: Accounts Payable	AS400 Coexistence Tables
10	812	F0413P	RM	44	1	Purge - Accounts Payable Matching Documents	Purge Files	04: Accounts Payable	AS400 Coexistence Tables
11	812	F0413Z1	SY	65	2	F0413 Interoperability Table	Batch Input Files	04: Accounts Payable	No
12	812	F0414	RN	53	7	Accounts Payable Matching Document Detail	Transaction Files	04: Accounts Payable	AS400 Coexistence Tables
13	812	F0414A	RN	54	2	WF - As Of - Accounts Payable Payment Detail	Regular Work Files	04: Accounts Payable	AS400 Coexistence Tables
14	812	F0414P	RN	53	1	Purge - Accounts Payable Matching Document Detail	Purge Files	04: Accounts Payable	AS400 Coexistence Tables
15	812	F0414Z1	SZ	73	2	F0414 Interoperability Table	Work Files	04: Accounts Payable	No
16	812	F0415	KJ	14	1	A/P Payments - Check Sequencing	Extra Features Files	04: Accounts Payable	AS400 Coexistence Tables
17	812	F0417	KB	15	1	A/P Payments - Default Print and Update	Extra Features Files	04: Accounts Payable	AS400 Coexistence Tables
18	812	F0417M	KB	3	1	Multiple Vendor Bank Account Types	Secondary Master Files	04: Accounts Payable	AS400 Coexistence Tables
19	812	F04257W2	KE	4	1	Payments Window Workfile	Work Files	04: Accounts Payable	AS400 Coexistence Tables
20	812	F0450	PC	18	2	Payee Control File	History Files	04: Accounts Payable	AS400 Coexistence Tables
21	812	F04514	G1	28	1	WF - 1099 Combined Workfile (Merge of F045141 and F045143)	Regular Work Files	04: Accounts Payable	AS400 Coexistence Tables
22	812	F045141	G1	28	1	WF - 1099 G/L Workfile	Regular Work Files	04: Accounts Payable	AS400 Coexistence Tables
23	812	F045143	G1	28	1	WF - 1099 A/P WorkFile	Regular Work Files	04: Accounts Payable	AS400 Coexistence Tables
24	812	F04514WF	KR	17	1	K Record Workfile	Files	04: Accounts Payable
25	812	F04515OW	G1	2	1	1099 Magnetic Media Tape File - OneWorld	Work Files	04: Accounts Payable	No
26	812	F0457	KM	26	1	A/P Payment Tape File	Master Files	04: Accounts Payable	AS400 Coexistence Tables
27	812	F04571	KH	39	1	A/P Payment Processing - Header File	Work Files	04: Accounts Payable	AS400 Coexistence Tables
28	812	F04572	KK	61	4	A/P Payment Processing - Summary File	Work Files	04: Accounts Payable	AS400 Coexistence Tables
29	812	F04572OW	KN	4	1	A/P Payment Tape File - OneWorld	Work Files	04: Accounts Payable	AS400 Coexistence Tables
30	812	F04573	KI	54	3	A/P Payment Processing - Detail File	Work Files	04: Accounts Payable	AS400 Coexistence Tables
31	812	F0474N1	QB	10	2	A/P Enterprise Info. - Sweden BGI/BGU	Secondary Master Files	04: Accounts Payable	No
32	812	F0474N2	QD	22	1	A/P Enterprise Info. - Norway DNB	Secondary Master Files	04: Accounts Payable	No
33	812	F0474N3	QC	13	2	Supplier Inf. Foreigen Payments Sweden	Secondary Master Files	04: Accounts Payable	No
34	812	F0490	GC	2	1	A/P 'As Of' Date Workfile	Work Files	04: Accounts Payable	AS400 Coexistence Tables
35	812	F04UI004	RP	7	1	Integrity Report Table F04UI004	Work Files	04: Accounts Payable	No
36	812	F04UI006	G1	6	5	1099 Workfiles User Index	Work Files	04: Accounts Payable	No
37	812	F09UI005	GL	45	1	Tax Offsets User Index	Work Files	04: Accounts Payable	No
38	812	F09UI006	TD	68	1	Tax (F0018) Replica	Work Files	04: Accounts Payable	No
39	812	F70404	Z7	28	1	G/L Registration Balance File	Balance Files	04: Accounts Payable	AS400 Coexistence Tables
40	812	F7404S1	SW	3	1	Swiss SOG Payment Format Order Number Table	History Files	04: Accounts Payable	No

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 tables812 | 04