Table 5050 Contact in 20

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

App: Base Application

Fields, 85 Keys, 14 Procedures, 66 Events, 107

Versions17 18 192021 22 23 24 25 26 27 28 latest

Source29

Fields, 85

Id	Name	Type	Obsolete
1	No.	Code[20]	-
2	Name	Text[100]	-
3	Search Name	Code[100]	-
4	Name 2	Text[50]	-
5	Address	Text[100]	-
6	Address 2	Text[50]	-
7	City	Text[30]	-
9	Phone No.	Text[30]	-
10	Telex No.	Text[20]	-
15	Territory Code	Code[10]	-
22	Currency Code	Code[10]	-
24	Language Code	Code[10]	-
29	Salesperson Code	Code[20]	-
35	Country/Region Code	Code[10]	-
38	Comment	Boolean	-
54	Last Date Modified	Date	-
84	Fax No.	Text[30]	-
85	Telex Answer Back	Text[20]	-
86	VAT Registration No.	Text[20]	-
89	Picture	Blob	Removed 18.0
Replaced by Image field
91	Post Code	Code[20]	-
92	County	Text[30]	-
102	E-Mail	Text[80]	-
103	Home Page	Text[80]	-
107	No. Series	Code[20]	-
140	Image	Media	-
150	Privacy Blocked	Boolean	-
151	Minor	Boolean	-
152	Parental Consent Received	Boolean	-
720	Coupled to CRM	Boolean	-
5050	Type	Enum Contact Type	-
5051	Company No.	Code[20]	-
5052	Company Name	Text[100]	-
5053	Lookup Contact No.	Code[20]	-
5054	First Name	Text[30]	-
5055	Middle Name	Text[30]	-
5056	Surname	Text[30]	-
5058	Job Title	Text[30]	-
5059	Initials	Text[30]	-
5060	Extension No.	Text[30]	-
5061	Mobile Phone No.	Text[30]	-
5062	Pager	Text[30]	-
5063	Organizational Level Code	Code[10]	-
5064	Exclude from Segment	Boolean	-
5065	Date Filter	Date	-
5066	Next Task Date	Date	-
5067	Last Date Attempted	Date	-
5068	Date of Last Interaction	Date	-
5069	No. of Job Responsibilities	Integer	-
5070	No. of Industry Groups	Integer	-
5071	No. of Business Relations	Integer	-
5072	No. of Mailing Groups	Integer	-
5073	External ID	Code[20]	-
5074	No. of Interactions	Integer	-
5075	Business Relation	Text[50]	Pending 18.1
Replaced by the Contact Business Relation field.
5076	Cost (LCY)	Decimal	-
5077	Duration (Min.)	Decimal	-
5078	No. of Opportunities	Integer	-
5079	Estimated Value (LCY)	Decimal	-
5080	Calcd. Current Value (LCY)	Decimal	-
5082	Opportunity Entry Exists	Boolean	-
5083	Task Entry Exists	Boolean	-
5084	Salesperson Filter	Code[20]	-
5085	Campaign Filter	Code[20]	-
5086	Contact Business Relation	Enum Contact Business Relation	-
5087	Action Taken Filter	Option	-
5088	Sales Cycle Filter	Code[10]	-
5089	Sales Cycle Stage Filter	Integer	-
5090	Probability % Filter	Decimal	-
5091	Completed % Filter	Decimal	-
5092	Estimated Value Filter	Decimal	-
5093	Calcd. Current Value Filter	Decimal	-
5094	Chances of Success % Filter	Decimal	-
5095	Task Status Filter	Enum Task Status	-
5096	Task Closed Filter	Boolean	-
5097	Priority Filter	Option	-
5098	Team Filter	Code[10]	-
5099	Close Opportunity Filter	Code[10]	-
5100	Correspondence Type	Enum Correspondence Type	-
5101	Salutation Code	Code[10]	-
5102	Search E-Mail	Code[80]	-
5104	Last Time Modified	Time	-
5105	E-Mail 2	Text[80]	-
5106	Job Responsibility Filter	Code[10]	-
8050	Xrm Id	Guid	-

Keys, 14

Name	Fields	Obsolete
Key1, clustered	No.	-
Key2	Search Name	-
Key3	Company Name, Company No., Type, Name	-
Key4	Company No.	-
Key5	Territory Code	-
Key6	Salesperson Code	-
Key7	VAT Registration No.	-
Key8	Search E-Mail	-
Key9	Name	-
Key10	City	-
Key11	Post Code	-
Key12	Phone No.	-
Key13	SystemModifiedAt	-
Key14	Coupled to CRM	-

Procedures, 66

Name	Parameters	Returns	Access	Obsolete
DoModify	(Record Contact)		public	-
TypeChange	()		public	-
AssistEdit	(Record Contact)	Boolean	public	-
CreateCustomer	()	Code[20]	public	-
CreateCustomer	(Code[10])	Code[20]	public	Pending 18.0
Will be removed with other functionality related to "old" templates. Replaced by CreateCustomerFromTemplate()
CreateVendor	()	Code[20]	public	-
CreateBankAccount	()	Code[20]	public	-
CreateCustomerLink	()		public	-
CreateVendorLink	()		public	-
CreateBankAccountLink	()		public	-
CreateInteraction	()		public	-
GetDefaultPhoneNo	()	Text[30]	public	-
ShowCustVendBank	()		public	Pending 18.0
Replaced by the procedure ShowBusinessRelation()
SetSkipDefault	()		public	-
IdenticalAddress	(Record Contact)	Boolean	public	-
ActiveAltAddress	(Date)	Code[10]	public	-
CalculatedName	()	Text[100]	public	-
CheckContactType	(Enum Contact Type)		public	-
FindCustomerTemplate	()	Code[10]	public	Pending 18.0
Will be removed with other functionality related to "old" templates. Replaced by FindNewCustomerTemplate()
ChooseCustomerTemplate	()	Code[10]	public	Pending 18.0
Will be removed with other functionality related to "old" templates. Replaced by ChooseNewCustomerTemplate()
GetSalutation	(Enum Salutation Formula Salutation Type, Code[10])	Text[260]	public	-
InheritCompanyToPersonData	(Record Contact)		public	-
StaleAddress	()	Boolean	protected	-
SetHideValidationDialog	(Boolean)		public	-
GetHideValidationDialog	()	Boolean	public	-
DisplayMap	()		public	-
GetCompNo	(Text)	Text	public	-
LookupCompany	()		public	-
LookupCustomerTemplate	()	Code[20]	public	Pending 18.0
Will be removed with other functionality related to "old" templates. Replaced by LookupNewCustomerTemplate()
CheckForExistingRelationships	(Enum Contact Business Relation Link To Table)		public	-
SetLastDateTimeModified	()		public	-
GetLastDateTimeModified	()	DateTime	public	-
SetLastDateTimeFilter	(DateTime)		public	-
TouchContact	(Code[20])		public	-
CountNoOfBusinessRelations	()	Integer	public	Pending 18.0
Replaced by CountNoOfBusinessRelations with LinkToTable parameter
CreateSalesQuoteFromContact	()		public	-
ContactToCustBusinessRelationExist	()	Boolean	public	-
CheckIfMinorForProfiles	()		public	-
CheckIfPrivacyBlocked	(Boolean)		public	-
CheckIfPrivacyBlockedGeneric	()		public	-
GetContNo	(Text)	Code[20]	public	-
GetContactsSelectionFromContactList	(Boolean)	Boolean	public	-
CreateEmployee	()	Code[20]	public	-
CreateEmployeeLink	()		public	-
CreateCustomerFromTemplate	(Code[20])	Code[20]	public	-
ShowBusinessRelation	(Enum Contact Business Relation Link To Table, Boolean)		public	-
ShowBusinessRelations	()		public	-
UpdateBusinessRelation	()	Boolean	public	-
HasBusinessRelation	(Enum Contact Business Relation Link To Table, Code[10])	Boolean	public	-
HasBusinessRelations	(var Boolean, var Boolean, var Boolean, var Boolean)		public	-
FindNewCustomerTemplate	()	Code[20]	public	-
ChooseNewCustomerTemplate	()	Code[20]	public	-
UpdateQuotes	(Record Customer, Code[10])		public	Pending 18.0
Will be removed with other functionality related to "old" templates. Replaced by UpdateQuotesFromTemplate()
UpdateQuotesFromTemplate	(Record Customer, Code[20])		public	-
ToPriceSource	(var Record Price Source)		public	-
LookupNewCustomerTemplate	()	Code[20]	public	-
CountNoOfBusinessRelations	(Enum Contact Business Relation Link To Table)	Integer	public	-
GetOrClear	(Code[20])		public	-
UpdateCustomerFromConversionTemplate	(var Record Customer, Record Customer Template)		public	Pending 18.0
This function will be removed once the Feature Key is removed. Will be replaced by ApplyCustomerTemplate() from CustomerTemplMgt codeunit.
RunOnShowCustVendBankCaseElse	(var Record Contact Business Relation)		public	Pending 18.0
Replaced by "Contact Business Relation".OnShowRelatedCardPageCaseElse
CreateVendorFromTemplate	(Code[20])	Code[20]	public	-
UpdateSearchName	()		protected	-
SetDefaultSalesperson	()		protected	-
VATRegistrationValidation	()		public	-
MarkContactsWithSimilarName	(var Record Contact, Text)		protected	-
SetSearchEmail	()		protected	-

Events, 107

Kind	Name	Parameters	Obsolete
Integration event	OnAfterGetSalutation	(var Enum Salutation Formula Salutation Type, var Code[10], var Text[100], var Record Contact, var Record Salutation Formula)	-
Integration event	OnAfterInheritCompanyToPersonData	(var Record Contact, Record Contact, Record Contact)	-
Integration event	OnAfterUpdateQuotesForContact	(Record Contact, Record Customer)	-
Integration event	OnAfterVendorInsert	(var Record Vendor, var Record Contact)	-
Integration event	OnBeforeChooseCustomerTemplate	(var Record Contact, var Code[10], var Boolean)	Pending 18.0
Will be removed with other functionality related to "old" templates. Replaced by ()
Integration event	OnBeforeCreateLink	(var Record Contact, var Record Contact Business Relation, var Integer, var Code[10], var Enum Contact Business Relation Link To Table)	-
Integration event	OnBeforeCustomerInsert	(var Record Customer, Code[10], var Record Contact)	Pending 18.0
Will be removed with other functionality related to "old" templates. Replaced by OnCreateCustomerFromTemplateOnBeforeCustomerInsert()
Integration event	OnBeforeFindCustomerTemplate	(var Record Contact, var Code[10], var Boolean)	Pending 18.0
Will be removed with other functionality related to "old" templates. Replaced by OnBeforeFindNewCustomerTemplate()
Integration event	OnBeforeInheritCompanyToPersonData	(var Record Contact, Record Contact, var Record Contact, var Boolean)	-
Integration event	OnCreateCustomerOnBeforeCustomerModify	(var Record Customer, Record Contact)	-
Integration event	OnCreateCustomerOnTransferFieldsFromTemplate	(var Record Customer, Record Customer Template)	Pending 18.0
Will be removed with other functionality related to "old" templates. Replaced by OnCreateCustomerFromTemplateOnAfterApplyCustomerTemplate()
Integration event	OnAfterCalculatedName	(var Record Contact, var Text[92])	-
Integration event	OnAfterCreateCustomer	(var Record Contact, var Record Customer)	-
Integration event	OnAfterCreateCustomerLink	(var Record Contact)	-
Integration event	OnAfterCreateVendor	(var Record Contact, var Record Vendor)	-
Integration event	OnAfterIdenticalAddress	(Record Contact, Record Contact, var Boolean)	-
Integration event	OnAfterModifySellToCustomerNo	(var Record Sales Header, var Record Sales Line)	-
Integration event	OnAfterModifyBillToCustomerNo	(var Record Sales Header, var Record Sales Line)	-
Integration event	OnAfterOnModify	(var Record Contact, Record Contact)	-
Integration event	OnAfterProcessNameChange	(var Record Contact, Record Customer, Record Vendor)	-
Integration event	OnAfterSetDefaults	(var Record Contact, Record Marketing Setup)	-
Integration event	OnAfterSetLastDateTimeModified	(var Record Contact)	-
Integration event	OnAfterSetDefaultSalesperson	(var Record Contact)	-
Integration event	OnAfterShowCustVendBank	(var Record Contact, var Record Contact Business Relation, Boolean)	-
Integration event	OnAfterValidateCity	(var Record Contact, Record Contact)	-
Integration event	OnAfterValidatePostCode	(var Record Contact, Record Contact)	-
Integration event	OnBeforeApplyCompanyChangeToPerson	(var Record Contact, Record Contact, Record Contact, var Boolean, Record Contact)	-
Integration event	OnBeforeAssistEdit	(var Record Contact, Record Contact, var Boolean, var Boolean)	-
Integration event	OnBeforeDuplicateCheck	(Record Contact, Record Contact, var Boolean)	-
Integration event	OnBeforeCalculatedName	(var Record Contact, var Text[100], var Boolean)	-
Integration event	OnBeforeCheckForExistingRelationships	(var Record Contact, Integer, var Boolean)	-
Integration event	OnBeforeCheckForCompanyContactExistingRelationships	(var Record Contact, var Record Contact Business Relation, var Boolean)	-
Integration event	OnBeforeCheckCompanyNo	(var Record Contact, var Boolean)	-
Integration event	OnBeforeCheckDuplicates	(var Record Contact, var Boolean)	-
Integration event	OnBeforeCheckContactType	(var Record Contact, Enum Contact Type, var Boolean)	-
Integration event	OnBeforeCheckUnloggedSegments	(var Record Contact, var Boolean)	-
Integration event	OnBeforeCreateCustomer	(var Record Contact, var Code[20], var Boolean, Code[10], Boolean)	Pending 18.0
Will be removed with other functionality related to "old" templates. Replaced by OnBeforeCreateCustomerFromTemplate()
Integration event	OnBeforeCreateCompanyContactCustomer	(var Record Contact, Code[10], var Code[20], Boolean, var Boolean, var Boolean)	Pending 18.0
Will be removed with other functionality related to "old" templates. Replaced by OnBeforeCreateCompanyContactCustomerFromTemplate()
Integration event	OnBeforeCreateCompanyContactVendor	(var Record Contact, var Code[20], Boolean, var Boolean, var Boolean)	-
Integration event	OnBeforeCreateSalesQuoteFromContact	(var Record Contact, var Record Sales Header)	-
Integration event	OnBeforeCreateVendor	(var Record Contact, var Code[20], var Boolean)	-
Integration event	OnBeforeGetSalutation	(var Record Contact, var Enum Salutation Formula Salutation Type, var Code[10], var Boolean, var Text[260])	-
Integration event	OnBeforeLookupCity	(var Record Contact, var Record Post Code)	-
Integration event	OnBeforeLookupPostCode	(var Record Contact, var Record Post Code)	-
Integration event	OnBeforeNameBreakdown	(var Record Contact, var Boolean)	-
Integration event	OnBeforeVATRegistrationValidation	(var Record Contact, var Boolean)	-
Integration event	OnBeforeValidateCity	(var Record Contact, var Record Post Code)	-
Integration event	OnBeforeValidateNo	(var Record Contact, var Boolean)	-
Integration event	OnBeforeLaunchDuplicateForm	(var Record Contact, var Boolean)	-
Integration event	OnBeforeUpdateCompanyNo	(var Record Contact, Record Contact)	-
Integration event	OnBeforeUpdateFieldForNewCompany	(var Record Contact, var Integer, var Boolean)	-
Integration event	OnBeforeUpdateSearchName	(var Record Contact, Record Contact, var Boolean)	-
Integration event	OnBeforeValidatePostCode	(var Record Contact, var Record Post Code)	-
Integration event	OnCreateSalesQuoteFromContactOnBeforeSalesHeaderInsert	(var Record Contact, var Record Sales Header)	-
Integration event	OnCreateCustomerOnBeforeUpdateQuotes	(var Record Customer, Record Contact)	-
Integration event	OnCreateVendorOnAfterUpdateVendor	(var Record Vendor, Record Contact, var Record Contact Business Relation)	-
Integration event	OnLookupCustomerTemplateOnBeforeSetTableView	(Record Contact, var Record Customer Template)	Pending 18.0
Will be removed with other functionality related to "old" templates. Replaced by OnLookupNewCustomerTemplateOnBeforeSetTableView()
Integration event	OnGetCompNoOnAfterSetFilters	(var Record Contact)	-
Integration event	OnGetSalutationString	(var Text[260], Record Salutation Formula, Text[100])	-
Integration event	OnShowCustVendBankCaseElse	(var Record Contact Business Relation)	Pending 18.0
Replaced by "Contact Business Relation".OnShowRelatedCardPageCaseElse
Integration event	OnShowCustVendBankOnBeforeRunPage	(var Record Contact, Boolean, var Record Contact Business Relation, var Boolean)	-
Integration event	OnAfterCreateEmployee	(var Record Employee, var Record Contact Business Relation)	-
Integration event	OnTypeChangeOnAfterCheckInteractionLog	(var Record Contact, Record Contact)	-
Integration event	OnTypeChangeOnAfterContSetFilters	(var Record Contact, Record Contact)	-
Integration event	OnTypeChangeOnAfterTypePersonTestFields	(Record Contact)	-
Integration event	OnBeforeChooseNewCustomerTemplate	(var Record Contact, var Code[20], var Boolean)	-
Integration event	OnCreateCustomerFromTemplateOnBeforeCustomerInsert	(var Record Customer, Code[20], var Record Contact)	-
Integration event	OnBeforeFindNewCustomerTemplate	(var Record Contact, var Code[20], var Boolean)	-
Integration event	OnBeforeIsUpdateNeeded	(var Record Contact, Record Contact, var Boolean)	-
Integration event	OnAfterCreateBankAccount	(var Record Contact, var Record Bank Account)	-
Integration event	OnAfterOnInsert	(var Record Contact, Record Contact)	-
Integration event	OnBeforeBankAccountInsert	(var Record Bank Account, var Record Contact)	-
Integration event	OnBeforeCreateCustomerFromTemplate	(var Record Contact, var Code[20], var Boolean, Code[20], Boolean)	-
Integration event	OnBeforeCreateCompanyContactCustomerFromTemplate	(var Record Contact, Code[20], var Code[20], Boolean, var Boolean, var Boolean)	-
Integration event	OnBeforeCreateBankAccount	(var Record Contact, var Code[20], var Boolean)	-
Integration event	OnBeforeOnInsert	(var Record Contact, var Boolean)	-
Integration event	OnBeforeValidateVATRegistrationNo	(var Record Contact, Record Contact, Integer, var Boolean)	-
Integration event	OnLookupNewCustomerTemplateOnBeforeSetTableView	(Record Contact, var Record Customer Templ.)	-
Integration event	OnBeforeSetDefaultSalesperson	(var Record Contact, var Boolean)	-
Integration event	OnCreateVendorFromTemplateOnBeforeCommit	(Record Contact, Record Vendor, var Boolean)	-
Integration event	OnCreateCustomerFromTemplateOnAfterApplyCustomerTemplate	(var Record Customer, Record Customer Templ., var Record Contact)	-
Integration event	OnAfterSetTypeForContact	(var Record Contact, Record Contact)	-
Integration event	OnAssistEditOnAfterNoSeriesMgtSetSeries	(var Record Contact, Record Contact)	-
Integration event	OnBeforeCreateCustomerLink	(var Record Contact, var Boolean)	-
Integration event	OnBeforeProcessPersonNameChange	(var Boolean, var Record Contact, var Record Customer, var Record Vendor)	-
Integration event	OnBeforeUpdateQuotesFromTemplate	(Record Customer, Code[20], var Boolean, var Record Contact)	-
Integration event	OnBeforeVendorInsert	(var Record Vendor, var Record Contact, Code[20])	-
Integration event	OnBeforeCheckIfTypeChangePossibleForPerson	(var Record Contact, Record Contact, var Boolean)	-
Integration event	OnChooseNewCustomerTemplateOnBeforeSelectWithConfirm	(var Record Contact, var Record Customer Templ., var Boolean)	-
Integration event	OnCreateCustomerLinkOnAfterCreateLink	(var Record Contact, Record Contact, var Record Contact Business Relation)	-
Integration event	OnAfterCreateInteraction	(var Record Contact)	-
Integration event	OnAfterCreateLink	(var Record Contact, Record Contact, Integer)	-
Integration event	OnAfterSyncAddress	(var Record Contact, Record Contact, var Boolean, var Record Contact)	-
Integration event	OnAfterTypeChange	(var Record Contact)	-
Integration event	OnBeforeActiveAltAddress	(var Record Contact, var Code[10], var Boolean)	-
Integration event	OnBeforeOnDelete	(var Record Contact, Record Contact, var Boolean)	-
Integration event	OnBeforeTypeChange	(var Record Contact, Record Contact, var Record Interaction Log Entry, var Record Opportunity, var Record To-do, var Record Contact, var Boolean)	-
Integration event	OnBeforeShowResultForCustomer	(var Record Customer, var Record Contact, var Boolean, var Boolean)	-
Integration event	OnBeforeShowResultForVendor	(var Record Vendor, var Record Contact, var Boolean, var Boolean)	-
Integration event	OnAfterCreateVendorLink	(var Record Contact, Record Contact)	-
Integration event	OnBeforeCreateVendorLink	(var Record Contact, var Boolean)	-
Integration event	OnCreateCustomerFromTemplateOnBeforeInitCustomerNo	(var Record Customer, var Record Contact, Record Customer Templ., var Boolean)	-
Integration event	OnCreateVendorFromTemplateOnBeforeInitVendorNo	(var Record Vendor, var Record Contact, Record Vendor Templ., var Boolean)	-
Integration event	OnBeforeProcessCompanyNameChange	(var Record Contact, var Boolean)	-
Integration event	OnProcessPersonNameChangeOnBeforeAssignCustomerContact	(var Record Customer, var Record Contact, var Boolean)	-
Integration event	OnProcessPersonNameChangeOnBeforeAssignVendorContact	(var Record Vendor, var Record Contact, var Boolean)	-
Integration event	OnBeforeOnModify	(var Record Contact, Record Contact)	-