	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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

106 columns | 920 | STAM

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0018	Taxes	15	TD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
2	F00189	WF - Tax Reconciliation	16	TG	STAM	Amount - Tax	Numeric	Generic Edit	15	2
3	F0018R	Tax Reconciliation Repository	13	ED	STAM	Amount - Tax	Numeric	Generic Edit	15	2
4	F0028	Sales Tax Work File by Taxing Authority	8	TE	STAM	Amount - Tax	Numeric	Generic Edit	15	2
5	F0029	Sales Tax Work File by Taxing Authority and Document	8	TF	STAM	Amount - Tax	Numeric	Generic Edit	15	2
6	F004201	Prepayment Transaction Table	52	PT	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP03: Accounts Receivable
7	F0311	Accounts Receivable Ledger	30	RP	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP03B: Enhanced Accounts Receivable
8	F03B11	Customer Ledger	30	RP	STAM	Amount - Tax	Numeric	Generic Edit	15	2
9	F03B112	Invoice Revisions	32	RW	STAM	Amount - Tax	Numeric	Generic Edit	15	2
10	F03B112P	Invoice Revisions Purge File	32	RW	STAM	Amount - Tax	Numeric	Generic Edit	15	2
11	F03B11P	Customer Ledger Purge File	30	RP	STAM	Amount - Tax	Numeric	Generic Edit	15	2
12	F03B11Z1	Batch Invoices	48	VJ	STAM	Amount - Tax	Numeric	Generic Edit	15	2
13	F03B11Z2	F03B11 Interoperability Table	43	SY	STAM	Amount - Tax	Numeric	Generic Edit	15	2
14	F03B20	A/R Notification History	31	ZR	STAM	Amount - Tax	Numeric	Generic Edit	15	2
15	F03B21	A/R Notification History Detail	33	ZS	STAM	Amount - Tax	Numeric	Generic Edit	15	2
16	F03B575	Auto Debit Invoice Select and Build	33	RD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP04: Accounts Payable
17	F0411	Accounts Payable Ledger	30	RP	STAM	Amount - Tax	Numeric	Generic Edit	15	2
18	F0411A	WF - 'As Of' Accounts Payable Ledger	30	RP	STAM	Amount - Tax	Numeric	Generic Edit	15	2
19	F0411P	Purge - Accounts Payable Ledger	30	RP	STAM	Amount - Tax	Numeric	Generic Edit	15	2
20	F0411Z1	Voucher Transactions - Batch Upload	48	VL	STAM	Amount - Tax	Numeric	Generic Edit	15	2
21	F0411Z3	F0411 Interoperability Table	52	SZ	STAM	Amount - Tax	Numeric	Generic Edit	15	2
22	F09UI006	Tax (F0018) Replica	15	TD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP07: Payroll
23	F07880	SUI Magnetic Media Workfile	56	YW	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP09: General Accounting
24	F0911Z1	Journal Entry Transactions - Batch File	180	VN	STAM	Amount - Tax	Numeric	Generic Edit	15	2
25	F0917	Bank Statement Detail	14	GD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
26	F09617	Auto Bank Statement Detail	17	GM	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP15: Real Estate Management
27	F15016	Tenant Escalation Master	52	NU	STAM	Amount - Tax	Numeric	Generic Edit	15	2
28	F15016B	Tenant Escalation Master	55	NU	STAM	Amount - Tax	Numeric	Generic Edit	15	2
29	F1502	Recurring Billings Master	47	NF	STAM	Amount - Tax	Numeric	Generic Edit	15	2
30	F1502B	Recurring Billings Master	47	NF	STAM	Amount - Tax	Numeric	Generic Edit	15	2
31	F1502WB	Estimated EP Recurring Billings	50	N4	STAM	Amount - Tax	Numeric	Generic Edit	15	2
32	F1511	Tenant/Lease Billings Detail	48	NJ	STAM	Amount - Tax	Numeric	Generic Edit	15	2
33	F1511B	Lease Billings Master	48	NJ	STAM	Amount - Tax	Numeric	Generic Edit	15	2
34	F1511H	Tenant/Lease Billings Detail History	48	N#	STAM	Amount - Tax	Numeric	Generic Edit	15	2
35	F1511HB	Lease Billings History	48	NC	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP17: Customer Service Management
36	F1721	Contract Detail	80	CD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP42: Sales Management
37	F42565	Invoice Print File	64	IW	STAM	Amount - Tax	Numeric	Generic Edit	15	2
38	F42800G1	Sales Update G Batch Detail Workfile	45	DG	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP43: Procurement
39	F43121	Purchase Order Receiver File	107	PR	STAM	Amount - Tax	Numeric	Generic Edit	15	2
40	F43121Z	Receiver workfile	146	PW	STAM	Amount - Tax	Numeric	Generic Edit	15	2
41	F43121Z1	Receipts Unedited Transaction Table	176	SZ	STAM	Amount - Tax	Numeric	Generic Edit	15	2
42	F4314Z	Voucher Match Selection File	45	PN	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP43A: Purchase Order Receipt/Routing
43	F43126	Purchase Order Receiver Multiple Account	44	P4	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP43E: Requisition Self Service
44	F43E20	Shopping Cart Detail	20	SC	STAM	Amount - Tax	Numeric	Generic Edit	15	2
45	F43E20WF	eReq - Shopping Cart Work File	20	SW	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP47: Electronic Commerce
46	F470161	EDI Purchase Order Additional Header - Outbound	51	S3	STAM	Amount - Tax	Numeric	Generic Edit	15	2
47	F47042	EDI Invoice Detail - Inbound	67	SZ	STAM	Amount - Tax	Numeric	Generic Edit	15	2
48	F47044	EDI Invoice Summary - Inbound	33	SW	STAM	Amount - Tax	Numeric	Generic Edit	15	2
49	F470461	EDI Invoice Additional Header - Outbound	52	S3	STAM	Amount - Tax	Numeric	Generic Edit	15	2
50	F470473	EDI Invoice Detail Charges	36	S7	STAM	Amount - Tax	Numeric	Generic Edit	15	2
51	F47057	EDI Payment Order Remittance Advice - Outbound	62	D3	STAM	Amount - Tax	Numeric	Generic Edit	15	2
52	F47057W	EDI Payment Order Remittance Advice - Work	62	D3	STAM	Amount - Tax	Numeric	Generic Edit	15	2
53	F471061	EDI Response to RFQ Additional Header - Outbound	52	S3	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP48S: Service Billing
54	F4822	Invoice Summary Work File	51	W4	STAM	Amount - Tax	Numeric	Generic Edit	15	2
55	F4823	Voucher Summary	47	W0	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP49: Transportation Management
56	F4981	Freight Audit History	89	FH	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP52: Contract Billing
57	F5202	Contract Billing Line Detail	35	G6	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP52G: Proj & Gov Contract Accounting
58	F4822H	Invoice Summary History	51	IH	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP70: Multi-National Products
59	F702033	Sales Document Line Tag File - COMM - 42	5	D1	STAM	Amount - Tax	Numeric	Generic Edit	15	2
60	F704100	Suspended VAT AP - COMM - 70	19	VA	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP74: EMEA Localization
61	F00900	Year-End VAT Revision - Italy	9	IR	STAM	Amount - Tax	Numeric	Generic Edit	15	2
62	F740018D	Data extraction ESL - 74	13	DE	STAM	Amount - Tax	Numeric	Generic Edit	15	2
63	F740018W	Data extraction ESL - Workfile - 74	13	DE	STAM	Amount - Tax	Numeric	Generic Edit	15	2
64	F74093	Worktable for Printing IVA Summary - Italy	14	HC	STAM	Amount - Tax	Numeric	Generic Edit	15	2
65	F740931	IVA Summary Report Header - Worktable- Italy	3	HD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
66	F7430030	Legal Document Header (Print Info) - COMM - 03B	17	PI	STAM	Amount - Tax	Numeric	Generic Edit	15	2
67	F7430033	A/R Document Line (Print Info) - COMM - 03B	13	PI	STAM	Amount - Tax	Numeric	Generic Edit	15	2
68	F74900	Foreign Receivables and Payables - EMEA	37	RP	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP74B: Begium Localization
69	F7403B11	Belgium - Work File Yearly Vat Declaration Data	8	QA	STAM	Amount - Tax	Numeric	Generic Edit	15	2
70	F74B200	Yearly/Quarterly VAT Listing - Belgium	7	VT	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP74H: Hungary
71	F74H1004	VAT Declaration Detail - HUN -04	13	VD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
72	F74H410	Foreign Voucher Supplier Amounts - HUN - 74H	15	SA	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP74L: Portugal
73	F74L3035	Tax Details by Legal Document - POR - 74L	13	TD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
74	F74LUI03	Tax Details - Temp Table - 74L	9	TT	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP74R: Russia
75	F74R0018	Russian Tax File - 74R	18	TD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
76	F74R410	Tax on Hold - RUS - 04	7	TH	STAM	Amount - Tax	Numeric	Generic Edit	15	2
77	F74R420	Tax Releases - RUS - 04	13	TR	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP74Y: Italy
78	F74Y015	Yearly List Declaration - WF - IT - 00	22	YL	STAM	Amount - Tax	Numeric	Generic Edit	15	2
79	F74Y171	Contract Relations - IT - 00	11	CR	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP74Z: Czech Republic
80	F74ZUI02	Czech VAT Report - CZE - 74Z - Work File	6	CZ	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP75J: Japan
81	F75013	Stamp Tax - Japan - 04	2	J3	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP75T: Taiwan
82	F75T004	GUI/VAT Transaction Header - 75T	21	TH	STAM	Amount - Tax	Numeric	Generic Edit	15	2
83	F75T0049	GUI/VAT Transaction Header History - 75T	21	TH	STAM	Amount - Tax	Numeric	Generic Edit	15	2
84	F75T004P	GUI/VAT Transaction Header POS - 75T	22	TH	STAM	Amount - Tax	Numeric	Generic Edit	15	2
85	F75T004Z	GUI/VAT Transaction Header - Work - 75T	19	ZH	STAM	Amount - Tax	Numeric	Generic Edit	15	2
86	F75T005	GUI/VAT Transaction Detail - 75T	18	TD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
87	F75T0059	GUI/VAT Transaction Detail History - 75T	18	TD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
88	F75T005P	GUI/VAT Transaction Detail POS - 75T	23	TD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
89	F75T005T	GUI/VAT Transaction Detail Temp - 75T	18	TD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
90	F75T005Z	GUI/VAT Transaction Detail - Work - 75T	25	ZD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP76A: Argentina
91	F76A8014	CITI Report - ARG - 04 - 76A	6	CT	STAM	Amount - Tax	Numeric	Generic Edit	15	2
92	F76AUI50	VAT Perception Support RG 715 WF - ARG - 04 - 76A	9	WF	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP76B: Brazil
93	F76B4017	Tax Accumulates by AN8, Company - BR - 04	7	AC	STAM	Amount - Tax	Numeric	Generic Edit	15	2
94	F76B424	Service Nota Fiscal Accumulated Withholding-BRA-76B	7	SW	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP76C: Colombia
95	F76C031A	A/R Customer ledger As Of - F76C031A - COL - 04	30	RP	STAM	Amount - Tax	Numeric	Generic Edit	15	2
96	F76CUI02	Tax Detail - Work File - COL - 76C	13	TD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
97	F76CUI04	Tax Detail for Distribution - Work File - COL - 76C	14	TD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP76H: Chile
98	F76H218	Taxes by Sales Order Line - CHI - 42 - 76H	14	TD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
99	F76H3B31	Legal Document Header (Print Info) - CHI - 03B - 76H	38	PI	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP76M: Mexico
100	F76M0314	Receipt Detail Tag File - Mexico	15	MA	STAM	Amount - Tax	Numeric	Generic Edit	15	2
101	F76M0414	F0414 - Payment Detail Tag File - Mexico	17	RT	STAM	Amount - Tax	Numeric	Generic Edit	15	2
102	F76M311	AR Soft Rounding VAT - Mexico	7	MB	STAM	Amount - Tax	Numeric	Generic Edit	15	2
103	F76M411	Soft Rounding VAT Calculation	9	RS	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP76V: Venezuela
104	F76VLO01	Withholdings Temporal Table - VEN -04 - 76V	13	LO	STAM	Amount - Tax	Numeric	Generic Edit	15	2
105	F76VLV01	Temporal Table for VAT Type - R76VLV01 - VEN -03B - 76V	4	IM	STAM	Amount - Tax	Numeric	Generic Edit	15	2
106	F76VLV03	Temporal Table for VAT Type - R76VLV02 - VEN -03B - 76V	4	IA	STAM	Amount - Tax	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

106 columns | 920 | STAM