This article is a copy of my post on my old SPandCRM.com blog, I will be slowly moving across some of the more popular articles.

Another quick reference article today, in this article I’ll provide a list of type codes which are internal ID references to entities and I’ll provide some and SQL query that will allow you to easily return your own ID values.

It’s worth knowing that Microsoft has reserved ID numbers 0 – 10,000 with any custom entities appearing from 10,000 onwards. Any system entities should have the same ID’s as below but you will need to run the below code against your organisation database to return custom entity ID’s-

select [ObjectTypeCode], [Name], [LogicalName]  
from EntityView 
order by ObjectTypeCode

Entity ID List