Question Status

Verified
Andrew Ciccarelli asked a question on 17 Jan 2013 4:38 PM

Hello - Can you recommend a good reference for Entity Type Codes for MS CRM 2011?  I found the following reference but it's for CRM 3.0:  http://technet.microsoft.com/en-us/library/aa682922.aspx

Reply
Verified Answer
Sumedha Obeysekera responded on 17 Jan 2013 7:52 PM

I think you need to query them..

SELECT * from EntityViewORDER BY ObjectTypeCode

Reply
www.crmworldinfo.blogspot.com responded on 17 Jan 2013 9:21 PM
EntityLogicalName DisplayName OTC
account Account 1
accountleads 16
activitymimeattachment E-Mail Attachment 1001
activityparty Activity Party 135
activitypointer Activity 4200
annotation Note 5
annualfiscalcalendar Annual Fiscal Calendar 2000
applicationfile Application File 4707
appointment Appointment 4201
asyncoperation System Job 4700
attachment Attachment 1002
attributemap Attribute Map 4601
audit Auditing 4567
bulkdeletefailure Bulk Delete Failure 4425
bulkdeleteoperation Bulk Delete Operation 4424
bulkoperation Quick Campaign 4406
bulkoperationlog Bulk Operation Log 4405
businessunit Business Unit 10
businessunitmap Business Unit Map 6
businessunitnewsarticle Announcement 132
calendar Calendar 4003
calendarrule Calendar Rule 4004
campaign Campaign 4400
campaignactivity Campaign Activity 4402
campaignactivityitem Campaign Activity Item 4404
campaignitem Campaign Item 4403
campaignresponse Campaign Response 4401
clientupdate Client update 36
columnmapping Column Mapping 4417
commitment Commitment 4215
competitor Competitor 123
competitoraddress Competitor Address 1004
competitorproduct Competitor Product 1006
competitorsalesliterature 26
connection Connection 3234
connectionrole Connection Role 3231
connectionroleassociation 3232
connectionroleobjecttypecode Connection Role Object Type Code 3233
constraintbasedgroup Resource Group 4007
contact Contact 2
contactinvoices 17
contactleads 22
contactorders 19
contactquotes 18
contract Contract 1010
contractdetail Contract Line 1011
contracttemplate Contract Template 2011
customeraddress Address 1071
customeropportunityrole Opportunity Relationship 4503
customerrelationship Customer Relationship 4502
dependency Dependency 7105
dependencynode Dependency Node 7106
discount Discount 1013
discounttype Discount List 1080
displaystring Display String 4102
displaystringmap Display String Map 4101
documentindex Indexed Article 126
duplicaterecord Duplicate Record 4415
duplicaterule Duplicate Detection Rule 4414
duplicaterulecondition Duplicate Rule Condition 4416
email E-mail 4202
emailhash E-Mail Hash 4023
emailsearch E-Mail Search 4299
entitymap Entity Map 4600
equipment Facility/Equipment 4000
fax Fax 4204
fieldpermission Field Permission 1201
fieldsecurityprofile Field Security Profile 1200
filtertemplate Filter Template 30
fixedmonthlyfiscalcalendar Fixed Monthly Fiscal Calendar 2004
goal Goal 9600
goalrollupquery Rollup Query 9602
import Data Import 4410
importdata Import Data 4413
importentitymapping Import Entity Mapping 4428
importfile Import Source File 4412
importjob Import Job 9107
importlog Import Log 4423
importmap Data Map 4411
incident Case 112
incidentresolution Case Resolution 4206
integrationstatus Integration Status 3000
internaladdress Internal Address 1003
interprocesslock Inter Process Lock 4011
invaliddependency Invalid Dependency 7107
invoice Invoice 1090
invoicedetail Invoice Product 1091
isvconfig ISV Config 4705
kbarticle Article 127
kbarticlecomment Article Comment 1082
kbarticletemplate Article Template 1016
lead Lead 4
leadaddress Lead Address 1017
leadcompetitors 24
leadproduct 27
letter Letter 4207
license License 2027
list Marketing List 4300
listmember Marketing List Member 4301
lookupmapping Lookup Mapping 4419
mailmergetemplate Mail Merge Template 9106
metric Goal Metric 9603
monthlyfiscalcalendar Monthly Fiscal Calendar 2003
msdyn_postalbum Profile Album 10000
msdyn_postconfig Post Configuration 10001
msdyn_postruleconfig Post Rule Configuration 10002
msdyn_wallsavedquery Wall View 10003
msdyn_wallsavedqueryusersettings Filter 10004
notification Notification 4110
opportunity Opportunity 3
opportunityclose Opportunity Close 4208
opportunitycompetitors 25
opportunityproduct Opportunity Product 1083
orderclose Order Close 4209
organization Organization 1019
organizationstatistic Organization Statistic 4708
organizationui Organization UI 1021
owner Owner 7
ownermapping Owner Mapping 4420
phonecall Phone Call 4210
picklistmapping List Value Mapping 4418
pluginassembly Plug-in Assembly 4605
plugintype Plug-in Type 4602
plugintypestatistic Plug-in Type Statistic 4603
post Post 8000
postcomment Comment 8005
postfollow Follow 8003
postlike Like 8006
postregarding Post Regarding 8002
postrole Post Role 8001
pricelevel Price List 1022
principalattributeaccessmap 43
principalentitymap 41
principalobjectaccess 11
principalobjectaccessreadsnapshot 90
principalobjectattributeaccess Field Sharing 44
privilege Privilege 1023
privilegeobjecttypecodes Privilege Object Type Code 31
processsession Dialog Session 4710
product Product 1024
productassociation Product Association 1025
productpricelevel Price List Item 1026
productsalesliterature 21
productsubstitute Product Substitute 1028
publisher Publisher 7101
publisheraddress Publisher Address 7102
quarterlyfiscalcalendar Quarterly Fiscal Calendar 2002
queue Queue 2020
queueitem Queue Item 2029
quote Quote 1084
quoteclose Quote Close 4211
quotedetail Quote Product 1085
recordcountsnapshot 91
recurrencerule Recurrence Rule 4250
recurringappointmentmaster Recurring Appointment 4251
relationshiprole Relationship Role 4500
relationshiprolemap Relationship Role Map 4501
replicationbacklog Replication Backlog 1140
report Report 9100
reportcategory Report Related Category 9102
reportentity Report Related Entity 9101
reportlink Report Link 9104
reportvisibility Report Visibility 9103
resource Resource 4002
resourcegroup Scheduling Group 4005
resourcegroupexpansion Resource Expansion 4010
resourcespec Resource Specification 4006
ribboncommand Ribbon Command 1116
ribboncontextgroup Ribbon Context Group 1115
ribboncustomization Application Ribbons 1120
ribbondiff Ribbon Difference 1130
ribbonrule Ribbon Rule 1117
ribbontabtocommandmap Ribbon Tab To Command Mapping 1113
role Security Role 1036
roleprivileges 12
roletemplate Role Template 1037
roletemplateprivileges 28
rollupfield Rollup Field 9604
salesliterature Sales Literature 1038
salesliteratureitem Sales Attachment 1070
salesorder Order 1088
salesorderdetail Order Product 1089
salesprocessinstance Sales Process Instance 32
savedquery View 1039
savedqueryvisualization System Chart 1111
sdkmessage Sdk Message 4606
sdkmessagefilter Sdk Message Filter 4607
sdkmessagepair Sdk Message Pair 4613
sdkmessageprocessingstep Sdk Message Processing Step 4608
sdkmessageprocessingstepimage Sdk Message Processing Step Image 4615
sdkmessageprocessingstepsecureconfig Sdk Message Processing Step Secure Configuration 4616
sdkmessagerequest Sdk Message Request 4609
sdkmessagerequestfield Sdk Message Request Field 4614
sdkmessageresponse Sdk Message Response 4610
sdkmessageresponsefield Sdk Message Response Field 4611
semiannualfiscalcalendar Semiannual Fiscal Calendar 2001
service Service 4001
serviceappointment Service Activity 4214
servicecontractcontacts 20
serviceendpoint Service Endpoint 4618
sharepointdocumentlocation Document Location 9508
sharepointsite SharePoint Site 9502
site Site 4009
sitemap Site Map 4709
solution Solution 7100
solutioncomponent Solution Component 7103
statusmap Status Map 1075
stringmap String Map 1043
subject Subject 129
subscription Subscription 29
subscriptionclients Subscription Clients 1072
subscriptionmanuallytrackedobject Subscription Manually Tracked Object 37
subscriptionsyncinfo Subscription Synchronization Information 33
subscriptiontrackingdeletedobject Tracking information for deleted entities 35
systemform System Form 1030
systemuser User 8
systemuserbusinessunitentitymap SystemUser BusinessUnit Entity Map 42
systemuserlicenses 13
systemuserprincipals System User Principal 14
systemuserprofiles 1202
systemuserroles 15
task Task 4212
team Team 9
teammembership 23
teamprofiles Team Profiles 1203
teamroles 40
template E-mail Template 2010
territory Territory 2013
timezonedefinition Time Zone Definition 4810
timezonelocalizedname Time Zone Localized Name 4812
timezonerule Time Zone Rule 4811
transactioncurrency Currency 9105
transformationmapping Transformation Mapping 4426
transformationparametermapping Transformation Parameter Mapping 4427
unresolvedaddress Unresolved Address 2012
uom Unit 1055
uomschedule Unit Group 1056
userentityinstancedata UserEntityInstanceData 2501
userentityuisettings User Entity UI Settings 2500
userfiscalcalendar User Fiscal Calendar 1086
userform User Dashboard 1031
userquery Saved View 4230
userqueryvisualization User Chart 1112
usersettings User Settings 150
webresource Web Resource 9333
webwizard Web Wizard 4800
wizardaccessprivilege Web Wizard Access Privilege 4803
wizardpage Wizard Page 4802
workflow Process 4703
workflowdependency Process Dependency 4704
workflowlog Process Log 4706
workflowwaitsubscription Workflow Wait Subscription 4702

 

The above table shows the all object type codes of every entity in CRM 2011.It will help you.

Regards

Suresh

www.crmworldinfo.blogspot.com
Reply
Suggested Answer
Churchill Kumar responded on 31 Oct 2013 4:05 PM

Hello,

Please find the same in the below article :

community.dynamics.com/.../list-of-object-types-in-dynamics-crm-2011.aspx

Thanks.

Reply
Verified Answer
Sumedha Obeysekera responded on 17 Jan 2013 7:52 PM

I think you need to query them..

SELECT * from EntityViewORDER BY ObjectTypeCode

Reply
Suggested Answer
Churchill Kumar responded on 31 Oct 2013 4:05 PM

Hello,

Please find the same in the below article :

community.dynamics.com/.../list-of-object-types-in-dynamics-crm-2011.aspx

Thanks.

Reply