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

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

E-mail

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

email

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

Microsoft Dynamics CRM 2011
Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.

Community Additions

Show: