	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

92 columns | 910 | 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
2	F0911	Account Ledger	140	GL	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP03B: Enhanced Accounts Receivable
3	F03B112	Invoice Revisions	5	RW	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
4	F03B112P	Invoice Revisions Purge File	5	RW	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP04: Accounts Payable
5	F0411	Accounts Payable Ledger	5	RP	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
6	F0411A	WF - As Of Accounts Payable Ledger	5	RP	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
7	F0411P	Purge - Accounts Payable Ledger	5	RP	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
8	F0411Z1	Voucher Transactions - Batch Upload	23	VL	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
9	F0411Z3	F0411 Interoperability Table	27	SZ	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
10	F0414	Accounts Payable Matching Document Detail	8	RN	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
11	F0414A	WF - As Of Accounts Payable Payment Detail	8	RN	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
12	F0414P	Purge - Accounts Payable Matching Document Detail	8	RN	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
13	F0414Z1	F0414 Interoperability Table	21	SZ	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
14	F04573	A/P Payment Processing - Detail	26	KI	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
15	F09UI005	Tax Offsets User Index	47	GL	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP09: General Accounting
16	F0911P	Purge - Account Ledger	140	GL	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
17	F0911R	WF - Account Ledger Reconciliation	78	GL	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
18	F0911Z1	Journal Entry Transactions - Batch File	192	VN	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
19	F0911Z4	F0911 Interoperability Table	167	SZ	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP40G: Grower Management
20	F40G95	Pay On Proceeds Log File	43	PP	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP43: Procurement
21	F43121T	Purchase Order Receiver Tag File	11	PR	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP43A: Purchase Order Receipt/Routing
22	F43126T	Purchase Order Receiver Multiple Account Tag File	13	P4	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP45: Advanced Pricing
23	F4576	Ship and Debit Claims	35	AC	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
24	F4576TMP	Ship and Debit Claims- Temp Table	35	AC	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
25	F4576Z1	Ship and Debit Claims Unedited Transaction Table	48	Z1	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP47: Electronic Commerce
26	F47057	EDI Payment Order Remittance Advice - Outbound	37	D3	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
27	F47057W	EDI Payment Order Remittance Advice - Work	37	D3	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP70: Multi-National Products - obsolete-do not reuse
28	F704001	Payment WH Info TEMP - COMM - 04	14	PT	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
29	F704002	Payment WH Info - COMM - 04	13	PF	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
30	F704002P	Payment WH Info Purge - COMM - 04	13	PF	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP74: EMEA Localization
31	F7404573	Detail Payment Instructions EXT. for German Payments	8	KI	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
32	F74900	Foreign Receivables and Payables - EMEA	6	RP	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP74H: Hungary
33	F74H1004	VAT Declaration Detail - HUN -04	5	VD	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP74R: CIS
34	F74R0018	Russian Tax File - 74R	9	TD	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
35	F74R0480	Pay Item Differences - RUS - 04 - 74R	5	RP	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
36	F74R4014	F0414 Tag File - RUS - 04 - 74R	8	TF	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP74U: United Kingdom Localizations
37	F74U0116	F0411 CIS Tag Table - 04	5	TF	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
38	F74U0118	Payment Voucher Status History - 04	5	VH	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
39	F74U0120	CiS Supp F0411 Tag File - UK - 04	5	MV	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
40	F74U0205	Payment Profile - 15	20	P8	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
41	F74U0445	SPC Accounts Payable Match Doc Detail Tag File - UK - 43	7	RN	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
42	F74U4030	CIS Withholding Verification Detail - UK - 04	5	VD	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
43	F74U4053	Subcontractor Documents Detail - CIS Monthly Return - UK- 04	7	DM	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
44	F74UCW02	CIS Voucher Entry Workfile 2 - UK - 04	5	CV	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP74W: Sweden - Reporting System Only
45	F74W200	A/P Payment Processing Sequence Numbers File - 74W	8	K0	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
46	F74W203	Debit Advice Invoice File - 74W	18	K3	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP74Y: Italy - Reporting System Only
47	F74Y171	Contract Relations - IT - 00	7	CR	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
48	F74Y415	Vouchers Related to AP DN/CN - ITA - 04	5	RV	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP75A: Australia - Reporting System Only
49	F75A0202	GST - RCTI Adjustment Print Control Table	6	RA	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP75I: India
50	F75I055	Vouchers Generated for Reverse Charge AP - IND - 04	5	RP	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
51	F75I101	TDS Certificate Work Maintenance	48	QB	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
52	F75I411	F0411 Tag File - IN - 04	5	TF	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
53	F75I741	Service Tax A/P File - IND - 04	5	ST	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
54	F75I742	Service Tax A/P File Additional Info - IND - 04	5	ST	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
55	F75IUI7	Service Tax Credit Register - Work File - IND	8	WF	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP75T: Taiwan
56	F75T005	GUI/VAT Transaction Detail - 75T	41	TD	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
57	F75T0059	GUI/VAT Transaction Detail History - 75T	41	TD	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
58	F75T005P	GUI/VAT Transaction Detail POS - 75T	40	TD	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
59	F75T005T	GUI/VAT Transaction Detail Temp - 75T	41	TD	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP76A: Argentina
60	F760411A	A/P Ledger Tag Table - ARG - 04 - 76A	5	B2	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
61	F760414A	A/P Payment Detail Tag Table - ARG - 04 - 76A	8	V1	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
62	F76A33	Receipt Invoice - Audit Log ARG - 03B - 76A	5	X4	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
63	F76A411P	Purge A/P Tag Ledger Tag - ARG - 04 - 76A	5	B2	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
64	F76A411Q	F76A411P Tag File Purge - ARG - 04 - 76A	5	B1	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
65	F76A411T	F760411A A/P Tag File - ARG - 04 - 76A	5	B1	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
66	F76A414P	Purge - A/P Payment Detail - ARG - 04 - 76A	8	V1	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
67	F76AUI04	A/P Legel Tax Tag Table - ARG - 04 - 76A	5	WC	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP76B: Brazil - Reporting System Only
68	F76B0411	Voucher Additional Information Brazil - 04	5	VB	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
69	F76B04BC	Voucher Additional Information - Brazil - 04	5	BC	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
70	F76B410H	INSS-Work Table for Services Third Party Inbound NF H - 42	22	SI	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
71	F76B415	Withholding by City and Service Additional Info - BR - 04	5	CS	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP76C: Colombia
72	F76C0411	A/P Tag File - COL - 76C	5	RP	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
73	F76C4011	A/P Ledger Tag Table - COL - 04	5	VC	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
74	F76C4F02	DIAN Formats File by Invoice - COL - 04	6	FI	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
75	F76CUI02	Tax Detail - Work File - COL - 76C	6	TD	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP76H: Chile
76	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
77	F76M0414	F0414 - Payment Detail Tag File - Mexico	16	RT	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
78	F76M411	Soft Rounding VAT Calculation	5	RS	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
79	F76M411T	F0411 A/P Tag File - MEX - 04 TF	5	TF	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
80	F76M573	PCG Detail Withholding Amounts - MEX - 04	8	WD	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
81	F76M930	AR VAT on Gain/loss MEX - 76M	9	AP	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
82	F76M940	AP VAT on Gain/loss - MEX - 76M	21	AP	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
83	F76M990	GL VAT on Gain/loss MEX - 76M	25	GL	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP76P: Peru
84	F76P411T	Peru AP Tag File - PER - 04 - 76P	5	T4	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
85	F76P414T	F0414 Tag File - PER - 04 - 76P	8	P4	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
86	F76PUI45	Workfile VAT Purchasing Ledger - PER - 04 - 76P	8	WF	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP76V: Venezuela
87	F76V4581	Withholding Historical File - VEN - 04	5	HR	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
88	F76V4582	Wittholding Documents Temporal - VEN - 04 - 76V	5	DR	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
TOP79A: Greenhouse Gas Accounting
89	F79A11	GHG Ledger	6	GR	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
90	F79A11Z1	GHG Ledger - Batch File	24	GL	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
91	F79A12	GHG Ledger Audit	7	GR	SFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0
92	F79AU11	GHG Ledger Work Table	9	GR	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

92 columns | 910 | SFXE