	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

32 columns | 920 | VDGJ

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP03B: Enhanced Accounts Receivable
1	F03B11	Customer Ledger	100	RP	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
2	F03B11P	Customer Ledger Purge File	100	RP	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
3	F03B11Z1	Batch Invoices	116	VJ	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
4	F03B11Z2	F03B11 Interoperability Table	113	SY	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
5	F03B13	Receipts Header	45	RY	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
6	F03B13P	Receipts Header Purge File	45	RY	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
7	F03B13Z2	F03B13 Interoperability Table	58	SY	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
8	F03B14	Receipts Detail	93	RZ	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
9	F03B14P	Receipts Detail Purge File	93	RZ	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
10	F03B14Z2	F03B14 Interoperability Table	106	SZ	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
11	F03B575	Auto Debit Invoice Select and Build	109	RD	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
12	F03B672	Draft Remittance	44	RD	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
TOP04: Accounts Payable
13	F0413	Accounts Payable - Matching Document	7	RM	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
14	F0413A	WF - 'As Of' Accounts Payable Payment Register	7	RM	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
15	F0413P	Purge - Accounts Payable Matching Documents	7	RM	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
16	F0413Z1	F0413 Interoperability Table	21	SY	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
TOP70: Multi-National Products
17	F704001	Payment WH Info TEMP - COMM - 04	41	PT	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
18	F704002	Payment WH Info - COMM - 04	40	PF	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
19	F704002P	Payment WH Info Purge - COMM - 04	40	PF	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
TOP74: EMEA Localization
20	F7430010	Legal Document Header - COMM - 03B	13	LD	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
TOP74H: Hungary
21	F74H309	Gains & Losses Unrealized Account ing - HUN - 03B	12	GL	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
22	F74H409	A/P Gains & Losses Unrealized Accounting - HUN - 04	12	GL	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
TOP74P: Poland
23	F74P9100	Cash Desk Transaction - POL - 74P	11	CD	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
TOP74R: Russia
24	F74R0100	Petty Cash Transactions - RUS - 00 - 74R	12	PC	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
TOP75T: Taiwan
25	F75T004	GUI/VAT Transaction Header - 75T	109	TH	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
26	F75T0049	GUI/VAT Transaction Header History - 75T	109	TH	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
27	F75T004P	GUI/VAT Transaction Header POS - 75T	100	TH	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
28	F75T004Z	GUI/VAT Transaction Header - Work - 75T	61	ZH	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
TOP76A: Argentina
29	F76AUI81	Draft - Invoices Work File - ARG - 03B - 76A	45	WF	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
30	F76AUI82	Draft - Drafts Work File - ARG - 03B - 03B	44	WF	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
31	F76AUI83	Draft - Application Drafts - Invoices Work File - ARG - 76A	45	WF	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
TOP76C: Colombia
32	F76C034A	A/R Check Detail file As Of - COL - 03B	92	RZ	VDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	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

32 columns | 920 | VDGJ