Contact table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Person with whom a business unit has a relationship, such as customer, supplier, and colleague.
Messages
| Message | Web API Operation | SDK Assembly |
|---|---|---|
| Assign | PATCH [org URI]/api/data/v9.0/contacts(contactid) Update ownerid property. |
AssignRequest |
| Create | POST [org URI]/api/data/v9.0/contacts See Create |
CreateRequest or Create |
| Delete | DELETE [org URI]/api/data/v9.0/contacts(contactid) See Delete |
DeleteRequest or Delete |
| GrantAccess | GrantAccess Action | GrantAccessRequest |
| Merge | Merge Action | MergeRequest |
| ModifyAccess | ModifyAccess Action | ModifyAccessRequest |
| Retrieve | GET [org URI]/api/data/v9.0/contacts(contactid) See Retrieve |
RetrieveRequest or Retrieve |
| RetrieveMultiple | GET [org URI]/api/data/v9.0/contacts See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
| RetrievePrincipalAccess | RetrievePrincipalAccess Function | RetrievePrincipalAccessRequest |
| RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccess Function | RetrieveSharedPrincipalsAndAccessRequest |
| RevokeAccess | RevokeAccess Action | RevokeAccessRequest |
| Rollup | Rollup Function | RollupRequest |
| SetState | PATCH [org URI]/api/data/v9.0/contacts(contactid) Update statecode and statuscode properties. |
SetStateRequest |
| Update | PATCH [org URI]/api/data/v9.0/contacts(contactid) See Update |
UpdateRequest or Update |
Properties
| Property | Value |
|---|---|
| CollectionSchemaName | Contacts |
| DisplayCollectionName | Contacts |
| DisplayName | Contact |
| EntitySetName | contacts |
| IsBPFEntity | False |
| LogicalCollectionName | contacts |
| LogicalName | contact |
| OwnershipType | UserOwned |
| PrimaryIdAttribute | contactid |
| PrimaryNameAttribute | fullname |
| SchemaName | Contact |
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
- 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
- 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 |
AccountRoleCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 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 |
Address1_AddressTypeCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 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 |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_city |
| MaxLength | 80 |
| RequiredLevel | None |
| Type | String |
Address1_Country
| Property | Value |
|---|---|
| Description | Type the country or region for the primary address. |
| DisplayName | Address 1: Country/Region |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_country |
| MaxLength | 80 |
| RequiredLevel | None |
| Type | String |
Address1_County
| Property | Value |
|---|---|
| Description | Type the county for the primary address. |
| DisplayName | Address 1: County |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_county |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
Address1_Fax
| Property | Value |
|---|---|
| Description | Type the fax number associated with the primary address. |
| DisplayName | Address 1: Fax |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_fax |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
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 |
Address1_FreightTermsCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 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 |
| MaxValue | 90 |
| MinValue | -90 |
| Precision | 5 |
| RequiredLevel | None |
| Type | Double |
Address1_Line1
| Property | Value |
|---|---|
| Description | Type the first line of the primary address. |
| DisplayName | Address 1: Street 1 |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_line1 |
| MaxLength | 250 |
| RequiredLevel | None |
| Type | String |
Address1_Line2
| Property | Value |
|---|---|
| Description | Type the second line of the primary address. |
| DisplayName | Address 1: Street 2 |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_line2 |
| MaxLength | 250 |
| RequiredLevel | None |
| Type | String |
Address1_Line3
| Property | Value |
|---|---|
| Description | Type the third line of the primary address. |
| DisplayName | Address 1: Street 3 |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_line3 |
| MaxLength | 250 |
| RequiredLevel | None |
| Type | String |
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 |
| MaxValue | 180 |
| MinValue | -180 |
| Precision | 5 |
| RequiredLevel | None |
| Type | Double |
Address1_Name
| Property | Value |
|---|---|
| Description | Type a descriptive name for the primary address, such as Corporate Headquarters. |
| DisplayName | Address 1: Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_name |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
Address1_PostalCode
| Property | Value |
|---|---|
| Description | Type the ZIP Code or postal code for the primary address. |
| DisplayName | Address 1: ZIP/Postal Code |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_postalcode |
| MaxLength | 20 |
| RequiredLevel | None |
| Type | String |
Address1_PostOfficeBox
| Property | Value |
|---|---|
| Description | Type the post office box number of the primary address. |
| DisplayName | Address 1: Post Office Box |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_postofficebox |
| MaxLength | 20 |
| RequiredLevel | None |
| Type | String |
Address1_PrimaryContactName
| Property | Value |
|---|---|
| Description | Type the name of the main contact at the account's primary address. |
| DisplayName | Address 1: Primary Contact Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_primarycontactname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
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 |
Address1_ShippingMethodCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 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 |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_stateorprovince |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
Address1_Telephone1
| Property | Value |
|---|---|
| Description | Type the main phone number associated with the primary address. |
| DisplayName | Address 1: Phone |
| FormatName | Phone |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_telephone1 |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
Address1_Telephone2
| Property | Value |
|---|---|
| Description | Type a second phone number associated with the primary address. |
| DisplayName | Address 1: Telephone 2 |
| FormatName | Phone |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_telephone2 |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
Address1_Telephone3
| Property | Value |
|---|---|
| Description | Type a third phone number associated with the primary address. |
| DisplayName | Address 1: Telephone 3 |
| FormatName | Phone |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_telephone3 |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
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 |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_upszone |
| MaxLength | 4 |
| RequiredLevel | None |
| Type | String |
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 |
| Format | TimeZone |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_utcoffset |
| MaxValue | 1500 |
| MinValue | -1500 |
| RequiredLevel | None |
| Type | Integer |
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 |
Address2_AddressTypeCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Default Value |
Address2_City
| Property | Value |
|---|---|
| Description | Type the city for the secondary address. |
| DisplayName | Address 2: City |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_city |
| MaxLength | 80 |
| RequiredLevel | None |
| Type | String |
Address2_Country
| Property | Value |
|---|---|
| Description | Type the country or region for the secondary address. |
| DisplayName | Address 2: Country/Region |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_country |
| MaxLength | 80 |
| RequiredLevel | None |
| Type | String |
Address2_County
| Property | Value |
|---|---|
| Description | Type the county for the secondary address. |
| DisplayName | Address 2: County |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_county |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
Address2_Fax
| Property | Value |
|---|---|
| Description | Type the fax number associated with the secondary address. |
| DisplayName | Address 2: Fax |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_fax |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
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 |
Address2_FreightTermsCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 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 |
| MaxValue | 90 |
| MinValue | -90 |
| Precision | 5 |
| RequiredLevel | None |
| Type | Double |
Address2_Line1
| Property | Value |
|---|---|
| Description | Type the first line of the secondary address. |
| DisplayName | Address 2: Street 1 |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_line1 |
| MaxLength | 250 |
| RequiredLevel | None |
| Type | String |
Address2_Line2
| Property | Value |
|---|---|
| Description | Type the second line of the secondary address. |
| DisplayName | Address 2: Street 2 |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_line2 |
| MaxLength | 250 |
| RequiredLevel | None |
| Type | String |
Address2_Line3
| Property | Value |
|---|---|
| Description | Type the third line of the secondary address. |
| DisplayName | Address 2: Street 3 |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_line3 |
| MaxLength | 250 |
| RequiredLevel | None |
| Type | String |
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 |
| MaxValue | 180 |
| MinValue | -180 |
| Precision | 5 |
| RequiredLevel | None |
| Type | Double |
Address2_Name
| Property | Value |
|---|---|
| Description | Type a descriptive name for the secondary address, such as Corporate Headquarters. |
| DisplayName | Address 2: Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_name |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
Address2_PostalCode
| Property | Value |
|---|---|
| Description | Type the ZIP Code or postal code for the secondary address. |
| DisplayName | Address 2: ZIP/Postal Code |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_postalcode |
| MaxLength | 20 |
| RequiredLevel | None |
| Type | String |
Address2_PostOfficeBox
| Property | Value |
|---|---|
| Description | Type the post office box number of the secondary address. |
| DisplayName | Address 2: Post Office Box |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_postofficebox |
| MaxLength | 20 |
| RequiredLevel | None |
| Type | String |
Address2_PrimaryContactName
| Property | Value |
|---|---|
| Description | Type the name of the main contact at the account's secondary address. |
| DisplayName | Address 2: Primary Contact Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_primarycontactname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
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 |
Address2_ShippingMethodCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Default Value |
Address2_StateOrProvince
| Property | Value |
|---|---|
| Description | Type the state or province of the secondary address. |
| DisplayName | Address 2: State/Province |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_stateorprovince |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
Address2_Telephone1
| Property | Value |
|---|---|
| Description | Type the main phone number associated with the secondary address. |
| DisplayName | Address 2: Telephone 1 |
| FormatName | Phone |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_telephone1 |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
Address2_Telephone2
| Property | Value |
|---|---|
| Description | Type a second phone number associated with the secondary address. |
| DisplayName | Address 2: Telephone 2 |
| FormatName | Phone |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_telephone2 |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
Address2_Telephone3
| Property | Value |
|---|---|
| Description | Type a third phone number associated with the secondary address. |
| DisplayName | Address 2: Telephone 3 |
| FormatName | Phone |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_telephone3 |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
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 |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_upszone |
| MaxLength | 4 |
| RequiredLevel | None |
| Type | String |
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 |
| Format | TimeZone |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_utcoffset |
| MaxValue | 1500 |
| MinValue | -1500 |
| RequiredLevel | None |
| Type | Integer |
Address3_AddressId
| Property | Value |
|---|---|
| Description | Unique identifier for address 3. |
| DisplayName | Address 3: ID |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | address3_addressid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
Address3_AddressTypeCode
| Property | Value |
|---|---|
| Description | Select the third address type. |
| DisplayName | Address 3: Address Type |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address3_addresstypecode |
| RequiredLevel | None |
| Type | Picklist |
Address3_AddressTypeCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Default Value |
Address3_City
| Property | Value |
|---|---|
| Description | Type the city for the 3rd address. |
| DisplayName | Address 3: City |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address3_city |
| MaxLength | 80 |
| RequiredLevel | None |
| Type | String |
Address3_Country
| Property | Value |
|---|---|
| Description | the country or region for the 3rd address. |
| DisplayName | Address3: Country/Region |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address3_country |
| MaxLength | 80 |
| RequiredLevel | None |
| Type | String |
Address3_County
| Property | Value |
|---|---|
| Description | Type the county for the third address. |
| DisplayName | Address 3: County |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address3_county |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
Address3_Fax
| Property | Value |
|---|---|
| Description | Type the fax number associated with the third address. |
| DisplayName | Address 3: Fax |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address3_fax |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
Address3_FreightTermsCode
| Property | Value |
|---|---|
| Description | Select the freight terms for the third address to make sure shipping orders are processed correctly. |
| DisplayName | Address 3: Freight Terms |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address3_freighttermscode |
| RequiredLevel | None |
| Type | Picklist |
Address3_FreightTermsCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Default Value |
Address3_Latitude
| Property | Value |
|---|---|
| Description | Type the latitude value for the third address for use in mapping and other applications. |
| DisplayName | Address 3: Latitude |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address3_latitude |
| MaxValue | 90 |
| MinValue | -90 |
| Precision | 5 |
| RequiredLevel | None |
| Type | Double |
Address3_Line1
| Property | Value |
|---|---|
| Description | the first line of the 3rd address. |
| DisplayName | Address3: Street 1 |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address3_line1 |
| MaxLength | 250 |
| RequiredLevel | None |
| Type | String |
Address3_Line2
| Property | Value |
|---|---|
| Description | the second line of the 3rd address. |
| DisplayName | Address3: Street 2 |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address3_line2 |
| MaxLength | 250 |
| RequiredLevel | None |
| Type | String |
Address3_Line3
| Property | Value |
|---|---|
| Description | the third line of the 3rd address. |
| DisplayName | Address3: Street 3 |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address3_line3 |
| MaxLength | 250 |
| RequiredLevel | None |
| Type | String |
Address3_Longitude
| Property | Value |
|---|---|
| Description | Type the longitude value for the third address for use in mapping and other applications. |
| DisplayName | Address 3: Longitude |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address3_longitude |
| MaxValue | 180 |
| MinValue | -180 |
| Precision | 5 |
| RequiredLevel | None |
| Type | Double |
Address3_Name
| Property | Value |
|---|---|
| Description | Type a descriptive name for the third address, such as Corporate Headquarters. |
| DisplayName | Address 3: Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address3_name |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
Address3_PostalCode
| Property | Value |
|---|---|
| Description | the ZIP Code or postal code for the 3rd address. |
| DisplayName | Address3: ZIP/Postal Code |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address3_postalcode |
| MaxLength | 20 |
| RequiredLevel | None |
| Type | String |
Address3_PostOfficeBox
| Property | Value |
|---|---|
| Description | the post office box number of the 3rd address. |
| DisplayName | Address 3: Post Office Box |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address3_postofficebox |
| MaxLength | 20 |
| RequiredLevel | None |
| Type | String |
Address3_PrimaryContactName
| Property | Value |
|---|---|
| Description | Type the name of the main contact at the account's third address. |
| DisplayName | Address 3: Primary Contact Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address3_primarycontactname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
Address3_ShippingMethodCode
| Property | Value |
|---|---|
| Description | Select a shipping method for deliveries sent to this address. |
| DisplayName | Address 3: Shipping Method |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address3_shippingmethodcode |
| RequiredLevel | None |
| Type | Picklist |
Address3_ShippingMethodCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Default Value |
Address3_StateOrProvince
| Property | Value |
|---|---|
| Description | the state or province of the third address. |
| DisplayName | Address3: State/Province |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address3_stateorprovince |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
Address3_Telephone1
| Property | Value |
|---|---|
| Description | Type the main phone number associated with the third address. |
| DisplayName | Address 3: Telephone1 |
| FormatName | Phone |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address3_telephone1 |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
Address3_Telephone2
| Property | Value |
|---|---|
| Description | Type a second phone number associated with the third address. |
| DisplayName | Address 3: Telephone2 |
| FormatName | Phone |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address3_telephone2 |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
Address3_Telephone3
| Property | Value |
|---|---|
| Description | Type a third phone number associated with the primary address. |
| DisplayName | Address 3: Telephone3 |
| FormatName | Phone |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address3_telephone3 |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
Address3_UPSZone
| Property | Value |
|---|---|
| Description | Type the UPS zone of the third address to make sure shipping charges are calculated correctly and deliveries are made promptly, if shipped by UPS. |
| DisplayName | Address 3: UPS Zone |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address3_upszone |
| MaxLength | 4 |
| RequiredLevel | None |
| Type | String |
Address3_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 3: UTC Offset |
| Format | TimeZone |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address3_utcoffset |
| MaxValue | 1500 |
| MinValue | -1500 |
| RequiredLevel | None |
| Type | Integer |
Anniversary
| Property | Value |
|---|---|
| DateTimeBehavior | DateOnly |
| Description | Enter the date of the contact's wedding or service anniversary for use in customer gift programs or other communications. |
| DisplayName | Anniversary |
| Format | DateOnly |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | anniversary |
| RequiredLevel | None |
| Type | DateTime |
AnnualIncome
| Property | Value |
|---|---|
| Description | Type the contact's annual income for use in profiling and financial analysis. |
| DisplayName | Annual Income |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | annualincome |
| MaxValue | 100000000000000 |
| MinValue | 0 |
| Precision | 2 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
AssistantName
| Property | Value |
|---|---|
| Description | Type the name of the contact's assistant. |
| DisplayName | Assistant |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | assistantname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
AssistantPhone
| Property | Value |
|---|---|
| Description | Type the phone number for the contact's assistant. |
| DisplayName | Assistant Phone |
| FormatName | Phone |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | assistantphone |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
BirthDate
| Property | Value |
|---|---|
| DateTimeBehavior | DateOnly |
| Description | Enter the contact's birthday for use in customer gift programs or other communications. |
| DisplayName | Birthday |
| Format | DateOnly |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | birthdate |
| RequiredLevel | None |
| Type | DateTime |
Business2
| Property | Value |
|---|---|
| Description | Type a second business phone number for this contact. |
| DisplayName | Business Phone 2 |
| FormatName | Phone |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | business2 |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
Callback
| Property | Value |
|---|---|
| Description | Type a callback phone number for this contact. |
| DisplayName | Callback Number |
| FormatName | Phone |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | callback |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
ChildrensNames
| Property | Value |
|---|---|
| Description | Type the names of the contact's children for reference in communications and client programs. |
| DisplayName | Children's Names |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | childrensnames |
| MaxLength | 255 |
| RequiredLevel | None |
| Type | String |
Company
| Property | Value |
|---|---|
| Description | Type the company phone of the contact. |
| DisplayName | Company Phone |
| FormatName | Phone |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | company |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
ContactId
| Property | Value |
|---|---|
| Description | Unique identifier of the contact. |
| DisplayName | Contact |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | contactid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
CreditLimit
| Property | Value |
|---|---|
| Description | Type the credit limit of the contact for reference when you address invoice and accounting issues with the customer. |
| DisplayName | Credit Limit |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | creditlimit |
| MaxValue | 100000000000000 |
| MinValue | 0 |
| Precision | 2 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
CreditOnHold
| Property | Value |
|---|---|
| Description | Select whether the contact is on a credit hold, for reference when addressing invoice and accounting issues. |
| DisplayName | Credit Hold |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | creditonhold |
| RequiredLevel | None |
| Type | Boolean |
CreditOnHold Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: 0
CustomerSizeCode
| Property | Value |
|---|---|
| Description | Select the size of the contact's company for segmentation and reporting purposes. |
| DisplayName | Customer Size |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | customersizecode |
| RequiredLevel | None |
| Type | Picklist |
CustomerSizeCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Default Value |
CustomerTypeCode
| Property | Value |
|---|---|
| Description | Select the category that best describes the relationship between the contact and your organization. |
| DisplayName | Relationship Type |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | customertypecode |
| RequiredLevel | None |
| Type | Picklist |
CustomerTypeCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Default Value |
Department
| Property | Value |
|---|---|
| Description | Type the department or business unit where the contact works in the parent company or business. |
| DisplayName | Department |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | department |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
Description
| Property | Value |
|---|---|
| Description | Type additional information to describe the contact, such as an excerpt from the company's website. |
| DisplayName | Description |
| Format | TextArea |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | description |
| MaxLength | 2000 |
| RequiredLevel | None |
| Type | Memo |
DoNotBulkEMail
| Property | Value |
|---|---|
| Description | Select whether the contact accepts bulk email sent through marketing campaigns or quick campaigns. If Do Not Allow is selected, the contact can be added to marketing lists, but will be excluded from the email. |
| DisplayName | Do not allow Bulk Emails |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | donotbulkemail |
| RequiredLevel | None |
| Type | Boolean |
DoNotBulkEMail Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Do Not Allow | |
| 0 | Allow |
DefaultValue: 0
DoNotBulkPostalMail
| Property | Value |
|---|---|
| Description | Select whether the contact accepts bulk postal mail sent through marketing campaigns or quick campaigns. If Do Not Allow is selected, the contact can be added to marketing lists, but will be excluded from the letters. |
| DisplayName | Do not allow Bulk Mails |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | donotbulkpostalmail |
| RequiredLevel | None |
| Type | Boolean |
DoNotBulkPostalMail Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: 0
DoNotEMail
| Property | Value |
|---|---|
| Description | Select whether the contact allows direct email sent from Microsoft Dynamics 365. If Do Not Allow is selected, Microsoft Dynamics 365 will not send the email. |
| DisplayName | Do not allow Emails |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | donotemail |
| RequiredLevel | None |
| Type | Boolean |
DoNotEMail Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Do Not Allow | |
| 0 | Allow |
DefaultValue: 0
DoNotFax
| Property | Value |
|---|---|
| Description | Select whether the contact allows faxes. If Do Not Allow is selected, the contact will be excluded from any fax activities distributed in marketing campaigns. |
| DisplayName | Do not allow Faxes |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | donotfax |
| RequiredLevel | None |
| Type | Boolean |
DoNotFax Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Do Not Allow | |
| 0 | Allow |
DefaultValue: 0
DoNotPhone
| Property | Value |
|---|---|
| Description | Select whether the contact accepts phone calls. If Do Not Allow is selected, the contact will be excluded from any phone call activities distributed in marketing campaigns. |
| DisplayName | Do not allow Phone Calls |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | donotphone |
| RequiredLevel | None |
| Type | Boolean |
DoNotPhone Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Do Not Allow | |
| 0 | Allow |
DefaultValue: 0
DoNotPostalMail
| Property | Value |
|---|---|
| Description | Select whether the contact allows direct mail. If Do Not Allow is selected, the contact will be excluded from letter activities distributed in marketing campaigns. |
| DisplayName | Do not allow Mails |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | donotpostalmail |
| RequiredLevel | None |
| Type | Boolean |
DoNotPostalMail Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Do Not Allow | |
| 0 | Allow |
DefaultValue: 0
DoNotSendMM
| Property | Value |
|---|---|
| Description | Select whether the contact accepts marketing materials, such as brochures or catalogs. Contacts that opt out can be excluded from marketing initiatives. |
| DisplayName | Send Marketing Materials |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | donotsendmm |
| RequiredLevel | None |
| Type | Boolean |
DoNotSendMM Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Do Not Send | |
| 0 | Send |
DefaultValue: 0
EducationCode
| Property | Value |
|---|---|
| Description | Select the contact's highest level of education for use in segmentation and analysis. |
| DisplayName | Education |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | educationcode |
| RequiredLevel | None |
| Type | Picklist |
EducationCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Default Value |
EMailAddress1
| Property | Value |
|---|---|
| Description | Type the primary email address for the contact. |
| DisplayName | |
| FormatName | |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | emailaddress1 |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
EMailAddress2
| Property | Value |
|---|---|
| Description | Type the secondary email address for the contact. |
| DisplayName | Email Address 2 |
| FormatName | |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | emailaddress2 |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
EMailAddress3
| Property | Value |
|---|---|
| Description | Type an alternate email address for the contact. |
| DisplayName | Email Address 3 |
| FormatName | |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | emailaddress3 |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
EmployeeId
| Property | Value |
|---|---|
| Description | Type the employee ID or number for the contact for reference in orders, service cases, or other communications with the contact's organization. |
| DisplayName | Employee |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | employeeid |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
EntityImage
| Property | Value |
|---|---|
| Description | Shows the default image for the record. |
| DisplayName | Entity Image |
| IsPrimaryImage | True |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | entityimage |
| MaxHeight | 144 |
| MaxWidth | 144 |
| RequiredLevel | None |
| Type | Image |
ExternalUserIdentifier
| Property | Value |
|---|---|
| Description | Identifier for an external user. |
| DisplayName | External User Identifier |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | externaluseridentifier |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
FamilyStatusCode
| Property | Value |
|---|---|
| Description | Select the marital status of the contact for reference in follow-up phone calls and other communications. |
| DisplayName | Marital Status |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | familystatuscode |
| RequiredLevel | None |
| Type | Picklist |
FamilyStatusCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Single | |
| 2 | Married | |
| 3 | Divorced | |
| 4 | Widowed |
Fax
| Property | Value |
|---|---|
| Description | Type the fax number for the contact. |
| DisplayName | Fax |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | fax |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
FirstName
| Property | Value |
|---|---|
| Description | Type the contact's first name to make sure the contact is addressed correctly in sales calls, email, and marketing campaigns. |
| DisplayName | First Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | firstname |
| MaxLength | 50 |
| RequiredLevel | Recommended |
| Type | String |
FollowEmail
| Property | Value |
|---|---|
| Description | Information about whether to allow following email activity like opens, attachment views and link clicks for emails sent to the contact. |
| DisplayName | Follow Email Activity |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | followemail |
| RequiredLevel | None |
| Type | Boolean |
FollowEmail Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Allow | |
| 0 | Do Not Allow |
DefaultValue: 1
FtpSiteUrl
| Property | Value |
|---|---|
| Description | Type the URL for the contact's FTP site to enable users to access data and share documents. |
| DisplayName | FTP Site |
| FormatName | Url |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | ftpsiteurl |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
GenderCode
| Property | Value |
|---|---|
| Description | Select the contact's gender to make sure the contact is addressed correctly in sales calls, email, and marketing campaigns. |
| DisplayName | Gender |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | gendercode |
| RequiredLevel | None |
| Type | Picklist |
GenderCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Male | |
| 2 | Female |
GovernmentId
| Property | Value |
|---|---|
| Description | Type the passport number or other government ID for the contact for use in documents or reports. |
| DisplayName | Government |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | governmentid |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
HasChildrenCode
| Property | Value |
|---|---|
| Description | Select whether the contact has any children for reference in follow-up phone calls and other communications. |
| DisplayName | Has Children |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | haschildrencode |
| RequiredLevel | None |
| Type | Picklist |
HasChildrenCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Default Value |
Home2
| Property | Value |
|---|---|
| Description | Type a second home phone number for this contact. |
| DisplayName | Home Phone 2 |
| FormatName | Phone |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | home2 |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
ImportSequenceNumber
| Property | Value |
|---|---|
| Description | Unique identifier of the data import or data migration that created this record. |
| DisplayName | Import Sequence Number |
| Format | None |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | importsequencenumber |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
| RequiredLevel | None |
| Type | Integer |
IsBackofficeCustomer
| Property | Value |
|---|---|
| Description | Select whether the contact exists in a separate accounting or other system, such as Microsoft Dynamics GP or another ERP database, for use in integration processes. |
| DisplayName | Back Office Customer |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | isbackofficecustomer |
| RequiredLevel | None |
| Type | Boolean |
IsBackofficeCustomer Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: 0
JobTitle
| Property | Value |
|---|---|
| Description | Type the job title of the contact to make sure the contact is addressed correctly in sales calls, email, and marketing campaigns. |
| DisplayName | Job Title |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | jobtitle |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
LastName
| Property | Value |
|---|---|
| Description | Type the contact's last name to make sure the contact is addressed correctly in sales calls, email, and marketing campaigns. |
| DisplayName | Last Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | lastname |
| MaxLength | 50 |
| RequiredLevel | ApplicationRequired |
| Type | String |
LastOnHoldTime
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Contains the date and time stamp of the last on hold time. |
| DisplayName | Last On Hold Time |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | lastonholdtime |
| RequiredLevel | None |
| Type | DateTime |
LastUsedInCampaign
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Shows the date when the contact was last included in a marketing campaign or quick campaign. |
| DisplayName | Last Date Included in Campaign |
| Format | DateOnly |
| IsValidForCreate | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | lastusedincampaign |
| RequiredLevel | None |
| Type | DateTime |
LeadSourceCode
| Property | Value |
|---|---|
| Description | Select the primary marketing source that directed the contact to your organization. |
| DisplayName | Lead Source |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | leadsourcecode |
| RequiredLevel | None |
| Type | Picklist |
LeadSourceCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Default Value |
ManagerName
| Property | Value |
|---|---|
| Description | Type the name of the contact's manager for use in escalating issues or other follow-up communications with the contact. |
| DisplayName | Manager |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | managername |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ManagerPhone
| Property | Value |
|---|---|
| Description | Type the phone number for the contact's manager. |
| DisplayName | Manager Phone |
| FormatName | Phone |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | managerphone |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
MarketingOnly
| Property | Value |
|---|---|
| Description | Whether is only for marketing |
| DisplayName | Marketing Only |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | marketingonly |
| RequiredLevel | None |
| Type | Boolean |
MarketingOnly Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: 0
MiddleName
| Property | Value |
|---|---|
| Description | Type the contact's middle name or initial to make sure the contact is addressed correctly. |
| DisplayName | Middle Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | middlename |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
MobilePhone
| Property | Value |
|---|---|
| Description | Type the mobile phone number for the contact. |
| DisplayName | Mobile Phone |
| FormatName | Phone |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mobilephone |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
NickName
| Property | Value |
|---|---|
| Description | Type the contact's nickname. |
| DisplayName | Nickname |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | nickname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
NumberOfChildren
| Property | Value |
|---|---|
| Description | Type the number of children the contact has for reference in follow-up phone calls and other communications. |
| DisplayName | No. of Children |
| Format | None |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | numberofchildren |
| MaxValue | 1000000000 |
| MinValue | 0 |
| RequiredLevel | None |
| Type | Integer |
OverriddenCreatedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time that the record was migrated. |
| DisplayName | Record Created On |
| Format | DateOnly |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | overriddencreatedon |
| RequiredLevel | None |
| Type | DateTime |
OwnerId
| Property | Value |
|---|---|
| Description | Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. |
| DisplayName | Owner |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | ownerid |
| RequiredLevel | SystemRequired |
| Targets | systemuser,team |
| Type | Owner |
OwnerIdType
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridtype |
| RequiredLevel | SystemRequired |
| Type | EntityName |
Pager
| Property | Value |
|---|---|
| Description | Type the pager number for the contact. |
| DisplayName | Pager |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | pager |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
ParentCustomerId
| Property | Value |
|---|---|
| Description | Select the parent account or parent contact for the contact to provide a quick link to additional details, such as financial information, activities, and opportunities. |
| DisplayName | Company Name |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | parentcustomerid |
| RequiredLevel | None |
| Targets | account,contact |
| Type | Customer |
ParentCustomerIdType
| Property | Value |
|---|---|
| Description | |
| DisplayName | Parent Customer Type |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | parentcustomeridtype |
| RequiredLevel | None |
| Type | EntityName |
ParticipatesInWorkflow
| Property | Value |
|---|---|
| Description | Shows whether the contact participates in workflow rules. |
| DisplayName | Participates in Workflow |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | participatesinworkflow |
| RequiredLevel | None |
| Type | Boolean |
ParticipatesInWorkflow Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: 0
PaymentTermsCode
| Property | Value |
|---|---|
| Description | Select the payment terms to indicate when the customer needs to pay the total amount. |
| DisplayName | Payment Terms |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | paymenttermscode |
| RequiredLevel | None |
| Type | Picklist |
PaymentTermsCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Net 30 | |
| 2 | 2% 10, Net 30 | |
| 3 | Net 45 | |
| 4 | Net 60 |
PreferredAppointmentDayCode
| Property | Value |
|---|---|
| Description | Select the preferred day of the week for service appointments. |
| DisplayName | Preferred Day |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | preferredappointmentdaycode |
| RequiredLevel | None |
| Type | Picklist |
PreferredAppointmentDayCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 0 | Sunday | |
| 1 | Monday | |
| 2 | Tuesday | |
| 3 | Wednesday | |
| 4 | Thursday | |
| 5 | Friday | |
| 6 | Saturday |
PreferredAppointmentTimeCode
| Property | Value |
|---|---|
| Description | Select the preferred time of day for service appointments. |
| DisplayName | Preferred Time |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | preferredappointmenttimecode |
| RequiredLevel | None |
| Type | Picklist |
PreferredAppointmentTimeCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Morning | |
| 2 | Afternoon | |
| 3 | Evening |
PreferredContactMethodCode
| Property | Value |
|---|---|
| Description | Select the preferred method of contact. |
| DisplayName | Preferred Method of Contact |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | preferredcontactmethodcode |
| RequiredLevel | None |
| Type | Picklist |
PreferredContactMethodCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Any | |
| 2 | ||
| 3 | Phone | |
| 4 | Fax | |
| 5 |
PreferredSystemUserId
| Property | Value |
|---|---|
| Description | Choose the regular or preferred customer service representative for reference when scheduling service activities for the contact. |
| DisplayName | Preferred User |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | preferredsystemuserid |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ProcessId
| Property | Value |
|---|---|
| Description | Shows the ID of the process. |
| DisplayName | Process |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | processid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
Salutation
| Property | Value |
|---|---|
| Description | Type the salutation of the contact to make sure the contact is addressed correctly in sales calls, email messages, and marketing campaigns. |
| DisplayName | Salutation |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | salutation |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ShippingMethodCode
| Property | Value |
|---|---|
| Description | Select a shipping method for deliveries sent to this address. |
| DisplayName | Shipping Method |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | shippingmethodcode |
| RequiredLevel | None |
| Type | Picklist |
ShippingMethodCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Default Value |
SLAId
| Property | Value |
|---|---|
| Description | Choose the service level agreement (SLA) that you want to apply to the Contact record. |
| DisplayName | SLA |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | slaid |
| RequiredLevel | None |
| Targets | sla |
| Type | Lookup |
SpousesName
| Property | Value |
|---|---|
| Description | Type the name of the contact's spouse or partner for reference during calls, events, or other communications with the contact. |
| DisplayName | Spouse/Partner Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | spousesname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
StageId
| Property | Value |
|---|---|
| Description | Shows the ID of the stage. |
| DisplayName | (Deprecated) Process Stage |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | stageid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
StateCode
| Property | Value |
|---|---|
| Description | Shows whether the contact is active or inactive. Inactive contacts are read-only and can't be edited unless they are reactivated. |
| DisplayName | Status |
| IsValidForCreate | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statecode |
| RequiredLevel | SystemRequired |
| Type | State |
StateCode Choices/Options
| Value | Label | DefaultStatus | InvariantName |
|---|---|---|---|
| 0 | Active | 1 | Active |
| 1 | Inactive | 2 | Inactive |
StatusCode
| Property | Value |
|---|---|
| Description | Select the contact's status. |
| DisplayName | Status Reason |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statuscode |
| RequiredLevel | None |
| Type | Status |
StatusCode Choices/Options
| Value | Label | State |
|---|---|---|
| 1 | Active | 0 |
| 2 | Inactive | 1 |
SubscriptionId
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Subscription |
| IsValidForForm | False |
| IsValidForRead | False |
| IsValidForUpdate | False |
| LogicalName | subscriptionid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
Suffix
| Property | Value |
|---|---|
| Description | Type the suffix used in the contact's name, such as Jr. or Sr. to make sure the contact is addressed correctly in sales calls, email, and marketing campaigns. |
| DisplayName | Suffix |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | suffix |
| MaxLength | 10 |
| RequiredLevel | None |
| Type | String |
Telephone1
| Property | Value |
|---|---|
| Description | Type the main phone number for this contact. |
| DisplayName | Business Phone |
| FormatName | Phone |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | telephone1 |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
Telephone2
| Property | Value |
|---|---|
| Description | Type a second phone number for this contact. |
| DisplayName | Home Phone |
| FormatName | Phone |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | telephone2 |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
Telephone3
| Property | Value |
|---|---|
| Description | Type a third phone number for this contact. |
| DisplayName | Telephone 3 |
| FormatName | Phone |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | telephone3 |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
TerritoryCode
| Property | Value |
|---|---|
| Description | Select a region or territory for the contact for use in segmentation and analysis. |
| DisplayName | Territory |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | territorycode |
| RequiredLevel | None |
| Type | Picklist |
TerritoryCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Default Value |
TimeZoneRuleVersionNumber
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Time Zone Rule Version Number |
| Format | None |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | timezoneruleversionnumber |
| MaxValue | 2147483647 |
| MinValue | -1 |
| RequiredLevel | None |
| Type | Integer |
TransactionCurrencyId
| Property | Value |
|---|---|
| Description | Choose the local currency for the record to make sure budgets are reported in the correct currency. |
| DisplayName | Currency |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | transactioncurrencyid |
| RequiredLevel | None |
| Targets | transactioncurrency |
| Type | Lookup |
TraversedPath
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | (Deprecated) Traversed Path |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | traversedpath |
| MaxLength | 1250 |
| RequiredLevel | None |
| Type | String |
UTCConversionTimeZoneCode
| Property | Value |
|---|---|
| Description | Time zone code that was in use when the record was created. |
| DisplayName | UTC Conversion Time Zone Code |
| Format | None |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | utcconversiontimezonecode |
| MaxValue | 2147483647 |
| MinValue | -1 |
| RequiredLevel | None |
| Type | Integer |
WebSiteUrl
| Property | Value |
|---|---|
| Description | Type the contact's professional or personal website or blog URL. |
| DisplayName | Website |
| FormatName | Url |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | websiteurl |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
YomiFirstName
| Property | Value |
|---|---|
| Description | Type the phonetic spelling of the contact's first name, if the name is specified in Japanese, to make sure the name is pronounced correctly in phone calls with the contact. |
| DisplayName | Yomi First Name |
| FormatName | PhoneticGuide |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | yomifirstname |
| MaxLength | 150 |
| RequiredLevel | None |
| Type | String |
YomiLastName
| Property | Value |
|---|---|
| Description | Type the phonetic spelling of the contact's last name, if the name is specified in Japanese, to make sure the name is pronounced correctly in phone calls with the contact. |
| DisplayName | Yomi Last Name |
| FormatName | PhoneticGuide |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | yomilastname |
| MaxLength | 150 |
| RequiredLevel | None |
| Type | String |
YomiMiddleName
| Property | Value |
|---|---|
| Description | Type the phonetic spelling of the contact's middle name, if the name is specified in Japanese, to make sure the name is pronounced correctly in phone calls with the contact. |
| DisplayName | Yomi Middle Name |
| FormatName | PhoneticGuide |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | yomimiddlename |
| MaxLength | 150 |
| RequiredLevel | None |
| Type | String |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
- AccountId
- AccountIdName
- AccountIdYomiName
- Address1_Composite
- Address2_Composite
- Address3_Composite
- Aging30
- Aging30_Base
- Aging60
- Aging60_Base
- Aging90
- Aging90_Base
- AnnualIncome_Base
- CreatedBy
- CreatedByExternalParty
- CreatedByExternalPartyName
- CreatedByExternalPartyYomiName
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- CreditLimit_Base
- EntityImage_Timestamp
- EntityImage_URL
- EntityImageId
- ExchangeRate
- FullName
- IsAutoCreate
- IsPrivate
- MasterContactIdName
- MasterContactIdYomiName
- MasterId
- Merged
- ModifiedBy
- ModifiedByExternalParty
- ModifiedByExternalPartyName
- ModifiedByExternalPartyYomiName
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OnHoldTime
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningBusinessUnitName
- OwningTeam
- OwningUser
- ParentContactId
- ParentContactIdName
- ParentContactIdYomiName
- ParentCustomerIdName
- ParentCustomerIdYomiName
- PreferredSystemUserIdName
- PreferredSystemUserIdYomiName
- SLAInvokedId
- SLAInvokedIdName
- SLAName
- TimeSpentByMeOnEmailAndMeetings
- TransactionCurrencyIdName
- VersionNumber
- YomiFullName
AccountId
| Property | Value |
|---|---|
| Description | Unique identifier of the account with which the contact is associated. |
| DisplayName | Account |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | accountid |
| RequiredLevel | None |
| Targets | account |
| Type | Lookup |
AccountIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | accountidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
AccountIdYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | accountidyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
Address1_Composite
| Property | Value |
|---|---|
| Description | Shows the complete primary address. |
| DisplayName | Address 1 |
| Format | TextArea |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address1_composite |
| MaxLength | 1000 |
| RequiredLevel | None |
| Type | Memo |
Address2_Composite
| Property | Value |
|---|---|
| Description | Shows the complete secondary address. |
| DisplayName | Address 2 |
| Format | TextArea |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address2_composite |
| MaxLength | 1000 |
| RequiredLevel | None |
| Type | Memo |
Address3_Composite
| Property | Value |
|---|---|
| Description | Shows the complete third address. |
| DisplayName | Address 3 |
| Format | TextArea |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | address3_composite |
| MaxLength | 1000 |
| RequiredLevel | None |
| Type | Memo |
Aging30
| Property | Value |
|---|---|
| Description | For system use only. |
| DisplayName | Aging 30 |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | aging30 |
| MaxValue | 100000000000000 |
| MinValue | 0 |
| Precision | 2 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
Aging30_Base
| Property | Value |
|---|---|
| Description | Shows the Aging 30 field converted to the system's default base currency. The calculations use the exchange rate specified in the Currencies area. |
| DisplayName | Aging 30 (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | aging30_base |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
Aging60
| Property | Value |
|---|---|
| Description | For system use only. |
| DisplayName | Aging 60 |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | aging60 |
| MaxValue | 100000000000000 |
| MinValue | 0 |
| Precision | 2 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
Aging60_Base
| Property | Value |
|---|---|
| Description | Shows the Aging 60 field converted to the system's default base currency. The calculations use the exchange rate specified in the Currencies area. |
| DisplayName | Aging 60 (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | aging60_base |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
Aging90
| Property | Value |
|---|---|
| Description | For system use only. |
| DisplayName | Aging 90 |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | aging90 |
| MaxValue | 100000000000000 |
| MinValue | 0 |
| Precision | 2 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
Aging90_Base
| Property | Value |
|---|---|
| Description | Shows the Aging 90 field converted to the system's default base currency. The calculations use the exchange rate specified in the Currencies area. |
| DisplayName | Aging 90 (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | aging90_base |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
AnnualIncome_Base
| Property | Value |
|---|---|
| Description | Shows the Annual Income field converted to the system's default base currency. The calculations use the exchange rate specified in the Currencies area. |
| DisplayName | Annual Income (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | annualincome_base |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
CreatedBy
| Property | Value |
|---|---|
| Description | Shows who created the record. |
| DisplayName | Created By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
CreatedByExternalParty
| Property | Value |
|---|---|
| Description | Shows the external party who created the record. |
| DisplayName | Created By (External Party) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdbyexternalparty |
| RequiredLevel | None |
| Targets | externalparty |
| Type | Lookup |
CreatedByExternalPartyName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyexternalpartyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedByExternalPartyYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyexternalpartyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. |
| DisplayName | Created On |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdon |
| RequiredLevel | None |
| Type | DateTime |
CreatedOnBehalfBy
| Property | Value |
|---|---|
| Description | Shows who created the record on behalf of another user. |
| DisplayName | Created By (Delegate) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdonbehalfby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
CreatedOnBehalfByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOnBehalfByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreditLimit_Base
| Property | Value |
|---|---|
| Description | Shows the Credit Limit field converted to the system's default base currency for reporting purposes. The calculations use the exchange rate specified in the Currencies area. |
| DisplayName | Credit Limit (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | creditlimit_base |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
EntityImage_Timestamp
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | entityimage_timestamp |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
| RequiredLevel | None |
| Type | BigInt |
EntityImage_URL
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Url |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | entityimage_url |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
EntityImageId
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Entity Image Id |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | entityimageid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
ExchangeRate
| Property | Value |
|---|---|
| Description | Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency. |
| DisplayName | Exchange Rate |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | exchangerate |
| MaxValue | 100000000000 |
| MinValue | 0.000000000001 |
| Precision | 12 |
| RequiredLevel | None |
| Type | Decimal |
FullName
| Property | Value |
|---|---|
| Description | Combines and shows the contact's first and last names so that the full name can be displayed in views and reports. |
| DisplayName | Full Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | fullname |
| MaxLength | 160 |
| RequiredLevel | None |
| Type | String |
IsAutoCreate
| Property | Value |
|---|---|
| Description | Information about whether the contact was auto-created when promoting an email or an appointment. |
| DisplayName | Auto-created |
| IsValidForForm | False |
| IsValidForRead | False |
| LogicalName | isautocreate |
| RequiredLevel | None |
| Type | Boolean |
IsAutoCreate Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: 0
IsPrivate
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | False |
| LogicalName | isprivate |
| RequiredLevel | None |
| Type | Boolean |
IsPrivate Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: 0
MasterContactIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | mastercontactidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
MasterContactIdYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | mastercontactidyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
MasterId
| Property | Value |
|---|---|
| Description | Unique identifier of the master contact for merge. |
| DisplayName | Master ID |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | masterid |
| RequiredLevel | None |
| Targets | contact |
| Type | Lookup |
Merged
| Property | Value |
|---|---|
| Description | Shows whether the account has been merged with a master contact. |
| DisplayName | Merged |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | merged |
| RequiredLevel | None |
| Type | Boolean |
Merged Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: 0
ModifiedBy
| Property | Value |
|---|---|
| Description | Shows who last updated the record. |
| DisplayName | Modified By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ModifiedByExternalParty
| Property | Value |
|---|---|
| Description | Shows the external party who modified the record. |
| DisplayName | Modified By (External Party) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedbyexternalparty |
| RequiredLevel | None |
| Targets | externalparty |
| Type | Lookup |
ModifiedByExternalPartyName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyexternalpartyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedByExternalPartyYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyexternalpartyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. |
| DisplayName | Modified On |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedon |
| RequiredLevel | None |
| Type | DateTime |
ModifiedOnBehalfBy
| Property | Value |
|---|---|
| Description | Shows who last updated the record on behalf of another user. |
| DisplayName | Modified By (Delegate) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ModifiedOnBehalfByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOnBehalfByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
OnHoldTime
| Property | Value |
|---|---|
| Description | Shows how long, in minutes, that the record was on hold. |
| DisplayName | On Hold Time (Minutes) |
| Format | None |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | onholdtime |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
| RequiredLevel | None |
| Type | Integer |
OwnerIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridname |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OwnerIdYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridyominame |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OwningBusinessUnit
| Property | Value |
|---|---|
| Description | Unique identifier of the business unit that owns the contact. |
| DisplayName | Owning Business Unit |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | owningbusinessunit |
| RequiredLevel | None |
| Targets | businessunit |
| Type | Lookup |
OwningBusinessUnitName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningbusinessunitname |
| MaxLength | 160 |
| RequiredLevel | None |
| Type | String |
OwningTeam
| Property | Value |
|---|---|
| Description | Unique identifier of the team who owns the contact. |
| DisplayName | Owning Team |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningteam |
| RequiredLevel | None |
| Targets | team |
| Type | Lookup |
OwningUser
| Property | Value |
|---|---|
| Description | Unique identifier of the user who owns the contact. |
| DisplayName | Owning User |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owninguser |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ParentContactId
| Property | Value |
|---|---|
| Description | Unique identifier of the parent contact. |
| DisplayName | Parent Contact |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | parentcontactid |
| RequiredLevel | None |
| Targets | contact |
| Type | Lookup |
ParentContactIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | parentcontactidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ParentContactIdYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | parentcontactidyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ParentCustomerIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | parentcustomeridname |
| MaxLength | 160 |
| RequiredLevel | ApplicationRequired |
| Type | String |
ParentCustomerIdYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | parentcustomeridyominame |
| MaxLength | 450 |
| RequiredLevel | ApplicationRequired |
| Type | String |
PreferredSystemUserIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | preferredsystemuseridname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
PreferredSystemUserIdYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | preferredsystemuseridyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
SLAInvokedId
| Property | Value |
|---|---|
| Description | Last SLA that was applied to this case. This field is for internal use only. |
| DisplayName | Last SLA applied |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | slainvokedid |
| RequiredLevel | None |
| Targets | sla |
| Type | Lookup |
SLAInvokedIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | slainvokedidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
SLAName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | slaname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
TimeSpentByMeOnEmailAndMeetings
| Property | Value |
|---|---|
| Description | Total time spent for emails (read and write) and meetings by me in relation to the contact record. |
| DisplayName | Time Spent by me |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | timespentbymeonemailandmeetings |
| MaxLength | 1250 |
| RequiredLevel | None |
| Type | String |
TransactionCurrencyIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | transactioncurrencyidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
VersionNumber
| Property | Value |
|---|---|
| Description | Version number of the contact. |
| DisplayName | Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
| RequiredLevel | None |
| Type | BigInt |
YomiFullName
| Property | Value |
|---|---|
| Description | Shows the combined Yomi first and last names of the contact so that the full phonetic name can be displayed in views and reports. |
| DisplayName | Yomi Full Name |
| FormatName | PhoneticGuide |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | yomifullname |
| MaxLength | 450 |
| RequiredLevel | None |
| Type | String |
One-To-Many Relationships
Listed by SchemaName.
- contact_principalobjectattributeaccess
- slakpiinstance_contact
- socialactivity_postauthoraccount_contacts
- Contact_Email_EmailSender
- Contact_Tasks
- contact_PostFollows
- Contact_RecurringAppointmentMasters
- contact_master_contact
- lk_contact_feedback_createdby
- contact_actioncard
- contact_connections2
- Contact_BulkDeleteFailures
- contact_activity_parties
- Contact_DuplicateBaseRecord
- Contact_Annotation
- Contact_SocialActivities
- Contact_ActivityPointers
- Contact_MailboxTrackingFolder
- account_primary_contact
- Socialprofile_customer_contacts
- socialactivity_postauthor_contacts
- lk_contact_feedback_createdonbehalfby
- Contact_Emails
- Contact_Appointments
- Contact_Feedback
- Contact_ProcessSessions
- Contact_AsyncOperations
- contact_connections1
- Contact_CustomerAddress
- Contact_Phonecalls
- contact_customer_contacts
- Contact_SyncErrors
- Contact_DuplicateMatchingRecord
- Contact_Faxes
- Contact_Letters
- contact_chats
contact_principalobjectattributeaccess
Same as the contact_principalobjectattributeaccess many-to-one relationship for the principalobjectattributeaccess table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | principalobjectattributeaccess |
| ReferencingAttribute | objectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | contact_principalobjectattributeaccess |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
slakpiinstance_contact
Same as the slakpiinstance_contact many-to-one relationship for the slakpiinstance table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | slakpiinstance |
| ReferencingAttribute | regarding |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | slakpiinstance_contact |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
socialactivity_postauthoraccount_contacts
Same as the socialactivity_postauthoraccount_contacts many-to-one relationship for the socialactivity table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | socialactivity |
| ReferencingAttribute | postauthoraccount |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | socialactivity_postauthoraccount_contacts |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Contact_Email_EmailSender
Same as the Contact_Email_EmailSender many-to-one relationship for the email table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | |
| ReferencingAttribute | emailsender |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | Contact_Email_EmailSender |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Contact_Tasks
Same as the Contact_Tasks many-to-one relationship for the task table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | task |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | Contact_Tasks |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
contact_PostFollows
Same as the contact_PostFollows many-to-one relationship for the postfollow table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | postfollow |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | contact_PostFollows |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Contact_RecurringAppointmentMasters
Same as the Contact_RecurringAppointmentMasters many-to-one relationship for the recurringappointmentmaster table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | recurringappointmentmaster |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | Contact_RecurringAppointmentMasters |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
contact_master_contact
Same as the contact_master_contact many-to-one relationship for the contact table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | contact |
| ReferencingAttribute | masterid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | contact_master_contact |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
lk_contact_feedback_createdby
Same as the lk_contact_feedback_createdby many-to-one relationship for the feedback table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | feedback |
| ReferencingAttribute | createdbycontact |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | lk_contact_feedback_createdby |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
contact_actioncard
Same as the contact_actioncard many-to-one relationship for the actioncard table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | actioncard |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | contact_actioncard |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
contact_connections2
Same as the contact_connections2 many-to-one relationship for the connection table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | connection |
| ReferencingAttribute | record2id |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | contact_connections2 |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: 100 |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: Cascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Contact_BulkDeleteFailures
Same as the Contact_BulkDeleteFailures many-to-one relationship for the bulkdeletefailure table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | bulkdeletefailure |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | Contact_BulkDeleteFailures |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
contact_activity_parties
Same as the contact_activity_parties many-to-one relationship for the activityparty table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | activityparty |
| ReferencingAttribute | partyid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | contact_activity_parties |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Contact_DuplicateBaseRecord
Same as the Contact_DuplicateBaseRecord many-to-one relationship for the duplicaterecord table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | duplicaterecord |
| ReferencingAttribute | baserecordid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | Contact_DuplicateBaseRecord |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Contact_Annotation
Same as the Contact_Annotation many-to-one relationship for the annotation table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | annotation |
| ReferencingAttribute | objectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | Contact_Annotation |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
Contact_SocialActivities
Same as the Contact_SocialActivities many-to-one relationship for the socialactivity table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | socialactivity |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | Contact_SocialActivities |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
Contact_ActivityPointers
Same as the Contact_ActivityPointers many-to-one relationship for the activitypointer table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | activitypointer |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | Contact_ActivityPointers |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 20 |
| CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Contact_MailboxTrackingFolder
Same as the Contact_MailboxTrackingFolder many-to-one relationship for the mailboxtrackingfolder table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | mailboxtrackingfolder |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | Contact_MailboxTrackingFolder |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
account_primary_contact
Same as the account_primary_contact many-to-one relationship for the account table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | account |
| ReferencingAttribute | primarycontactid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | account_primary_contact |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: Cascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Socialprofile_customer_contacts
Same as the Socialprofile_customer_contacts many-to-one relationship for the socialprofile table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | socialprofile |
| ReferencingAttribute | customerid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | Socialprofile_customer_contacts |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 40 |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
socialactivity_postauthor_contacts
Same as the socialactivity_postauthor_contacts many-to-one relationship for the socialactivity table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | socialactivity |
| ReferencingAttribute | postauthor |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | socialactivity_postauthor_contacts |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
lk_contact_feedback_createdonbehalfby
Same as the lk_contact_feedback_createdonbehalfby many-to-one relationship for the feedback table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | feedback |
| ReferencingAttribute | createdonbehalfbycontact |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | lk_contact_feedback_createdonbehalfby |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Contact_Emails
Same as the Contact_Emails many-to-one relationship for the email table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | Contact_Emails |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
Contact_Appointments
Same as the Contact_Appointments many-to-one relationship for the appointment table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | appointment |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | Contact_Appointments |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
Contact_Feedback
Same as the Contact_Feedback many-to-one relationship for the feedback table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | feedback |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | Contact_Feedback |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 150 |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Contact_ProcessSessions
Same as the Contact_ProcessSessions many-to-one relationship for the processsession table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | processsession |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | Contact_ProcessSessions |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 110 |
| CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Contact_AsyncOperations
Same as the Contact_AsyncOperations many-to-one relationship for the asyncoperation table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | asyncoperation |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | Contact_AsyncOperations |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
contact_connections1
Same as the contact_connections1 many-to-one relationship for the connection table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | connection |
| ReferencingAttribute | record1id |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | contact_connections1 |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 100 |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: Cascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Contact_CustomerAddress
Same as the Contact_CustomerAddress many-to-one relationship for the customeraddress table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | customeraddress |
| ReferencingAttribute | parentid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | Contact_CustomerAddress |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 10 |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: Cascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Contact_Phonecalls
Same as the Contact_Phonecalls many-to-one relationship for the phonecall table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | phonecall |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | Contact_Phonecalls |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
contact_customer_contacts
Same as the contact_customer_contacts many-to-one relationship for the contact table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | contact |
| ReferencingAttribute | parentcustomerid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | contact_customer_contacts |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 40 |
| CascadeConfiguration | Assign: Cascade Delete: RemoveLink Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
Contact_SyncErrors
Same as the Contact_SyncErrors many-to-one relationship for the syncerror table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | syncerror |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | Contact_SyncErrors |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
Contact_DuplicateMatchingRecord
Same as the Contact_DuplicateMatchingRecord many-to-one relationship for the duplicaterecord table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | duplicaterecord |
| ReferencingAttribute | duplicaterecordid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | Contact_DuplicateMatchingRecord |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Contact_Faxes
Same as the Contact_Faxes many-to-one relationship for the fax table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | fax |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | Contact_Faxes |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
Contact_Letters
Same as the Contact_Letters many-to-one relationship for the letter table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | letter |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | Contact_Letters |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
contact_chats
Added by: Activities Patch Solution
Same as the contact_chats many-to-one relationship for the chat table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | chat |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | contact_chats |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
Many-To-One Relationships
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.
- transactioncurrency_contact
- contact_master_contact
- lk_contactbase_createdby
- lk_contact_createdonbehalfby
- team_contacts
- manualsla_contact
- system_user_contacts
- lk_contactbase_modifiedby
- sla_contact
- contact_customer_accounts
- lk_contact_modifiedonbehalfby
- processstage_contact
- contact_owning_user
- contact_customer_contacts
- business_unit_contacts
transactioncurrency_contact
See the transactioncurrency_contact one-to-many relationship for the transactioncurrency table/entity.
contact_master_contact
See the contact_master_contact one-to-many relationship for the contact table/entity.
lk_contactbase_createdby
See the lk_contactbase_createdby one-to-many relationship for the systemuser table/entity.
lk_contact_createdonbehalfby
See the lk_contact_createdonbehalfby one-to-many relationship for the systemuser table/entity.
team_contacts
See the team_contacts one-to-many relationship for the team table/entity.
manualsla_contact
See the manualsla_contact one-to-many relationship for the sla table/entity.
system_user_contacts
See the system_user_contacts one-to-many relationship for the systemuser table/entity.
lk_contactbase_modifiedby
See the lk_contactbase_modifiedby one-to-many relationship for the systemuser table/entity.
sla_contact
See the sla_contact one-to-many relationship for the sla table/entity.
contact_customer_accounts
See the contact_customer_accounts one-to-many relationship for the account table/entity.
lk_contact_modifiedonbehalfby
See the lk_contact_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.
processstage_contact
See the processstage_contact one-to-many relationship for the processstage table/entity.
contact_owning_user
See the contact_owning_user one-to-many relationship for the systemuser table/entity.
contact_customer_contacts
See the contact_customer_contacts one-to-many relationship for the contact table/entity.
business_unit_contacts
See the business_unit_contacts one-to-many relationship for the businessunit table/entity.
See also
Dataverse table/entity reference
Web API Reference
contact EntityType
Feedback
Submit and view feedback for