	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

131 columns | 920 | UDTTM

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP01: Address Book
1	F01301	Activity Master	44	AM	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
2	F01301D	Activity Detail	45	AD	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
3	F01301W	Mobile Client Deleted Activities	45	AW	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
4	F01311	Centralized Calendar Master	31	CC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
5	F01315	Calendar Associations	12	CC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
6	F01321	Recurrence Master	11	RM	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
7	F01331	Recurrence Exclusion	7	RE	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
8	F01401	Action Plan	11	AP	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
9	F01411	Action Plan Activity	15	AC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
TOP42: Sales Management
10	F42140	Customer Master Commission Information	19	CM	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
TOP42B: Sales Order Entry
11	F4201UR	F4201 CRM User Reserved Tag File	27	SH	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
12	F4211UR	F4211 CRM User Reserved Tag File	41	UR	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
TOP90CA: CRM Foundation
13	F4107	Item Feature Table	26	IF	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
14	F90CA000	CRM_Constants Table	18	CO	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
15	F90CA001	F0101 Used Address Book Number Table	5	UA	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
16	F90CA020	Person Table	49	TT	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
17	F90CA02A	Person_Notification Table	30	TA	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
18	F90CA030	Profile Table	46	PR	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
19	F90CA040	Employee Table	48	EE	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
20	F90CA041	Employee and Subordinates	10	ES	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
21	F90CA042	Flat Employee Hierarchy	6	EM	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
22	F90CA050	Partner Table	46	PP	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
23	F90CA05A	Partner_Employee Table	31	PA	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
24	F90CA05B	Partner_Item Table	9	PB	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
25	F90CA060	Competitor Table	29	RC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
26	F90CA06A	Competitor_KillSheet Table	30	RA	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
27	F90CA070	Contact Table	49	CT	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
28	F90CA07A	Contact_Event Table	10	CA	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
29	F90CA07B	Contact_Profile Table	30	CB	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
30	F90CA080	Customer Table	44	UU	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
31	F90CA086	Flat Customer Related Address Table	6	CR	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
32	F90CA08A	Customer_Employee Table	32	UA	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
33	F90CA08C	Customer_Partner Table	9	UC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
34	F90CA08E	Customer_Profile Table	29	UE	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
35	F90CA100	CRM Item Table	29	IT	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
36	F90CA10A	Item_Hierarchy Table	35	IH	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
37	F90CA10B	Item_Item_Hierarchy Table	9	II	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
38	F90CA10C	Item_Hierarchy_Employee Table	30	IE	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
39	F90CA120	Industry Grouping Table	28	IG	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
40	F90CA121	Industry Grouping Recursive Children Temp Table	6	IG	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
41	F90CA12A	Industry Grouping Industry	28	IA	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
42	F90CA12B	Industry Grouping Employee Table	12	IB	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
43	F90CA130	Industry Buying Issues	31	BI	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
44	F90CA140	Territory Table	9	TY	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
45	F90CA142	Territory Recursive Children Temp Table	6	TY	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
46	F90CA14A	Territory Employee Table	12	TE	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
47	F90CA14B	Territory Country Table	9	TB	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
48	F90CA14C	Territory State Table	10	TC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
49	F90CA14D	Territory Zip Code Table	11	TD	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
50	F90CA14E	Territory City Table	12	TE	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
51	F90CA180	Territory Alignment Table	11	TA	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
52	F90CA18B	Industry Grouping Alignment Table	11	IG	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
53	F90CA18C	Sales Team Alignment Table	10	ST	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
54	F90CA24E	Simple Template Alternate Key	11	SK	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
55	F90CA31	Activity Extension Table	37	EX	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
56	F90CA31H	Activity Employee Extension Table	20	EX	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
57	F90CA500	E-MAIL Table	11	EM	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
58	F90CA50A	MEMBER Table	8	ME	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
59	F90CA50B	MEMBER PERSON Table	7	ME	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
60	F90CA50C	MEMBER EMAIL GROUP Table	6	ME	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
61	F90CA50D	EMAIL CONTACT Table	7	EM	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
62	F90CA510	E-MAIL GROUP Table	5	EG	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
63	F90CA60E	Activity Lead Associative Table (FOR CRM UPGRADE)	3	AC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
64	F90CA61E	Activity Opportunity Associative Table (FOR CRM UPGRADE)	3	AC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
65	F90CA62E	Activity Contact Associative Table (FOR CRM UPGRADE)	7	AC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
66	F90CA63E	Activity Customer Associative Table (FOR CRM UPGRADE)	7	AC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
67	F90CA64E	Activity Case Associative Table (FOR CRM UPGRADE)	6	AC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
68	F90CA65	Call Plan Table	10	EX	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
69	F90CA900	Address_Extension Table	31	AE	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
70	F90CA901	Phone_Extension Table	27	PE	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
71	F90CA902	Email_Extension Table	27	EE	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
TOP90CB: CRM Sales Force Automation
72	F90CB010	Lead Table	97	LD	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
73	F90CB01A	Lead_Address Table	9	LA	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
74	F90CB01B	Lead_Activity Table	9	LT	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
75	F90CB01C	Lead_Partner Table	9	LP	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
76	F90CB01D	Lead_Item_Hierarchy Table	11	LI	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
77	F90CB020	Opportunity Table	68	OT	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
78	F90CB02C	Opportunity_Competitor Table	9	OC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
79	F90CB02D	Opportunity_Contact Table	31	OD	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
80	F90CB02E	Opportunity_Employee Table	34	OE	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
81	F90CB02G	Opportunity_Partner Table	9	OG	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
82	F90CB02I	Opportunity_Item Table	52	OI	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
83	F90CB02J	Opportunity_Sales_Cycle Table	30	OJ	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
84	F90CB02M	Cost Table	38	OM	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
85	F90CB030	CRM Address Table (Lead related information)	38	AD	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
86	F90CB040	Qualification Table	12	QL	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
87	F90CB041	Qualification_Answer Table	13	QA	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
88	F90CB042	Qualification_Question Table	26	QQ	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
89	F90CB043	Qualification_Object Table	11	QO	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
90	F90CB050	Sales_Methodology Table	29	SM	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
91	F90CB05A	Sales_Cycle Table	37	OP	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
92	F90CB05B	Sale_Driver Table	34	ON	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
93	F90CB05C	Sales_Cycle_Notification_Ledger Table	17	NL	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
94	F90CB060	Forecast	61	FC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
95	F90CB06A	Forecast Opportunity	9	FO	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
96	F90CB06B	Opportunity_For_Forecast Table	68	OF	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
97	F90CB06C	Opportunity_Item_For_Forecast Table	55	OH	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
98	F90CB06Z	Opportunity for Forecast WTF	69	ZF	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
TOP90CD: CRM Service Management
99	F4801UR	F4801 CRM User Reserved Tag File	23	UR	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
TOP90CE: CRM Solution Advisor
100	F90CE01	Solution Table	17	ST	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
101	F90CE01A	Solution/ Work Order Intersection	6	WO	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
102	F90CE01B	Solution/ Case Intersection	7	SC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
103	F90CE01D	Solution/ Item Intersection	7	SP	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
104	F90CE02	Library	10	LI	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
105	F90CE999	Test Audit Table	4	AU	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
TOP90CF: CRM Call Scripting
106	F90CF030	Answer Value	11	AV	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
107	F90CF03A	Answer Translations - All Columns	7	CC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
108	F90CF040	Answer Set	9	AS	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
109	F90CF050	Question Group	6	CC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
110	F90CF05A	Question Group Line Items	6	CC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
111	F90CF060	Question Values	5	CC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
112	F90CF06A	Question Translation	7	CC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
113	F90CF070	Tokens	6	CC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
114	F90CF080	Variable	9	SV	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
115	F90CF140	Rate Set	5	CC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
116	F90CF14A	Rate Set Item	6	CC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
117	F90CF160	Script	18	SC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
118	F90CF16A	Script/Question table	5	CC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
119	F90CF16B	Script/Item Table	3	IS	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
120	F90CF16C	Script Translations	3	CC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
121	F90CF170	Script Tree Node	19	TN	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
122	F90CF180	Script Instance Header	12	IH	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
123	F90CF18A	Script Instance Detail	18	ID	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
124	F90CF18B	Script Instance Comments	10	IC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
125	F90CF18C	Script Instance - Token Extension	8	IT	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
TOP90CG: CRM Case Management
126	F1755UR	F1755 - CRM User Reserved Tag File	36	CA	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
127	F90CG001	Apropos Parm Table	8	AP	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
128	F90CG002	Apropos URL table	6	CC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
129	F90CG503	Case Association Table	16	CA	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
130	F90CG506	Provider Group Employees	10	ZC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
131	F90CG507	Case/ Workflow Intersection	7	CC	UDTTM	Updated Date Time	JDE UTime	Generic Edit	11	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

131 columns | 920 | UDTTM