Table 5050 Contact in 17

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

App: Base Application

Fields, 82 Keys, 13 Procedures, 44 Events, 72

Versions1718 19 20 21 22 23 24 25 26 27 28 latest

Source29

Fields, 82

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	Pending 15.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	-
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	-
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]	-
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	Option	-
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, 13

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	-

Procedures, 44

Name	Parameters	Returns	Access	Obsolete
DoModify	(Record Contact)		public	-
TypeChange	()		public	-
AssistEdit	(Record Contact)	Boolean	public	-
CreateCustomer	()		public	-
CreateCustomer	(Code[10])	Code[20]	public	-
CreateVendor	()	Code[20]	public	-
CreateBankAccount	()		public	-
CreateCustomerLink	()		public	-
CreateVendorLink	()		public	-
CreateBankAccountLink	()		public	-
CreateInteraction	()		public	-
GetDefaultPhoneNo	()	Text[30]	public	-
ShowCustVendBank	()		public	-
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	-
ChooseCustomerTemplate	()	Code[10]	public	-
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	-
CheckForExistingRelationships	(Enum Contact Business Relation Link To Table)		public	-
SetLastDateTimeModified	()		public	-
GetLastDateTimeModified	()	DateTime	public	-
SetLastDateTimeFilter	(DateTime)		public	-
TouchContact	(Code[20])		public	-
CountNoOfBusinessRelations	()	Integer	public	-
CreateSalesQuoteFromContact	()		public	-
ContactToCustBusinessRelationExist	()	Boolean	public	-
CheckIfMinorForProfiles	()		public	-
CheckIfPrivacyBlocked	(Boolean)		public	-
CheckIfPrivacyBlockedGeneric	()		public	-
GetContNo	(Text)	Code[20]	public	-
GetContactsSelectionFromContactList	(Boolean)	Boolean	public	-
CreateEmployee	()		public	-
CreateEmployeeLink	()		public	-

Events, 72

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	OnBeforeVendorInsert	(var Record Vendor, var Record Contact)	-
Integration event	OnBeforeChooseCustomerTemplate	(var Record Contact, var Code[10], var Boolean)	-
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)	-
Integration event	OnBeforeFindCustomerTemplate	(var Record Contact, var Code[10], var Boolean)	-
Integration event	OnBeforeInheritCompanyToPersonData	(var Record Contact, Record Contact, var Record Contact, var Boolean)	-
Integration event	OnBeforeIsUpdateNeeded	(Record Contact, Record Contact, var Boolean)	-
Integration event	OnCreateCustomerOnBeforeCustomerModify	(var Record Customer, Record Contact)	-
Integration event	OnCreateCustomerOnTransferFieldsFromTemplate	(var Record Customer, Record Customer Template)	-
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	OnAfterSetTypeForContact	(var Record Contact)	-
Integration event	OnAfterShowCustVendBank	(var Record Contact, var Record Contact Business Relation, Boolean)	-
Integration event	OnAfterSyncAddress	(var Record Contact, Record Contact, var 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	OnBeforeBankAccountInsert	(var Record Bank Account)	-
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)	-
Integration event	OnBeforeCreateCompanyContactCustomer	(var Record Contact, Code[10], var Code[20], Boolean, var Boolean, var Boolean)	-
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	OnBeforeProcessPersonNameChange	(var Boolean)	-
Integration event	OnBeforeTypeChange	(Record Contact, Record Contact, var Record Interaction Log Entry, var Record Opportunity, var Record To-do, 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)	-
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)	-
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)	-