CRM Table Definitions

Obligatory Warning : Do not interfere with the underlying table structure or data of the CRM. Microsoft will not support you if you make any such changes and a future update consequently breaks the installation and your company data. The following is for information only!

OK, warning over. Here are the table names for all BASE tables within Microsoft CRM. There are actually many more tables but those ending in the word 'base' contain the general data that Dynamics manipulates. Therefore, if you are unable to find the GUID of a customer, you may (if you are careful) go to the Microsoft SQL Server Manager, run a new query :

SELECT AccountId , Name , AccountNumber FROM AccountBase

You will see all GUID's for your customers listed along with their common names.

Alternatively, you could go to the CRM web interface, choose a customer and then press F11 twice. This will force the browser to display the querystring value which will have the GUID in it.

AccountBase	PhoneCallBase
AccountExtensionBase	PhoneCallExtensionBase
ActivityPartyBase	PickListMappingBase
ActivityPointerBase	PluginAssemblyBase
AnnotationBase	PluginAssemblyBaseIDs
ApplicationFileBase	PluginTypeBase
AppointmentBase	PluginTypeBaseIDs
AppointmentExtensionBase	PriceLevelBase
AsyncOperationBase	PrivilegeBase
AttributeMapBase	ProductBase
BulkDeleteFailureBase	ProductExtensionBase
BulkDeleteOperationBase	ProductPriceLevelBase
BulkOperationBase	QueueBase
BulkOperationLogBase	QueueItemBase
BusinessTaskBase	QuoteBase
BusinessUnitBase	QuoteCloseBase
BusinessUnitNewsArticleBase	QuoteDetailBase
CalendarBase	QuoteDetailExtensionBase
CalendarRuleBase	QuoteExtensionBase
CampaignActivityBase	RelationshipRoleBase
CampaignActivityExtensionBase	RelationshipRoleMapBase
CampaignActivityItemBase	ReportBase
CampaignBase	ReportCategoryBase
CampaignExtensionBase	ReportCategoryExtensionBase
CampaignItemBase	ReportEntityBase
CampaignResponseBase	ReportLinkBase
CampaignResponseExtensionBase	ReportVisibilityBase
ColumnMappingBase	ResourceBase
CompetitorAddressBase	ResouceGroupBase
CompetitorBase	ResourceGroupExtensionBase
CompetitorExtensionBase	ResourceSpecBase
ConstraintBasedGroupBase	RoleBase
ContactBase	RoleTemplateBase
ContactExtensionBase	SalesLiteratureBase
ContractBase	SalesLiteratureExtensionBase
ContractDetailBase	SalesLiteratureItemBase
ContractDetailExtensionBase	SalesOrderBase
ContractExtensionBase	SalesOrderDetailBase
ContractTemplateBase	SalesOrderExtensionBase
CustomerAddressBase	SavedQueryBase
CustomerAddressExtensionBase	SDKMessageBase
CustomerOpportunityRoleBase	SDKMessageBaseIDs
CustomerRelationshipBase	SDKMessageFilterBase
DiscountBase	SDKMessageFilterBaseIDs
DiscountTypeBase	SDKMessagePairBase
DisplayStringBase	SDKMessagePairBaseIDs
DisplayStringMapBase	SDKMessageProcessingStepBase
DuplicateRecordBase	SDKMessageProcessingStepBaseIDs
DuplicateRuleBase	SDKMessageProcessingStepImageBase
DuplicateRuleConditionBase	SDKMessageProcessingStepSecureConfigBase
EmailBase	SDKMessageProcessingStepSecureConfigBaseIDs
EmailExtensionBase	SDKMessageRequestBase
EmailHashBase	SDKMessageRequestBaseIDs
EntityMapBase	SDKMessageRequestFieldBase
EquipmentBase	SDKMessageRequestInputBase
EquipmentExtensionBase	SDKMessageResponseBase
FaxBase	SDKMessageResponseBaseIDs
FaxExensionBase	SDKMessageResponseFieldBase
ImportBase	ServiceAppointmentBase
ImportDataBase	ServiceAppointmentExtensionBase
ImportFileBase	ServiceBase
ImportJobBase	SiteBase
ImportLogBase	SubjectBase
ImportMapBase	SystemUserBase
IncidentBase	SystemUserExtensionBase
IncidentExtensionBase	TaskBase
IncidentResolutionBase	TaskExtensionBase
IntegrationStatusBase	TeamBase
InternalAddressBase	TemplateBase
InterprocessLockBase	TerritoryBase
InvoiceBase	TimeZoneDefinitionBase
InvoiceDetailBase	TimeZoneLocalizedNameBase
InvoiceDetailExtensionBase	TimeZoneRuleBase
InvoiceExtensionBase	TransactionCurrencyBase
IsConfigBase	TransformationMappingBase
KBArticleBase	TransformationPerameterMappingBase
KBArticleCommentBase	UnresolvedAddressBase
KBArticleTemplateBase	UoMBase
LeadAddressBase	UoMScheduleBase
LeadBase	UserFiscalCalendarBase
LeadExtensionBase	UserQueryBase
LetterBase	UserSettingBase
LetterExtensionBase	WebWizardBase
ListBase	WizardAccessPrivilegeBase
ListExtensionBase	WizardPageBase
ListMemberBase	WorkflowBase
LookupMappingBase	WorkflowCompletedScopeBase
MailmergeTemplateBase	WorkFlowDependencyBase
MailmergeTemplateExtensionBase	WorkFlowLogBase
New_SalesMatrixBase	WorkFlowWaitSubscriptionBase
New_SalesMatrixExtensionBase
New_VendorBase
New_VendorExtensionBase
OpportunityBase
OpportunityCloseBase
OpportunityExtensionBase
OpportunityProductBase
OpportunityProductExtensionBase
OrderCloseBase
OrganizationBase
OrganizationStatisticBase
OrganizationUIBase
OwnerMappingBase