An overview of all database tables by table number
The table numbers do not change and is the numbers you will see in the database when one table is referring to another table. Tables named "Obsolete_x" where removed from CRM 7, but kept in dictionary.
0 sequence
1 company
2 associate
3 AssociateGroupLink
4 AssociateHeadingLink
5 contact
6 person
7 address
8 phone
9 appointment
10 document
11 project
12 projectmember
13 sale
14 contactinterest
15 personinterest
16 ziptocity
17 redletterday
18 text
19 country
20 CountryGroupLink
21 CountryHeadingLink
22 preference
23 selection
24 selectionmember
25 SORPublishGroupLink
26 obsolete_2
27 obsolete_3
28 activeuser
29 traveltransactionlog
30 travelgeneratedtransaction
31 traveller
32 travelcurrent
33 travelgenerateddatabase
34 obsolete_4
35 udcontactSmall
36 udcontactLarge
37 MergeMoveLog
38 area
39 obsolete_9
40 areauserassignment
41 areauserinclusion
42 satellite
43 travelidmapping
44 freetextstopwords
45 freetextwords
46 freetextindex
47 obsolete_5
48 relationdefinition
49 RelDefGroupLink
50 RelDefHeadingLink
51 relationtarget
52 relations
53 History
54 URL
55 Email
56 UserPreference
57 AddressFormat
58 Heading
59 UserGroup
60 UserGroupLink
61 Business
62 BusinessGroupLink
63 BusinessHeadingLink
64 Category
65 CategoryGroupLink
66 CategoryHeadingLink
67 Task
68 TaskGroupLink
69 TaskHeadingLink
70 ContInt
71 ContIntGroupLink
72 ContIntHeadingLink
73 PersInt
74 PersIntGroupLink
75 PersIntHeadingLink
76 PersPos
77 PersPosGroupLink
78 PersPosHeadingLink
79 Priority
80 PriorityGroupLink
81 PriorityHeadingLink
82 Prob
83 ProbGroupLink
84 ProbHeadingLink
85 ProjType
86 ProjTypeGroupLink
87 ProjTypeHeadingLink
88 ProjStatus
89 ProjStatusGroupLink
90 ProjStatusHeadingLink
91 PMembType
92 PMembTypeGroupLink
93 PMembTypeHeadingLink
94 MrMrs
95 MrMrsGroupLink
96 MrMrsHeadingLink
97 Credited
98 CreditedGroupLink
99 CreditedHeadingLink
100 Source
101 SourceGroupLink
102 SourceHeadingLink
103 Reason
104 ReasonGroupLink
105 ReasonHeadingLink
106 SearchCat
107 SearchCatGroupLink
108 SearchCatHeadingLink
109 Comptr
110 ComptrGroupLink
111 ComptrHeadingLink
112 Currency
113 CurrencyGroupLink
114 CurrencyHeadingLink
115 ReasonSold
116 ReasonSoldGroupLink
117 ReasonSoldHeadingLink
118 SaleTypeCat
119 SaleTypeCatGroupLink
120 SaleTypeCatHeadingLink
121 SaleStakeholder
122 StakeholderRole
123 StakeholderRoleGroupLink
124 StakeholderRoleHeadingLink
125 SuggestedAppointment
126 SuggestedDocument
127 obsolete_6
128 obsolete_7
129 obsolete_8
130 DocTmpl
131 DocTmplGroupLink
132 DocTmplHeadingLink
133 ExtApp
134 ExtAppGroupLink
135 ExtAppHeadingLink
136 UDList
137 UDListGroupLink
138 UDListHeadingLink
139 UDListDefinition
140 udpersonSmall
141 udpersonLarge
142 udprojectSmall
143 udprojectLarge
144 udtempSmall
145 udtempLarge
146 UDefField
147 UDefFieldGL
148 CacheTables
149 SaleType
150 SaleTypeGroupLink
151 SaleTypeHeadingLink
152 TabOrder
153 SystemEvent
154 ReasonStalled
155 ReasonStalledGroupLink
156 ReasonStalledHeadingLink
157 SaleHist
158 udsalesmall
159 udsalelarge
160 SaleTypeStageLink
161 OLESubject
162 OLESubjectText
163 OLEView
164 OLEViewText
165 OLEField
166 OLEFieldText
167 OwnerContactLink
168 FieldLabel
169 LocaleText
170 ReporterListDef
171 RefCounts
172 RefCountRange
173 SORTemplate
174 SORPublish
175 SORCriteria
176 SOROperators
177 SORSection
178 SORFCT
179 SORField
180 SORLabelLayout
181 foreignapp
182 foreigndevice
183 foreignkey
184 PrefDesc
185 PrefDescLine
186 ImportObject
187 ImportField
188 ImportRelation
189 ImportDefault
190 UsageStats
191 Role
192 UserRoleLink
193 FunctionRight
194 FunctionRightRoleLink
195 DataRight
196 VisibleFor
197 CounterValue
198 StatusDef
199 StatusValue
200 Publish
201 SearchCriteria
202 SearchCriteriaGroup
203 SearchCriterion
204 SearchCriterionValue
205 BinaryObject
206 BinaryObjectLink
207 RecurrenceRule
208 WinPosSize
209 SuperListColumnSize
210 LanguageInfo
211 LanguageInfoCountry
212 ModuleOwner
213 ProjectTypeStatusLink
214 DiaryView
215 DiaryViewRow
216 Intent
217 IntentGroupLink
218 IntentHeadingLink
219 Salutation
220 SalutationGroupLink
221 SalutationHeadingLink
222 RejectReason
223 RejectReasonGroupLink
224 RejectReasonHeadingLink
225 AmountClass
226 AmountClassGroupLink
227 AmountClassHeadingLink
228 udappntsmall
229 udappntlarge
230 uddocsmall
231 uddoclarge
232 AudienceVisibility
233 ExternalEvent
234 AudienceLayout
235 AudienceLayoutLink
236 AudienceConfig
237 ModuleLicense
238 LicenseAssocLink
239 LicenseSatlLink
240 ProductVersion
241 MessageHandler
242 Message
243 BatchTask
244 BatchTaskDefinition
245 TZLocation
246 TZStdRule
247 TZDstRule
248 BaseTZLocation
249 WebAppUsage
250 Credentials
251 PhoneFormat
252 TrayApp
Following tables where new in CRM 7
253 registry
254 session_object
255 config
256 ticket_attachment
257 ej_category
258 ej_message
259 message_header
260 message_customers
261 ticket_status_history
262 ticket
263 ticket_status
264 ticket_customers
265 invoice
266 invoice_sum
267 ticket_log
268 ticket_log_change
269 ticket_log_action
270 category_membership
271 mail_in_filter
272 mail_in_uidl
273 mail_alias
274 ticket_alert
275 ticket_priority
276 reply_template_folder
277 reply_template
278 reply_template_attachment
279 reply_template_body
280 doc_document
281 doc_folder
282 kb_entry
283 kb_category
284 kb_attachment
285 kb_http_link
286 kb_group
287 kb_group_entry
288 kb_entry_keyword
289 kb_entry_comment
290 kb_entry_log
291 kb_category_log
292 kb_workflow
293 kb_workflow_access
294 kb_solution_finder
295 kb_solution_finder_entry
296 attachment
297 login
298 login_customer
299 ejuser
300 timestamps
301 notify
302 help
303 company_domain
304 extra_fields
305 extra_tables
306 hierarchy
307 extra_menus
308 extra_tables_result
309 extra_tables_entry
310 ms_filter
311 ms_filter_mail
312 ms_trashbin
313 ms_substitute
314 eab_folder
315 eab_entry
316 mail_block
317 ext_datasource
318 ext_table
319 ext_field
320 cust_lang
321 cust_category
322 password_rules
323 ej_role
324 role_member
325 role_category
326 role_element
327 role_workflow
328 element_profile
329 profile
330 chat_topic
331 chat_topic_user
332 chat_session
333 chat_message
334 s_shipment
335 s_message
336 s_link
337 s_link_customer
338 s_link_customer_statical
339 s_picture_folder
340 s_picture_entry
341 s_washing
342 s_bounce_shipment
343 s_washing_list
344 s_list
345 s_list_element
346 s_list_customer
347 s_shipment_addr
348 s_list_shipment
349 s_attachment
350 s_dyn_criteria
351 outbox
352 inbox
353 legal_html_tags
354 kb_entry_words
355 word_relations
356 temporary_words
357 wsdl_description
358 dictionary
359 dictionary_base
360 invoice_entry
361 invoice_type
362 soap_access
363 hotlist
364 log_events
365 log_debug
366 form_keys
367 sms_hysteria
368 item_config
369 snapshot
370 screen_definition
371 screen_definition_action
372 screen_definition_element
373 screen_definition_hidden
374 screen_definition_language
375 screen_chooser
376 scheduled_task
377 ejscript
378 system_script
379 schedule
380 locking
381 dbi_agent
382 dbi_agent_field
383 dbi_agent_schedule
384 ejpackage
385 ejpackage_item
386 message_id
387 ejscript_debug
388 sms
389 user_candidate
390 s_smtp_servers
391 ejselection
392 ejsel_ejsel
393 ejsel_source_idlist
394 ejsel_source_script
395 ejsel_source_xml
396 static_list_ref
397 ejsel_meta_result
398 ejsel_result_set
399 tree_explorer_entry
400 tree_explorer_link
401 external_document
402 autosave
403 user_attribute
404 notice_frame
405 s_sent_message
406 access_script
Following table was new from 7.1
407 outgoing_message