	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

78 tables812 | H96

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
H96: Deployment
1	812	F00945	RM	15	1	Release Master	Install Files	H96: Deployment	System Tables
2	812	F960004	CU	13	1	Change Table - User Defined Code Types	Work Files	H96: Deployment	Control Tables
3	812	F960005	CR	12	1	Change Table - User Defined Codes	Work Files	H96: Deployment	Control Tables
4	812	F9603	PH	20	2	Software Package Header	Master Files	H96: Deployment	System Tables
5	812	F96215	HH	27	2	Software Package Build Header - History	History Files	H96: Deployment	System Tables
6	812	F9622	BD	15	3	Software Package Build Detail	Master Files	H96: Deployment	System Tables
7	812	F96225	HD	25	2	Software Package Build Detail - History	History Files	H96: Deployment	System Tables
8	812	F9631	PD	14	2	Software Package Detail	Master Files	H96: Deployment	System Tables
9	812	F9640	CH	23	1	CD Configuration Header File	Master Files	H96: Deployment	System Tables
10	812	F96400	SG	23	10	Sar grouping file for ESUs	History Files	H96: Deployment	System Tables
11	812	F9641	CD	21	2	CD Configuration Detail File	Install Files	H96: Deployment	System Tables
12	812	F9642	CF	16	3	Change Table Configuration Details	Install Files	H96: Deployment	System Tables
13	812	F9643	CB	18	3	CD Build Steps File	Files	H96: Deployment	System Tables
14	812	F9644	CF	19	1	CD Director Control File	Install Files	H96: Deployment	System Tables
15	812	F9645	UP	24	4	OneWorld Master Repair File	Install Files	H96: Deployment	System Tables
16	812	F9646	PH	18	1	Procedure Header File	Master Files	H96: Deployment	System Tables
17	812	F9647	PD	25	8	Procedure Detail File	Master Files	H96: Deployment	System Tables
18	812	F9648	PP	17	2	Procedure Predecessor Table	Files	H96: Deployment	System Tables
19	812	F9650	MM	29	4	Machine Master	Master Files	H96: Deployment	System Tables
20	812	F9651	MD	16	2	Machine Detail	Master Files	H96: Deployment	System Tables
21	812	F9652	DH	13	1	Deployment Group Header	Master Files	H96: Deployment	System Tables
22	812	F9653	DD	15	3	Deployment Group Detail Definitions	Master Files	H96: Deployment	System Tables
23	812	F9654	DL	16	3	Deployment Locations Definition	Master Files	H96: Deployment	System Tables
24	812	F9660	TB	17	1	Task Breaks	Master Files	H96: Deployment	No
25	812	F96600	FD	21	1	Deployment Feature	Master Files	H96: Deployment	System Tables
26	812	F96601	FD	24	2	Deployment Registry	Master Files	H96: Deployment	System Tables
27	812	F96602	FD	31	2	Deployment Shortcut	Master Files	H96: Deployment	System Tables
28	812	F96603	FD	29	8	Deployment Execute	Master Files	H96: Deployment	System Tables
29	812	F96604	FD	29	3	Deployment Third Party	Master Files	H96: Deployment	System Tables
30	812	F96605	FD	28	4	Deployment Initialization	Master Files	H96: Deployment	System Tables
31	812	F96606	FD	26	3	Deployment File Set	Master Files	H96: Deployment	System Tables
32	812	F9670	SU	18	3	Software Update Master Table	History Files	H96: Deployment	System Tables
33	812	F9671	SD	13	1	Software Update Detail Table	History Files	H96: Deployment	System Tables
34	812	F9672	SU	20	4	Software Update Pathcode Information	Files	H96: Deployment	System Tables
35	812	F96761	SO	17	3	Software Update Object Detail	History Files	H96: Deployment	System Tables
36	812	F967611	SL	12	1	Software Update Language Table	Regular Work Files	H96: Deployment	System Tables
37	812	F9691100	FV	17	1	Change Table - Favorites	Install Files	H96: Deployment	System Tables
38	812	F9691400	DT	28	1	Change Table - Report Director Template Header	Install Files	H96: Deployment	System Tables
39	812	F9691410	DT	13	1	Change Table - Report Director Template Sequence	Install Files	H96: Deployment	System Tables
40	812	F9691420	SM	13	1	Change Table - Smart Field Activity	Install Files	H96: Deployment	System Tables
41	812	F9691430	SM	13	1	Change Table - Smart Field Criteria	Install Files	H96: Deployment	System Tables
42	812	F9691500	TP	12	1	Change Table - Tips of the Day Header	Install Files	H96: Deployment	System Tables
43	812	F9691510	TP	12	1	Change Table - Tips of the Day Detail	Install Files	H96: Deployment	System Tables
44	812	F969861	CT	10	1	Object Change Table Definition	Master Files	H96: Deployment	Environment Change Table
45	812	F9698710	TA	12	2	Change Table - Tables	Install Files	H96: Deployment	Environment Change Table
46	812	F9698712	IX	13	2	Change Table - Indexes	Install Files	H96: Deployment	Environment Change Table
47	812	F9746	D$	6	1	Change Table - User Defined Codes	Work Files	H96: Deployment	Planner Tables
48	812	F9755	D$	6	1	Change Table - Data Item Master	Work Files	H96: Deployment	Environment Change Table
49	812	F9757	D$	7	1	Change Table - Data Item Alpha Description	Work Files	H96: Deployment	Environment Change Table
50	812	F9759	D$	4	1	Change Table - Error Message Pgm Call	Work Files	H96: Deployment	Environment Change Table
51	812	F9760	D$	42	1	Change Table - OneWorld Data Field Specification	Work Files	H96: Deployment	Environment Change Table
52	812	F9840	PM	21	2	Installation Plan Master Table	Install Files	H96: Deployment	Planner Tables
53	812	F98401	PD	11	2	Data Source Plan Detail Table	Install Files	H96: Deployment	Planner Tables
54	812	F98402	PH	11	2	Host Plan Detail Table	Install Files	H96: Deployment	Planner Tables
55	812	F984021	LP	9	2	Location Plan Detail Table	Install Files	H96: Deployment	Planner Tables
56	812	F984022	RP	13	1	Replication Plan Detail Table	Install Files	H96: Deployment	Planner Tables
57	812	F98403	PE	16	3	Environment Plan Detail Table	Install Files	H96: Deployment	Planner Tables
58	812	F984031	PL	17	1	Language Plan by Environment	Install Files	H96: Deployment	Planner Tables
59	812	F98404	PP	9	2	Package Plan Detail Table	Install Files	H96: Deployment	Planner Tables
60	812	F98405	ST	27	5	Table Conversion Scheduler	Install Files	H96: Deployment	Planner Tables
61	812	F984072	CL	16	4	Table and Index Creation Log	Install Files	H96: Deployment	Planner Tables
62	812	F9841	SP	18	1	Simple Installation Planner	Install Files	H96: Deployment	Planner Tables
63	812	F98411	SD	14	1	Simple Installation Data Sources	Install Files	H96: Deployment	Planner Tables
64	812	F98412	SH	11	1	Simple Plan Host Information	Install Files	H96: Deployment	Planner Tables
65	812	F9843	JS	18	6	Table Conversion - JDE Scheduler	Install Files	H96: Deployment	Planner Tables
66	812	F9848	CU	14	2	Content Update Revision	Batch Input Files	H96: Deployment	System Tables
67	812	F98481	CD	13	2	Content Update Revision Detail	Batch Input Files	H96: Deployment	System Tables
68	812	F98511	SP	28	6	On Track Data Sources by Environment	Install Files	H96: Deployment	Planner Tables
69	812	F986115	TD	33	1	Table and Data Source Sizing Table	Constants Files	H96: Deployment	System Tables
70	812	F986116	TD	45	1	DB2 UDB Database Object Sizing Table	Constants Files	H96: Deployment	System Tables
71	812	F98826	UP	30	5	Package Deployment on Servers Information	Master Files	H96: Deployment	System Tables
72	812	F9888	BL	7	2	Merge Log	History Files	H96: Deployment	Planner Tables
73	812	F98881	SM	24	2	Specification Merge Logging File	History Files	H96: Deployment	System Tables
74	812	F988810	SM	13	2	SpecMerge Tracking	Work Files	H96: Deployment	System Tables
75	812	F9889	MT	21	3	Deployment Location Master	Master Files	H96: Deployment	System Tables
76	812	F98891	MT	17	1	Deployment Location Path Code	Secondary Master Files	H96: Deployment	System Tables
77	812	F98892	MT	33	1	Package Deployment Scheduling	Secondary Master Files	H96: Deployment	System Tables
78	812	F99410	OC	7	2	OneWorld System Control File	Constants Files	H96: Deployment	No

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

78 tables812 | H96