Table 5342 CRM Contact

Base Application, Microsoft.Integration.D365Sales

192 fields

IdNameTypeVersions
1ContactIdGuid17-29
2DefaultPriceLevelIdGuid17-29
3CustomerSizeCodeOption17-29
4CustomerTypeCodeOption17-29
5PreferredContactMethodCodeOption17-29
6LeadSourceCodeOption17-29
7OwningBusinessUnitGuid17-29
8OwningUserGuid17-29
10ShippingMethodCodeOption17-29
11AccountIdGuid17-29
12ParticipatesInWorkflowBoolean17-29
13IsBackofficeCustomerBoolean17-29
14SalutationText[100]17-29
15JobTitleText[100]17-29
16FirstNameText[50]17-29
17DepartmentText[100]17-29
18NickNameText[50]17-29
19MiddleNameText[50]17-29
20LastNameText[50]17-29
21SuffixText[10]17-29
22YomiFirstNameText[150]17-29
23FullNameText[160]17-29
24YomiMiddleNameText[150]17-29
25YomiLastNameText[150]17-29
26AnniversaryDate17-29
27BirthDateDate17-29
28GovernmentIdText[50]17-29
29YomiFullNameText[250]17-29
30DescriptionBlob17-29
31EmployeeIdText[50]17-29
32GenderCodeOption17-29
33AnnualIncomeDecimal17-29
34HasChildrenCodeOption17-29
35EducationCodeOption17-29
36WebSiteUrlText[200]17-29
37FamilyStatusCodeOption17-29
38FtpSiteUrlText[200]17-29
39EMailAddress1Text[100]17-29
40SpousesNameText[100]17-29
41AssistantNameText[100]17-29
42EMailAddress2Text[100]17-29
43AssistantPhoneText[50]17-29
44EMailAddress3Text[100]17-29
45DoNotPhoneBoolean17-29
46ManagerNameText[100]17-29
47ManagerPhoneText[50]17-29
48DoNotFaxBoolean17-29
49DoNotEMailBoolean17-29
50DoNotPostalMailBoolean17-29
51DoNotBulkEMailBoolean17-29
52DoNotBulkPostalMailBoolean17-29
53AccountRoleCodeOption17-29
54TerritoryCodeOption17-29
55CreditLimitDecimal17-29
56CreatedOnDateTime17-29
57CreditOnHoldBoolean17-29
58CreatedByGuid17-29
59ModifiedOnDateTime17-29
60ModifiedByGuid17-29
61NumberOfChildrenInteger17-29
62ChildrensNamesText[250]17-29
63VersionNumberBigInteger17-29
64MobilePhoneText[50]17-29
65PagerText[50]17-29
66Telephone1Text[50]17-29
67Telephone2Text[50]17-29
68Telephone3Text[50]17-29
69FaxText[50]17-29
70Aging30Decimal17-29
71StateCodeOption17-29
72Aging60Decimal17-29
73StatusCodeOption17-29
74Aging90Decimal17-29
75ParentContactIdGuid17-29
76ParentContactIdNameText[160]17-29
77AccountIdNameText[160]17-29
78DefaultPriceLevelIdNameText[100]17-29
79Address1_AddressIdGuid17-29
80Address1_AddressTypeCodeOption17-29
81Address1_NameText[200]17-29
82Address1_PrimaryContactNameText[100]17-29
83Address1_Line1Text[250]17-29
84Address1_Line2Text[250]17-29
85Address1_Line3Text[250]17-29
86Address1_CityText[80]17-29
87Address1_StateOrProvinceText[50]17-29
88Address1_CountyText[50]17-29
89Address1_CountryText[80]17-29
90Address1_PostOfficeBoxText[20]17-29
91Address1_PostalCodeText[20]17-29
92Address1_UTCOffsetInteger17-29
94Address1_UPSZoneText[4]17-29
95Address1_LatitudeDecimal17-29
96Address1_Telephone1Text[50]17-29
97Address1_LongitudeDecimal17-29
99Address1_Telephone2Text[50]17-29
100Address1_Telephone3Text[50]17-29
101Address1_FaxText[50]17-29
102Address2_AddressIdGuid17-29
103Address2_AddressTypeCodeOption17-29
104Address2_NameText[100]17-29
105Address2_PrimaryContactNameText[100]17-29
106Address2_Line1Text[250]17-29
107Address2_Line2Text[250]17-29
108Address2_Line3Text[250]17-29
109Address2_CityText[80]17-29
110Address2_StateOrProvinceText[50]17-29
111Address2_CountyText[50]17-29
112Address2_CountryText[80]17-29
113Address2_PostOfficeBoxText[20]17-29
114Address2_PostalCodeText[20]17-29
115Address2_UTCOffsetInteger17-29
116Address2_FreightTermsCodeOption17-29
117Address2_UPSZoneText[4]17-29
118Address2_LatitudeDecimal17-29
119Address2_Telephone1Text[50]17-29
120Address2_LongitudeDecimal17-29
121Address2_ShippingMethodCodeOption17-29
122Address2_Telephone2Text[50]17-29
123Address2_Telephone3Text[50]17-29
124Address2_FaxText[50]17-29
125CreatedByNameText[200]17-29
126ModifiedByNameText[200]17-29
127OwnerIdGuid17-29
128OwnerIdTypeOption17-29
129PreferredSystemUserIdGuid17-29
130MasterIdGuid17-29
131PreferredAppointmentDayCodeOption17-29
132PreferredAppointmentTimeCodeOption17-29
133DoNotSendMMBoolean17-29
134ParentCustomerIdGuid17-29
135MergedBoolean17-29
136ExternalUserIdentifierText[50]17-29
137LastUsedInCampaignDate17-29
138MasterContactIdNameText[160]17-29
139PreferredSystemUserIdNameText[200]17-29
140ParentCustomerIdTypeOption17-29
141TransactionCurrencyIdGuid17-29
142OverriddenCreatedOnDate17-29
143ExchangeRateDecimal17-29
144ImportSequenceNumberInteger17-29
145TimeZoneRuleVersionNumberInteger17-29
146UTCConversionTimeZoneCodeInteger17-29
147AnnualIncome_BaseDecimal17-29
148CreditLimit_BaseDecimal17-29
149Aging60_BaseDecimal17-29
150Aging90_BaseDecimal17-29
151Aging30_BaseDecimal17-29
152TransactionCurrencyIdNameText[100]17-29
153CreatedOnBehalfByGuid17-29
154CreatedOnBehalfByNameText[200]17-29
155ModifiedOnBehalfByGuid17-29
156ModifiedOnBehalfByNameText[200]17-29
157OwningTeamGuid17-29
158StageIdGuid17-29
159ProcessIdGuid17-29
160Address2_CompositeBlob17-29
161Address1_CompositeBlob17-29
162EntityImageIdGuid17-29
163TraversedPathText[250]17-29
164Address3_CountryText[80]17-29
165Address3_Line1Text[250]17-29
166Address3_Line2Text[250]17-29
167Address3_Line3Text[250]17-29
168Address3_PostalCodeText[20]17-29
169Address3_PostOfficeBoxText[20]17-29
170Address3_StateOrProvinceText[50]17-29
171Address3_CityText[80]17-29
172Business2Text[50]17-29
173CallbackText[50]17-29
174CompanyText[50]17-29
175Home2Text[50]17-29
176Address3_AddressIdGuid17-29
177Address3_CompositeBlob17-29
178Address3_FaxText[50]17-29
179Address3_FreightTermsCodeOption17-29
180Address3_LatitudeDecimal17-29
181Address3_LongitudeDecimal17-29
182Address3_NameText[200]17-29
183Address3_PrimaryContactNameText[100]17-29
184Address3_ShippingMethodCodeOption17-29
185Address3_Telephone1Text[50]17-29
186Address3_Telephone2Text[50]17-29
187Address3_Telephone3Text[50]17-29
188Address3_UPSZoneText[4]17-29
189Address3_UTCOffsetInteger17-29
190Address3_CountyText[50]17-29
191Address3_AddressTypeCodeOption17-29
192CompanyIdGuid17-29
193PaymentTermsCodeEnumEnum "CDS Payment Terms Code"17-29
194Address1_FreightTermsCodeEnumEnum "CDS Shipment Method Code"17-29
195Address1_ShippingMethodCodeEnumEnum "CDS Shipping Agent Code"17-29