	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

146 columns | 910 | AG

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0018	Taxes	56	TD	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP03: Accounts Receivable
2	F0311	Accounts Receivable Ledger	24	RP	AG	Amount - Gross	Numeric	Generic Edit	15	2
3	F0312	A/R Batch Cash Application	23	RU	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP03B: Enhanced Accounts Receivable
4	F03B11	Customer Ledger	24	RP	AG	Amount - Gross	Numeric	Generic Edit	15	2
5	F03B112	Invoice Revisions	26	RW	AG	Amount - Gross	Numeric	Generic Edit	15	2
6	F03B112P	Invoice Revisions Purge File	26	RW	AG	Amount - Gross	Numeric	Generic Edit	15	2
7	F03B11P	Customer Ledger Purge File	24	RP	AG	Amount - Gross	Numeric	Generic Edit	15	2
8	F03B11Z1	Batch Invoices	42	VJ	AG	Amount - Gross	Numeric	Generic Edit	15	2
9	F03B11Z2	F03B11 Interoperability Table	37	SY	AG	Amount - Gross	Numeric	Generic Edit	15	2
10	F03B13Z1	Electronic Receipts Input	29	RU	AG	Amount - Gross	Numeric	Generic Edit	15	2
11	F03B16	A/R Statistical History	17	RV	AG	Amount - Gross	Numeric	Generic Edit	15	2
12	F03B16S	A/R Statistical Summary	10	RS	AG	Amount - Gross	Numeric	Generic Edit	15	2
13	F03B20	A/R Notification History	62	ZR	AG	Amount - Gross	Numeric	Generic Edit	15	2
14	F03B21	A/R Notification History Detail	61	ZS	AG	Amount - Gross	Numeric	Generic Edit	15	2
15	F03B465	A/R Netting Workfile	24	RO	AG	Amount - Gross	Numeric	Generic Edit	15	2
16	F03B571	Auto Debit Batch Control	11	RC	AG	Amount - Gross	Numeric	Generic Edit	15	2
17	F03B575	Auto Debit Invoice Select and Build	27	RD	AG	Amount - Gross	Numeric	Generic Edit	15	2
18	F03BUI04	Work File for Integrity by Offset Account	5	W3	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP04: Accounts Payable
19	F0411	Accounts Payable Ledger	24	RP	AG	Amount - Gross	Numeric	Generic Edit	15	2
20	F0411A	WF - As Of Accounts Payable Ledger	24	RP	AG	Amount - Gross	Numeric	Generic Edit	15	2
21	F0411P	Purge - Accounts Payable Ledger	24	RP	AG	Amount - Gross	Numeric	Generic Edit	15	2
22	F0411Z1	Voucher Transactions - Batch Upload	42	VL	AG	Amount - Gross	Numeric	Generic Edit	15	2
23	F0411Z3	F0411 Interoperability Table	46	SZ	AG	Amount - Gross	Numeric	Generic Edit	15	2
24	F04573	A/P Payment Processing - Detail	37	KI	AG	Amount - Gross	Numeric	Generic Edit	15	2
25	F09UI005	Tax Offsets User Index	1	GL	AG	Amount - Gross	Numeric	Generic Edit	15	2
26	F09UI006	Tax (F0018) Replica	56	TD	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP07: Payroll
27	F06491	Payroll/Accounts Payable Ledger Detail	9	J6	AG	Amount - Gross	Numeric	Generic Edit	15	2
28	F06492	Payroll - Accounts Payable Control	9	JC	AG	Amount - Gross	Numeric	Generic Edit	15	2
29	F07491	Payroll - Accounts Payable Summary File	9	J6	AG	Amount - Gross	Numeric	Generic Edit	15	2
30	F07492	Payroll - Accounts Payable Control File	9	JC	AG	Amount - Gross	Numeric	Generic Edit	15	2
31	F07880	SUI Magnetic Media Workfile	55	YW	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP09: General Accounting
32	F0911Z1	Journal Entry Transactions - Batch File	182	VN	AG	Amount - Gross	Numeric	Generic Edit	15	2
33	F0917	Bank Statement Detail	10	GD	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP15: Property Management
34	F15015	Minimum rent/recoveries Master	11	NQ	AG	Amount - Gross	Numeric	Generic Edit	15	2
35	F15015B	Min/Max Rents And Recoveries Master	18	NQ	AG	Amount - Gross	Numeric	Generic Edit	15	2
36	F1502	Recurring Billings Master	8	NF	AG	Amount - Gross	Numeric	Generic Edit	15	2
37	F1502B	Recurring Billings Master	8	NF	AG	Amount - Gross	Numeric	Generic Edit	15	2
38	F1502WAB	Rent Increase Amounts	6	NF	AG	Amount - Gross	Numeric	Generic Edit	15	2
39	F1502WB	Estimated EP Recurring Billings	10	N4	AG	Amount - Gross	Numeric	Generic Edit	15	2
40	F1511	Tenant/Lease Billings Detail	23	NJ	AG	Amount - Gross	Numeric	Generic Edit	15	2
41	F1511B	Lease Billings Master	23	NJ	AG	Amount - Gross	Numeric	Generic Edit	15	2
42	F1511H	Tenant/Lease Billings Detail History	23	N#	AG	Amount - Gross	Numeric	Generic Edit	15	2
43	F1511HB	Lease Billings History	23	NC	AG	Amount - Gross	Numeric	Generic Edit	15	2
44	F151991	G/L Transaction A/R Application Work File	10	NB	AG	Amount - Gross	Numeric	Generic Edit	15	2
45	F1525	A/R Fee Interest	8	N0	AG	Amount - Gross	Numeric	Generic Edit	15	2
46	F1525B	Fees and Interest	9	NM	AG	Amount - Gross	Numeric	Generic Edit	15	2
47	F1538	WF - Expence Participation Register	48	NZ	AG	Amount - Gross	Numeric	Generic Edit	15	2
48	F1538B	EP Billing Register	49	NZ	AG	Amount - Gross	Numeric	Generic Edit	15	2
49	F1565	Security Deposit Master	14	JF	AG	Amount - Gross	Numeric	Generic Edit	15	2
50	F15703	Legal Clause Amounts	5	NI	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP15L: Adv Real Estate Forecasting
51	F15L302	AREF Prior Gross Billings	18	PG	AG	Amount - Gross	Numeric	Generic Edit	15	2
52	F15L38	AREF EP Billing Register	53	NZ	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP17C: Call Management
53	F1755	Case Master	104	ZA	AG	Amount - Gross	Numeric	Generic Edit	15	2
54	F1760	Time Entry	29	ZB	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP43: Procurement
55	F4314Z	Voucher Match Selection File	53	PN	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP43S: Supplier Self Service
56	F4323	PO FLIP Header	8	PD	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP47: Electronic Commerce
57	F470161	EDI Purchase Order Additional Header - Outbound	46	S3	AG	Amount - Gross	Numeric	Generic Edit	15	2
58	F47042	EDI Invoice Detail - Inbound	61	SZ	AG	Amount - Gross	Numeric	Generic Edit	15	2
59	F47044	EDI Invoice Summary - Inbound	27	SW	AG	Amount - Gross	Numeric	Generic Edit	15	2
60	F470461	EDI Invoice Additional Header - Outbound	47	S3	AG	Amount - Gross	Numeric	Generic Edit	15	2
61	F47057	EDI Payment Order Remittance Advice - Outbound	56	D3	AG	Amount - Gross	Numeric	Generic Edit	15	2
62	F47057W	EDI Payment Order Remittance Advice - Work	56	D3	AG	Amount - Gross	Numeric	Generic Edit	15	2
63	F471061	EDI Response to RFQ Additional Header - Outbound	47	S3	AG	Amount - Gross	Numeric	Generic Edit	15	2
64	F47114	EDI Lockbox/Payment Detail - Payment	19	Z4	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP49: Transportation Management
65	F4945	Shipment Charges	15	SC	AG	Amount - Gross	Numeric	Generic Edit	15	2
66	F4981	Freight Audit History	32	FH	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP55: Reserved for Clients
67	F74H1051	Invoicing Workfile - New	20	IW	AG	Amount - Gross	Numeric	Generic Edit	15	2
68	F74T531	Customer Ledger Tranaction File	6	CT	AG	Amount - Gross	Numeric	Generic Edit	15	2
69	F74T532	Supplier Ledger Transaction File	16	SL	AG	Amount - Gross	Numeric	Generic Edit	15	2
70	F74T133	Customer Year End Table	5	CT	AG	Amount - Gross	Numeric	Generic Edit	15	2
71	F74T134	Supplier Year End Table	5	ST	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP74: EMEA Localization
72	F740018D	Data extraction ESL - 74	30	DE	AG	Amount - Gross	Numeric	Generic Edit	15	2
73	F740018O	Original Transaction Detail for Data Extraction	14	OT	AG	Amount - Gross	Numeric	Generic Edit	15	2
74	F740018W	Data extraction ESL - Workfile - 74	30	DE	AG	Amount - Gross	Numeric	Generic Edit	15	2
75	F74093	Worktable for Printing IVA Summary - Italy	55	HC	AG	Amount - Gross	Numeric	Generic Edit	15	2
76	F7430030	Legal Document Header (Print Info) - COMM - 03B	18	PI	AG	Amount - Gross	Numeric	Generic Edit	15	2
77	F7430033	A/R Document Line (Print Info) - COMM - 03B	14	PI	AG	Amount - Gross	Numeric	Generic Edit	15	2
78	F74412	Customer / Supplier Balance Worktable (A/P and A/R)	19	RP	AG	Amount - Gross	Numeric	Generic Edit	15	2
79	F74900	Foreign Receivables and Payables - EMEA	31	RP	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP74H: Hungary
80	F74H410	Foreign Voucher Supplier Amounts - HUN - 74H	18	SA	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP74P: Poland
81	F74P03BW	A/R Trial Balance - POL - 03B - 74P	12	P3	AG	Amount - Gross	Numeric	Generic Edit	15	2
82	F74P04W	A/P Trial Balance Work Table - POL - 04 - 74P	12	P2	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP74R: CIS
83	F74R0018	Russian Tax File - 74R	15	TD	AG	Amount - Gross	Numeric	Generic Edit	15	2
84	F74R0480	Pay Item Differences - RUS - 04 - 74R	9	RP	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP74U: United Kingdom Localizations
85	F74U0405	SPC Certificate Holding Table - UK - 43	28	CH	AG	Amount - Gross	Numeric	Generic Edit	15	2
86	F74U0420	SPC - Application Master - UK - 43	36	SE	AG	Amount - Gross	Numeric	Generic Edit	15	2
87	F74U0425	SPC - Certificate Master - UK - 43	38	SF	AG	Amount - Gross	Numeric	Generic Edit	15	2
88	F74U4053	Subcontractor Documents Detail - CIS Monthly Return - UK- 04	9	DM	AG	Amount - Gross	Numeric	Generic Edit	15	2
89	F74U4316	SPC - Purchase Order Line Additional Information - UK - 43	16	SC	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP74Y: Italy - Reporting System Only
90	F74Y015	Yearly List Declaration - WF - IT - 00	20	YL	AG	Amount - Gross	Numeric	Generic Edit	15	2
91	F74Y171	Contract Relations - IT - 00	9	CR	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP74Z: Czech Republic
92	F74ZUI02	Czech VAT Report - CZE - 74Z - Work File	4	CZ	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP75A: Australia - Reporting System Only
93	F75A0220	Payment Summary Workfile	20	PS	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP75C: China - Reporting System Only
94	F75C010W	AP & AR XML Workfile - China -75C	18	AA	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP75I: India
95	F75I100	TDS Ceritificate Master Maintenance	11	QB	AG	Amount - Gross	Numeric	Generic Edit	15	2
96	F75I100Q	TDS Form 26Q - WorkFile (Quarterly)	12	EF	AG	Amount - Gross	Numeric	Generic Edit	15	2
97	F75I100W	TDS Form 26 - WorkFile	12	EF	AG	Amount - Gross	Numeric	Generic Edit	15	2
98	F75I101	TDS Certificate Work Maintenance	12	QB	AG	Amount - Gross	Numeric	Generic Edit	15	2
99	F75I104	TDS Certificate Master Maintenance Tag File	10	TD	AG	Amount - Gross	Numeric	Generic Edit	15	2
100	F75I119T	Challan number wise amount	4	CN	AG	Amount - Gross	Numeric	Generic Edit	15	2
101	F75I2213	Setoff Temp Table	25	TT	AG	Amount - Gross	Numeric	Generic Edit	15	2
102	F75I403	Stock Transfer Details	30	AB	AG	Amount - Gross	Numeric	Generic Edit	15	2
103	F75I403T	Temp Data for F75i403	31	AB	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP76A: Argentina
104	F760081A	SICORE Step 1 & 2 - ARG - 03B - 76A	8	V6	AG	Amount - Gross	Numeric	Generic Edit	15	2
105	F760473A	PCG Detail Information Tag Table - ARG - 04 - 76A	9	E5	AG	Amount - Gross	Numeric	Generic Edit	15	2
106	F76A0209	Header & Footer Invoice/ShipmentNote History WF - ARG - 76A	50	HF	AG	Amount - Gross	Numeric	Generic Edit	15	2
107	F76A020P	Header/Footer Inv./ShipmentNote History WF Purge - AR - 76A	50	HF	AG	Amount - Gross	Numeric	Generic Edit	15	2
108	F76A0219	Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A	15	DL	AG	Amount - Gross	Numeric	Generic Edit	15	2
109	F76A021P	Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76A	15	DL	AG	Amount - Gross	Numeric	Generic Edit	15	2
110	F76A0440	Check details RG 1547 - ARG - 04 - 76A	6	CD	AG	Amount - Gross	Numeric	Generic Edit	15	2
111	F76A08	Credit Invoice Payments - ARG - 04 - 76A	7	CF	AG	Amount - Gross	Numeric	Generic Edit	15	2
112	F76A09	Invoice Total - ARG - 03B - 76A	13	TT	AG	Amount - Gross	Numeric	Generic Edit	15	2
113	F76A09P	Invoice Total Purge - ARG - 03B - 76A	13	TT	AG	Amount - Gross	Numeric	Generic Edit	15	2
114	F76A21	Credit Invoice Header - F76A21 - ARG - 3B - 76A	14	IH	AG	Amount - Gross	Numeric	Generic Edit	15	2
115	F76A21P	Credit Invoice Header Purge - ARG - 03B - 76A	14	IH	AG	Amount - Gross	Numeric	Generic Edit	15	2
116	F76A22	Credit Invoice Detail - F76A22 - ARG - 03B - 76A	9	ID	AG	Amount - Gross	Numeric	Generic Edit	15	2
117	F76A22P	Credit Invoice Detail Purge - ARG - 03B - 76A	9	ID	AG	Amount - Gross	Numeric	Generic Edit	15	2
118	F76A23	Credit Invoice Withholdings - F76A23 - ARG - 03B - 76A	8	IW	AG	Amount - Gross	Numeric	Generic Edit	15	2
119	F76A23P	Credit Invoice Withholdings Purge - ARG - 03B - 76A	8	IW	AG	Amount - Gross	Numeric	Generic Edit	15	2
120	F76A24	Credit Invoice Information - Accounts Payable - ARG - - 76A	16	IE	AG	Amount - Gross	Numeric	Generic Edit	15	2
121	F76A8001	Generation SICOREs - Last Step -RG 738/99 - ARG - 04 - 76A	6	V2	AG	Amount - Gross	Numeric	Generic Edit	15	2
122	F76A81	A/P Payment Control Group File - ARG - 04 - 76A	6	C5	AG	Amount - Gross	Numeric	Generic Edit	15	2
123	F76A82	A/P Payment Control Group File - ARG - 04 - 76A	5	C6	AG	Amount - Gross	Numeric	Generic Edit	15	2
124	F76A8500	Tag File F03B14 - ARG - 03B - 76A	12	TF	AG	Amount - Gross	Numeric	Generic Edit	15	2
125	F76A8510	Tag File F76A60 - ARG - 03B - 76A	3	TF	AG	Amount - Gross	Numeric	Generic Edit	15	2
126	F76A85Z1	Tag File F76A60 Batch Entry - ARG - 03B - 76A	8	BE	AG	Amount - Gross	Numeric	Generic Edit	15	2
127	F76AUI20	Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A	50	HF	AG	Amount - Gross	Numeric	Generic Edit	15	2
128	F76AUI21	Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A	15	DL	AG	Amount - Gross	Numeric	Generic Edit	15	2
129	F76AUI81	Draft - Invoices Work File - ARG - 03B - 76A	12	WF	AG	Amount - Gross	Numeric	Generic Edit	15	2
130	F76AUI83	Draft - Application Drafts - Invoices Work File - ARG - 76A	14	WF	AG	Amount - Gross	Numeric	Generic Edit	15	2
131	F76AUI89	Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76A	11	WF	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP76B: Brazil - Reporting System Only
132	F76B20	Account Payable and Receivable Table - IN68 - 03B	6	PR	AG	Amount - Gross	Numeric	Generic Edit	15	2
133	F76B4016	Tax Accumulates by AN8 - BR - 04	5	AA	AG	Amount - Gross	Numeric	Generic Edit	15	2
134	F76B4017	Tax Accumulates by AN8 - Company - BR - 04	6	AC	AG	Amount - Gross	Numeric	Generic Edit	15	2
135	F76B424	Service Nota Fiscal Accumulated Withholding-BRA-76B	6	SW	AG	Amount - Gross	Numeric	Generic Edit	15	2
136	F76B8602	IN86-Work Table for Suppliers and Customers - 04	12	PR	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP76C: Colombia
137	F76C031A	A/R Customer ledger As Of - F76C031A - COL - 04	24	RP	AG	Amount - Gross	Numeric	Generic Edit	15	2
138	F76C9F11	DIAN Formats File by Account Id - COL - 09	15	DF	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP76H: Chile
139	F76H218	Taxes by Sales Order Line - CHI - 42 - 76H	11	TD	AG	Amount - Gross	Numeric	Generic Edit	15	2
140	F76H3B31	Legal Document Header (Print Info) - CHI - 03B - 76H	39	PI	AG	Amount - Gross	Numeric	Generic Edit	15	2
141	F76HUI32	Workfile for R76H3B40 - CHI - 42 - 76H	18	WF	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP76P: Peru
142	F76P473T	F04573 Tag File - PER - 04 - 76P	9	K3	AG	Amount - Gross	Numeric	Generic Edit	15	2
TOP76V: Venezuela
143	F76V4581	Withholding Historical File - VEN - 04	14	HR	AG	Amount - Gross	Numeric	Generic Edit	15	2
144	F76VLC01	Purchase Register Temporal - VEN -04 - 76V	7	LC	AG	Amount - Gross	Numeric	Generic Edit	15	2
145	F76VLO01	Withholdings Temporal Table - VEN -04 - 76V	11	LO	AG	Amount - Gross	Numeric	Generic Edit	15	2
146	F76VTART	Temporal Table for Withholdings - VEN -04 - 76V	11	TR	AG	Amount - Gross	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

146 columns | 910 | AG