	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

94 columns | 812 | ACR

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0911	Account Ledger	132	GL	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP03: Accounts Receivable
2	F0311	Accounts Receivable Ledger	34	RP	ACR	Amount - Currency	Numeric	Generic Edit	15	2
3	F0312	A/R Batch Cash Application	31	RU	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP03B: Enhanced Accounts Receivable
4	F03B11	Customer Ledger	36	RP	ACR	Amount - Currency	Numeric	Generic Edit	15	2
5	F03B112	Invoice Revisions	38	RW	ACR	Amount - Currency	Numeric	Generic Edit	15	2
6	F03B112P	Invoice Revisions Purge File	38	RW	ACR	Amount - Currency	Numeric	Generic Edit	15	2
7	F03B11P	Customer Ledger Purge File	36	RP	ACR	Amount - Currency	Numeric	Generic Edit	15	2
8	F03B11Z1	Invoice Transactions - Batch File	53	VJ	ACR	Amount - Currency	Numeric	Generic Edit	15	2
9	F03B11Z2	F03B11 Interoperability Table	49	SY	ACR	Amount - Currency	Numeric	Generic Edit	15	2
10	F03B21	A/R Notification History Detail	62	ZS	ACR	Amount - Currency	Numeric	Generic Edit	15	2
11	F03B465	A/R Netting Workfile	28	RO	ACR	Amount - Currency	Numeric	Generic Edit	15	2
12	F03B575	Auto Debit Invoice Select and Build	45	RD	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP04: Accounts Payable
13	F0411	Accounts Payable Ledger	36	RP	ACR	Amount - Currency	Numeric	Generic Edit	15	2
14	F0411A	WF - As Of - Accounts Payable Ledger	36	RP	ACR	Amount - Currency	Numeric	Generic Edit	15	2
15	F0411P	Purge - Accounts Payable Ledger	36	RP	ACR	Amount - Currency	Numeric	Generic Edit	15	2
16	F0411Z1	Voucher Transactions - Batch File	54	VL	ACR	Amount - Currency	Numeric	Generic Edit	15	2
17	F0411Z3	F0411 Interoperability Table	59	SZ	ACR	Amount - Currency	Numeric	Generic Edit	15	2
18	F04573	A/P Payment Processing - Detail File	16	KI	ACR	Amount - Currency	Numeric	Generic Edit	15	2
19	F09UI005	Tax Offsets User Index	28	GL	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP05T: Time Entry
20	F063951	Payroll Journal (Compressed) File	38	GL	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP07: Payroll
21	F05290	WF - Payroll Journal (Detail)	39	JR	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP09: General Accounting
22	F0911P	Purge - Account Ledger	132	GL	ACR	Amount - Currency	Numeric	Generic Edit	15	2
23	F0911R	WF - Acct Ledger File for Reconciliation	75	GL	ACR	Amount - Currency	Numeric	Generic Edit	15	2
24	F0911Z1	Journal Entry Transactions - Batch File	123	VN	ACR	Amount - Currency	Numeric	Generic Edit	15	2
25	F0911Z4	F0911 Interoperability Table	122	SZ	ACR	Amount - Currency	Numeric	Generic Edit	15	2
26	F0917	Bank Statement Detail	12	GD	ACR	Amount - Currency	Numeric	Generic Edit	15	2
27	F09UI007	Match Bank Tape to Recon File - ONE WORLD ONLY	19	GL	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP15: Property Management
28	F15012B	Tenant E.P. Class Master	89	NS	ACR	Amount - Currency	Numeric	Generic Edit	15	2
29	F15016	Tenant Escalation Master	49	NU	ACR	Amount - Currency	Numeric	Generic Edit	15	2
30	F15016B	Tenant Escalation Master	52	NU	ACR	Amount - Currency	Numeric	Generic Edit	15	2
31	F1502	Recurring Billings Master	44	NF	ACR	Amount - Currency	Numeric	Generic Edit	15	2
32	F1502B	Recurring Billings Master	44	NF	ACR	Amount - Currency	Numeric	Generic Edit	15	2
33	F1502WB	Estimated EP Recurring Billing Work File (OneWorld)	47	N4	ACR	Amount - Currency	Numeric	Generic Edit	15	2
34	F1511	Tenant/Lease Billings Detail	45	NJ	ACR	Amount - Currency	Numeric	Generic Edit	15	2
35	F1511B	Tenant/Lease Billings Detail Master	45	NJ	ACR	Amount - Currency	Numeric	Generic Edit	15	2
36	F1511H	Tenant/Lease Billings Detail History	45	N#	ACR	Amount - Currency	Numeric	Generic Edit	15	2
37	F1511HB	Tenant/Lease Billings Detail History	45	NC	ACR	Amount - Currency	Numeric	Generic Edit	15	2
38	F151991	G/L Transaction A/R Application Work File	16	NB	ACR	Amount - Currency	Numeric	Generic Edit	15	2
39	F1538B	EP Billing Register Work File	119	NZ	ACR	Amount - Currency	Numeric	Generic Edit	15	2
40	F1540B	Sales Report Control File	48	NR	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP17C: Call Management
41	F1755	Customer Call Master	105	ZA	ACR	Amount - Currency	Numeric	Generic Edit	15	2
42	F1760	Time Entry	28	ZB	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP42: Sales Management
43	F42800G1	Sales Update G Batch Detail Workfile	42	DG	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP43: Procurement
44	F4314Z	Voucher Match Selection File	54	PN	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP47: Electronic Commerce
45	F470161	EDI Purchase Order Additional Header - Outbound	52	S3	ACR	Amount - Currency	Numeric	Generic Edit	15	2
46	F47042	EDI Invoice Detail - Inbound	73	SZ	ACR	Amount - Currency	Numeric	Generic Edit	15	2
47	F47044	EDI Invoice Summary - Inbound	38	SW	ACR	Amount - Currency	Numeric	Generic Edit	15	2
48	F470461	EDI Invoice Additional Header - Outbound	53	S3	ACR	Amount - Currency	Numeric	Generic Edit	15	2
49	F47057	EDI Payment Order Remittance Advice - Outbound	63	D3	ACR	Amount - Currency	Numeric	Generic Edit	15	2
50	F47057W	EDI Payment Order Remittance Advice - Work	63	D3	ACR	Amount - Currency	Numeric	Generic Edit	15	2
51	F471061	EDI Response to RFQ Additional Header - Outbound	53	S3	ACR	Amount - Currency	Numeric	Generic Edit	15	2
52	F47114	EDI Lockbox/Payment Detail - Payment	21	Z4	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP48S: Service Billing
53	F4812	Billing Detail Workfile	198	WD	ACR	Amount - Currency	Numeric	Generic Edit	15	2
54	F4812H	Billing Workfile - History	199	WD	ACR	Amount - Currency	Numeric	Generic Edit	15	2
55	F4812HS	Billing Workfile History Purged Save	199	WD	ACR	Amount - Currency	Numeric	Generic Edit	15	2
56	F4822	Invoice Summary Work File	43	W4	ACR	Amount - Currency	Numeric	Generic Edit	15	2
57	F4823	Voucher Summary	39	W0	ACR	Amount - Currency	Numeric	Generic Edit	15	2
58	F48S910	Billing Detail Journal File	31	W2	ACR	Amount - Currency	Numeric	Generic Edit	15	2
59	F48S911	Compressed Journal File	31	W3	ACR	Amount - Currency	Numeric	Generic Edit	15	2
60	F48SUI01	Billing Detail Print Workfile	195	WD	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP57: Reserved for Clients
61	F74T531	Customer Ledger Tranaction File	18	CT	ACR	Amount - Currency	Numeric	Generic Edit	15	2
62	F74T532	Supplier Ledger Transaction File	18	SL	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP74: EMEA Localization
63	F74412	Customer / Supplier Balance Workfile (A/R and A/P)	20	RP	ACR	Amount - Currency	Numeric	Generic Edit	15	2
64	F74900	Foreign Receivables and Payables - EMEA	43	RP	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP74P: Poland
65	F74P03BW	A/R Trial Balance - POL - 03B - 74P	13	P3	ACR	Amount - Currency	Numeric	Generic Edit	15	2
66	F74P04W	A/P Trial Balance Work Table - POL - 04 - 74P	13	P2	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP74R: CIS
67	F74R0018	Russian Tax File - 74R	19	TD	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP74U: United Kingdom Localizations
68	F74U25BT	Interest Tag Table - 15	11	PK	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP74W: Sweden - Reporting System Only
69	F74W203	Debit Advice Invoice File - 74W	8	K3	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP76A: Argentina
70	F760473A	PCG Detail Information Tag File - ARG - 04	10	E5	ACR	Amount - Currency	Numeric	Generic Edit	15	2
71	F76A0440	Check details RG 1547 - ARG - 04 - 76A	10	CD	ACR	Amount - Currency	Numeric	Generic Edit	15	2
72	F76A08	Credit Invoice Payments - ARG - 00	10	CF	ACR	Amount - Currency	Numeric	Generic Edit	15	2
73	F76A09	Invoice Total - ARG - 00 - 00	16	TT	ACR	Amount - Currency	Numeric	Generic Edit	15	2
74	F76A09P	Invoice Total Purge - ARG - 03B - 76A	16	TT	ACR	Amount - Currency	Numeric	Generic Edit	15	2
75	F76A21	Credit Invoice Header - F76A21 - ARG - 3B - 76A	15	IH	ACR	Amount - Currency	Numeric	Generic Edit	15	2
76	F76A21P	Credit Invoice Header Purge - ARG - 03B - 76A	15	IH	ACR	Amount - Currency	Numeric	Generic Edit	15	2
77	F76A22	Credit Invoice Detail - F76A22 - ARG - 03B - 76A	10	ID	ACR	Amount - Currency	Numeric	Generic Edit	15	2
78	F76A22P	Credit Invoice Detail Purge - ARG - 03B - 76A	10	ID	ACR	Amount - Currency	Numeric	Generic Edit	15	2
79	F76A24	Credit Invoice Information - Accounts Payable - ARG - - 76A	17	IE	ACR	Amount - Currency	Numeric	Generic Edit	15	2
80	F76A81	A/P Payment Control Group File - ARG - 04 - 76A	7	C5	ACR	Amount - Currency	Numeric	Generic Edit	15	2
81	F76A82	A/P Payment Control Group File - ARG - 04 - 76A	6	C6	ACR	Amount - Currency	Numeric	Generic Edit	15	2
82	F76A8500	Tag File F03B14 - ARG - 03B - 76A	15	TF	ACR	Amount - Currency	Numeric	Generic Edit	15	2
83	F76A8510	Tag File F76A60 - ARG - 03B - 76A	5	TF	ACR	Amount - Currency	Numeric	Generic Edit	15	2
84	F76A85Z1	Tag File F76A60 Batch Entry - ARG - 03B - 76A	10	BE	ACR	Amount - Currency	Numeric	Generic Edit	15	2
85	F76AUI81	Draft - Invoices Work File - ARG - 03B - 76A	9	WF	ACR	Amount - Currency	Numeric	Generic Edit	15	2
86	F76AUI83	Draft - Application Drafts - Invoices Work File - ARG - 76A	10	WF	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP76B: Brazil - Reporting System Only
87	F76B473T	F04573 Brazilian Temp WH File - BR - 04	18	W3	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP76C: Colombia
88	F76C031A	A/R Customer ledger As Of - F76C031A - COL - 04	35	RP	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP76P: Peru
89	F76P473T	F04573 Tag File - PER - 04 - 76P	10	K3	ACR	Amount - Currency	Numeric	Generic Edit	15	2
TOP89: Conversion Programs
90	F05290T	Needed for upgrade from Xe to B9	3	JR	ACR	Amount - Currency	Numeric	Generic Edit	15	2
91	F06116T	Needed for upgrade from Xe to B9	7	YT	ACR	Amount - Currency	Numeric	Generic Edit	15	2
92	F06116TZ	Needed for upgrade from Xe to B9	8	VL	ACR	Amount - Currency	Numeric	Generic Edit	15	2
93	F0618T	Needed for upgrade from Xe to B9	7	YT	ACR	Amount - Currency	Numeric	Generic Edit	15	2
94	F063951T	Needed for upgrade from Xe to B9	3	GL	ACR	Amount - Currency	Numeric	Generic Edit	15	2

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

94 columns | 812 | ACR