	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

42 columns | 910 | AN8J

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP03: Accounts Receivable
1	F0311	Accounts Receivable Ledger	20	RP	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
TOP03B: Enhanced Accounts Receivable
2	F03B11	Customer Ledger	18	RP	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
3	F03B11P	Customer Ledger Purge File	18	RP	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
4	F03B11Z1	Batch Invoices	36	VJ	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
5	F03B11Z2	F03B11 Interoperability Table	31	SY	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
6	F03B575	Auto Debit Invoice Select and Build	21	RD	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
TOP15: Property Management
7	F1501	Tenant/Lease Master	7	NE	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
8	F15012	Tenant E.P. Class Master	43	NS	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
9	F15012B	Tenant E.P. Class Master	48	NS	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
10	F15013	Sales Overage Master	4	NO	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
11	F15013B	Sales Overage Master File	14	NO	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
12	F15016	Tenant Escalation Master	39	NU	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
13	F15016B	Tenant Escalation Master	40	NU	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
14	F1501B	Lease Master Header	9	NE	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
15	F1502	Recurring Billings Master	27	NF	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
16	F1502B	Recurring Billings Master	27	NF	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
17	F1502WB	Estimated EP Recurring Billings	29	N4	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
18	F1511	Tenant/Lease Billings Detail	10	NJ	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
19	F1511B	Lease Billings Master	10	NJ	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
20	F1511H	Tenant/Lease Billings Detail History	10	N#	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
21	F1511HB	Lease Billings History	10	NC	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
22	F1513	FASB 13 Lease Control File	10	O3	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
23	F1513B	FASB 13 Lease Control	10	O3	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
24	F1538	WF - Expence Participation Register	3	NZ	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
25	F1538B	EP Billing Register	3	NZ	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
26	F1548	Escalation Billing Register	3	N1	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
27	F1548B	Escalation Billing Register	3	N1	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
28	F1565	Security Deposit Master	22	JF	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
TOP47: Electronic Commerce
29	F47041	EDI Invoice Header - Inbound	29	SY	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
TOP48S: Service Billing
30	F4822	Invoice Summary Work File	15	W4	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
31	F4823	Voucher Summary	13	W0	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
TOP52G: Government Contracting
32	F4822H	Invoice Summary History	15	IH	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
TOP74: EMEA Localization
33	F74900	Foreign Receivables and Payables - EMEA	24	RP	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
TOP76A: Argentina
34	F76A0110	UTE Members - 76A	2	U1	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
35	F76A09	Invoice Total - ARG - 03B - 76A	18	TT	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
36	F76A09P	Invoice Total Purge - ARG - 03B - 76A	18	TT	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
37	F76A401	UTE Members Type - ARG - 04	3	UT	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
TOP76B: Brazil - Reporting System Only
38	F76B0401	Tax Code - 04	7	CT	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
39	F76B0411	Voucher Additional Information Brazil - 04	19	VB	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
40	F76B406	Taxes Setup by City Code - BR - 04	2	TS	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
41	F76B473T	F04573 Brazilian Temp WH File - BR - 04	23	W3	AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0
TOP76C: Colombia
42	F76C031A	A/R Customer ledger As Of - F76C031A - COL - 04	18	RP	AN8J	Address Number - Alternate Payee	Numeric	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

42 columns | 910 | AN8J