	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

159 columns | 812 | SFX

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0018R	Tax Reconciliation Repository	7	ED	SFX	Document Pay Item	String	Generic Edit	3	0
2	F0911	Account Ledger	41	GL	SFX	Document Pay Item	String	Generic Edit	3	0
TOP03: Accounts Receivable
3	F0311	Accounts Receivable Ledger	5	RP	SFX	Document Pay Item	String	Generic Edit	3	0
4	F0312	A/R Batch Cash Application	12	RU	SFX	Document Pay Item	String	Generic Edit	3	0
TOP03B: Enhanced Accounts Receivable
5	F03B11	Customer Ledger	4	RP	SFX	Document Pay Item	String	Generic Edit	3	0
6	F03B112	Invoice Revisions	4	RW	SFX	Document Pay Item	String	Generic Edit	3	0
7	F03B112P	Invoice Revisions Purge File	4	RW	SFX	Document Pay Item	String	Generic Edit	3	0
8	F03B11P	Customer Ledger Purge File	4	RP	SFX	Document Pay Item	String	Generic Edit	3	0
9	F03B11Z1	Invoice Transactions - Batch File	22	VJ	SFX	Document Pay Item	String	Generic Edit	3	0
10	F03B11Z2	F03B11 Interoperability Table	17	SY	SFX	Document Pay Item	String	Generic Edit	3	0
11	F03B13Z1	Electronic Receipts Input	10	RU	SFX	Document Pay Item	String	Generic Edit	3	0
12	F03B14	A/R Check Detail File	7	RZ	SFX	Document Pay Item	String	Generic Edit	3	0
13	F03B14P	Receipts Detail Purge File	7	RZ	SFX	Document Pay Item	String	Generic Edit	3	0
14	F03B14Z2	F03B14 Interoperability Table	20	SZ	SFX	Document Pay Item	String	Generic Edit	3	0
15	F03B21	A/R Notification History Detail	8	ZS	SFX	Document Pay Item	String	Generic Edit	3	0
16	F03B22	A/R Fee Journal History	5	RS	SFX	Document Pay Item	String	Generic Edit	3	0
17	F03B23	A/R Fee Journal History Detail	6	RT	SFX	Document Pay Item	String	Generic Edit	3	0
18	F03B465	A/R Netting Workfile	6	RO	SFX	Document Pay Item	String	Generic Edit	3	0
19	F03B575	Auto Debit Invoice Select and Build	7	RD	SFX	Document Pay Item	String	Generic Edit	3	0
TOP04: Accounts Payable
20	F0411	Accounts Payable Ledger	4	RP	SFX	Document Pay Item	String	Generic Edit	3	0
21	F0411A	WF - As Of - Accounts Payable Ledger	4	RP	SFX	Document Pay Item	String	Generic Edit	3	0
22	F0411P	Purge - Accounts Payable Ledger	4	RP	SFX	Document Pay Item	String	Generic Edit	3	0
23	F0411Z1	Voucher Transactions - Batch File	22	VL	SFX	Document Pay Item	String	Generic Edit	3	0
24	F0411Z3	F0411 Interoperability Table	26	SZ	SFX	Document Pay Item	String	Generic Edit	3	0
25	F0414	Accounts Payable Matching Document Detail	7	RN	SFX	Document Pay Item	String	Generic Edit	3	0
26	F0414A	WF - As Of - Accounts Payable Payment Detail	7	RN	SFX	Document Pay Item	String	Generic Edit	3	0
27	F0414P	Purge - Accounts Payable Matching Document Detail	7	RN	SFX	Document Pay Item	String	Generic Edit	3	0
28	F0414Z1	F0414 Interoperability Table	20	SZ	SFX	Document Pay Item	String	Generic Edit	3	0
29	F0450	Payee Control File	10	PC	SFX	Document Pay Item	String	Generic Edit	3	0
30	F04573	A/P Payment Processing - Detail File	7	KI	SFX	Document Pay Item	String	Generic Edit	3	0
TOP07: Payroll
31	F06491	Payroll/Accounts Payable Ledger Detail	19	J6	SFX	Document Pay Item	String	Generic Edit	3	0
32	F07491	Payroll - Accounts Payable Summary File	19	J6	SFX	Document Pay Item	String	Generic Edit	3	0
TOP09: General Accounting
33	F0911P	Purge - Account Ledger	41	GL	SFX	Document Pay Item	String	Generic Edit	3	0
34	F0911R	WF - Acct Ledger File for Reconciliation	38	GL	SFX	Document Pay Item	String	Generic Edit	3	0
35	F0911Z1	Journal Entry Transactions - Batch File	58	VN	SFX	Document Pay Item	String	Generic Edit	3	0
36	F0911Z4	F0911 Interoperability Table	63	SZ	SFX	Document Pay Item	String	Generic Edit	3	0
37	F0912	Cost Allocations/Flex Budgeting	25	RJ	SFX	Document Pay Item	String	Generic Edit	3	0
38	F0912A	Index Computation Entry File	21	RI	SFX	Document Pay Item	String	Generic Edit	3	0
39	F0917	Bank Statement Detail	27	GD	SFX	Document Pay Item	String	Generic Edit	3	0
40	F09617	Auto Bank Statement Detail	30	GM	SFX	Document Pay Item	String	Generic Edit	3	0
41	F09UI015	Indexed Computations Multi-Tiered Entries	41	GL	SFX	Document Pay Item	String	Generic Edit	3	0
TOP15: Property Management
42	F1511	Tenant/Lease Billings Detail	4	NJ	SFX	Document Pay Item	String	Generic Edit	3	0
43	F1511B	Tenant/Lease Billings Detail Master	4	NJ	SFX	Document Pay Item	String	Generic Edit	3	0
44	F1511H	Tenant/Lease Billings Detail History	4	N#	SFX	Document Pay Item	String	Generic Edit	3	0
45	F1511HB	Tenant/Lease Billings Detail History	4	NC	SFX	Document Pay Item	String	Generic Edit	3	0
46	F151991	G/L Transaction A/R Application Work File	5	NB	SFX	Document Pay Item	String	Generic Edit	3	0
TOP40: Inventory/OP Base
47	F40UI801	Generic Error Table	13	ZB	SFX	Document Pay Item	String	Generic Edit	3	0
TOP41: Inventory Management
48	F4111	Item Ledger File	24	IL	SFX	Document Pay Item	String	Generic Edit	3	0
49	F41UI001	Inventory Transactions Detail File	9	IT	SFX	Document Pay Item	String	Generic Edit	3	0
TOP42: Sales Management
50	F42800G1	Sales Update G Batch Detail Workfile	30	DG	SFX	Document Pay Item	String	Generic Edit	3	0
TOP43: Procurement
51	F4311Z	Purchase Order Generator File	202	PW	SFX	Document Pay Item	String	Generic Edit	3	0
52	F43121	Purchase Order Receiver File	58	PR	SFX	Document Pay Item	String	Generic Edit	3	0
53	F43121T	Purchase Order Receiver Tag File	10	PR	SFX	Document Pay Item	String	Generic Edit	3	0
54	F43121Z1	Receipts Unedited Transaction Table	75	SZ	SFX	Document Pay Item	String	Generic Edit	3	0
55	F4314Z	Voucher Match Selection File	158	PN	SFX	Document Pay Item	String	Generic Edit	3	0
TOP43A: Purchase Order Receipt/Routing
56	F43126	Purchase Order Receiver Multiple Account	25	P4	SFX	Document Pay Item	String	Generic Edit	3	0
57	F43126T	Purchase Order Receiver Multiple Account Tag File	12	P4	SFX	Document Pay Item	String	Generic Edit	3	0
TOP45: Advanced Pricing
58	F4576	Ship and Debit Claims	34	AC	SFX	Document Pay Item	String	Generic Edit	3	0
59	F4576TMP	Ship and Debit Claims- Temp Table	34	AC	SFX	Document Pay Item	String	Generic Edit	3	0
60	F4576Z1	Ship and Debit Claims Unedited Transaction Table	47	Z1	SFX	Document Pay Item	String	Generic Edit	3	0
TOP47: Electronic Commerce
61	F47057	EDI Payment Order Remittance Advice - Outbound	35	D3	SFX	Document Pay Item	String	Generic Edit	3	0
62	F47057W	EDI Payment Order Remittance Advice - Work	35	D3	SFX	Document Pay Item	String	Generic Edit	3	0
63	F47114	EDI Lockbox/Payment Detail - Payment	17	Z4	SFX	Document Pay Item	String	Generic Edit	3	0
64	F47122	EDI Product Activity Data Detail - Inbound	52	MJ	SFX	Document Pay Item	String	Generic Edit	3	0
65	F47127	EDI Product Activity Data Detail - Outbound	52	MJ	SFX	Document Pay Item	String	Generic Edit	3	0
TOP48S: Service Billing
66	F4812	Billing Detail Workfile	130	WD	SFX	Document Pay Item	String	Generic Edit	3	0
67	F4812G	Retro Adjustment Workfile	12	WD	SFX	Document Pay Item	String	Generic Edit	3	0
68	F4812H	Billing Workfile - History	130	WD	SFX	Document Pay Item	String	Generic Edit	3	0
69	F4812HS	Billing Workfile History Purged Save	130	WD	SFX	Document Pay Item	String	Generic Edit	3	0
70	F4822	Invoice Summary Work File	31	W4	SFX	Document Pay Item	String	Generic Edit	3	0
71	F48221	Service Billing Retention Release Cross Reference File	6	WH	SFX	Document Pay Item	String	Generic Edit	3	0
72	F4823	Voucher Summary	29	W0	SFX	Document Pay Item	String	Generic Edit	3	0
73	F48S411	CSB Pay When Paid Table	15	BZ	SFX	Document Pay Item	String	Generic Edit	3	0
74	F48S910	Billing Detail Journal File	14	W2	SFX	Document Pay Item	String	Generic Edit	3	0
75	F48S912	G/L Link File	9	W6	SFX	Document Pay Item	String	Generic Edit	3	0
76	F48SUI01	Billing Detail Print Workfile	130	WD	SFX	Document Pay Item	String	Generic Edit	3	0
TOP74: EMEA Localization
77	F7400006	Processed Documents in Legal Applications - COMM - 00	4	PD	SFX	Document Pay Item	String	Generic Edit	3	0
78	F7404573	Detail Payment Instructions EXT. for German Payments	7	KI	SFX	Document Pay Item	String	Generic Edit	3	0
79	F7430018	Taxes by A/R Invoice Line - COMM - 03B	4	TI	SFX	Document Pay Item	String	Generic Edit	3	0
80	F7430032	Legal Document Detail (Print Info) - COMM - 03B	10	PI	SFX	Document Pay Item	String	Generic Edit	3	0
81	F74411	Withholding Tax Detail File-Italy	4	RS	SFX	Document Pay Item	String	Generic Edit	3	0
82	F74900	Foreign Receivables and Payables - EMEA	5	RP	SFX	Document Pay Item	String	Generic Edit	3	0
TOP74H: Hungary
83	F74H1004	VAT Declaration Detail	4	VD	SFX	Document Pay Item	String	Generic Edit	3	0
TOP74P: Poland
84	F74P03BW	A/R Trial Balance - POL - 03B - 74P	4	P3	SFX	Document Pay Item	String	Generic Edit	3	0
85	F74P04W	A/P Trial Balance Work Table - POL - 04 - 74P	4	P2	SFX	Document Pay Item	String	Generic Edit	3	0
86	F74P3B24	Processed Documents in Finance Charge Processing - POL - 03B	4	PD	SFX	Document Pay Item	String	Generic Edit	3	0
TOP74R: CIS
87	F74R0018	Russian Tax File - 74R	8	TD	SFX	Document Pay Item	String	Generic Edit	3	0
88	F74R0480	Pay Item Differences - RUS - 04 - 74R	4	RP	SFX	Document Pay Item	String	Generic Edit	3	0
89	F74R3B14	F03B14 Tag File - RUS - 03B - 74R	8	TF	SFX	Document Pay Item	String	Generic Edit	3	0
90	F74R4014	F0414 Tag File - RUS - 04 - 74R	7	TF	SFX	Document Pay Item	String	Generic Edit	3	0
TOP74U: United Kingdom Localizations
91	F74U0116	F0411 CIS Tag File	4	TF	SFX	Document Pay Item	String	Generic Edit	3	0
92	F74U0118	Payment Voucher Status History	4	VH	SFX	Document Pay Item	String	Generic Edit	3	0
93	F74U0205	Payment Profile - 15	19	P8	SFX	Document Pay Item	String	Generic Edit	3	0
94	F74U4053	Subcontractor Documents Detail - CIS Monthly Return - UK- 04	6	DM	SFX	Document Pay Item	String	Generic Edit	3	0
TOP74W: Sweden - Reporting System Only
95	F74W200	A/P Payment Processing Sequence Numbers File - 74W	7	K0	SFX	Document Pay Item	String	Generic Edit	3	0
96	F74W203	Debit Advice Invoice File - 74W	17	K3	SFX	Document Pay Item	String	Generic Edit	3	0
TOP74Y: Italy - Reporting System Only
97	F743B14I	Suspended IVA Generation - Receipt/Rebate Control-Italy	15	TI	SFX	Document Pay Item	String	Generic Edit	3	0
TOP75A: Australia - Reporting System Only
98	F75A0201	Recipient Created Tax Invoice Tag File	5	TF	SFX	Document Pay Item	String	Generic Edit	3	0
99	F75A0202	GST - RCTI Adjustment Print Control Table	5	RA	SFX	Document Pay Item	String	Generic Edit	3	0
100	F75A200	GST - Tax Invoice / Adjustment Note Tag file	6	TF	SFX	Document Pay Item	String	Generic Edit	3	0
TOP75C: China - Reporting System Only
101	F75C001	Chinese GUI cross reference file	6	CR	SFX	Document Pay Item	String	Generic Edit	3	0
TOP75J: Japan - Reporting System Only
102	F750411	Withholding Tax Detail Table - Japan	4	JX	SFX	Document Pay Item	String	Generic Edit	3	0
TOP75T: Taiwan
103	F75T005	GUI/VAT Transaction Detail - 75T	27	TD	SFX	Document Pay Item	String	Generic Edit	3	0
104	F75T0059	GUI/VAT Transaction Detail History - 75T	27	TD	SFX	Document Pay Item	String	Generic Edit	3	0
105	F75T005P	GUI/VAT Transaction Detail POS - 75T	27	TD	SFX	Document Pay Item	String	Generic Edit	3	0
106	F75T005Z	GUI/VAT Transaction Detail - Work - 75T	33	ZD	SFX	Document Pay Item	String	Generic Edit	3	0
TOP76A: Argentina
107	F760411A	A/P Tag Ledger Tag File - ARG	4	B2	SFX	Document Pay Item	String	Generic Edit	3	0
108	F760414A	A/P Payment Detail Tag File - ARG - 04	7	V1	SFX	Document Pay Item	String	Generic Edit	3	0
109	F760473A	PCG Detail Information Tag File - ARG - 04	7	E5	SFX	Document Pay Item	String	Generic Edit	3	0
110	F760499A	Contract Withholding - Advances - ARG -04 - 04	10	K8	SFX	Document Pay Item	String	Generic Edit	3	0
111	F76A19	Taxes - Tax Amounts by Invoice Suffix AGR	4	TI	SFX	Document Pay Item	String	Generic Edit	3	0
112	F76A19P	Taxes - Tax Amounts by Invoice Suffix Purge ARG - 03B - 76A	4	TI	SFX	Document Pay Item	String	Generic Edit	3	0
113	F76A19Z1	Taxes - Tax Amounts by Invoice Suffix - Batch Entry A - 03B	22	VK	SFX	Document Pay Item	String	Generic Edit	3	0
114	F76A24	Credit Invoice Information - Accounts Payable - ARG - - 76A	4	IE	SFX	Document Pay Item	String	Generic Edit	3	0
115	F76A33	Receipt Invoice - Audit Log AGR	4	X4	SFX	Document Pay Item	String	Generic Edit	3	0
116	F76A411P	Purge A/P Tag Ledger Tag - ARG - 04 - 76A	4	B2	SFX	Document Pay Item	String	Generic Edit	3	0
117	F76A411Q	F76A411P Tag File Purge - ARG - 04 - 76A	4	B1	SFX	Document Pay Item	String	Generic Edit	3	0
118	F76A411T	F760411A A/P Tag File - ARG - 04 - 76A	4	B1	SFX	Document Pay Item	String	Generic Edit	3	0
119	F76A414P	Purge - A/P Payment Detail - ARG - 04 - 76A	7	V1	SFX	Document Pay Item	String	Generic Edit	3	0
120	F76A50	Processed Documents in Legal Applications - ARG - 00 - 76A	4	A1	SFX	Document Pay Item	String	Generic Edit	3	0
121	F76A8017	A/P Payment Detail Aditional Tag File RG 738 - ARG - 04	6	TF	SFX	Document Pay Item	String	Generic Edit	3	0
122	F76A8500	Tag File F03B14 - ARG - 03B - 76A	7	TF	SFX	Document Pay Item	String	Generic Edit	3	0
123	F76AUI04	A/P Tag Legel Tax File - ARG - WF	4	WC	SFX	Document Pay Item	String	Generic Edit	3	0
124	F76AUI24	Taxes Work File - ARG - 00	4	TI	SFX	Document Pay Item	String	Generic Edit	3	0
125	F76AUI51	Credit Invoice - Create PGC Error and Wrn - ARG - 04 - 76A	7	IK	SFX	Document Pay Item	String	Generic Edit	3	0
126	F76AUI81	Draft - Invoices Work File - ARG - 03B - 76A	6	WF	SFX	Document Pay Item	String	Generic Edit	3	0
127	F76AUI83	Draft - Application Drafts - Invoices Work File - ARG - 76A	7	WF	SFX	Document Pay Item	String	Generic Edit	3	0
128	F76AUI89	Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76A	8	WF	SFX	Document Pay Item	String	Generic Edit	3	0
TOP76B: Brazil - Reporting System Only
129	F7603B1	A/R Additional Information - Brazil	4	CI	SFX	Document Pay Item	String	Generic Edit	3	0
130	F7603B1P	Archive A/R Additional Information - Brazil - 03B	4	BP	SFX	Document Pay Item	String	Generic Edit	3	0
131	F76B0411	Voucher Additional Information Brazil - 04	4	VB	SFX	Document Pay Item	String	Generic Edit	3	0
132	F76B04BC	Voucher Additional Information - Brazil - 04	4	BC	SFX	Document Pay Item	String	Generic Edit	3	0
133	F76B20	Account Payable and Receivable Table - IN68 - 03B	10	PR	SFX	Document Pay Item	String	Generic Edit	3	0
134	F76B410H	INSS-Work Table for Services Third Party Inbound NF H - 42	21	SI	SFX	Document Pay Item	String	Generic Edit	3	0
135	F76B473T	F04573 Brazilian Temp WH File - BR - 04	7	W3	SFX	Document Pay Item	String	Generic Edit	3	0
136	F76B8602	IN86-Work Table for Suppliers and Customers - 04	19	PR	SFX	Document Pay Item	String	Generic Edit	3	0
TOP76C: Colombia
137	F76C031A	A/R Customer ledger As Of - F76C031A - COL - 04	4	RP	SFX	Document Pay Item	String	Generic Edit	3	0
138	F76C034A	A/R Check Detail file As Of - COL - 76C	7	RZ	SFX	Document Pay Item	String	Generic Edit	3	0
139	F76C0411	A/P Tag File - COL - 76C	4	RP	SFX	Document Pay Item	String	Generic Edit	3	0
140	F76C311T	A/R Tag File - Recycle Recurring - COL - 03B - 76C	4	RP	SFX	Document Pay Item	String	Generic Edit	3	0
141	F76C4011	A/P Ledger Tag Table - COL - 04	4	VC	SFX	Document Pay Item	String	Generic Edit	3	0
142	F76C575	Work File Magnetic Media - COL - 04	9	Q1	SFX	Document Pay Item	String	Generic Edit	3	0
143	F76CT1	Tributary Information - COL - 76C	9	TI	SFX	Document Pay Item	String	Generic Edit	3	0
144	F76CUI02	Tax Detail - Work File - COL - 76C	5	TD	SFX	Document Pay Item	String	Generic Edit	3	0
TOP76H: Chile
145	F76H3B32	Legal Document Detail (Print Info) - CHI - 03B - 76H	10	PI	SFX	Document Pay Item	String	Generic Edit	3	0
146	F76H402	Chilean A/P Doc Lines Print Mark - CHI - 04 - 76H	6	LP	SFX	Document Pay Item	String	Generic Edit	3	0
147	F76H611	Actual Item Ledger File - CHI - 41 - 76H	25	AL	SFX	Document Pay Item	String	Generic Edit	3	0
148	F76HUI33	Workfile for R76H3B40 - CHI - 42 - 76H	7	WF	SFX	Document Pay Item	String	Generic Edit	3	0
TOP76M: Mexico
149	F76M311	AR Soft Rounding VAT - Mexico	4	MB	SFX	Document Pay Item	String	Generic Edit	3	0
150	F76M411	Soft Rounding VAT Calculation	4	RS	SFX	Document Pay Item	String	Generic Edit	3	0
TOP76P: Peru
151	F76P411T	Peru AP Tag File - PER - 04 - 76P	4	T4	SFX	Document Pay Item	String	Generic Edit	3	0
152	F76P414T	F0414 Tag File - PER - 04 - 76P	7	P4	SFX	Document Pay Item	String	Generic Edit	3	0
153	F76P473T	F04573 Tag File - PER - 04 - 76P	7	K3	SFX	Document Pay Item	String	Generic Edit	3	0
154	F76PUI45	Workfile VAT Purchasing Ledger - PER - 04 - 76P	7	WF	SFX	Document Pay Item	String	Generic Edit	3	0
TOP76V: Venezuela
155	F76V0401	Relation Invoice/Retention Code - VEN - 76V	4	RE	SFX	Document Pay Item	String	Generic Edit	3	0
156	F76V4011	A/P Ledger Tag File - VEN - 04	4	TF	SFX	Document Pay Item	String	Generic Edit	3	0
157	F76V4581	Withholding Historical File - VEN - 04	4	HR	SFX	Document Pay Item	String	Generic Edit	3	0
158	F76V4582	Wittholding Documents Temporal - VEN - 04 - 76V	4	DR	SFX	Document Pay Item	String	Generic Edit	3	0
TOPD3N: dcLINK (data collection) - DSI
159	FD3N911	dcLINK Interface - Cache UCC128 Numbers - Table	10	UC	SFX	Document Pay Item	String	Generic Edit	3	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

159 columns | 812 | SFX