Table 5342 "CRM Contact"

Base Application · Microsoft.Integration.D365Sales · captioned “Dataverse Contact” · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Dataverse Contact
TableType	CRM
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	ContactId	Guid	Contact caption
2	DefaultPriceLevelId	Guid	Price List caption	TableRelation Table 5346 “CRM Pricelevel” (“CRM Pricelevel”.PriceLevelId)
3	CustomerSizeCode	Option	Customer Size caption	OptionCaption: Default Value
4	CustomerTypeCode	Option	Relationship Type caption	OptionCaption: Default Value
5	PreferredContactMethodCode	Option	Preferred Method of Contact caption	OptionCaption: Any,Email,Phone,Fax,Mail
6	LeadSourceCode	Option	Lead Source caption	OptionCaption: Default Value
7	OwningBusinessUnit	Guid	Owning Business Unit caption	TableRelation Table 5364 “CRM Businessunit” (“CRM Businessunit”.BusinessUnitId)
8	OwningUser	Guid	Owning User caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
10	ShippingMethodCode	Option	Shipping Method caption	OptionCaption: Default Value
11	AccountId	Guid	Account caption	TableRelation Table 5341 “CRM Account” (“CRM Account”.AccountId)
12	ParticipatesInWorkflow	Boolean	Participates in Workflow caption
13	IsBackofficeCustomer	Boolean	Back Office Customer caption
14	Salutation	Text[100]	—
15	JobTitle	Text[100]	Job Title caption
16	FirstName	Text[50]	First Name caption
17	Department	Text[100]	—
18	NickName	Text[50]	Nickname caption
19	MiddleName	Text[50]	Middle Name caption
20	LastName	Text[50]	Last Name caption
21	Suffix	Text[10]	—
22	YomiFirstName	Text[150]	Yomi First Name caption
23	FullName Δ BC28	Text[160]	Specifies data from a corresponding field in a Dataverse entity. For more information about Dataverse, see Dataverse Help Center.
24	YomiMiddleName	Text[150]	Yomi Middle Name caption
25	YomiLastName	Text[150]	Yomi Last Name caption
26	Anniversary	Date	—
27	BirthDate	Date	Birthday caption
28	GovernmentId	Text[50]	Government caption
29	YomiFullName	Text[250]	Yomi Full Name caption
30	Description	BLOB	—
31	EmployeeId	Text[50]	Employee caption
32	GenderCode	Option	Gender caption	OptionCaption: ,Male,Female
33	AnnualIncome Δ BC28	Decimal	Annual Income caption
34	HasChildrenCode	Option	Has Children caption	OptionCaption: Default Value
35	EducationCode	Option	Education caption	OptionCaption: Default Value
36	WebSiteUrl Δ BC28	Text[200]	Specifies data from a corresponding field in a Dataverse entity. For more information about Dataverse, see Dataverse Help Center.
37	FamilyStatusCode	Option	Marital Status caption	OptionCaption: ,Single,Married,Divorced,Widowed
38	FtpSiteUrl	Text[200]	FTP Site caption
39	EMailAddress1 Δ BC28	Text[100]	Specifies the email address.
40	SpousesName	Text[100]	Spouse/Partner Name caption
41	AssistantName	Text[100]	Assistant caption
42	EMailAddress2	Text[100]	Email Address 2 caption
43	AssistantPhone	Text[50]	Assistant Phone caption
44	EMailAddress3	Text[100]	Email Address 3 caption
45	DoNotPhone	Boolean	Do not allow Phone Calls caption
46	ManagerName	Text[100]	Manager caption
47	ManagerPhone	Text[50]	Manager Phone caption
48	DoNotFax	Boolean	Do not allow Faxes caption
49	DoNotEMail	Boolean	Do not allow Emails caption
50	DoNotPostalMail	Boolean	Do not allow Mails caption
51	DoNotBulkEMail	Boolean	Do not allow Bulk Emails caption
52	DoNotBulkPostalMail	Boolean	Do not allow Bulk Mails caption
53	AccountRoleCode	Option	Role caption	OptionCaption: ,Decision Maker,Employee,Influencer
54	TerritoryCode	Option	Territory caption	OptionCaption: Default Value
55	CreditLimit Δ BC28	Decimal	Credit Limit caption
56	CreatedOn	DateTime	Created On caption
57	CreditOnHold	Boolean	Credit Hold caption
58	CreatedBy	Guid	Created By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
59	ModifiedOn	DateTime	Modified On caption
60	ModifiedBy	Guid	Modified By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
61	NumberOfChildren	Integer	No. of Children caption
62	ChildrensNames	Text[250]	Children’s Names caption
63	VersionNumber	BigInteger	Version Number caption
64	MobilePhone Δ BC28	Text[50]	Specifies data from a corresponding field in a Dataverse entity. For more information about Dataverse, see Dataverse Help Center.
65	Pager Δ BC28	Text[50]	Specifies data from a corresponding field in a Dataverse entity. For more information about Dataverse, see Dataverse Help Center.
66	Telephone1 Δ BC28	Text[50]	Specifies data from a corresponding field in a Dataverse entity. For more information about Dataverse, see Dataverse Help Center.
67	Telephone2	Text[50]	Home Phone caption
68	Telephone3	Text[50]	Telephone 3 caption
69	Fax Δ BC28	Text[50]	Specifies data from a corresponding field in a Dataverse entity. For more information about Dataverse, see Dataverse Help Center.
70	Aging30 Δ BC28	Decimal	Aging 30 caption
71	StateCode	Option	Status caption	OptionCaption: Active,Inactive
72	Aging60 Δ BC28	Decimal	Aging 60 caption
73	StatusCode	Option	Status Reason caption	OptionCaption: ,Active,Inactive
74	Aging90 Δ BC28	Decimal	Aging 90 caption
75	ParentContactId	Guid	Parent Contact caption	TableRelation Table 5342 “CRM Contact” (“CRM Contact”.ContactId)
76	ParentContactIdName Δ BC24	Text[160]	—	FlowField: lookup(“CRM Contact”.FullName where(ContactId = field(ParentContactId)))
77	AccountIdName Δ BC24	Text[160]	—	FlowField: lookup(“CRM Account”.Name where(AccountId = field(AccountId)))
78	DefaultPriceLevelIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Pricelevel”.Name where(PriceLevelId = field(DefaultPriceLevelId)))
79	Address1_AddressId	Guid	Address 1: ID caption
80	Address1_AddressTypeCode	Option	Address 1: Address Type caption	OptionCaption: ,Bill To,Ship To,Primary,Other
81	Address1_Name	Text[200]	Address 1: Name caption
82	Address1_PrimaryContactName	Text[100]	Address 1: Primary Contact Name caption
83	Address1_Line1 Δ BC28	Text[250]	Specifies data from a corresponding field in a Dataverse entity. For more information about Dataverse, see Dataverse Help Center.
84	Address1_Line2 Δ BC28	Text[250]	Specifies data from a corresponding field in a Dataverse entity. For more information about Dataverse, see Dataverse Help Center.
85	Address1_Line3	Text[250]	Address 1: Street 3 caption
86	Address1_City Δ BC28	Text[80]	Specifies data from a corresponding field in a Dataverse entity. For more information about Dataverse, see Dataverse Help Center.
87	Address1_StateOrProvince	Text[50]	Address 1: State/Province caption
88	Address1_County	Text[50]	Address 1: County caption
89	Address1_Country Δ BC28	Text[80]	Specifies data from a corresponding field in a Dataverse entity. For more information about Dataverse, see Dataverse Help Center.
90	Address1_PostOfficeBox	Text[20]	Address 1: Post Office Box caption
91	Address1_PostalCode Δ BC28	Text[20]	Specifies data from a corresponding field in a Dataverse entity. For more information about Dataverse, see Dataverse Help Center.
92	Address1_UTCOffset	Integer	Address 1: UTC Offset caption
94	Address1_UPSZone	Text[4]	Address 1: UPS Zone caption
95	Address1_Latitude Δ BC28	Decimal	Address 1: Latitude caption
96	Address1_Telephone1	Text[50]	Address 1: Phone caption
97	Address1_Longitude Δ BC28	Decimal	Address 1: Longitude caption
99	Address1_Telephone2	Text[50]	Address 1: Telephone 2 caption
100	Address1_Telephone3	Text[50]	Address 1: Telephone 3 caption
101	Address1_Fax	Text[50]	Address 1: Fax caption
102	Address2_AddressId	Guid	Address 2: ID caption
103	Address2_AddressTypeCode	Option	Address 2: Address Type caption	OptionCaption: Default Value
104	Address2_Name	Text[100]	Address 2: Name caption
105	Address2_PrimaryContactName	Text[100]	Address 2: Primary Contact Name caption
106	Address2_Line1	Text[250]	Address 2: Street 1 caption
107	Address2_Line2	Text[250]	Address 2: Street 2 caption
108	Address2_Line3	Text[250]	Address 2: Street 3 caption
109	Address2_City	Text[80]	Address 2: City caption
110	Address2_StateOrProvince	Text[50]	Address 2: State/Province caption
111	Address2_County	Text[50]	Address 2: County caption
112	Address2_Country	Text[80]	Address 2: Country/Region caption
113	Address2_PostOfficeBox	Text[20]	Address 2: Post Office Box caption
114	Address2_PostalCode	Text[20]	Address 2: ZIP/Postal Code caption
115	Address2_UTCOffset	Integer	Address 2: UTC Offset caption
116	Address2_FreightTermsCode	Option	Address 2: Freight Terms caption	OptionCaption: Default Value
117	Address2_UPSZone	Text[4]	Address 2: UPS Zone caption
118	Address2_Latitude Δ BC28	Decimal	Address 2: Latitude caption
119	Address2_Telephone1	Text[50]	Address 2: Telephone 1 caption
120	Address2_Longitude Δ BC28	Decimal	Address 2: Longitude caption
121	Address2_ShippingMethodCode	Option	Address 2: Shipping Method caption	OptionCaption: Default Value
122	Address2_Telephone2	Text[50]	Address 2: Telephone 2 caption
123	Address2_Telephone3	Text[50]	Address 2: Telephone 3 caption
124	Address2_Fax	Text[50]	Address 2: Fax caption
125	CreatedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedBy)))
126	ModifiedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedBy)))
127	OwnerId	Guid	Owner caption	TableRelation Table 5340 “CRM Systemuser”, Table 5359 “CRM Team” (if (OwnerIdType = const(systemuser)) “CRM Systemuser”.SystemUserId else if (OwnerIdType = const(team)) “CRM Team”.TeamId)
128	OwnerIdType	Option	—	OptionCaption: ,systemuser,team
129	PreferredSystemUserId	Guid	Preferred User caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
130	MasterId	Guid	Master ID caption	TableRelation Table 5342 “CRM Contact” (“CRM Contact”.ContactId)
131	PreferredAppointmentDayCode	Option	Preferred Day caption	OptionCaption: ,Sunday,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday
132	PreferredAppointmentTimeCode	Option	Preferred Time caption	OptionCaption: Morning,Afternoon,Evening
133	DoNotSendMM	Boolean	Send Marketing Materials caption
134	ParentCustomerId	Guid	Company Name caption	TableRelation Table 5341 “CRM Account”, Table 5342 “CRM Contact” (if (ParentCustomerIdType = const(account)) “CRM Account”.AccountId else if (ParentCustomerIdType = const(contact)) “CRM Contact”.ContactId)
135	Merged	Boolean	—
136	ExternalUserIdentifier	Text[50]	External User Identifier caption
137	LastUsedInCampaign	Date	Last Date Included in Campaign caption
138	MasterContactIdName Δ BC24	Text[160]	—	FlowField: lookup(“CRM Contact”.FullName where(ContactId = field(MasterId)))
139	PreferredSystemUserIdName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(PreferredSystemUserId)))
140	ParentCustomerIdType	Option	Parent Customer Type caption	OptionCaption: ,account,contact
141	TransactionCurrencyId	Guid	Currency caption	TableRelation Table 5345 “CRM Transactioncurrency” (“CRM Transactioncurrency”.TransactionCurrencyId)
142	OverriddenCreatedOn	Date	Record Created On caption
143	ExchangeRate Δ BC28	Decimal	Exchange Rate caption
144	ImportSequenceNumber	Integer	Import Sequence Number caption
145	TimeZoneRuleVersionNumber	Integer	Time Zone Rule Version Number caption
146	UTCConversionTimeZoneCode	Integer	UTC Conversion Time Zone Code caption
147	AnnualIncome_Base Δ BC28	Decimal	Annual Income (Base) caption
148	CreditLimit_Base Δ BC28	Decimal	Credit Limit (Base) caption
149	Aging60_Base Δ BC28	Decimal	Aging 60 (Base) caption
150	Aging90_Base Δ BC28	Decimal	Aging 90 (Base) caption
151	Aging30_Base Δ BC28	Decimal	Aging 30 (Base) caption
152	TransactionCurrencyIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Transactioncurrency”.CurrencyName where(TransactionCurrencyId = field(TransactionCurrencyId)))
153	CreatedOnBehalfBy	Guid	Created By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
154	CreatedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedOnBehalfBy)))
155	ModifiedOnBehalfBy	Guid	Modified By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
156	ModifiedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedOnBehalfBy)))
157	OwningTeam	Guid	Owning Team caption	TableRelation Table 5359 “CRM Team” (“CRM Team”.TeamId)
158	StageId	Guid	Process Stage caption
159	ProcessId	Guid	Process caption
160	Address2_Composite	BLOB	Address 2 caption
161	Address1_Composite	BLOB	Address 1 caption
162	EntityImageId	Guid	Entity Image Id caption
163	TraversedPath	Text[250]	Traversed Path caption
164	Address3_Country	Text[80]	Address3: Country/Region caption
165	Address3_Line1	Text[250]	Address3: Street 1 caption
166	Address3_Line2	Text[250]	Address3: Street 2 caption
167	Address3_Line3	Text[250]	Address3: Street 3 caption
168	Address3_PostalCode	Text[20]	Address3: ZIP/Postal Code caption
169	Address3_PostOfficeBox	Text[20]	Address 3: Post Office Box caption
170	Address3_StateOrProvince	Text[50]	Address3: State/Province caption
171	Address3_City	Text[80]	Address 3: City caption
172	Business2	Text[50]	Business Phone 2 caption
173	Callback	Text[50]	Callback Number caption
174	Company	Text[50]	Company Phone caption
175	Home2	Text[50]	Home Phone 2 caption
176	Address3_AddressId	Guid	Address 3: ID caption
177	Address3_Composite	BLOB	Address 3 caption
178	Address3_Fax	Text[50]	Address 3: Fax caption
179	Address3_FreightTermsCode	Option	Address 3: Freight Terms caption	OptionCaption: ,Default Value
180	Address3_Latitude Δ BC28	Decimal	Address 3: Latitude caption
181	Address3_Longitude Δ BC28	Decimal	Address 3: Longitude caption
182	Address3_Name	Text[200]	Address 3: Name caption
183	Address3_PrimaryContactName	Text[100]	Address 3: Primary Contact Name caption
184	Address3_ShippingMethodCode	Option	Address 3: Shipping Method caption	OptionCaption: ,Default Value
185	Address3_Telephone1	Text[50]	Address 3: Telephone1 caption
186	Address3_Telephone2	Text[50]	Address 3: Telephone2 caption
187	Address3_Telephone3	Text[50]	Address 3: Telephone3 caption
188	Address3_UPSZone	Text[4]	Address 3: UPS Zone caption
189	Address3_UTCOffset	Integer	Address 3: UTC Offset caption
190	Address3_County	Text[50]	Address 3: County caption
191	Address3_AddressTypeCode	Option	Address 3: Address Type caption	OptionCaption: ,Default Value
192	CompanyId	Guid	Company Id caption	TableRelation Table 5393 “CDS Company” (“CDS Company”.CompanyId)
193	PaymentTermsCodeEnum	Enum “CDS Payment Terms Code”	Payment Terms caption	enum Enum 5334 “CDS Payment Terms Code”
194	Address1_FreightTermsCodeEnum	Enum “CDS Shipment Method Code”	Address 1: Freight Terms caption	enum Enum 5335 “CDS Shipment Method Code”
195	Address1_ShippingMethodCodeEnum	Enum “CDS Shipping Agent Code”	Address 1: Shipping Method caption	enum Enum 5336 “CDS Shipping Agent Code”

Keys

Key1: ContactId (clustered)
Key2: FullName

Relations

CreatedByName: CalcFormula Table 5340 “CRM Systemuser”
CreatedOnBehalfByName: CalcFormula Table 5340 “CRM Systemuser”
ModifiedByName: CalcFormula Table 5340 “CRM Systemuser”
ModifiedOnBehalfByName: CalcFormula Table 5340 “CRM Systemuser”
PreferredSystemUserIdName: CalcFormula Table 5340 “CRM Systemuser”
CreatedBy: TableRelation Table 5340 “CRM Systemuser”
CreatedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
OwnerId: TableRelation Table 5340 “CRM Systemuser” (conditional)
OwningUser: TableRelation Table 5340 “CRM Systemuser”
PreferredSystemUserId: TableRelation Table 5340 “CRM Systemuser”
AccountIdName: CalcFormula Table 5341 “CRM Account”
AccountId: TableRelation Table 5341 “CRM Account”
ParentCustomerId: TableRelation Table 5341 “CRM Account” (conditional)
MasterContactIdName: CalcFormula Table 5342 “CRM Contact”
ParentContactIdName: CalcFormula Table 5342 “CRM Contact”
MasterId: TableRelation Table 5342 “CRM Contact”
ParentContactId: TableRelation Table 5342 “CRM Contact”
ParentCustomerId: TableRelation Table 5342 “CRM Contact” (conditional)
TransactionCurrencyIdName: CalcFormula Table 5345 “CRM Transactioncurrency”
TransactionCurrencyId: TableRelation Table 5345 “CRM Transactioncurrency”
DefaultPriceLevelIdName: CalcFormula Table 5346 “CRM Pricelevel”
DefaultPriceLevelId: TableRelation Table 5346 “CRM Pricelevel”
OwnerId: TableRelation Table 5359 “CRM Team” (conditional)
OwningTeam: TableRelation Table 5359 “CRM Team”
OwningBusinessUnit: TableRelation Table 5364 “CRM Businessunit”
CompanyId: TableRelation Table 5393 “CDS Company”

Referenced by

40 fields in 14 objects relate to this table (TableRelation or CalcFormula).

Table 5349 “CRM Incident”: ContactIdName, PrimaryContactIdName, ResponsibleContactIdName, ContactId, CustomerId, PrimaryContactId, ResponsibleContactId
Table 5357 “CRM Contract”: BillingContactIdName, ContactIdName, BillingContactId, BillingCustomerId, ContactId, CustomerId
Table 5342 “CRM Contact”: MasterContactIdName, ParentContactIdName, MasterId, ParentContactId, ParentCustomerId
Table 5343 “CRM Opportunity”: ContactIdName, ParentContactIdName, ContactId, CustomerId, ParentContactId
Table 5351 “CRM Quote”: ContactIdName, ContactId, CustomerId
Table 5353 “CRM Salesorder”: ContactIdName, ContactId, CustomerId
Table 5355 “CRM Invoice”: ContactIdName, ContactId, CustomerId
Table 5341 “CRM Account”: PrimaryContactIdName, PrimaryContactId
Table 5344 “CRM Post”: RegardingObjectId
Table 5360 “CRM Customeraddress”: ParentId
Table 6400 “FS Work Order”: ReportedByContact
Table 6410 “FS Bookable Resource”: ContactId
Table 6610 “FS Bookable Resource”: ContactId
Table 6617 “FS Work Order”: ReportedByContact

Pages and codeunits on this table

Page 5342 “CRM Contact List” (source table)

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "CRM Contact"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Across versions

Neighbourhood 21 connected objects and pages