	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

108 columns | 920 | DESC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F00085	Daylight Savings Rules	2	DS	DESC	Description	String	Generic Edit	30	0
2	F00421	Column Relationships	7	RS	DESC	Description	String	Generic Edit	30	0
TOP03B: Enhanced Accounts Receivable
3	F03B28	Letter Text	4	RJ	DESC	Description	String	Generic Edit	30	0
TOP07: Payroll
4	F06136A	Tax Summary (Additional)	14	YZ	DESC	Description	String	Generic Edit	30	0
5	F06136B	Tax Summary (PA ACT 32)	67	YZ	DESC	Description	String	Generic Edit	30	0
6	F06166A	Tax Ledger (Additional)	21	YV	DESC	Description	String	Generic Edit	30	0
7	F06166B	Tax Ledger (PA ACT 32)	24	YV	DESC	Description	String	Generic Edit	30	0
8	F0701730	Populate Vertex Filing Status	3	VS	DESC	Description	String	Generic Edit	30	0
9	F0701731	Compensation Overrides	4	YC	DESC	Description	String	Generic Edit	30	0
10	F0701735	Pretax Deduction Overrides	7	YC	DESC	Description	String	Generic Edit	30	0
TOP08: Human Resources
11	F083302	Benefit Statement Heading Codes Type	2	HT	DESC	Description	String	Generic Edit	30	0
TOP09: General Accounting
12	F09UI009	Trial Balance Generic Work File - OneWorld ONLY	5	GB	DESC	Description	String	Generic Edit	30	0
13	F09UI618	Auto Bank Statement Process Work Table	16	NB	DESC	Description	String	Generic Edit	30	0
TOP12: Fixed Assets
14	F1215	Specification Cross Reference	5	GV	DESC	Description	String	Generic Edit	30	0
15	F12851	Depreciation Rules	1	LU	DESC	Description	String	Generic Edit	30	0
16	F12851D	Demo Depreciation Rules	1	LU	DESC	Description	String	Generic Edit	30	0
TOP15L: Adv Real Estate Forecasting
17	F15L101	AREF Unit Master	5	UM	DESC	Description	String	Generic Edit	30	0
18	F15L103	AREF Sales Overage Rule Header	4	SH	DESC	Description	String	Generic Edit	30	0
19	F15L108	AREF Base Account Definition	6	AD	DESC	Description	String	Generic Edit	30	0
20	F15L118	AREF Base Account Definition Detail	7	DD	DESC	Description	String	Generic Edit	30	0
21	F15L120	AREF Account Association	5	AA	DESC	Description	String	Generic Edit	30	0
TOP17C: Call Management
22	F1755	Case Master	11	ZA	DESC	Description	String	Generic Edit	30	0
TOP37: Quality Management
23	F3705	Sample Container	3	SC	DESC	Description	String	Generic Edit	30	0
TOP40: Inventory/OP Base
24	F4013	Order Processing Cross Reference File	5	SX	DESC	Description	String	Generic Edit	30	0
25	F40P011	Promotion Deal Detail File	3	PD	DESC	Description	String	Generic Edit	30	0
26	F4207	Price by Item	4	PM	DESC	Description	String	Generic Edit	30	0
27	F4208	Price by Customer	2	PG	DESC	Description	String	Generic Edit	30	0
TOP40G: Grower Management
28	F40G021	Block Descriptors	3	SB	DESC	Description	String	Generic Edit	30	0
29	F40G023	Block Coordinates	4	BC	DESC	Description	String	Generic Edit	30	0
30	F40G25	QA Operation History Workfile	14	WF	DESC	Description	String	Generic Edit	30	0
TOP42: Sales Management
31	F4015W	Order Templates - Web Customers	3	OD	DESC	Description	String	Generic Edit	30	0
32	F42003	Related Salesperson File	8	RE	DESC	Description	String	Generic Edit	30	0
TOP43: Procurement
33	F4301	Purchase Order Header	28	PH	DESC	Description	String	Generic Edit	30	0
34	F4301Z	PO Header Work File	32	PA	DESC	Description	String	Generic Edit	30	0
35	F4301Z1	Purchase Order Header Unedited Transaction Table	41	SY	DESC	Description	String	Generic Edit	30	0
36	F43UI50H	PO Print Header Work File	45	PA	DESC	Description	String	Generic Edit	30	0
TOP43Q: Strategic Sourcing
37	F43Q20	Event Header Bid Questions	5	EH	DESC	Description	String	Generic Edit	30	0
38	F43Q21	Event Detail Bid Questions	7	ED	DESC	Description	String	Generic Edit	30	0
39	F43Q401	Response Header Question	11	RC	DESC	Description	String	Generic Edit	30	0
40	F43Q411	Response Detail Question	12	RE	DESC	Description	String	Generic Edit	30	0
41	F43Q60	Bid Questions	8	BQ	DESC	Description	String	Generic Edit	30	0
TOP44H: Homebuilder Management
42	F44H601	Bid Header	14	BH	DESC	Description	String	Generic Edit	30	0
43	F44H711	Lot Start Workfile	39	SW	DESC	Description	String	Generic Edit	30	0
44	F44H711P	After Start Purchasing	28	TP	DESC	Description	String	Generic Edit	30	0
45	F44H711Z	HB Lot Start Unedited Transaction File	52	SZ	DESC	Description	String	Generic Edit	30	0
46	F44H71W1	Lot Start Generation Workfile	39	GW	DESC	Description	String	Generic Edit	30	0
47	F44H73W1	Lot Start - P.O. / Committment Generation Work File	71	CG	DESC	Description	String	Generic Edit	30	0
TOP45: Advanced Pricing
48	F4576	Ship and Debit Claims	30	AC	DESC	Description	String	Generic Edit	30	0
49	F4576TMP	Ship and Debit Claims- Temp Table	30	AC	DESC	Description	String	Generic Edit	30	0
50	F4576Z1	Ship and Debit Claims Unedited Transaction Table	43	Z1	DESC	Description	String	Generic Edit	30	0
TOP47: Electronic Commerce
51	F47016	EDI Purchase Order Header - Outbound	43	SY	DESC	Description	String	Generic Edit	30	0
52	F47021	EDI P.O. Acknowledgment Header - Inbound	43	SY	DESC	Description	String	Generic Edit	30	0
53	F47031	EDI Shipping Notice Header - Inbound	41	SY	DESC	Description	String	Generic Edit	30	0
54	F47071	EDI Receiving Advice Header - Inbound	44	SY	DESC	Description	String	Generic Edit	30	0
55	F47076	EDI Receiving Advice Header - Outbound	44	SY	DESC	Description	String	Generic Edit	30	0
56	F47096	EDI Request for Quote Header - Outbound	43	SY	DESC	Description	String	Generic Edit	30	0
57	F47101	EDI Response to RFQ Header - Inbound	43	SY	DESC	Description	String	Generic Edit	30	0
58	F47136	EDI Purchase Order Change Header - Outbound	43	SY	DESC	Description	String	Generic Edit	30	0
59	F47141	EDI P.O. Change Acknowledgment Header - Inbound	44	SY	DESC	Description	String	Generic Edit	30	0
60	F47156	EDI Shipping Schedule Header - Outbound	46	SY	DESC	Description	String	Generic Edit	30	0
TOP48S: Service Billing
61	F4805	Invoice Sequence/Summarization Table Header	2	WK	DESC	Description	String	Generic Edit	30	0
TOP49: Transportation Management
62	F4947	Shipment Status Codes	8	ST	DESC	Description	String	Generic Edit	30	0
63	F4950	Routing Entries	18	RT	DESC	Description	String	Generic Edit	30	0
64	F49T100	Procurement Freight Request staging table	6	OB	DESC	Description	String	Generic Edit	30	0
TOP52G: Proj & Gov Contract Accounting
65	F52G20	Contract Specific Labor Categories	6	LC	DESC	Description	String	Generic Edit	30	0
66	F52G20W	Labor Category Work File	8	LW	DESC	Description	String	Generic Edit	30	0
TOP74L: Portugal
67	F74L3035	Tax Details by Legal Document - POR - 74L	10	TD	DESC	Description	String	Generic Edit	30	0
TOP74U: United Kingdom Localizations
68	F74U0430	Authenticated Receipts Letter Text - UK - 43	5	SG	DESC	Description	String	Generic Edit	30	0
69	F74U4320	Requisition Template Qestions - UK - 43	4	TV	DESC	Description	String	Generic Edit	30	0
TOP75I: India
70	F75I344Y	Print ARE-1Bond Register-IND-00	32	CD	DESC	Description	String	Generic Edit	30	0
71	F75I345	Excise - ARE3 Form Header Details-IND-00	7	QR	DESC	Description	String	Generic Edit	30	0
72	F75I345X	Excise - ARE-3 Form Header for Yarn	36	QR	DESC	Description	String	Generic Edit	30	0
73	F75I402	Purchase Tax Form Details	18	PT	DESC	Description	String	Generic Edit	30	0
74	F75I402T	Purchase Tax Form Details -Secondary	18	PT	DESC	Description	String	Generic Edit	30	0
TOP76A: Argentina
75	F76A8500	Tag File F03B14 - ARG - 03B - 76A	25	TF	DESC	Description	String	Generic Edit	30	0
TOP76B: Brazil
76	F7615B	Transaction Nature - Brazil - 42B	3	TN	DESC	Description	String	Generic Edit	30	0
77	F76B0522	Transaction Nature Brazilian Work File	4	TN	DESC	Description	String	Generic Edit	30	0
78	F76B400F	IN86-Work Table for Transaction Nature - 42	4	TN	DESC	Description	String	Generic Edit	30	0
79	F76B41	Nota Fiscal Detail/Table for Services - IN68 - 42	8	IS	DESC	Description	String	Generic Edit	30	0
TOP76M: Mexico
80	F76M001	Withholding Legal Concepts - MX - 76M	2	WL	DESC	Description	String	Generic Edit	30	0
81	F76M002	Withholding Concepts - MX - 76M	2	WC	DESC	Description	String	Generic Edit	30	0
TOP83: Management Reporting - FASTR
82	F83100	Date Title	3	DT	DESC	Description	String	Generic Edit	30	0
TOP90CA: CRM Foundation
83	F90CA140	Territory Table	2	TY	DESC	Description	String	Generic Edit	30	0
84	F90CA141	Territory and Subordinates	3	TS	DESC	Description	String	Generic Edit	30	0
85	F90CA142	Territory Recursive Children Temp Table	4	TY	DESC	Description	String	Generic Edit	30	0
86	F90CA500	E-MAIL Table	33	EM	DESC	Description	String	Generic Edit	30	0
TOP98: Technical Tools
87	F980014W	Mail Merge Web Objects	2	MM	DESC	Description	String	Generic Edit	30	0
TOPF30L: DFM Line Design
88	FF30L005	DFM Task Master	5	TM	DESC	Description	String	Generic Edit	30	0
89	FF30L951	DFM Operation Definition Detail	19	OM	DESC	Description	String	Generic Edit	30	0
TOPF31: Lean Transactions
90	FF31011	TransactionID Master File	27	EH	DESC	Description	String	Generic Edit	30	0
91	FF31011S	Purge - TransactionID Master File	27	ER	DESC	Description	String	Generic Edit	30	0
TOPH90: EnterpriseOne TOOLS
92	F980014	MailMerge Objects	2	MM	DESC	Description	String	Generic Edit	30	0
93	F99DTL	Workflow Demonstration Sales Order Detail	4	WD	DESC	Description	String	Generic Edit	30	0
94	F99WFITM	Workflow Demonstration Item Table	2	WI	DESC	Description	String	Generic Edit	30	0
TOPH91: Design Tools
95	F00085A	Daylight Savings Rules	3	DS	DESC	Description	String	Generic Edit	30	0
96	F91400	Report Director Templates	2	DT	DESC	Description	String	Generic Edit	30	0
97	F91420	Report Director Templates Smart Field Activation	3	SM	DESC	Description	String	Generic Edit	30	0
TOPH92: Interactive Engine/OL
98	F98712	Primary Index Header	4	TP	DESC	Description	String	Generic Edit	30	0
99	F98713	Primary Index Detail	4	TL	DESC	Description	String	Generic Edit	30	0
100	F98745	Smart Field Named Mappings	3	SF	DESC	Description	String	Generic Edit	30	0
101	F9883	OneWorld Network Locations Table	3	FN	DESC	Description	String	Generic Edit	30	0
TOPH95: Object and Environment Tech
102	F95151	Index Selection Detail Table	5	ID	DESC	Description	String	Generic Edit	30	0
103	F980045	Mail Merge Simple Template Header	2	ST	DESC	Description	String	Generic Edit	30	0
104	F980046	Composite Template Header	2	CT	DESC	Description	String	Generic Edit	30	0
105	F980047	Mail Merge Data Set Header	2	DT	DESC	Description	String	Generic Edit	30	0
TOPH96U: Upgrade
106	F9889	Deployment Location Master	3	MT	DESC	Description	String	Generic Edit	30	0
107	F98891	Deployment Location Path Code	4	MT	DESC	Description	String	Generic Edit	30	0
TOPH98: Internet
108	F986152	Server Package Master	2	SM	DESC	Description	String	Generic Edit	30	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

108 columns | 920 | DESC