Entity Type Codes in Dynamics CRM On-premisis verion
You can retrieve the type codes for all entities by running the following SQL Query in CRM database.
1
| select * from EntityView order by ObjectTypeCode |
Type codes below 10000 are reserved for Microsoft CRM systementities. Custom entities have a value greater than or equal to 10,000. Note that custom entity object type codes may change during import and are not guaranteed to be the same between systems.
The following table shows the type codes for system entities.
| Entity Name | ObjectTypeCode |
| Account | 1 |
| Contact | 2 |
| Opportunity | 3 |
| Lead | 4 |
| Annotation | 5 |
| BusinessUnitMap | 6 |
| Owner | 7 |
| SystemUser | 8 |
| Team | 9 |
| BusinessUnit | 10 |
| PrincipalObjectAccess | 11 |
| RolePrivileges | 12 |
| SystemUserLicenses | 13 |
| SystemUserPrincipals | 14 |
| SystemUserRoles | 15 |
| AccountLeads | 16 |
| ContactInvoices | 17 |
| ContactQuotes | 18 |
| ContactOrders | 19 |
| ServiceContractContacts | 20 |
| ProductSalesLiterature | 21 |
| ContactLeads | 22 |
| TeamMembership | 23 |
| LeadCompetitors | 24 |
| OpportunityCompetitors | 25 |
| CompetitorSalesLiterature | 26 |
| LeadProduct | 27 |
| RoleTemplatePrivileges | 28 |
| Subscription | 29 |
| FilterTemplate | 30 |
| PrivilegeObjectTypeCodes | 31 |
| SalesProcessInstance | 32 |
| SubscriptionSyncInfo | 33 |
| SubscriptionTrackingDeletedObject | 35 |
| ClientUpdate | 36 |
| SubscriptionManuallyTrackedObject | 37 |
| TeamRoles | 40 |
| PrincipalEntityMap | 41 |
| SystemUserBusinessUnitEntityMap | 42 |
| PrincipalAttributeAccessMap | 43 |
| PrincipalObjectAttributeAccess | 44 |
| PrincipalObjectAccessReadSnapshot | 90 |
| RecordCountSnapshot | 91 |
| Incident | 112 |
| Competitor | 123 |
| DocumentIndex | 126 |
| KbArticle | 127 |
| Subject | 129 |
| BusinessUnitNewsArticle | 132 |
| ActivityParty | 135 |
| UserSettings | 150 |
| ActivityMimeAttachment | 1001 |
| Attachment | 1002 |
| InternalAddress | 1003 |
| CompetitorAddress | 1004 |
| CompetitorProduct | 1006 |
| Contract | 1010 |
| ContractDetail | 1011 |
| Discount | 1013 |
| KbArticleTemplate | 1016 |
| LeadAddress | 1017 |
| Organization | 1019 |
| OrganizationUI | 1021 |
| PriceLevel | 1022 |
| Privilege | 1023 |
| Product | 1024 |
| ProductAssociation | 1025 |
| ProductPriceLevel | 1026 |
| ProductSubstitute | 1028 |
| SystemForm | 1030 |
| UserForm | 1031 |
| Role | 1036 |
| RoleTemplate | 1037 |
| SalesLiterature | 1038 |
| SavedQuery | 1039 |
| StringMap | 1043 |
| UoM | 1055 |
| UoMSchedule | 1056 |
| SalesLiteratureItem | 1070 |
| CustomerAddress | 1071 |
| SubscriptionClients | 1072 |
| StatusMap | 1075 |
| DiscountType | 1080 |
| KbArticleComment | 1082 |
| OpportunityProduct | 1083 |
| Quote | 1084 |
| QuoteDetail | 1085 |
| UserFiscalCalendar | 1086 |
| SalesOrder | 1088 |
| SalesOrderDetail | 1089 |
| Invoice | 1090 |
| InvoiceDetail | 1091 |
| SavedQueryVisualization | 1111 |
| UserQueryVisualization | 1112 |
| RibbonTabToCommandMap | 1113 |
| RibbonContextGroup | 1115 |
| RibbonCommand | 1116 |
| RibbonRule | 1117 |
| RibbonCustomization | 1120 |
| RibbonDiff | 1130 |
| ReplicationBacklog | 1140 |
| FieldSecurityProfile | 1200 |
| FieldPermission | 1201 |
| SystemUserProfiles | 1202 |
| TeamProfiles | 1203 |
| AnnualFiscalCalendar | 2000 |
| SemiAnnualFiscalCalendar | 2001 |
| QuarterlyFiscalCalendar | 2002 |
| MonthlyFiscalCalendar | 2003 |
| FixedMonthlyFiscalCalendar | 2004 |
| Template | 2010 |
| ContractTemplate | 2011 |
| UnresolvedAddress | 2012 |
| Territory | 2013 |
| Queue | 2020 |
| License | 2027 |
| QueueItem | 2029 |
| UserEntityUISettings | 2500 |
| UserEntityInstanceData | 2501 |
| IntegrationStatus | 3000 |
| ConnectionRole | 3231 |
| ConnectionRoleAssociation | 3232 |
| ConnectionRoleObjectTypeCode | 3233 |
| Connection | 3234 |
| Equipment | 4000 |
| Service | 4001 |
| Resource | 4002 |
| Calendar | 4003 |
| CalendarRule | 4004 |
| ResourceGroup | 4005 |
| ResourceSpec | 4006 |
| ConstraintBasedGroup | 4007 |
| Site | 4009 |
| ResourceGroupExpansion | 4010 |
| InterProcessLock | 4011 |
| EmailHash | 4023 |
| DisplayStringMap | 4101 |
| DisplayString | 4102 |
| Notification | 4110 |
| ActivityPointer | 4200 |
| Appointment | 4201 |
| 4202 | |
| Fax | 4204 |
| IncidentResolution | 4206 |
| Letter | 4207 |
| OpportunityClose | 4208 |
| OrderClose | 4209 |
| PhoneCall | 4210 |
| QuoteClose | 4211 |
| Task | 4212 |
| ServiceAppointment | 4214 |
| Commitment | 4215 |
| UserQuery | 4230 |
| RecurrenceRule | 4250 |
| RecurringAppointmentMaster | 4251 |
| EmailSearch | 4299 |
| List | 4300 |
| ListMember | 4301 |
| Campaign | 4400 |
| CampaignResponse | 4401 |
| CampaignActivity | 4402 |
| CampaignItem | 4403 |
| CampaignActivityItem | 4404 |
| BulkOperationLog | 4405 |
| BulkOperation | 4406 |
| Import | 4410 |
| ImportMap | 4411 |
| ImportFile | 4412 |
| ImportData | 4413 |
| DuplicateRule | 4414 |
| DuplicateRecord | 4415 |
| DuplicateRuleCondition | 4416 |
| ColumnMapping | 4417 |
| PickListMapping | 4418 |
| LookUpMapping | 4419 |
| OwnerMapping | 4420 |
| ImportLog | 4423 |
| BulkDeleteOperation | 4424 |
| BulkDeleteFailure | 4425 |
| TransformationMapping | 4426 |
| TransformationParameterMapping | 4427 |
| ImportEntityMapping | 4428 |
| RelationshipRole | 4500 |
| RelationshipRoleMap | 4501 |
| CustomerRelationship | 4502 |
| CustomerOpportunityRole | 4503 |
| Audit | 4567 |
| EntityMap | 4600 |
| AttributeMap | 4601 |
| PluginType | 4602 |
| PluginTypeStatistic | 4603 |
| PluginAssembly | 4605 |
| SdkMessage | 4606 |
| SdkMessageFilter | 4607 |
| SdkMessageProcessingStep | 4608 |
| SdkMessageRequest | 4609 |
| SdkMessageResponse | 4610 |
| SdkMessageResponseField | 4611 |
| SdkMessagePair | 4613 |
| SdkMessageRequestField | 4614 |
| SdkMessageProcessingStepImage | 4615 |
| SdkMessageProcessingStepSecureConfig | 4616 |
| ServiceEndpoint | 4618 |
| AsyncOperation | 4700 |
| WorkflowWaitSubscription | 4702 |
| Workflow | 4703 |
| WorkflowDependency | 4704 |
| IsvConfig | 4705 |
| WorkflowLog | 4706 |
| ApplicationFile | 4707 |
| OrganizationStatistic | 4708 |
| SiteMap | 4709 |
| ProcessSession | 4710 |
| WebWizard | 4800 |
| WizardPage | 4802 |
| WizardAccessPrivilege | 4803 |
| TimeZoneDefinition | 4810 |
| TimeZoneRule | 4811 |
| TimeZoneLocalizedName | 4812 |
| Solution | 7100 |
| Publisher | 7101 |
| PublisherAddress | 7102 |
| SolutionComponent | 7103 |
| Dependency | 7105 |
| DependencyNode | 7106 |
| InvalidDependency | 7107 |
| Post | 8000 |
| PostRole | 8001 |
| PostRegarding | 8002 |
| PostFollow | 8003 |
| PostComment | 8005 |
| PostLike | 8006 |
| Report | 9100 |
| ReportEntity | 9101 |
| ReportCategory | 9102 |
| ReportVisibility | 9103 |
| ReportLink | 9104 |
| TransactionCurrency | 9105 |
| MailMergeTemplate | 9106 |
| ImportJob | 9107 |
| WebResource | 9333 |
| SharePointSite | 9502 |
| SharePointDocumentLocation | 9508 |
| Goal | 9600 |
| GoalRollupQuery | 9602 |
| Metric | 9603 |
| RollupField | 9604 |
