Contact table/entity reference (Microsoft Dataverse)

Person with whom a business unit has a relationship, such as customer, supplier, and colleague.

Messages

The following table lists the messages for the Contact table. Messages represent operations that can be performed on the table. They may also be events.

Name Is Event?	Web API Operation	SDK for .NET
`Assign` Event: True	`PATCH` /contacts(contactid) Update the `ownerid` property.	AssignRequest
`Associate` Event: True	Associate records	Associate records
`Create` Event: True	`POST` /contacts See Create	Create records
`CreateMultiple` Event: True	CreateMultiple	CreateMultipleRequest
`Delete` Event: True	`DELETE` /contacts(contactid) See Delete	Delete records
`Disassociate` Event: True	Disassociate records	Disassociate records
`GrantAccess` Event: True	GrantAccess	GrantAccessRequest
`IsValidStateTransition` Event: True	IsValidStateTransition	IsValidStateTransitionRequest
`Merge` Event: True	Merge	MergeRequest
`ModifyAccess` Event: True	ModifyAccess	ModifyAccessRequest
`Retrieve` Event: True	`GET` /contacts(contactid) See Retrieve	Retrieve records
`RetrieveMultiple` Event: True	`GET` /contacts See Query data	Query data
`RetrievePrincipalAccess` Event: True	RetrievePrincipalAccess	RetrievePrincipalAccessRequest
`RetrieveSharedPrincipalsAndAccess` Event: True	RetrieveSharedPrincipalsAndAccess	RetrieveSharedPrincipalsAndAccessRequest
`RevokeAccess` Event: True	RevokeAccess	RevokeAccessRequest
`SetState` Event: True	`PATCH` /contacts(contactid) Update the `statecode` and `statuscode` properties.	SetStateRequest
`Update` Event: True	`PATCH` /contacts(contactid) See Update	Update records
`UpdateMultiple` Event: True	UpdateMultiple	UpdateMultipleRequest
`Upsert` Event: False	`PATCH` /contacts(contactid) See Upsert a table row	UpsertRequest
`UpsertMultiple` Event: False	UpsertMultiple	UpsertMultipleRequest

Properties

The following table lists selected properties for the Contact table.

Property	Value
DisplayName	Contact
DisplayCollectionName	Contacts
SchemaName	`Contact`
CollectionSchemaName	`Contacts`
EntitySetName	`contacts`
LogicalName	`contact`
LogicalCollectionName	`contacts`
PrimaryIdAttribute	`contactid`
PrimaryNameAttribute	`fullname`
TableType	`Standard`
OwnershipType	`UserOwned`

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

AccountRoleCode
Address1_AddressId
Address1_AddressTypeCode
Address1_City
Address1_Country
Address1_County
Address1_Fax
Address1_FreightTermsCode
Address1_Latitude
Address1_Line1
Address1_Line2
Address1_Line3
Address1_Longitude
Address1_Name
Address1_PostalCode
Address1_PostOfficeBox
Address1_PrimaryContactName
Address1_ShippingMethodCode
Address1_StateOrProvince
Address1_Telephone1
Address1_Telephone2
Address1_Telephone3
Address1_UPSZone
Address1_UTCOffset
Address2_AddressId
Address2_AddressTypeCode
Address2_City
Address2_Country
Address2_County
Address2_Fax
Address2_FreightTermsCode
Address2_Latitude
Address2_Line1
Address2_Line2
Address2_Line3
Address2_Longitude
Address2_Name
Address2_PostalCode
Address2_PostOfficeBox
Address2_PrimaryContactName
Address2_ShippingMethodCode
Address2_StateOrProvince
Address2_Telephone1
Address2_Telephone2
Address2_Telephone3
Address2_UPSZone
Address2_UTCOffset
Address3_AddressId
Address3_AddressTypeCode
Address3_City
Address3_Country
Address3_County
Address3_Fax
Address3_FreightTermsCode
Address3_Latitude
Address3_Line1
Address3_Line2
Address3_Line3
Address3_Longitude
Address3_Name
Address3_PostalCode
Address3_PostOfficeBox
Address3_PrimaryContactName
Address3_ShippingMethodCode
Address3_StateOrProvince
Address3_Telephone1
Address3_Telephone2
Address3_Telephone3
Address3_UPSZone
Address3_UTCOffset
adx_ConfirmRemovePassword
Adx_CreatedByIPAddress
Adx_CreatedByUsername
adx_identity_accessfailedcount
adx_identity_emailaddress1confirmed
adx_identity_lastsuccessfullogin
adx_identity_locallogindisabled
adx_identity_lockoutenabled
adx_identity_lockoutenddate
adx_identity_logonenabled
adx_identity_mobilephoneconfirmed
adx_identity_newpassword
adx_identity_passwordhash
adx_identity_securitystamp
adx_identity_twofactorenabled
adx_identity_username
Adx_ModifiedByIPAddress
Adx_ModifiedByUsername
Adx_OrganizationName
adx_preferredlcid
adx_profilealert
adx_profilealertdate
adx_profilealertinstructions
Adx_ProfileIsAnonymous
Adx_ProfileLastActivity
adx_profilemodifiedon
adx_PublicProfileCopy
Adx_TimeZone
Anniversary
AnnualIncome
AssistantName
AssistantPhone
BirthDate
Business2
Callback
ChildrensNames
Company
ContactId
CreditLimit
CreditOnHold
CustomerSizeCode
CustomerTypeCode
Department
Description
DoNotBulkEMail
DoNotBulkPostalMail
DoNotEMail
DoNotFax
DoNotPhone
DoNotPostalMail
DoNotSendMM
EducationCode
EMailAddress1
EMailAddress2
EMailAddress3
EmployeeId
EntityImage
ExternalUserIdentifier
FamilyStatusCode
Fax
FirstName
FollowEmail
FtpSiteUrl
GenderCode
GovernmentId
HasChildrenCode
Home2
ImportSequenceNumber
IsBackofficeCustomer
JobTitle
LastName
LastOnHoldTime
LastUsedInCampaign
LeadSourceCode
ManagerName
ManagerPhone
MarketingOnly
MiddleName
MobilePhone
msa_managingpartnerid
msdyn_disablewebtracking
msdyn_isminor
msdyn_isminorwithparentalconsent
msdyn_portaltermsagreementdate
mspp_userpreferredlcid
NickName
NumberOfChildren
OverriddenCreatedOn
OwnerId
OwnerIdType
Pager
ParentCustomerId
ParentCustomerIdType
ParticipatesInWorkflow
PaymentTermsCode
PreferredAppointmentDayCode
PreferredAppointmentTimeCode
PreferredContactMethodCode
PreferredSystemUserId
ProcessId
Salutation
ShippingMethodCode
SLAId
SpousesName
StageId
StateCode
StatusCode
SubscriptionId
Suffix
Telephone1
Telephone2
Telephone3
TerritoryCode
TimeZoneRuleVersionNumber
TransactionCurrencyId
TraversedPath
UTCConversionTimeZoneCode
WebSiteUrl
YomiFirstName
YomiLastName
YomiMiddleName

AccountRoleCode

Property	Value
Description	Select the contact's role within the company or sales process, such as decision maker, employee, or influencer.
DisplayName	Role
IsValidForForm	True
IsValidForRead	True
LogicalName	`accountrolecode`
RequiredLevel	None
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`contact_accountrolecode`

AccountRoleCode Choices/Options

Value	Label
1	Decision Maker
2	Employee
3	Influencer

Address1_AddressId

Property	Value
Description	Unique identifier for address 1.
DisplayName	Address 1: ID
IsValidForForm	False
IsValidForRead	True
LogicalName	`address1_addressid`
RequiredLevel	None
Type	Uniqueidentifier

Address1_AddressTypeCode

Property	Value
Description	Select the primary address type.
DisplayName	Address 1: Address Type
IsValidForForm	True
IsValidForRead	True
LogicalName	`address1_addresstypecode`
RequiredLevel	None
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`contact_address1_addresstypecode`

Address1_AddressTypeCode Choices/Options

Value	Label
1	Bill To
2	Ship To
3	Primary
4	Other

Address1_City

Property	Value
Description	Type the city for the primary address.
DisplayName	Address 1: City
IsValidForForm	True
IsValidForRead	True
LogicalName	`address1_city`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Active
IsLocalizable	False
MaxLength	80

Address1_Country

Property	Value
Description	Type the country or region for the primary address.
DisplayName	Address 1: Country/Region
IsValidForForm	True
IsValidForRead	True
LogicalName	`address1_country`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Active
IsLocalizable	False
MaxLength	80

Address1_County

Property	Value
Description	Type the county for the primary address.
DisplayName	Address 1: County
IsValidForForm	True
IsValidForRead	True
LogicalName	`address1_county`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Active
IsLocalizable	False
MaxLength	50

Address1_Fax

Property	Value
Description	Type the fax number associated with the primary address.
DisplayName	Address 1: Fax
IsValidForForm	True
IsValidForRead	True
LogicalName	`address1_fax`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Inactive
IsLocalizable	False
MaxLength	50

Address1_FreightTermsCode

Property	Value
Description	Select the freight terms for the primary address to make sure shipping orders are processed correctly.
DisplayName	Address 1: Freight Terms
IsValidForForm	True
IsValidForRead	True
LogicalName	`address1_freighttermscode`
RequiredLevel	None
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`contact_address1_freighttermscode`

Address1_FreightTermsCode Choices/Options

Value	Label
1	FOB
2	No Charge

Address1_Latitude

Property	Value
Description	Type the latitude value for the primary address for use in mapping and other applications.
DisplayName	Address 1: Latitude
IsValidForForm	True
IsValidForRead	True
LogicalName	`address1_latitude`
RequiredLevel	None
Type	Double
ImeMode	Disabled
MaxValue	90
MinValue	-90
Precision	5

Address1_Line1

Property	Value
Description	Type the first line of the primary address.
DisplayName	Address 1: Street 1
IsValidForForm	True
IsValidForRead	True
LogicalName	`address1_line1`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Active
IsLocalizable	False
MaxLength	250

Address1_Line2

Property	Value
Description	Type the second line of the primary address.
DisplayName	Address 1: Street 2
IsValidForForm	True
IsValidForRead	True
LogicalName	`address1_line2`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Active
IsLocalizable	False
MaxLength	250

Address1_Line3

Property	Value
Description	Type the third line of the primary address.
DisplayName	Address 1: Street 3
IsValidForForm	True
IsValidForRead	True
LogicalName	`address1_line3`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Active
IsLocalizable	False
MaxLength	250

Address1_Longitude

Property	Value
Description	Type the longitude value for the primary address for use in mapping and other applications.
DisplayName	Address 1: Longitude
IsValidForForm	True
IsValidForRead	True
LogicalName	`address1_longitude`
RequiredLevel	None
Type	Double
ImeMode	Disabled
MaxValue	180
MinValue	-180
Precision	5

Address1_Name

Property	Value
Description	Type a descriptive name for the primary address, such as Corporate Headquarters.
DisplayName	Address 1: Name
IsValidForForm	True
IsValidForRead	True
LogicalName	`address1_name`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Active
IsLocalizable	False
MaxLength	200

Address1_PostalCode

Property	Value
Description	Type the ZIP Code or postal code for the primary address.
DisplayName	Address 1: ZIP/Postal Code
IsValidForForm	True
IsValidForRead	True
LogicalName	`address1_postalcode`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Inactive
IsLocalizable	False
MaxLength	20

Address1_PostOfficeBox

Property	Value
Description	Type the post office box number of the primary address.
DisplayName	Address 1: Post Office Box
IsValidForForm	True
IsValidForRead	True
LogicalName	`address1_postofficebox`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Inactive
IsLocalizable	False
MaxLength	20

Address1_PrimaryContactName

Property	Value
Description	Type the name of the main contact at the account's primary address.
DisplayName	Address 1: Primary Contact Name
IsValidForForm	True
IsValidForRead	True
LogicalName	`address1_primarycontactname`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

Address1_ShippingMethodCode

Property	Value
Description	Select a shipping method for deliveries sent to this address.
DisplayName	Address 1: Shipping Method
IsValidForForm	True
IsValidForRead	True
LogicalName	`address1_shippingmethodcode`
RequiredLevel	None
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`contact_address1_shippingmethodcode`

Address1_ShippingMethodCode Choices/Options

Value	Label
1	Airborne
2	DHL
3	FedEx
4	UPS
5	Postal Mail
6	Full Load
7	Will Call

Address1_StateOrProvince

Property	Value
Description	Type the state or province of the primary address.
DisplayName	Address 1: State/Province
IsValidForForm	True
IsValidForRead	True
LogicalName	`address1_stateorprovince`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Active
IsLocalizable	False
MaxLength	50

Address1_Telephone1

Property	Value
Description	Type the main phone number associated with the primary address.
DisplayName	Address 1: Phone
IsValidForForm	True
IsValidForRead	True
LogicalName	`address1_telephone1`
RequiredLevel	None
Type	String
Format	Text
FormatName	Phone
ImeMode	Inactive
IsLocalizable	False
MaxLength	50

Address1_Telephone2

Property	Value
Description	Type a second phone number associated with the primary address.
DisplayName	Address 1: Telephone 2
IsValidForForm	True
IsValidForRead	True
LogicalName	`address1_telephone2`
RequiredLevel	None
Type	String
Format	Text
FormatName	Phone
ImeMode	Inactive
IsLocalizable	False
MaxLength	50

Address1_Telephone3

Property	Value
Description	Type a third phone number associated with the primary address.
DisplayName	Address 1: Telephone 3
IsValidForForm	True
IsValidForRead	True
LogicalName	`address1_telephone3`
RequiredLevel	None
Type	String
Format	Text
FormatName	Phone
ImeMode	Inactive
IsLocalizable	False
MaxLength	50

Address1_UPSZone

Property	Value
Description	Type the UPS zone of the primary address to make sure shipping charges are calculated correctly and deliveries are made promptly, if shipped by UPS.
DisplayName	Address 1: UPS Zone
IsValidForForm	True
IsValidForRead	True
LogicalName	`address1_upszone`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	4

Address1_UTCOffset

Property	Value
Description	Select the time zone, or UTC offset, for this address so that other people can reference it when they contact someone at this address.
DisplayName	Address 1: UTC Offset
IsValidForForm	True
IsValidForRead	True
LogicalName	`address1_utcoffset`
RequiredLevel	None
Type	Integer
MaxValue	1500
MinValue	-1500

Address2_AddressId

Property	Value
Description	Unique identifier for address 2.
DisplayName	Address 2: ID
IsValidForForm	False
IsValidForRead	True
LogicalName	`address2_addressid`
RequiredLevel	None
Type	Uniqueidentifier

Address2_AddressTypeCode

Property	Value
Description	Select the secondary address type.
DisplayName	Address 2: Address Type
IsValidForForm	True
IsValidForRead	True
LogicalName	`address2_addresstypecode`
RequiredLevel	None
Type	Picklist
DefaultFormValue	1
GlobalChoiceName	`contact_address2_addresstypecode`

Address2_AddressTypeCode Choices/Options

Value	Label
1	Default Value

Address2_City

Property	Value
Description	Type the city for the secondary address.
DisplayName	Address 2: City
IsValidForForm	True
IsValidForRead	True
LogicalName	`address2_city`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Active
IsLocalizable	False
MaxLength	80

Address2_Country

Property	Value
Description	Type the country or region for the secondary address.
DisplayName	Address 2: Country/Region
IsValidForForm	True
IsValidForRead	True
LogicalName	`address2_country`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Active
IsLocalizable	False
MaxLength	80

Address2_County

Property	Value
Description	Type the county for the secondary address.
DisplayName	Address 2: County
IsValidForForm	True
IsValidForRead	True
LogicalName	`address2_county`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Active
IsLocalizable	False
MaxLength	50

Address2_Fax

Property	Value
Description	Type the fax number associated with the secondary address.
DisplayName	Address 2: Fax
IsValidForForm	True
IsValidForRead	True
LogicalName	`address2_fax`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Inactive
IsLocalizable	False
MaxLength	50

Address2_FreightTermsCode

Property	Value
Description	Select the freight terms for the secondary address to make sure shipping orders are processed correctly.
DisplayName	Address 2: Freight Terms
IsValidForForm	True
IsValidForRead	True
LogicalName	`address2_freighttermscode`
RequiredLevel	None
Type	Picklist
DefaultFormValue	1
GlobalChoiceName	`contact_address2_freighttermscode`

Address2_FreightTermsCode Choices/Options

Value	Label
1	Default Value

Address2_Latitude

Property	Value
Description	Type the latitude value for the secondary address for use in mapping and other applications.
DisplayName	Address 2: Latitude
IsValidForForm	True
IsValidForRead	True
LogicalName	`address2_latitude`
RequiredLevel	None
Type	Double
ImeMode	Disabled
MaxValue	90
MinValue	-90
Precision	5

Address2_Line1

Property	Value
Description	Type the first line of the secondary address.
DisplayName	Address 2: Street 1
IsValidForForm	True
IsValidForRead	True
LogicalName	`address2_line1`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Active
IsLocalizable	False
MaxLength	250

Address2_Line2

Property	Value
Description	Type the second line of the secondary address.
DisplayName	Address 2: Street 2
IsValidForForm	True
IsValidForRead	True
LogicalName	`address2_line2`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Active
IsLocalizable	False
MaxLength	250

Address2_Line3

Property	Value
Description	Type the third line of the secondary address.
DisplayName	Address 2: Street 3
IsValidForForm	True
IsValidForRead	True
LogicalName	`address2_line3`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Active
IsLocalizable	False
MaxLength	250

Address2_Longitude

Property	Value
Description	Type the longitude value for the secondary address for use in mapping and other applications.
DisplayName	Address 2: Longitude
IsValidForForm	True
IsValidForRead	True
LogicalName	`address2_longitude`
RequiredLevel	None
Type	Double
ImeMode	Disabled
MaxValue	180
MinValue	-180
Precision	5

Address2_Name

Property	Value
Description	Type a descriptive name for the secondary address, such as Corporate Headquarters.
DisplayName	Address 2: Name
IsValidForForm	True
IsValidForRead	True
LogicalName	`address2_name`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Active
IsLocalizable	False
MaxLength	100

Address2_PostalCode

Property	Value
Description	Type the ZIP Code or postal code for the secondary address.
DisplayName	Address 2: ZIP/Postal Code
IsValidForForm	True
IsValidForRead	True
LogicalName	`address2_postalcode`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Inactive
IsLocalizable	False
MaxLength	20

Address2_PostOfficeBox

Property	Value
Description	Type the post office box number of the secondary address.
DisplayName	Address 2: Post Office Box
IsValidForForm	True
IsValidForRead	True
LogicalName	`address2_postofficebox`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Inactive
IsLocalizable	False
MaxLength	20

Address2_PrimaryContactName

Property	Value
Description	Type the name of the main contact at the account's secondary address.
DisplayName	Address 2: Primary Contact Name
IsValidForForm	True
IsValidForRead	True
LogicalName	`address2_primarycontactname`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

Address2_ShippingMethodCode

Property	Value
Description	Select a shipping method for deliveries sent to this address.
DisplayName	Address 2: Shipping Method
IsValidForForm	True
IsValidForRead	True
LogicalName	`address2_shippingmethodcode`
RequiredLevel	None
Type	Picklist
DefaultFormValue	1
GlobalChoiceName	`contact_address2_shippingmethodcode`

Address2_ShippingMethodCode Choices/Options

Value	Label
1	Default Value

Address2_StateOrProvince

Property	Value
Description	Type the state or province of the secondary address.
DisplayName	Address 2: State/Province
IsValidForForm	True
IsValidForRead	True
LogicalName	`address2_stateorprovince`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Active
IsLocalizable	False
MaxLength	50

Address2_Telephone1

Property	Value
Description	Type the main phone number associated with the secondary address.
DisplayName	Address 2: Telephone 1
IsValidForForm	True
IsValidForRead	True
LogicalName	`address2_telephone1`
RequiredLevel	None
Type	String
Format	Text
FormatName	Phone
ImeMode	Inactive
IsLocalizable	False
MaxLength	50

Address2_Telephone2

Property	Value
Description	Type a second phone number associated with the secondary address.
DisplayName	Address 2: Telephone 2
IsValidForForm	True
IsValidForRead	True
LogicalName	`address2_telephone2`
RequiredLevel	None
Type	String
Format	Text
FormatName	Phone
ImeMode	Inactive
IsLocalizable	False
MaxLength	50

Address2_Telephone3

Property	Value
Description	Type a third phone number associated with the secondary address.
DisplayName	Address 2: Telephone 3
IsValidForForm	True
IsValidForRead	True
LogicalName	`address2_telephone3`
RequiredLevel	None
Type	String
Format	Text
FormatName	Phone
ImeMode	Inactive
IsLocalizable	False
MaxLength	50

Address2_UPSZone

Property	Value
Description	Type the UPS zone of the secondary address to make sure shipping charges are calculated correctly and deliveries are made promptly, if shipped by UPS.
DisplayName	Address 2: UPS Zone
IsValidForForm	True
IsValidForRead	True
LogicalName	`address2_upszone`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	4

Address2_UTCOffset

Property	Value
Description	Select the time zone, or UTC offset, for this address so that other people can reference it when they contact someone at this address.
DisplayName	Address 2: UTC Offset
IsValidForForm	True
IsValidForRead	True
LogicalName	`address2_utcoffset`
RequiredLevel	None
Type	Integer
MaxValue	1500
MinValue	-1500

Address3_AddressId

Property	Value
Description	Unique identifier for address 3.
DisplayName	Address 3: ID
IsValidForForm	False
IsValidForRead	True
LogicalName	`address3_addressid`