	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

62 columns | 920 | GLBA

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0006	Business Unit Master	82	MC	GLBA	G/L Bank Account	String	Generic Edit	8	0
2	F0006S	Date Effective Business Unit Master	84	MC	GLBA	G/L Bank Account	String	Generic Edit	8	0
3	F0006Z1	Cost Center Unedited Transaction Table	95	SZ	GLBA	G/L Bank Account	String	Generic Edit	8	0
4	F0006Z2	Business Unit Master Z File	95	SZ	GLBA	G/L Bank Account	String	Generic Edit	8	0
TOP01: Address Book
5	F0101	Address Book Master	59	AB	GLBA	G/L Bank Account	String	Generic Edit	8	0
6	F0101Z2	Address Book - Interoperability	72	SZ	GLBA	G/L Bank Account	String	Generic Edit	8	0
TOP03: Accounts Receivable
7	F0311	Accounts Receivable Ledger	45	RP	GLBA	G/L Bank Account	String	Generic Edit	8	0
8	F0312	A/R Batch Cash Application	25	RU	GLBA	G/L Bank Account	String	Generic Edit	8	0
TOP03B: Enhanced Accounts Receivable
9	F03B11	Customer Ledger	46	RP	GLBA	G/L Bank Account	String	Generic Edit	8	0
10	F03B11P	Customer Ledger Purge File	46	RP	GLBA	G/L Bank Account	String	Generic Edit	8	0
11	F03B11Z1	Batch Invoices	63	VJ	GLBA	G/L Bank Account	String	Generic Edit	8	0
12	F03B11Z2	F03B11 Interoperability Table	59	SY	GLBA	G/L Bank Account	String	Generic Edit	8	0
13	F03B13	Receipts Header	34	RY	GLBA	G/L Bank Account	String	Generic Edit	8	0
14	F03B13P	Receipts Header Purge File	34	RY	GLBA	G/L Bank Account	String	Generic Edit	8	0
15	F03B13Z1	Electronic Receipts Input	32	RU	GLBA	G/L Bank Account	String	Generic Edit	8	0
16	F03B13Z2	F03B13 Interoperability Table	47	SY	GLBA	G/L Bank Account	String	Generic Edit	8	0
17	F03B465	A/R Netting Workfile	52	RO	GLBA	G/L Bank Account	String	Generic Edit	8	0
18	F03B571	Auto Debit Batch Control	15	RC	GLBA	G/L Bank Account	String	Generic Edit	8	0
19	F03B575	Auto Debit Invoice Select and Build	55	RD	GLBA	G/L Bank Account	String	Generic Edit	8	0
20	F03B672	Draft Remittance	33	RD	GLBA	G/L Bank Account	String	Generic Edit	8	0
TOP04: Accounts Payable
21	F0411	Accounts Payable Ledger	44	RP	GLBA	G/L Bank Account	String	Generic Edit	8	0
22	F0411A	WF - 'As Of' Accounts Payable Ledger	44	RP	GLBA	G/L Bank Account	String	Generic Edit	8	0
23	F0411P	Purge - Accounts Payable Ledger	44	RP	GLBA	G/L Bank Account	String	Generic Edit	8	0
24	F0411Z1	Voucher Transactions - Batch Upload	62	VL	GLBA	G/L Bank Account	String	Generic Edit	8	0
25	F0411Z3	F0411 Interoperability Table	67	SZ	GLBA	G/L Bank Account	String	Generic Edit	8	0
26	F0413	Accounts Payable - Matching Document	5	RM	GLBA	G/L Bank Account	String	Generic Edit	8	0
27	F0413A	WF - 'As Of' Accounts Payable Payment Register	5	RM	GLBA	G/L Bank Account	String	Generic Edit	8	0
28	F0413P	Purge - Accounts Payable Matching Documents	5	RM	GLBA	G/L Bank Account	String	Generic Edit	8	0
29	F0413Z1	F0413 Interoperability Table	18	SY	GLBA	G/L Bank Account	String	Generic Edit	8	0
30	F0417	A/P Payments - Default Print and Update	2	KB	GLBA	G/L Bank Account	String	Generic Edit	8	0
31	F0417M	Multiple Vendor Bank Account Types	2	KB	GLBA	G/L Bank Account	String	Generic Edit	8	0
32	F04257W2	Payments Window Worktable	2	KE	GLBA	G/L Bank Account	String	Generic Edit	8	0
33	F0457	A/P Payment Tape	3	KM	GLBA	G/L Bank Account	String	Generic Edit	8	0
34	F04571	A/P Payment Processing - Header	2	KH	GLBA	G/L Bank Account	String	Generic Edit	8	0
35	F04572	A/P Payment Processing - Summary	6	KK	GLBA	G/L Bank Account	String	Generic Edit	8	0
TOP05A: PeopleSoft HR & PR Foundation
36	F06345	Historical Payroll Register	19	JL	GLBA	G/L Bank Account	String	Generic Edit	8	0
TOP06: Payroll (old) - Obsolete-do not reuse
37	F06210	Payroll Cycle Parameters	13	YD	GLBA	G/L Bank Account	String	Generic Edit	8	0
TOP07: Payroll
38	F06053	Interim Check Parameters File	14	YW	GLBA	G/L Bank Account	String	Generic Edit	8	0
39	F06156	Pay Check History Summary	21	YU	GLBA	G/L Bank Account	String	Generic Edit	8	0
40	F06350I	WF - Paycheck (Interims)	11	Y4	GLBA	G/L Bank Account	String	Generic Edit	8	0
41	F06491	Payroll/Accounts Payable Ledger Detail	7	J6	GLBA	G/L Bank Account	String	Generic Edit	8	0
42	F07210	Pay Cycle Parameters File	61	YD	GLBA	G/L Bank Account	String	Generic Edit	8	0
43	F07350	Payment File	13	Y0	GLBA	G/L Bank Account	String	Generic Edit	8	0
44	F07351	Payment Distribution File	8	Y1	GLBA	G/L Bank Account	String	Generic Edit	8	0
45	F074001	New Hire Reporting Workfile - OneWorld Only	104	NH	GLBA	G/L Bank Account	String	Generic Edit	8	0
46	F07491	Payroll - Accounts Payable Summary File	7	J6	GLBA	G/L Bank Account	String	Generic Edit	8	0
TOP09: General Accounting
47	F0916	Bank Statement Header	2	GH	GLBA	G/L Bank Account	String	Generic Edit	8	0
48	F0917	Bank Statement Detail	2	GD	GLBA	G/L Bank Account	String	Generic Edit	8	0
49	F09616	Auto Bank Statement Header	2	GN	GLBA	G/L Bank Account	String	Generic Edit	8	0
50	F09617	Auto Bank Statement Detail	4	GM	GLBA	G/L Bank Account	String	Generic Edit	8	0
51	F09UI618	Auto Bank Statement Process Work Table	2	NB	GLBA	G/L Bank Account	String	Generic Edit	8	0
TOP47: Electronic Commerce
52	F47042	EDI Invoice Detail - Inbound	53	SZ	GLBA	G/L Bank Account	String	Generic Edit	8	0
53	F47057	EDI Payment Order Remittance Advice - Outbound	94	D3	GLBA	G/L Bank Account	String	Generic Edit	8	0
54	F47057W	EDI Payment Order Remittance Advice - Work	94	D3	GLBA	G/L Bank Account	String	Generic Edit	8	0
55	F47112	EDI Lockbox Header - Transaction	22	Z2	GLBA	G/L Bank Account	String	Generic Edit	8	0
TOP74: EMEA Localization
56	F74900	Foreign Receivables and Payables - EMEA	53	RP	GLBA	G/L Bank Account	String	Generic Edit	8	0
TOP76A: Argentina
57	F76AUI44	CERG A/P - Worktable - ARG - 04 - 76A	3	WF	GLBA	G/L Bank Account	String	Generic Edit	8	0
58	F76AUI46	CERG A/R -Work File - ARG - 03B - 76A	3	WF	GLBA	G/L Bank Account	String	Generic Edit	8	0
TOP76B: Brazil
59	F76B474I	File Upload For Bank Transaction Inbound Process - 03B	8	BI	GLBA	G/L Bank Account	String	Generic Edit	8	0
60	F76B477	Dynamic Formater GL Bank Account File Numbers - 03B	1	BG	GLBA	G/L Bank Account	String	Generic Edit	8	0
TOP76C: Colombia
61	F76C031A	A/R Customer ledger As Of - F76C031A - COL - 04	45	RP	GLBA	G/L Bank Account	String	Generic Edit	8	0
TOP89: Conversion Programs
62	F0917S	Needed for upgrade for XE and below	1	GD	GLBA	G/L Bank Account	String	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

62 columns | 920 | GLBA