Table "CRM Contact"
ID 5342
Namespace: Microsoft.Integration.D365Sales
Properties
| Name | Value |
|---|---|
| Caption | Dataverse Contact |
| Description | Person with whom a business unit has a relationship, such as customer, supplier, and colleague. |
| ExternalName | contact |
| TableType | CRM |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| ContactId | Guid | |
| DefaultPriceLevelId | Guid | |
| CustomerSizeCode | Option | |
| CustomerTypeCode | Option | |
| PreferredContactMethodCode | Option | |
| LeadSourceCode | Option | |
| OwningBusinessUnit | Guid | |
| OwningUser | Guid | |
| ShippingMethodCode | Option | |
| AccountId | Guid | |
| ParticipatesInWorkflow | Boolean | |
| IsBackofficeCustomer | Boolean | |
| Salutation | Text[100] | |
| JobTitle | Text[100] | |
| FirstName | Text[50] | |
| Department | Text[100] | |
| NickName | Text[50] | |
| MiddleName | Text[50] | |
| LastName | Text[50] | |
| Suffix | Text[10] | |
| YomiFirstName | Text[150] | |
| FullName | Text[160] | |
| YomiMiddleName | Text[150] | |
| YomiLastName | Text[150] | |
| Anniversary | Date | |
| BirthDate | Date | |
| GovernmentId | Text[50] | |
| YomiFullName | Text[250] | |
| Description | Blob | |
| EmployeeId | Text[50] | |
| GenderCode | Option | |
| AnnualIncome | Decimal | |
| HasChildrenCode | Option | |
| EducationCode | Option | |
| WebSiteUrl | Text[200] | |
| FamilyStatusCode | Option | |
| FtpSiteUrl | Text[200] | |
| EMailAddress1 | Text[100] | |
| SpousesName | Text[100] | |
| AssistantName | Text[100] | |
| EMailAddress2 | Text[100] | |
| AssistantPhone | Text[50] | |
| EMailAddress3 | Text[100] | |
| DoNotPhone | Boolean | |
| ManagerName | Text[100] | |
| ManagerPhone | Text[50] | |
| DoNotFax | Boolean | |
| DoNotEMail | Boolean | |
| DoNotPostalMail | Boolean | |
| DoNotBulkEMail | Boolean | |
| DoNotBulkPostalMail | Boolean | |
| AccountRoleCode | Option | |
| TerritoryCode | Option | |
| CreditLimit | Decimal | |
| CreatedOn | DateTime | |
| CreditOnHold | Boolean | |
| CreatedBy | Guid | |
| ModifiedOn | DateTime | |
| ModifiedBy | Guid | |
| NumberOfChildren | Integer | |
| ChildrensNames | Text[250] | |
| VersionNumber | BigInteger | |
| MobilePhone | Text[50] | |
| Pager | Text[50] | |
| Telephone1 | Text[50] | |
| Telephone2 | Text[50] | |
| Telephone3 | Text[50] | |
| Fax | Text[50] | |
| Aging30 | Decimal | |
| StateCode | Option | |
| Aging60 | Decimal | |
| StatusCode | Option | |
| Aging90 | Decimal | |
| ParentContactId | Guid | |
| ParentContactIdName | Text[160] | |
| AccountIdName | Text[160] | |
| DefaultPriceLevelIdName | Text[100] | |
| Address1_AddressId | Guid | |
| Address1_AddressTypeCode | Option | |
| Address1_Name | Text[200] | |
| Address1_PrimaryContactName | Text[100] | |
| Address1_Line1 | Text[250] | |
| Address1_Line2 | Text[250] | |
| Address1_Line3 | Text[250] | |
| Address1_City | Text[80] | |
| Address1_StateOrProvince | Text[50] | |
| Address1_County | Text[50] | |
| Address1_Country | Text[80] | |
| Address1_PostOfficeBox | Text[20] | |
| Address1_PostalCode | Text[20] | |
| Address1_UTCOffset | Integer | |
| Address1_UPSZone | Text[4] | |
| Address1_Latitude | Decimal | |
| Address1_Telephone1 | Text[50] | |
| Address1_Longitude | Decimal | |
| Address1_Telephone2 | Text[50] | |
| Address1_Telephone3 | Text[50] | |
| Address1_Fax | Text[50] | |
| Address2_AddressId | Guid | |
| Address2_AddressTypeCode | Option | |
| Address2_Name | Text[100] | |
| Address2_PrimaryContactName | Text[100] | |
| Address2_Line1 | Text[250] | |
| Address2_Line2 | Text[250] | |
| Address2_Line3 | Text[250] | |
| Address2_City | Text[80] | |
| Address2_StateOrProvince | Text[50] | |
| Address2_County | Text[50] | |
| Address2_Country | Text[80] | |
| Address2_PostOfficeBox | Text[20] | |
| Address2_PostalCode | Text[20] | |
| Address2_UTCOffset | Integer | |
| Address2_FreightTermsCode | Option | |
| Address2_UPSZone | Text[4] | |
| Address2_Latitude | Decimal | |
| Address2_Telephone1 | Text[50] | |
| Address2_Longitude | Decimal | |
| Address2_ShippingMethodCode | Option | |
| Address2_Telephone2 | Text[50] | |
| Address2_Telephone3 | Text[50] | |
| Address2_Fax | Text[50] | |
| CreatedByName | Text[200] | |
| ModifiedByName | Text[200] | |
| OwnerId | Guid | |
| OwnerIdType | Option | |
| PreferredSystemUserId | Guid | |
| MasterId | Guid | |
| PreferredAppointmentDayCode | Option | |
| PreferredAppointmentTimeCode | Option | |
| DoNotSendMM | Boolean | |
| ParentCustomerId | Guid | |
| Merged | Boolean | |
| ExternalUserIdentifier | Text[50] | |
| LastUsedInCampaign | Date | |
| MasterContactIdName | Text[160] | |
| PreferredSystemUserIdName | Text[200] | |
| ParentCustomerIdType | Option | |
| TransactionCurrencyId | Guid | |
| OverriddenCreatedOn | Date | |
| ExchangeRate | Decimal | |
| ImportSequenceNumber | Integer | |
| TimeZoneRuleVersionNumber | Integer | |
| UTCConversionTimeZoneCode | Integer | |
| AnnualIncome_Base | Decimal | |
| CreditLimit_Base | Decimal | |
| Aging60_Base | Decimal | |
| Aging90_Base | Decimal | |
| Aging30_Base | Decimal | |
| TransactionCurrencyIdName | Text[100] | |
| CreatedOnBehalfBy | Guid | |
| CreatedOnBehalfByName | Text[200] | |
| ModifiedOnBehalfBy | Guid | |
| ModifiedOnBehalfByName | Text[200] | |
| OwningTeam | Guid | |
| StageId | Guid | |
| ProcessId | Guid | |
| Address2_Composite | Blob | |
| Address1_Composite | Blob | |
| EntityImageId | Guid | |
| TraversedPath | Text[250] | |
| Address3_Country | Text[80] | |
| Address3_Line1 | Text[250] | |
| Address3_Line2 | Text[250] | |
| Address3_Line3 | Text[250] | |
| Address3_PostalCode | Text[20] | |
| Address3_PostOfficeBox | Text[20] | |
| Address3_StateOrProvince | Text[50] | |
| Address3_City | Text[80] | |
| Business2 | Text[50] | |
| Callback | Text[50] | |
| Company | Text[50] | |
| Home2 | Text[50] | |
| Address3_AddressId | Guid | |
| Address3_Composite | Blob | |
| Address3_Fax | Text[50] | |
| Address3_FreightTermsCode | Option | |
| Address3_Latitude | Decimal | |
| Address3_Longitude | Decimal | |
| Address3_Name | Text[200] | |
| Address3_PrimaryContactName | Text[100] | |
| Address3_ShippingMethodCode | Option | |
| Address3_Telephone1 | Text[50] | |
| Address3_Telephone2 | Text[50] | |
| Address3_Telephone3 | Text[50] | |
| Address3_UPSZone | Text[4] | |
| Address3_UTCOffset | Integer | |
| Address3_County | Text[50] | |
| Address3_AddressTypeCode | Option | |
| CompanyId | Guid | |
| PaymentTermsCodeEnum | Enum Microsoft.Integration.Dataverse."CDS Payment Terms Code" | |
| Address1_FreightTermsCodeEnum | Enum Microsoft.Integration.Dataverse."CDS Shipment Method Code" | |
| Address1_ShippingMethodCodeEnum | Enum Microsoft.Integration.Dataverse."CDS Shipping Agent Code" | |
| SystemId | Guid | |
| SystemRowVersion | BigInteger |