Contact Entity Metadata
[Applies to: Microsoft Dynamics CRM 2011]
The following information is for the contact entity in a default, uncustomized installation of Microsoft Dynamics CRM. The schema name and early bound entity name is Contact.
To view the entity metadata for your organization, install the Metadata Browser solution described in Browse the Metadata for Your Organization.
In This Topic
Entity Metadata
Privilege Metadata
Attribute Metadata
One-to-Many Relationships
Many-to-Many Relationships
Many-to-One Relationships
Entity Metadata
The following table shows the metadata for the contact entity.
Entity metadata property | Value |
---|---|
OTC |
2 |
EntityLogicalName |
contact |
DisplayName |
Contact |
DisplayCollectionName |
Contacts |
IsCustomizable |
True |
OwnershipType |
UserOwned |
AutoRouteToOwnerQueue |
False |
CanBeInManyToMany |
True |
CanBePrimaryEntityInRelationship |
True |
CanBeRelatedEntityInRelationship |
True |
CanCreateAttributes |
True |
CanCreateCharts |
True |
CanCreateForms |
True |
CanCreateViews |
True |
CanModifyAdditionalSettings |
True |
CanTriggerWorkflow |
True |
IsActivity |
False |
IsActivityParty |
True |
IsAuditEnabled |
False |
IsAvailableOffline |
True |
IsChildEntity |
False |
IsConnectionsEnabled |
canmodifyconnectionsettings |
IsCustomEntity |
False |
IsDocumentManagementEnabled |
False |
IsDuplicateDetectionEnabled |
True |
IsEnabledForCharts |
True |
IsImportable |
True |
IsIntersect |
False |
IsMailMergeEnabled |
True |
IsManaged |
True |
IsMappable |
True |
IsReadingPaneEnabled |
True |
IsRenameable |
True |
IsValidForAdvancedFind |
True |
IsValidForQueue |
False |
IsVisibleInMobile |
True |
PrimaryIdAttribute |
contactid |
PrimaryNameAttribute |
fullname |
ReportViewName |
FilteredContact |
Description |
Person with whom a business unit has a relationship, such as customer, supplier, and colleague. |
Privilege Metadata
The following table shows the privileges metadata for the contact entity.
PrivilegeName | Id | Type | CanBeBasic | CanBeDeep | CanBeGlobal | CanBeLocal |
---|---|---|---|---|---|---|
prvAppendContact |
2b16ba12-6ab4-4ad2-b7c0-8641d2d6dff2 |
Append |
True |
True |
True |
True |
prvAppendToContact |
158327b5-f4c1-448e-93d1-5f135126665b |
AppendTo |
True |
True |
True |
True |
prvAssignContact |
43c63782-c7c6-471c-bd9c-24f79bf8c2a1 |
Assign |
True |
True |
True |
True |
prvCreateContact |
a8bff87f-0df0-41d4-babd-f093faf1e32c |
Create |
True |
True |
True |
True |
prvDeleteContact |
2ddded47-7488-4039-b9ff-81defe81fdd3 |
Delete |
True |
True |
True |
True |
prvReadContact |
ba09ec92-12c4-4312-ba16-5715c2cbd6da |
Read |
True |
True |
True |
True |
prvShareContact |
ae756940-61ff-4bd3-bfbb-f2b0d542c608 |
Share |
True |
True |
True |
True |
prvWriteContact |
65c22075-4e09-4f39-baec-e4bc3a950686 |
Write |
True |
True |
True |
True |
Attribute Metadata
The following table shows the attribute metadata for the contact entity.
LogicalName | SchemaName | Type | RequiredLevel | IsValidForCreate | IsValidForRead | IsValidForUpdate | CanBeSecuredForCreate | CanBeSecuredForRead | CanBeSecuredForUpdate | IsCustomizable | IsAuditEnabled | IsManaged | IsPrimaryId | IsPrimaryName | IsRenameable | IsSecured | IsValidForAdvancedFind | DisplayName | DeprecatedVersion | Description |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
accountid |
AccountId |
Lookup |
None |
False |
True |
False |
False |
False |
False |
True |
True |
True |
False |
False |
False |
False |
False |
Account |
Unique identifier of the account with which the contact is associated. |
|
accountrolecode |
AccountRoleCode |
Picklist |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Role |
Account role of the contact. |
|
address1_addressid |
Address1_AddressId |
Uniqueidentifier |
None |
True |
True |
True |
False |
False |
False |
False |
False |
True |
True |
False |
False |
False |
False |
Address 1: ID |
Unique identifier for address 1. |
|
address1_addresstypecode |
Address1_AddressTypeCode |
Picklist |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 1: Address Type |
Type of address for address 1, such as billing, shipping, or primary address. |
|
address1_city |
Address1_City |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 1: City |
City name for address 1. |
|
address1_country |
Address1_Country |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 1: Country/Region |
Country/region name for address 1. |
|
address1_county |
Address1_County |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 1: County |
County name for address 1. |
|
address1_fax |
Address1_Fax |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 1: Fax |
Fax number for address 1. |
|
address1_freighttermscode |
Address1_FreightTermsCode |
Picklist |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 1: Freight Terms |
Freight terms for address 1. |
|
address1_latitude |
Address1_Latitude |
Double |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 1: Latitude |
Latitude for address 1. |
|
address1_line1 |
Address1_Line1 |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 1: Street 1 |
First line for entering address 1 information. |
|
address1_line2 |
Address1_Line2 |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 1: Street 2 |
Second line for entering address 1 information. |
|
address1_line3 |
Address1_Line3 |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 1: Street 3 |
Third line for entering address 1 information. |
|
address1_longitude |
Address1_Longitude |
Double |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 1: Longitude |
Longitude for address 1. |
|
address1_name |
Address1_Name |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 1: Name |
Name to enter for address 1. |
|
address1_postalcode |
Address1_PostalCode |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 1: ZIP/Postal Code |
ZIP Code or postal code for address 1. |
|
address1_postofficebox |
Address1_PostOfficeBox |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 1: Post Office Box |
Post office box number for address 1. |
|
address1_primarycontactname |
Address1_PrimaryContactName |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 1: Primary Contact Name |
Name to enter for address 1 for the primary contact. |
|
address1_shippingmethodcode |
Address1_ShippingMethodCode |
Picklist |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 1: Shipping Method |
Method of shipment for address 1. |
|
address1_stateorprovince |
Address1_StateOrProvince |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 1: State/Province |
State or province for address 1. |
|
address1_telephone1 |
Address1_Telephone1 |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 1: Phone |
First telephone number associated with address 1. |
|
address1_telephone2 |
Address1_Telephone2 |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 1: Telephone 2 |
Second telephone number associated with address 1. |
|
address1_telephone3 |
Address1_Telephone3 |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 1: Telephone 3 |
Third telephone number associated with address 1. |
|
address1_upszone |
Address1_UPSZone |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 1: UPS Zone |
United Parcel Service (UPS) zone for address 1. |
|
address1_utcoffset |
Address1_UTCOffset |
Integer |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
False |
Address 1: UTC Offset |
UTC offset for address 1. This is the difference between local time and standard Coordinated Universal Time. |
|
address2_addressid |
Address2_AddressId |
Uniqueidentifier |
None |
True |
True |
True |
False |
False |
False |
False |
False |
True |
True |
False |
False |
False |
False |
Address 2: ID |
Unique identifier for address 2. |
|
address2_addresstypecode |
Address2_AddressTypeCode |
Picklist |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
False |
Address 2: Address Type |
Type of address for address 2, such as billing, shipping, or primary address. |
|
address2_city |
Address2_City |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 2: City |
City name for address 2. |
|
address2_country |
Address2_Country |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 2: Country/Region |
Country/region name for address 2. |
|
address2_county |
Address2_County |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 2: County |
County name for address 2. |
|
address2_fax |
Address2_Fax |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 2: Fax |
Fax number for address 2. |
|
address2_freighttermscode |
Address2_FreightTermsCode |
Picklist |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
False |
Address 2: Freight Terms |
Freight terms for address 2. |
|
address2_latitude |
Address2_Latitude |
Double |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 2: Latitude |
Latitude for address 2. |
|
address2_line1 |
Address2_Line1 |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 2: Street 1 |
First line for entering address 2 information. |
|
address2_line2 |
Address2_Line2 |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 2: Street 2 |
Second line for entering address 2 information. |
|
address2_line3 |
Address2_Line3 |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 2: Street 3 |
Third line for entering address 2 information. |
|
address2_longitude |
Address2_Longitude |
Double |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 2: Longitude |
Longitude for address 2. |
|
address2_name |
Address2_Name |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 2: Name |
Name to enter for address 2. |
|
address2_postalcode |
Address2_PostalCode |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 2: ZIP/Postal Code |
ZIP Code or postal code for address 2. |
|
address2_postofficebox |
Address2_PostOfficeBox |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 2: Post Office Box |
Post office box number for address 2. |
|
address2_primarycontactname |
Address2_PrimaryContactName |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 2: Primary Contact Name |
Name to enter for address 2 for the primary contact. |
|
address2_shippingmethodcode |
Address2_ShippingMethodCode |
Picklist |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
False |
Address 2: Shipping Method |
Method of shipment for address 2. |
|
address2_stateorprovince |
Address2_StateOrProvince |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 2: State/Province |
State or province for address 2. |
|
address2_telephone1 |
Address2_Telephone1 |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 2: Telephone 1 |
First telephone number associated with address 2. |
|
address2_telephone2 |
Address2_Telephone2 |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 2: Telephone 2 |
Second telephone number associated with address 2. |
|
address2_telephone3 |
Address2_Telephone3 |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 2: Telephone 3 |
Third telephone number associated with address 2. |
|
address2_upszone |
Address2_UPSZone |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Address 2: UPS Zone |
United Parcel Service (UPS) zone for address 2. |
|
address2_utcoffset |
Address2_UTCOffset |
Integer |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
False |
Address 2: UTC Offset |
UTC offset for address 2. This is the difference between local time and standard Coordinated Universal Time. |
|
aging30 |
Aging30 |
Money |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
False |
False |
True |
False |
True |
Aging 30 |
For internal use only. |
|
aging30_base |
Aging30_Base |
Money |
None |
False |
True |
False |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Aging 30 (Base) |
Base currency equivalent of the aging 30 for the contact. |
|
aging60 |
Aging60 |
Money |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
False |
False |
True |
False |
True |
Aging 60 |
For internal use only. |
|
aging60_base |
Aging60_Base |
Money |
None |
False |
True |
False |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Aging 60 (Base) |
Base currency equivalent of the aging 60 for the contact. |
|
aging90 |
Aging90 |
Money |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
False |
False |
True |
False |
True |
Aging 90 |
For internal use only. |
|
aging90_base |
Aging90_Base |
Money |
None |
False |
True |
False |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Aging 90 (Base) |
Base currency equivalent of the aging 90 for the contact. |
|
anniversary |
Anniversary |
DateTime |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Anniversary |
Wedding anniversary of the contact. |
|
annualincome |
AnnualIncome |
Money |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Annual Income |
Annual income of the contact. |
|
annualincome_base |
AnnualIncome_Base |
Money |
None |
False |
True |
False |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Annual Income (Base) |
Base currency equivalent of the annual income of the contact. |
|
assistantname |
AssistantName |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Assistant |
Name of the contact's assistant contact. |
|
assistantphone |
AssistantPhone |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Assistant Phone |
Phone number for the contact's assistant. |
|
birthdate |
BirthDate |
DateTime |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Birthday |
Birth date of the contact. |
|
childrensnames |
ChildrensNames |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Children's Names |
Names of the contact's children. |
|
contactid |
ContactId |
Uniqueidentifier |
SystemRequired |
True |
True |
False |
False |
False |
False |
True |
False |
True |
True |
False |
True |
False |
True |
Contact |
Unique identifier of the contact. |
|
createdby |
CreatedBy |
Lookup |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
False |
False |
True |
False |
True |
Created By |
Unique identifier of the user who created the contact. |
|
createdon |
CreatedOn |
DateTime |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
False |
False |
True |
False |
True |
Created On |
Date and time when the contact was created. |
|
createdonbehalfby |
CreatedOnBehalfBy |
Lookup |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
False |
False |
True |
False |
True |
Created By (Delegate) |
Unique identifier of the delegate user who created the contact. |
|
creditlimit |
CreditLimit |
Money |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Credit Limit |
Credit limit for the contact. |
|
creditlimit_base |
CreditLimit_Base |
Money |
None |
False |
True |
False |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Credit Limit (Base) |
Base currency equivalent of the credit limit for the contact. |
|
creditonhold |
CreditOnHold |
Boolean |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Credit Hold |
Information about whether credit for the contact is on hold. |
|
customersizecode |
CustomerSizeCode |
Picklist |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
False |
Customer Size |
Size of the contact's business. |
|
customertypecode |
CustomerTypeCode |
Picklist |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
False |
Relationship Type |
Type of business associated with the contact. |
|
defaultpricelevelid |
DefaultPriceLevelId |
Lookup |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Price List |
Unique identifier of the default price list for the contact. |
|
department |
Department |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Department |
Department in the business unit or organization associated with the contact. |
|
description |
Description |
Memo |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Description |
Description of the contact. |
|
donotbulkemail |
DoNotBulkEMail |
Boolean |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
False |
Do not allow Bulk E-mails |
Information about whether to allow sending direct e-mail to the contact. |
|
donotbulkpostalmail |
DoNotBulkPostalMail |
Boolean |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
False |
Do not allow Bulk Mails |
Information about whether to allow sending bulk-rate postal mail to the contact. |
|
donotemail |
DoNotEMail |
Boolean |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Do not allow E-mails |
Information about whether to allow sending e-mail to the contact. |
|
donotfax |
DoNotFax |
Boolean |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Do not allow Faxes |
Information about whether to allow sending fax transmittals to the contact. |
|
donotphone |
DoNotPhone |
Boolean |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Do not allow Phone Calls |
Information about whether to allow phone calls to the contact. |
|
donotpostalmail |
DoNotPostalMail |
Boolean |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Do not allow Mails |
Information about whether to allow sending postal mail to the contact. |
|
donotsendmm |
DoNotSendMM |
Boolean |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Send Marketing Materials |
Information regarding whether to allow sending marketing mail to the contact. |
|
educationcode |
EducationCode |
Picklist |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
False |
Education |
Formal education level that the contact has attained. |
|
emailaddress1 |
EMailAddress1 |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
First e-mail address for the contact. |
||
emailaddress2 |
EMailAddress2 |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
E-mail Address 2 |
Second e-mail address for the contact. |
|
emailaddress3 |
EMailAddress3 |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
E-mail Address 3 |
Third e-mail address for the contact. |
|
employeeid |
EmployeeId |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Employee |
Employee ID for the contact. |
|
exchangerate |
ExchangeRate |
Decimal |
None |
False |
True |
False |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Exchange Rate |
Exchange rate for the currency associated with the contact with respect to the base currency. |
|
externaluseridentifier |
ExternalUserIdentifier |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
False |
False |
False |
External User Identifier |
Identifier for an external user. |
|
familystatuscode |
FamilyStatusCode |
Picklist |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Marital Status |
Marital status of the contact. |
|
fax |
Fax |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Fax |
Fax number for the contact. |
|
firstname |
FirstName |
String |
Recommended |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
First Name |
First name of the contact. |
|
ftpsiteurl |
FtpSiteUrl |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
FTP Site |
FTP site URL for the contact. |
|
fullname |
FullName |
String |
None |
False |
True |
False |
False |
False |
False |
True |
True |
True |
False |
True |
True |
False |
True |
Full Name |
Full name of the contact. |
|
gendercode |
GenderCode |
Picklist |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Gender |
Gender of the contact. |
|
governmentid |
GovernmentId |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Government |
Government ID for the contact. |
|
haschildrencode |
HasChildrenCode |
Picklist |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
False |
Has Children |
Information about whether the contact has children. |
|
importsequencenumber |
ImportSequenceNumber |
Integer |
None |
True |
True |
False |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Import Sequence Number |
Unique identifier of the data import or data migration that created this record. |
|
isautocreate |
IsAutoCreate |
Boolean |
None |
False |
False |
False |
False |
False |
False |
True |
True |
True |
False |
False |
False |
False |
False |
Auto-created |
Information about whether the contact was auto-created when promoting an email or an appointment. |
|
isbackofficecustomer |
IsBackofficeCustomer |
Boolean |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
False |
Backoffice Customer |
Information about whether the contact is in an associated Microsoft Great Plains database. |
|
isprivate |
IsPrivate |
Boolean |
None |
False |
False |
False |
False |
False |
False |
False |
False |
True |
False |
False |
False |
False |
False |
|||
jobtitle |
JobTitle |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Job Title |
Job title of the contact. |
|
lastname |
LastName |
String |
ApplicationRequired |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Last Name |
Last name of the contact. |
|
lastusedincampaign |
LastUsedInCampaign |
DateTime |
None |
False |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Last Date Included in Campaign |
Date and time when the contact was last contacted as a part of a marketing campaign. |
|
leadsourcecode |
LeadSourceCode |
Picklist |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
False |
Lead Source |
Source of the lead of the contact. |
|
managername |
ManagerName |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Manager |
Name of the contact's manager. |
|
managerphone |
ManagerPhone |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Manager Phone |
Phone number for the contact's manager. |
|
masterid |
MasterId |
Lookup |
None |
False |
True |
False |
False |
False |
False |
True |
True |
True |
False |
False |
False |
False |
False |
Master ID |
Unique identifier of the master contact for merge. |
|
merged |
Merged |
Boolean |
None |
False |
True |
False |
False |
False |
False |
True |
True |
True |
False |
False |
False |
False |
False |
Merged |
Information regarding whether the account has been merged with a master contact. |
|
middlename |
MiddleName |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Middle Name |
Middle name of the contact. |
|
mobilephone |
MobilePhone |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Mobile Phone |
Mobile phone number for the contact. |
|
modifiedby |
ModifiedBy |
Lookup |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
False |
False |
True |
False |
True |
Modified By |
Unique identifier of the user who last modified the contact. |
|
modifiedon |
ModifiedOn |
DateTime |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
False |
False |
True |
False |
True |
Modified On |
Date and time when the contact was last modified. |
|
modifiedonbehalfby |
ModifiedOnBehalfBy |
Lookup |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
False |
False |
True |
False |
True |
Modified By (Delegate) |
Unique identifier of the delegate user who last modified the contact. |
|
nickname |
NickName |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Nickname |
Nickname of the contact. |
|
numberofchildren |
NumberOfChildren |
Integer |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
No. of Children |
How many children the contact has. |
|
originatingleadid |
OriginatingLeadId |
Lookup |
None |
True |
True |
False |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Originating Lead |
Unique identifier of the lead from which the contact was created. |
|
overriddencreatedon |
OverriddenCreatedOn |
DateTime |
None |
True |
True |
False |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Record Created On |
Date and time that the record was migrated. |
|
ownerid |
OwnerId |
Owner |
SystemRequired |
True |
True |
False |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Owner |
Unique identifier of the user or team who owns the contact. |
|
owningbusinessunit |
OwningBusinessUnit |
Lookup |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
False |
False |
False |
False |
False |
Owning Business Unit |
Unique identifier of the business unit that owns the contact. |
|
owningteam |
OwningTeam |
Lookup |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
False |
False |
False |
False |
False |
Owning Team |
Unique identifier of the team who owns the contact. |
|
owninguser |
OwningUser |
Lookup |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
False |
False |
False |
False |
False |
Owning User |
Unique identifier of the user who owns the contact. |
|
pager |
Pager |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Pager |
Pager number for the contact. |
|
parentcontactid |
ParentContactId |
Lookup |
None |
False |
True |
False |
False |
False |
False |
True |
True |
True |
False |
False |
False |
False |
False |
Parent Contact |
Unique identifier of the parent contact. |
|
parentcustomerid |
ParentCustomerId |
Customer |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Parent Customer |
Unique identifier of the account or contact associated with the contact. |
|
participatesinworkflow |
ParticipatesInWorkflow |
Boolean |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
False |
False |
False |
Participates in Workflow |
Information about whether the contact participates in workflow rules. |
|
paymenttermscode |
PaymentTermsCode |
Picklist |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Payment Terms |
Payment terms for the contact. |
|
preferredappointmentdaycode |
PreferredAppointmentDayCode |
Picklist |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Preferred Day |
Day of the week that the contact prefers for scheduling service activities. |
|
preferredappointmenttimecode |
PreferredAppointmentTimeCode |
Picklist |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Preferred Time |
Time of day that the contact prefers for scheduling service activities. |
|
preferredcontactmethodcode |
PreferredContactMethodCode |
Picklist |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Preferred Method of Contact |
Preferred contact method for the contact. |
|
preferredequipmentid |
PreferredEquipmentId |
Lookup |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Preferred Facility/Equipment |
Unique identifier of the facility/equipment preferred by the contact for scheduling service activities. |
|
preferredserviceid |
PreferredServiceId |
Lookup |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Preferred Service |
Unique identifier of the service preferred by the contact for scheduling service activities. |
|
preferredsystemuserid |
PreferredSystemUserId |
Lookup |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Preferred User |
Unique identifier of the system user preferred by the contact for scheduling service activities. |
|
salutation |
Salutation |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Salutation |
Salutation for correspondence with the contact. |
|
shippingmethodcode |
ShippingMethodCode |
Picklist |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
False |
Shipping Method |
Method of shipping for the contact. |
|
spousesname |
SpousesName |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Spouse/Partner Name |
Name of the contact's spouse/partner. |
|
statecode |
StateCode |
State |
SystemRequired |
False |
True |
False |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Status |
Status of the contact. |
|
statuscode |
StatusCode |
Status |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Status Reason |
Reason for the status of the contact. |
|
subscriptionid |
SubscriptionId |
Uniqueidentifier |
None |
True |
False |
False |
False |
False |
False |
False |
False |
True |
False |
False |
False |
False |
False |
Subscription |
For internal use only. |
|
suffix |
Suffix |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Suffix |
Suffix for the contact name, such as Jr., Sr., or III. |
|
telephone1 |
Telephone1 |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Business Phone |
First telephone number for the contact. |
|
telephone2 |
Telephone2 |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Home Phone |
Second telephone number for the contact. |
|
telephone3 |
Telephone3 |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Telephone 3 |
Third telephone number for the contact. |
|
territorycode |
TerritoryCode |
Picklist |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
False |
Territory |
Unique identifier of the territory to which the contact is assigned. |
|
timezoneruleversionnumber |
TimeZoneRuleVersionNumber |
Integer |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
False |
False |
False |
False |
False |
Time Zone Rule Version Number |
For internal use only. |
|
transactioncurrencyid |
TransactionCurrencyId |
Lookup |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Currency |
Unique identifier of the currency associated with the contact. |
|
utcconversiontimezonecode |
UTCConversionTimeZoneCode |
Integer |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
False |
False |
False |
False |
False |
UTC Conversion Time Zone Code |
Time zone code that was in use when the record was created. |
|
versionnumber |
VersionNumber |
BigInt |
None |
False |
True |
False |
False |
False |
False |
False |
False |
True |
False |
False |
False |
False |
False |
Version Number |
Version number of the contact. |
|
websiteurl |
WebSiteUrl |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Web Site |
Website URL for the contact. |
|
yomifirstname |
YomiFirstName |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Yomi First Name |
Hiragana or Katakana phonetic guide for the contact first name, used for Yomi sorting. |
|
yomifullname |
YomiFullName |
String |
None |
False |
True |
False |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Yomi Full Name |
Hiragana or Katakana phonetic guide for the contact full name, used for Yomi sorting. |
|
yomilastname |
YomiLastName |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Yomi Last Name |
Hiragana or Katakana phonetic guide for the contact last name, used for Yomi sorting. |
|
yomimiddlename |
YomiMiddleName |
String |
None |
True |
True |
True |
False |
False |
False |
True |
True |
True |
False |
False |
True |
False |
True |
Yomi Middle Name |
Hiragana or Katakana phonetic guide for the contact middle name, used for Yomi sorting. |
One-to-Many Relationships
The following table shows the entities that are the referencing entity in a one-to-many relationship with the contact entity.
Relationship schema name | Referencing entity |
---|---|
account_primary_contact |
account |
contact_activity_parties |
activityparty |
Contact_ActivityPointers |
activitypointer |
Contact_Annotation |
annotation |
Contact_Appointments |
appointment |
Contact_AsyncOperations |
asyncoperation |
Contact_BulkDeleteFailures |
bulkdeletefailure |
SourceContact_BulkOperationLogs |
bulkoperationlog |
CreatedContact_BulkOperationLogs |
bulkoperationlog |
contact_connections2 |
connection |
contact_connections1 |
connection |
contact_master_contact |
contact |
contact_customer_contacts |
contact |
contract_customer_contacts |
contract |
contract_billingcustomer_contacts |
contract |
contractlineitem_customer_contacts |
contractdetail |
Contact_CustomerAddress |
customeraddress |
contact_customer_opportunity_roles |
customeropportunityrole |
contact_customer_relationship_partner |
customerrelationship |
contact_customer_relationship_customer |
customerrelationship |
Contact_DuplicateBaseRecord |
duplicaterecord |
Contact_DuplicateMatchingRecord |
duplicaterecord |
Contact_Emails |
|
Contact_Faxes |
fax |
contact_as_responsible_contact |
incident |
incident_customer_contacts |
incident |
invoice_customer_contacts |
invoice |
lead_customer_contacts |
lead |
lead_parent_contact |
lead |
Contact_Letters |
letter |
opportunity_parent_contact |
opportunity |
opportunity_customer_contacts |
opportunity |
Contact_Phonecalls |
phonecall |
contact_PostFollows |
postfollow |
contact_PostRegardings |
postregarding |
contact_PostRoles |
postrole |
contact_principalobjectattributeaccess |
principalobjectattributeaccess |
Contact_ProcessSessions |
processsession |
quote_customer_contacts |
quote |
Contact_RecurringAppointmentMasters |
recurringappointmentmaster |
order_customer_contacts |
salesorder |
Contact_ServiceAppointments |
serviceappointment |
Contact_Tasks |
task |
userentityinstancedata_contact |
userentityinstancedata |
Many-to-Many Relationships
The following table shows the many-to-many relationships for the contact entity.
Relationship schema name | Entity 1 name | Entity 2 name | Intersect entity name |
---|---|---|---|
contact_subscription_association |
subscription |
contact |
subscriptionmanuallytrackedobject |
contactinvoices_association |
invoice |
contact |
contactinvoices |
contactleads_association |
contact |
lead |
contactleads |
contactorders_association |
salesorder |
contact |
contactorders |
contactquotes_association |
quote |
contact |
contactquotes |
listcontact_association |
list |
contact |
listmember |
servicecontractcontacts_association |
contact |
contract |
servicecontractcontacts |
For information about using intersect entities, see Retrieve Records for Many-To-Many Relationships Using Intersect Entities.
Many-to-One Relationships
The following table shows the entities that are the referenced entity in a many-to-one relationship with the contact entity.
Relationship schema name | Referenced entity |
---|---|
contact_customer_accounts |
account |
business_unit_contacts |
businessunit |
contact_master_contact |
contact |
contact_customer_contacts |
contact |
equipment_contacts |
equipment |
contact_originating_lead |
lead |
owner_contacts |
owner |
price_level_contacts |
pricelevel |
service_contacts |
service |
lk_contactbase_createdby |
systemuser |
lk_contact_createdonbehalfby |
systemuser |
system_user_contacts |
systemuser |
lk_contactbase_modifiedby |
systemuser |
lk_contact_modifiedonbehalfby |
systemuser |
contact_owning_user |
systemuser |
team_contacts |
team |
transactioncurrency_contact |
transactioncurrency |
See Also
Reference
EntityMetadata
AttributeMetadata
OneToManyRelationshipMetadata
ManyToManyRelationshipMetadata
Concepts
Contact Entity Messages and Methods
Contact Entity OptionSet Attribute Metadata
Contact Entity Privileges
Other Resources
Customer Entities (Account, Contact)
Microsoft Dynamics CRM 2011
Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.