	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

51 columns | 920 | MATH02

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP05: Time Accounting and HRM Base
1	F05005	Generic UBE File	13	GF	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
2	F054101	Employee Personal Profile Information History Table	51	EH	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
3	F054101W	Employee Personal Profile Information Work Table	52	EP	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
4	F086011	Establishment Information	10	CO	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
TOP05A: PeopleSoft HR & PR Foundation
5	F060116W	EE Master Request File	216	YA	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
TOP07: Payroll
6	F06136B	Tax Summary (PA ACT 32)	62	YZ	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
7	F06166B	Tax Ledger (PA ACT 32)	19	YV	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
8	F0701734	Prior Head Tax from a Previous Employer	11	Y3	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
9	F0701735	Pretax Deduction Overrides	13	YC	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
10	F078504	Vertex Geo Code to ADP Code	18	VA	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
11	F8907422	New Hire Detail File - Massachusetts (22)	10	MA	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
12	F8907427	New Hire Detail File - Montana (27)	4	MT	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
13	F8907444	New Hire Detail File Transfer - Texas (44)	3	TX	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
TOP08: Human Resources
14	F083305	Mail Merge Header/Detail	26	MM	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
TOP08B: Benefits Administration
15	F08320D	Plan Master Tag Table	16	PD	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
16	F0833WF	Benefit Statement Work file	146	WF	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
TOP08H: Health and Safety
17	F08601C	Additional Health and Safety Information	14	PI	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
TOP30: Product Data Management
18	F3018	Kanban Size Calculation Parameters	24	KP	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
19	F30UI016	BOM Explosion Work File for BI	22	BE	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
TOP43E: Requisition Self Service
20	F43E20WF	eReq - Shopping Cart Work File	42	SW	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
TOP74R: Russia
21	F74RUI31	VAT Sales Book Workfile - RUS - 03B	23	W1	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
22	F74RUI41	VAT Purchase Book Workfile - RUS - 04	24	W1	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
TOP74Y: Italy
23	F74YUI01	Italy Legal Company WF - ITA - 74Y	22	LC	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
24	F74YUI10	Italy Customer Detail WF - ITA - 74Y	17	CD	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
25	F74YUI11	Italy SupplierDetail WF - ITA - 74Y	19	SD	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
TOP75C: China
26	F75C002	Electronic Accounting Book	20	EA	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
27	F75C007	China - Chart of Accounts Set Up	17	CA	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
TOP75I: India
28	F75I100Q	TDS Form 26Q - WorkFile (Quarterly)	48	EF	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
29	F75I100W	TDS Form 26 - WorkFile	38	EF	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
30	F75I344C	ARE-1 Bond Register for Cancelled Receipts-IND-00	31	CD	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
31	F75I3901	Work With Consignment - IND -43	68	CO	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
32	F75I395A	ER - 5 (1)	8	ER	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
33	F75I395B	ER - 5 (2)	26	ER	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
34	F75I395T	ER - 5 (temp)	27	ER	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
35	F75I396A	ER-6 - List of Finished goods manufactured	30	ES	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
36	F75I396B	ER-6	33	SE	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
37	F75I396C	Table for Opening Balance Quantity	29	OB	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
38	F75I396T	ER-6 Temp	30	SE	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
39	F75I397	ER-6 Scrap	19	SC	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
40	F75I397B	ER-6 Scrap	31	ES	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
41	F75IUI7	Service Tax Credit Register - Work File - IND	23	WF	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
TOP76A: Argentina
42	F76A8030	Taxes - Minimun Tax By Invoice - ARG - 03B - 76A	9	MT	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
43	F76A8500	Tag File F03B14 - ARG - 03B - 76A	22	TF	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
44	F76A8510	Tag File F76A60 - ARG - 03B - 76A	13	TF	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
45	F76A85Z1	Tag File F76A60 Batch Entry - ARG - 03B - 76A	18	BE	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
46	F76AUI82	Draft - Drafts Work File - ARG - 03B - 03B	30	WF	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
TOP77: Payroll (Canadian)
47	F77200A	Canadian Employee Year-End Form Header (Additional)	15	J5	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
48	F77703	Payroll History Audit Report - Worktable	15	AR	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
TOP89: Conversion Programs
49	F75I101A	TDS Ceritificate Master Tabel Extension	15	QB	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
TOPH96U: Upgrade
50	F968901	TC Performance Estimation Header Table	15	EH	MATH02	Math Numeric 02	Numeric	Generic Edit	15	2
TOPH98: Internet
51	F986113	Subsystem Job Master	22	SS	MATH02	Math Numeric 02	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

51 columns | 920 | MATH02