	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

58 columns | 812 | SFXE

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0018R	Tax Reconciliation Repository	8	ED	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP03B: Enhanced Accounts Receivable
2	F03B112	Invoice Revisions	5	RW	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
3	F03B112P	Invoice Revisions Purge File	5	RW	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP04: Accounts Payable
4	F0411	Accounts Payable Ledger	5	RP	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
5	F0411A	WF - As Of - Accounts Payable Ledger	5	RP	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
6	F0411P	Purge - Accounts Payable Ledger	5	RP	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
7	F0411Z1	Voucher Transactions - Batch File	23	VL	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
8	F0411Z3	F0411 Interoperability Table	27	SZ	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
9	F0414	Accounts Payable Matching Document Detail	8	RN	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
10	F0414A	WF - As Of - Accounts Payable Payment Detail	8	RN	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
11	F0414P	Purge - Accounts Payable Matching Document Detail	8	RN	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
12	F0414Z1	F0414 Interoperability Table	21	SZ	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
13	F04573	A/P Payment Processing - Detail File	26	KI	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP43: Procurement
14	F43121T	Purchase Order Receiver Tag File	11	PR	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP43A: Purchase Order Receipt/Routing
15	F43126T	Purchase Order Receiver Multiple Account Tag File	13	P4	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP45: Advanced Pricing
16	F4576	Ship and Debit Claims	35	AC	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
17	F4576TMP	Ship and Debit Claims- Temp Table	35	AC	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
18	F4576Z1	Ship and Debit Claims Unedited Transaction Table	48	Z1	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP47: Electronic Commerce
19	F47057	EDI Payment Order Remittance Advice - Outbound	37	D3	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
20	F47057W	EDI Payment Order Remittance Advice - Work	37	D3	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP74: EMEA Localization
21	F7404573	Detail Payment Instructions EXT. for German Payments	8	KI	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
22	F74900	Foreign Receivables and Payables - EMEA	6	RP	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP74H: Hungary
23	F74H1004	VAT Declaration Detail	5	VD	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP74R: CIS
24	F74R0018	Russian Tax File - 74R	9	TD	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
25	F74R0480	Pay Item Differences - RUS - 04 - 74R	5	RP	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
26	F74R4014	F0414 Tag File - RUS - 04 - 74R	8	TF	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP74U: United Kingdom Localizations
27	F74U0116	F0411 CIS Tag File	5	TF	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
28	F74U0118	Payment Voucher Status History	5	VH	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
29	F74U0205	Payment Profile - 15	20	P8	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
30	F74U4053	Subcontractor Documents Detail - CIS Monthly Return - UK- 04	7	DM	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP74W: Sweden - Reporting System Only
31	F74W200	A/P Payment Processing Sequence Numbers File - 74W	8	K0	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
32	F74W203	Debit Advice Invoice File - 74W	18	K3	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP75A: Australia - Reporting System Only
33	F75A0202	GST - RCTI Adjustment Print Control Table	6	RA	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP75T: Taiwan
34	F75T005	GUI/VAT Transaction Detail - 75T	28	TD	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
35	F75T0059	GUI/VAT Transaction Detail History - 75T	28	TD	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
36	F75T005P	GUI/VAT Transaction Detail POS - 75T	28	TD	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP76A: Argentina
37	F760411A	A/P Tag Ledger Tag File - ARG	5	B2	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
38	F760414A	A/P Payment Detail Tag File - ARG - 04	8	V1	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
39	F76A33	Receipt Invoice - Audit Log AGR	5	X4	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
40	F76A411P	Purge A/P Tag Ledger Tag - ARG - 04 - 76A	5	B2	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
41	F76A411Q	F76A411P Tag File Purge - ARG - 04 - 76A	5	B1	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
42	F76A411T	F760411A A/P Tag File - ARG - 04 - 76A	5	B1	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
43	F76A414P	Purge - A/P Payment Detail - ARG - 04 - 76A	8	V1	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
44	F76AUI04	A/P Tag Legel Tax File - ARG - WF	5	WC	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP76B: Brazil - Reporting System Only
45	F76B0411	Voucher Additional Information Brazil - 04	5	VB	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
46	F76B04BC	Voucher Additional Information - Brazil - 04	5	BC	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
47	F76B410H	INSS-Work Table for Services Third Party Inbound NF H - 42	22	SI	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP76C: Colombia
48	F76C0411	A/P Tag File - COL - 76C	5	RP	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
49	F76C4011	A/P Ledger Tag Table - COL - 04	5	VC	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
50	F76CUI02	Tax Detail - Work File - COL - 76C	6	TD	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP76H: Chile
51	F76H402	Chilean A/P Doc Lines Print Mark - CHI - 04 - 76H	7	LP	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP76M: Mexico
52	F76M0414	F0414 - Payment Detail Tag File - Mexico	16	RT	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
53	F76M411	Soft Rounding VAT Calculation	5	RS	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP76P: Peru
54	F76P411T	Peru AP Tag File - PER - 04 - 76P	5	T4	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
55	F76P414T	F0414 Tag File - PER - 04 - 76P	8	P4	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
56	F76PUI45	Workfile VAT Purchasing Ledger - PER - 04 - 76P	8	WF	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP76V: Venezuela
57	F76V4581	Withholding Historical File - VEN - 04	5	HR	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
58	F76V4582	Wittholding Documents Temporal - VEN - 04 - 76V	5	DR	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	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

58 columns | 812 | SFXE