	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

93 columns | 812 | STAM

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0018	Sales/Use/V.A.T. Tax File	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	Invoice Transactions - Batch File	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 File	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: Property 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 Billing Work File (OneWorld)	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	Tenant/Lease Billings Detail 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	Tenant/Lease Billings Detail 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	21	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
TOP55: Reserved for Clients
58	F74H1051	Invoicing Workfile - New	19	IW	STAM	Amount - Tax	Numeric	Generic Edit	15	2
59	F74H1052	Tax Summary Work Table - New	7	TS	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP74: EMEA Localization
60	F00900	Year-End VAT Revision File - Italy	9	IR	STAM	Amount - Tax	Numeric	Generic Edit	15	2
61	F74093	Workfile for Printing IVA Summary - Italy	14	HC	STAM	Amount - Tax	Numeric	Generic Edit	15	2
62	F740931	IVA Summary Report Header File - Work File-Italy	3	HD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
63	F7430030	Legal Document Header (Print Info) - COMM - 03B	17	PI	STAM	Amount - Tax	Numeric	Generic Edit	15	2
64	F7430033	A/R Document Line (Print Info) - COMM - 03B	13	PI	STAM	Amount - Tax	Numeric	Generic Edit	15	2
65	F74900	Foreign Receivables and Payables - EMEA	37	RP	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP74B: Begium Localization
66	F7403B11	Belgium - Work File Yearly Vat Declaration Data	8	QA	STAM	Amount - Tax	Numeric	Generic Edit	15	2
67	F74B200	Yearly/Quarterly VAT Listing - Belgium	7	VT	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP74H: Hungary
68	F74H1004	VAT Declaration Detail	13	VD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP74R: CIS
69	F74R0018	Russian Tax File - 74R	18	TD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP75J: Japan - Reporting System Only
70	F75013	Stamp Tax - Japan	2	J3	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP75T: Taiwan
71	F75T004	GUI/VAT Transaction Header - 75T	19	TH	STAM	Amount - Tax	Numeric	Generic Edit	15	2
72	F75T0049	GUI/VAT Transaction Header History - 75T	19	TH	STAM	Amount - Tax	Numeric	Generic Edit	15	2
73	F75T004P	GUI/VAT Transaction Header POS - 75T	19	TH	STAM	Amount - Tax	Numeric	Generic Edit	15	2
74	F75T004Z	GUI/VAT Transaction Header - Work - 75T	17	ZH	STAM	Amount - Tax	Numeric	Generic Edit	15	2
75	F75T005	GUI/VAT Transaction Detail - 75T	16	TD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
76	F75T0059	GUI/VAT Transaction Detail History - 75T	16	TD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
77	F75T005P	GUI/VAT Transaction Detail POS - 75T	16	TD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
78	F75T005Z	GUI/VAT Transaction Detail - Work - 75T	22	ZD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP76A: Argentina
79	F76A8014	CITI Report - ARG - - 04	6	CT	STAM	Amount - Tax	Numeric	Generic Edit	15	2
80	F76AUI50	VAT Perception Support RG 715 WF - ARG - 04 - 76A	9	WF	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP76B: Brazil - Reporting System Only
81	F76B4017	Tax Accumulates by AN8 - Company - BR - 04	7	AC	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP76C: Colombia
82	F76C031A	A/R Customer ledger As Of - F76C031A - COL - 04	30	RP	STAM	Amount - Tax	Numeric	Generic Edit	15	2
83	F76CUI02	Tax Detail - Work File - COL - 76C	13	TD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
84	F76CUI04	Tax Detail for Distribution - Work File - COL - 76C	14	TD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP76H: Chile
85	F76H218	Taxes by Sales Order Line - CHI - 42 - 76H	14	TD	STAM	Amount - Tax	Numeric	Generic Edit	15	2
86	F76H3B31	Legal Document Header (Print Info) - CHI - 03B - 76H	38	PI	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP76M: Mexico
87	F76M0314	Receipt Detail Tag File - Mexico	15	MA	STAM	Amount - Tax	Numeric	Generic Edit	15	2
88	F76M0414	F0414 - Payment Detail Tag File - Mexico	17	RT	STAM	Amount - Tax	Numeric	Generic Edit	15	2
89	F76M311	AR Soft Rounding VAT - Mexico	7	MB	STAM	Amount - Tax	Numeric	Generic Edit	15	2
90	F76M411	Soft Rounding VAT Calculation	9	RS	STAM	Amount - Tax	Numeric	Generic Edit	15	2
TOP76V: Venezuela
91	F76VLO01	Withholdings Temporal Table - VEN -04 - 76V	13	LO	STAM	Amount - Tax	Numeric	Generic Edit	15	2
92	F76VLV01	Temporal Table for VAT Type - R76VLV01 - VEN -03B - 76V	4	IM	STAM	Amount - Tax	Numeric	Generic Edit	15	2
93	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

93 columns | 812 | STAM