Table 5342 CRM Contact in 20

Jonas Paprotka, Base Application 20.5.45456.61928, checked 2026-09-20

App: Base Application

Versions17 18 192021 22 23 24 25 26 27 28 latest

Source29

Fields, 195

Id	Name	Type	Obsolete
1	ContactId	Guid	-
2	DefaultPriceLevelId	Guid	-
3	CustomerSizeCode	Option	-
4	CustomerTypeCode	Option	-
5	PreferredContactMethodCode	Option	-
6	LeadSourceCode	Option	-
7	OwningBusinessUnit	Guid	-
8	OwningUser	Guid	-
9	PaymentTermsCode	Option	Removed 19.0
This field is replaced by field 193 PaymentTermsCodeEnum
10	ShippingMethodCode	Option	-
11	AccountId	Guid	-
12	ParticipatesInWorkflow	Boolean	-
13	IsBackofficeCustomer	Boolean	-
14	Salutation	Text[100]	-
15	JobTitle	Text[100]	-
16	FirstName	Text[50]	-
17	Department	Text[100]	-
18	NickName	Text[50]	-
19	MiddleName	Text[50]	-
20	LastName	Text[50]	-
21	Suffix	Text[10]	-
22	YomiFirstName	Text[150]	-
23	FullName	Text[160]	-
24	YomiMiddleName	Text[150]	-
25	YomiLastName	Text[150]	-
26	Anniversary	Date	-
27	BirthDate	Date	-
28	GovernmentId	Text[50]	-
29	YomiFullName	Text[250]	-
30	Description	Blob	-
31	EmployeeId	Text[50]	-
32	GenderCode	Option	-
33	AnnualIncome	Decimal	-
34	HasChildrenCode	Option	-
35	EducationCode	Option	-
36	WebSiteUrl	Text[200]	-
37	FamilyStatusCode	Option	-
38	FtpSiteUrl	Text[200]	-
39	EMailAddress1	Text[100]	-
40	SpousesName	Text[100]	-
41	AssistantName	Text[100]	-
42	EMailAddress2	Text[100]	-
43	AssistantPhone	Text[50]	-
44	EMailAddress3	Text[100]	-
45	DoNotPhone	Boolean	-
46	ManagerName	Text[100]	-
47	ManagerPhone	Text[50]	-
48	DoNotFax	Boolean	-
49	DoNotEMail	Boolean	-
50	DoNotPostalMail	Boolean	-
51	DoNotBulkEMail	Boolean	-
52	DoNotBulkPostalMail	Boolean	-
53	AccountRoleCode	Option	-
54	TerritoryCode	Option	-
55	CreditLimit	Decimal	-
56	CreatedOn	DateTime	-
57	CreditOnHold	Boolean	-
58	CreatedBy	Guid	-
59	ModifiedOn	DateTime	-
60	ModifiedBy	Guid	-
61	NumberOfChildren	Integer	-
62	ChildrensNames	Text[250]	-
63	VersionNumber	BigInteger	-
64	MobilePhone	Text[50]	-
65	Pager	Text[50]	-
66	Telephone1	Text[50]	-
67	Telephone2	Text[50]	-
68	Telephone3	Text[50]	-
69	Fax	Text[50]	-
70	Aging30	Decimal	-
71	StateCode	Option	-
72	Aging60	Decimal	-
73	StatusCode	Option	-
74	Aging90	Decimal	-
75	ParentContactId	Guid	-
76	ParentContactIdName	Text[160]	-
77	AccountIdName	Text[160]	-
78	DefaultPriceLevelIdName	Text[100]	-
79	Address1_AddressId	Guid	-
80	Address1_AddressTypeCode	Option	-
81	Address1_Name	Text[200]	-
82	Address1_PrimaryContactName	Text[100]	-
83	Address1_Line1	Text[250]	-
84	Address1_Line2	Text[250]	-
85	Address1_Line3	Text[250]	-
86	Address1_City	Text[80]	-
87	Address1_StateOrProvince	Text[50]	-
88	Address1_County	Text[50]	-
89	Address1_Country	Text[80]	-
90	Address1_PostOfficeBox	Text[20]	-
91	Address1_PostalCode	Text[20]	-
92	Address1_UTCOffset	Integer	-
93	Address1_FreightTermsCode	Option	Removed 19.0
This field is replaced by field 194 Address1_FreightTermsCodeEnum
94	Address1_UPSZone	Text[4]	-
95	Address1_Latitude	Decimal	-
96	Address1_Telephone1	Text[50]	-
97	Address1_Longitude	Decimal	-
98	Address1_ShippingMethodCode	Option	Removed 19.0
This field is replaced by field 194 Address1_ShippingMethodCodeEnum
99	Address1_Telephone2	Text[50]	-
100	Address1_Telephone3	Text[50]	-
101	Address1_Fax	Text[50]	-
102	Address2_AddressId	Guid	-
103	Address2_AddressTypeCode	Option	-
104	Address2_Name	Text[100]	-
105	Address2_PrimaryContactName	Text[100]	-
106	Address2_Line1	Text[250]	-
107	Address2_Line2	Text[250]	-
108	Address2_Line3	Text[250]	-
109	Address2_City	Text[80]	-
110	Address2_StateOrProvince	Text[50]	-
111	Address2_County	Text[50]	-
112	Address2_Country	Text[80]	-
113	Address2_PostOfficeBox	Text[20]	-
114	Address2_PostalCode	Text[20]	-
115	Address2_UTCOffset	Integer	-
116	Address2_FreightTermsCode	Option	-
117	Address2_UPSZone	Text[4]	-
118	Address2_Latitude	Decimal	-
119	Address2_Telephone1	Text[50]	-
120	Address2_Longitude	Decimal	-
121	Address2_ShippingMethodCode	Option	-
122	Address2_Telephone2	Text[50]	-
123	Address2_Telephone3	Text[50]	-
124	Address2_Fax	Text[50]	-
125	CreatedByName	Text[200]	-
126	ModifiedByName	Text[200]	-
127	OwnerId	Guid	-
128	OwnerIdType	Option	-
129	PreferredSystemUserId	Guid	-
130	MasterId	Guid	-
131	PreferredAppointmentDayCode	Option	-
132	PreferredAppointmentTimeCode	Option	-
133	DoNotSendMM	Boolean	-
134	ParentCustomerId	Guid	-
135	Merged	Boolean	-
136	ExternalUserIdentifier	Text[50]	-
137	LastUsedInCampaign	Date	-
138	MasterContactIdName	Text[160]	-
139	PreferredSystemUserIdName	Text[200]	-
140	ParentCustomerIdType	Option	-
141	TransactionCurrencyId	Guid	-
142	OverriddenCreatedOn	Date	-
143	ExchangeRate	Decimal	-
144	ImportSequenceNumber	Integer	-
145	TimeZoneRuleVersionNumber	Integer	-
146	UTCConversionTimeZoneCode	Integer	-
147	AnnualIncome_Base	Decimal	-
148	CreditLimit_Base	Decimal	-
149	Aging60_Base	Decimal	-
150	Aging90_Base	Decimal	-
151	Aging30_Base	Decimal	-
152	TransactionCurrencyIdName	Text[100]	-
153	CreatedOnBehalfBy	Guid	-
154	CreatedOnBehalfByName	Text[200]	-
155	ModifiedOnBehalfBy	Guid	-
156	ModifiedOnBehalfByName	Text[200]	-
157	OwningTeam	Guid	-
158	StageId	Guid	-
159	ProcessId	Guid	-
160	Address2_Composite	Blob	-
161	Address1_Composite	Blob	-
162	EntityImageId	Guid	-
163	TraversedPath	Text[250]	-
164	Address3_Country	Text[80]	-
165	Address3_Line1	Text[250]	-
166	Address3_Line2	Text[250]	-
167	Address3_Line3	Text[250]	-
168	Address3_PostalCode	Text[20]	-
169	Address3_PostOfficeBox	Text[20]	-
170	Address3_StateOrProvince	Text[50]	-
171	Address3_City	Text[80]	-
172	Business2	Text[50]	-
173	Callback	Text[50]	-
174	Company	Text[50]	-
175	Home2	Text[50]	-
176	Address3_AddressId	Guid	-
177	Address3_Composite	Blob	-
178	Address3_Fax	Text[50]	-
179	Address3_FreightTermsCode	Option	-
180	Address3_Latitude	Decimal	-
181	Address3_Longitude	Decimal	-
182	Address3_Name	Text[200]	-
183	Address3_PrimaryContactName	Text[100]	-
184	Address3_ShippingMethodCode	Option	-
185	Address3_Telephone1	Text[50]	-
186	Address3_Telephone2	Text[50]	-
187	Address3_Telephone3	Text[50]	-
188	Address3_UPSZone	Text[4]	-
189	Address3_UTCOffset	Integer	-
190	Address3_County	Text[50]	-
191	Address3_AddressTypeCode	Option	-
192	CompanyId	Guid	-
193	PaymentTermsCodeEnum	Enum CDS Payment Terms Code	-
194	Address1_FreightTermsCodeEnum	Enum CDS Shipment Method Code	-
195	Address1_ShippingMethodCodeEnum	Enum CDS Shipping Agent Code	-

Keys, 2

Name	Fields	Obsolete
Key1, clustered	ContactId	-
Key2	FullName	-