	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

110 tables910 | 00

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
00: Foundation Environment
1	910	F0000194	SY	5	1	Generic Interface Table for B0000194	Files	09: General Accounting	Business Data
2	910	F0002	NN	31	1	Next Numbers - Automatic	Constants Files	09: General Accounting	Control Tables
3	910	F00021	NL	10	1	Next Numbers by Company/Fiscal Year - Automatic	Constants Files	09: General Accounting	Control Tables
4	910	F00022	UK	2	1	Unique Key File - Next Available Unique Key	Constants Files	41: Inventory Management	Business Data
5	910	F00023	DN	24	5	Distributed Next Number Table	Master Files	90CA: CRM Foundation	System Tables
6	910	F0006	MC	152	7	Business Unit Master	Master Files	09: General Accounting	Business Data
7	910	F0006D	LJ	7	2	Business Unit Alternate Description Master	Extra Features Files	09: General Accounting	Business Data
8	910	F0006S	MC	157	1	Date Effective Business Unit Master	Extra Features Files	09: General Accounting	Business Data
9	910	F0006S1	SH	8	1	Business Unit Snapshot Header	Extra Features Files	09: General Accounting	Business Data
10	910	F0006Z1	SZ	161	1	Cost Center Unedited Transaction Table	Batch Input Files	05A: OW HR & PR Foundation	Business Data
11	910	F0007	CZ	43	3	Workday Calendar	Extra Features Files	30: Product Data Management	Business Data
12	910	F0008	CD	25	2	Date Fiscal Patterns	Constants Files	09: General Accounting	Business Data
13	910	F00085	DS	18	1	Daylight Savings Rules	Constants Files	H91: Design Tools	System Tables
14	910	F0008B	CD	63	1	Date Fiscal Patterns - 52 Period Accounting	Constants Files	09: General Accounting	Business Data
15	910	F0009	GC	66	1	General Constants	Constants Files	09: General Accounting	Business Data
16	910	F00090	T1	22	1	Supplemental Database Setup	Constants Files	41: Inventory Management	Business Data
17	910	F00090D	T5	8	1	Supplemental Database Language Preferences	Transaction Files	41: Inventory Management	Business Data
18	910	F00091	T2	34	1	Supplemental Database Data Types	Transaction Files	41: Inventory Management	Business Data
19	910	F00092	T3	30	5	Supplemental Data	Transaction Files	41: Inventory Management	Business Data
20	910	F00093	FM	12	2	Flash Messages	Extra Features Files	17: Customer Service Management	Business Data
21	910	F00094	T1	10	1	CTI Properties	Extra Features Files	09: General Accounting	Business Data
22	910	F00095	A1	7	3	Business Object Reservation	Extra Features Files	42: Sales Management
23	910	F00096	M0	37	1	Default Media Object Category by Table	Extra Features Files	42: Sales Management	Business Data
24	910	F00098	ED	9	1	Enable Distributed Next Numner	Files	90CA: CRM Foundation	Business Data
25	910	F0010	CC	65	5	Company Constants	Constants Files	09: General Accounting	Business Data
26	910	F0010T	CC	12	1	Company Constants Tag Table	Files	09: General Accounting
27	910	F0011	IC	24	1	Batch Control Records	Extra Features Files	09: General Accounting	Business Data
28	910	F0011W	IC	5	1	F0011W - WF - Batch To Detail	Files	09: General Accounting
29	910	F0012	KG	20	2	Automatic Accounting Instructions Master	Constants Files	09: General Accounting	Business Data
30	910	F0012D	LJ	8	1	AAI Alternate Description Master	Extra Features Files	09: General Accounting	Business Data
31	910	F0013	CV	10	1	Currency Codes	Extra Features Files	09: General Accounting	Business Data
32	910	F0014	PN	16	1	Payment Terms	Constants Files	03B: Enhanced Accounts Receivable	Business Data
33	910	F00141	L3	5	3	Advanced Payment Terms	Constants Files	03B: Enhanced Accounts Receivable	Business Data
34	910	F00142	L4	23	1	Due Date Rules	Constants Files	03B: Enhanced Accounts Receivable	Business Data
35	910	F00143	L5	6	1	Due Date Rules Day Range	Constants Files	03B: Enhanced Accounts Receivable	Business Data
36	910	F00144	L6	6	3	Installment Payment Terms	Constants Files	03B: Enhanced Accounts Receivable	Business Data
37	910	F00147	L8	16	1	Multitiered Payment Terms	Constants Files	03B: Enhanced Accounts Receivable	Business Data
38	910	F0018	TD	68	6	Taxes	Extra Features Files	09: General Accounting	Business Data
39	910	F00189	TG	20	2	WF - Tax Reconciliation	Regular Work Files	09: General Accounting	Business Data
40	910	F0018R	ED	27	2	Tax Reconciliation Repository	Files	09: General Accounting
41	910	F0019	CG	6	1	Generic Message/Rate Types	Extra Features Files	48: Work Order Processing	Business Data
42	910	F00191	CE	6	1	Generic Message/Rates	Extra Features Files	48: Work Order Processing	Business Data
43	910	F00192	CF	5	1	General Message Detail	Extra Features Files	48: Work Order Processing	Business Data
44	910	F0022	VA	11	1	Tax Rules	Constants Files	04: Accounts Payable	Business Data
45	910	F0024	UG	2	2	Batch Approval / Post Security File	Extra Features Files	09: General Accounting	Business Data
46	910	F0025	LH	28	2	Ledger Type Master File	Constants Files	09: General Accounting	Business Data
47	910	F0026	CL	18	1	Job Cost Constants	Constants Files	51: Job Costing	Business Data
48	910	F0028	TE	10	1	Sales Tax Work File by Taxing Authority	Regular Work Files	09: General Accounting	Business Data
49	910	F0029	TF	14	1	Sales Tax Work File by Taxing Authority and Document	Regular Work Files	09: General Accounting	Business Data
50	910	F0030	AY	34	6	Bank Transit Master	Master Files	04: Accounts Payable	Business Data
51	910	F0030T	AZ	9	1	Bank Account X12 Information	Secondary Master Files	04: Accounts Payable	Business Data
52	910	F0031	AV	7	1	Bank Transit Master Tag Table	Files	00: Foundation Environment
53	910	F0039	GN	28	2	Generated Documents Definition	Extra Features Files	42: Sales Management	Business Data
54	910	F0039M	GH	12	1	Generated Document Media Object History	History Files	42: Sales Management	Business Data
55	910	F0040Z1	ZB	12	2	Error Message Log Table	Batch Input Files	42B: Sales Order Entry	Business Data
56	910	F0041Z1	ZF	11	4	Transaction Control File	Batch Input Files	42B: Sales Order Entry	Business Data
57	910	F004201	PT	72	3	Prepayment Transaction Table	Transaction Files	42: Sales Management	Business Data
58	910	F00421	RS	15	3	Column Relationships	Files	09: General Accounting	Business Data
59	910	F00422	RB	15	5	Data Relationships	Files	09: General Accounting	Business Data
60	910	F00422A	VR	10	4	Value Relationships - Work Table	Files	09: General Accounting
61	910	F00424	AC	9	1	Relationship Columns	Files	09: General Accounting	Business Data
62	910	F0045	ER	21	2	Services Error Recovery	Files	34A: Advanced Planning & Scheduling
63	910	F0046	PL	10	2	Processing Log	Transaction Files	09: General Accounting	Business Data
64	910	F0047	DE	15	2	Data Export Control	Transaction Files	09: General Accounting	Business Data
65	910	F0048	CM	13	5	Code Mappings Master	Transaction Files	00: Foundation Environment	Business Data
66	910	F0049	CA	15	2	Business Function Call Abstraction Register	Files	34A: Advanced Planning & Scheduling
67	910	F0050	MA	12	4	Organization Structure Master File	Extra Features Files	09: General Accounting	Business Data
68	910	F00690	M1	9	1	Cost Center Types of Data	Extra Features Files	41: Inventory Management	Business Data
69	910	F00692	M2	8	1	Cost Center Supplemental Data Codes	Extra Features Files	41: Inventory Management	Business Data
70	910	F00693	M3	6	1	Cost Center Supplemental Data Text	Extra Features Files	41: Inventory Management	Business Data
71	910	F0070	CK	12	1	Country Constants Master File	Constants Files	09: General Accounting	Business Data
72	910	F0075	CC	11	5	Credit Card Information	Files	09E: Expense Reimbursment	Business Data
73	910	F0080	S2	5	1	Supplemental Data Type Security File	Extra Features Files	41: Inventory Management	Business Data
74	910	F0085	YN	3	1	Audit Record Y/N File - Euro	Constants Files	09: General Accounting	Business Data
75	910	F0087	EU	7	2	Conversion Constants File for Euro	Extra Features Files	09: General Accounting	Business Data
76	910	F0095	IT	5	1	Integration Timestamp	Files	00: Foundation Environment
77	910	F00UI391	GW	16	1	Generated Document Work Table	Work Files	42: Sales Management	Business Data
78	910	F00UI392	GW	15	1	Text Substitution Work Table	Work Files	42: Sales Management	Business Data
79	910	F00UI393	GW	13	1	Bookmark Work Table	Work Files	42: Sales Management	Business Data
80	910	F01RS01W	TH	6	1	PCFGTV Header Public Data	Work Files	H95: Tech Resources/Applications
81	910	F01RS11W	TD	49	1	PCFGTV Detail Public Data	Work Files	H95: Tech Resources/Applications
82	910	F01RS12W	TR	4	1	PCFGTV Role Public Data	Files	H95: Tech Resources/Applications
83	910	F01RS13W	TA	14	1	PCFGTV By Role Public Data	Files	H95: Tech Resources/Applications
84	910	F03B470	PG	7	2	Pay When Paid Group Header	Extra Features Files	03B: Enhanced Accounts Receivable	Business Data
85	910	F0401Z1	VO	95	1	Supplier Master - Batch Upload	Batch Input Files	01: Address Book	Business Data
86	910	F0901WO	WO	2	1	Account Master Search Word Occurrence	Extra Features Files	09: General Accounting	Business Data
87	910	F0901WS	WS	4	3	Account - Word Search	Extra Features Files	09: General Accounting	Business Data
88	910	F0902	GB	56	9	Account Balances	Balance Files	09: General Accounting	Business Data
89	910	F0911	GL	141	26	Account Ledger	Transaction Files	09: General Accounting	Business Data
90	910	F09190	C9	10	4	Inter/Intra Company Account Relationships	Files	11: Multi Currency	Business Data
91	910	F15019	NL	29	1	Billing Frequency Master	Master Files	15: Property Management	Business Data
92	910	F17001	CS	61	1	Service/Warranty Constants Table - F17001	Constants Files	17C: Call Management	Business Data
93	910	F4008	TA	35	2	Tax Areas	Extra Features Files	04: Accounts Payable	Business Data
94	910	F4096	FA	21	1	Sales Flex Accounting	Master Files	42: Sales Management	Business Data
95	910	F4303M	PM	26	2	Log Models	Extra Features Files	43: Procurement	Business Data
96	910	F5192	JC	11	1	Inquiry Columns	Constants Files	43: Procurement	Business Data
97	910	F5192D	JC	6	1	Supplier Analysis Alternate Language Description	Extra Features Files	43: Procurement	Business Data
98	910	F5193	JD	7	1	Inquiry Formats	Constants Files	43: Procurement	Business Data
99	910	F5194	JE	5	1	Inquiry Paths	Constants Files	43: Procurement	Business Data
100	910	F5301	DI	43	6	Change Request Master Table	Master Files	53: Change Management	Business Data
101	910	F744008	TA	9	1	Tax areas - Tag Table EMEA - Spain / Italy	Master Files	04: Accounts Payable	Business Data
102	910	F800010	TD	17	2	Time Dimension	Master Files	00: Foundation Environment	Business Data
103	910	F80D306	HD	14	1	Action Definition	Files	80D: Plant Manager Dashboard
104	910	F80D307	HD	11	1	Metric Action Cross Reference	Files	80D: Plant Manager Dashboard
105	910	F80D309	MS	12	1	Metric Series Cross Ref	Files	80D: Plant Manager Dashboard
106	910	F80D310	AL	13	1	Alert Definition	Files	80D: Plant Manager Dashboard
107	910	F80D312	AS	12	1	Alert Subscription	Files	80D: Plant Manager Dashboard
108	910	F80D321	MG	12	1	UI Metric Group Definition	Files	80D: Plant Manager Dashboard
109	910	F80D322	MD	17	1	UI Metric Group Detail	Files	80D: Plant Manager Dashboard
110	910	F80D323	GE	11	1	GroupID Email Address	Files	80D: Plant Manager Dashboard

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

110 tables910 | 00