Contact

PX.Objects.CR

View API Entity: Contact/entity/Default/24.200.001/Contact

81 of 81 fields

	Field Name	Type	Display Name	Foreign Key
	`ContactID` API Default Navigation	`int`	Contact ID	-
Description:The identifier of the contact. This field is the key field. This field is an identity auto-increment database field that in normal conditions cannot be duplicated in different tenants. This value is present in the URI of the open document: "ScreenId=CR302000&ContactID=100044".
	`Anniversary`Obsolete	`datetime2`	Wedding Date	-
Description:The wedding date of the contact.
	`AssignDate`	`datetime`	Assignment Date	-
Description:The date and time when OwnerID or WorkgroupID were last changed.
	`Attention` API	`nvarchar(255)`	Attention	-
Description:The name of the document recipient (a person or team) used in the documents. Not used in primary graph, only in documents, for instance, CROpportunity, SO.SOOrder, and so on.
	`Attributes` API Nonexistent in DB	`unspecified`		-
Description:The attributes list available for the current contact. The field is preserved for internal use.
	`BAccountID`Default Navigation	`int`	Business Account	BAccount
Description:The identifier of the related business account. Corresponds to the value of the BAccount.BAccountID field.
	`CampaignID`Default Navigation	`nvarchar(15)`	Source Campaign	CRCampaign
Description:The identifier of the campaign that resulted in creation of the contact. Corresponds to the CRCampaign.campaignID field. The property is used by the LeadMaint graph and displayed on the Leads (CR301000) form.
	`CanBeMadePrimary`Nonexistent in DB	`bit`	Can be made Primary	-
Description:No description available
	`ClassID`Default Navigation	`nvarchar(10)`	Contact Class	CRContactClass
Description:The identifier of the class. Corresponds to the value of the CRContactClass.ClassID field.
	`ConsentAgreement`	`bit`	Consented to the Processing of Personal Data	-
Description:No description available
	`ConsentDate`	`datetime2`	Date of Consent	-
Description:No description available
	`ConsentExpirationDate`	`datetime2`	Consent Expires	-
Description:No description available
	`ContactPriority`	`int`	Type	-
Description:No description available
	`ContactType`	`char(2)`	Type	-
Description:The type of the contact. The field can have one of the values listed in the ContactTypesAttribute class. The default value is ContactTypesAttribute.Person. This field must be specified at the initialization stage and not be changed afterwards.
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`	Created On	-
Description:No description available
	`DateOfBirth` API	`datetime2`	Date Of Birth	-
Description:The date of birth.
	`DefAddressID`Default Navigation	`int`	Address	Address
Description:The identifier of the CR.Address object linked with the current document. The field can be empty for the contacts of the following types: ContactTypesAttribute.BAccountProperty and ContactTypesAttribute.Employee. Corresponds to the value of the Address.AddressID field.
	`DeletedDatabaseRecord`	`bit`		-
Description:No description available
	`DisplayName` API Default Navigation	`nvarchar(255)`	Contact	-
Description:No description available
	`DuplicateFound` API	`bit`	Duplicate Found	-
Description:No description available
	`DuplicateStatus`	`char(2)`	Duplicate	-
Description:The duplicate status of the contact. The field indicates whether the contact was validated by the duplicate validation (see FeaturesSet.ContactDuplicate). The field can have one of the values listed in the DuplicateStatusAttribute class. The default value is DuplicateStatusAttribute.NotValidated.
	`EMail` API	`nvarchar(255)`	Email	-
Description:The email address of the contact. The field should be a valid email address, or a list of email addresses separated by semicolons. The email addresses will be validated with the EmailParser.ParseAddresses(string) method.
	`ExtRefNbr` API	`nvarchar(40)`	Ext. Ref. Nbr.	-
Description:The external reference number of the contact. It can be an additional number of the contact used in external integration.
	`Fax` API	`nvarchar(50)`	Fax	-
Description:The fax number. The type of the number can be set by the FaxType field. The value should match the phone validation pattern specified for the current company. See Company.PhoneMask for details.
	`FaxType` API	`varchar(3)`	Fax Type	-
Description:The phone type for the Fax field. The field can have one of the values listed in the PhoneTypesAttribute class.
	`FirstName` API	`nvarchar(50)`	First Name	-
Description:The first name of the person.
	`FullName` API	`nvarchar(255)`	Account Name	-
Description:The name of the company the contact works for.
	`Gender` API	`char(1)`	Gender	-
Description:The gender of the contact. The field can have one of the values listed in the GendersAttribute class, and a default value can be set depending on the value of Title.
	`GrammValidationDateTime`	`datetime`		-
Description:The date and time of the last gramm validation. The field is preserved for internal use.
	`Img`	`nvarchar(MAX)`	Image	-
Description:The image attached to the contact. The value can be fetched from the exchange server during contacts synchronization (see FeaturesSet.ExchangeIntegration).
	`IsActive`	`bit`	Active	-
Description:Specifies whether the current contact is active and can be specified in documents. Only active contacts can be specified in such documents as CROpportunity, CRCase, CRQuote, PM.PMQuote. The duplicate validation feature FeaturesSet.ContactDuplicate works only with active contacts.
	`IsAddedAsExt`Nonexistent in DB	`bit`		-
Description:No description available
	`IsAddressSameAsMain`Nonexistent in DBObsolete	`bit`	Same as in Account	-
Description:No description available
	`IsConvertable`Obsolete	`bit`	Can Be Converted	-
Description:No description available
	`IsMeaningfull`	`bit`		-
Description:No description available
	`IsNotEmployee`Nonexistent in DB	`bit`	Is Not Employee	-
Description:Specifies whether the current contact's type is not the employee type. The value is when the value of ContactType is not equal to ContactTypesAttribute.Employee.
	`IsPrimary`Nonexistent in DB	`bit`	Primary	-
Description:Specifies (if set to ) that the contact, which the current ContactAccount represents, is primary for the business account, which the current ContactAccount also represents. It is used only by the BusinessAccountMaint graph.
	`LanguageID`Default Navigation	`nvarchar(10)`	Language/Locale	Locale
Description:No description available
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime` API	`datetime`	Last Modified On	-
Description:No description available
	`LastName` API	`nvarchar(100)`	Last Name	-
Description:The last name of the person.
	`MaritalStatus` API	`char(1)`	Marital Status	-
Description:The marital status of the contact. The field can have one of the values listed in the MaritalStatusesAttribute class.
	`MemberName`	`nvarchar(255)`	Member Name	-
Description:No description available
	`Method`	`varchar(1)`	Contact Method	-
Description:The person's preferred method of contact. The field can have one of the values listed in the CRContactMethodsAttribute class.
	`MidName`	`nvarchar(50)`	Middle Name	-
Description:The middle name of the person.
	`NoCall`	`bit`	Do Not Call	-
Description:Specifies (if set to ) that the contact should not be called. The system does not rely on this field, but the value can be used by an external system or as an indicator.
	`NoEMail`	`bit`	Do Not Email	-
Description:Specifies (if set to ) that the email of the contact will not be involved in the mass email process. This contact will not receive any notification emails. Contacts with this field set to will not receive mass emails sent by the CRMassMailMaint graph (the Mass Emails (CR308000) form).
	`NoFax`	`bit`	Do Not Fax	-
Description:Specifies (if set to ) that no fax should be sent to the contact. The system does not rely on this field, but the value can be used by an external system or as an indicator.
	`NoMail`	`bit`	Do Not Mail	-
Description:Specifies (if set to ) that no mail should be sent to the contact. The system does not rely on this field, but the value can be used by an external system or as an indicator.
	`NoMarketing` API	`bit`	No Marketing	-
Description:Specifies (if set to ) that the email of the contact will not be involved in the mass email process. Contacts with this field set to will not receive mass emails sent by the CRMassMailMaint graph (the Mass Emails (CR308000) form).
	`NoMassMail` API	`bit`	No Mass Mail	-
Description:Specifies (if set to ) that the email of the contact will not be involved in the mass email process. Contacts with this field set to will not receive mass emails sent by the CRMassMailMaint graph (the Mass Emails (CR308000) form).
	`NoteID` API	`uniqueidentifier`	NoteID	-
Description:No description available
	`OverrideAddress`Nonexistent in DB	`bit`	Override Address	-
Description:Specifies whether the address information of this contact differs from the address information of the business account associated with this contact. IF it is so, the address information is synchronized with the associated business account. The behavior is controlled by the ContactMaint.ContactBAccountSharedAddressOverrideGraphExt graph extension.
	`OverrideSalesTerritory`	`bit`	Override Territory	-
Description:The flag identified that the salesTerritoryID is filled automatically based on Address.state and Address.countryID or can be assigned manually.
	`OwnerID`Default Navigation	`int`	Owner	Contact
Description:No description available
	`ParentBAccountID`Default Navigation	`int`	Parent Account	BAccount
Description:The identifier of the account that is considered as parent for the current account (BAccountID). Corresponds to the value of the BAccount.BAccountID field. There is no business logic in the application for this field.
	`Phone1` API	`nvarchar(50)`	Phone 1	-
Description:The phone number. The type of the number can be set by the Phone1Type field. The value should match the phone validation pattern specified for the current company. See Company.PhoneMask for details.
	`Phone1Type` API	`varchar(3)`	Phone 1 Type	-
Description:The phone type for the Phone1 field. The field can have one of the values listed in the PhoneTypesAttribute class.
	`Phone2` API	`nvarchar(50)`	Phone 2	-
Description:The second phone number. The type of the number can be set by the Phone2Type field. The value should match the phone validation pattern specified for the current company. See Company.PhoneMask for details.
	`Phone2Type` API	`varchar(3)`	Phone 2 Type	-
Description:The phone type for the Phone2 field. The field can have one of the values listed in the PhoneTypesAttribute class.
	`Phone3` API	`nvarchar(50)`	Phone 3	-
Description:The third phone number. The type of the number can be set by the Phone3Type field. The value should match the phone validation pattern specified for the current company. See Company.PhoneMask for details.
	`Phone3Type` API	`varchar(3)`	Phone 3 Type	-
Description:The phone type for the Phone3 field. The field can have one of the values listed in the PhoneTypesAttribute class.
	`PseudonymizationStatus`	`int`	Pseudonymized	-
Description:No description available
	`Resolution`	`char(2)`	Reason	-
Description:The reason why the Status of this contact has been changed. The property is used by the LeadMaint graph, displayed on the Leads (CR301000) form for CRLead objects, and controlled by the workflow engine.
	`RevisionID`	`int`		-
Description:The identifier of the revision of the contact. It is increased at each update of the contact. This field is used to check whether the original contact was changed. Tables in PX.Objects that rely on this field: APContact, AR.ARContact, CRContact, PM.PMContact, PO.POContact, SO.SOContact,
	`SalesTerritoryID`Default Navigation	`nvarchar(15)`	Sales Territory	SalesTerritory
Description:The reference to SalesTerritory.salesTerritoryID. If overrideSalesTerritory is then it's filled automatically based on Address.state and Address.countryID otherwise it's assigned by user.
	`Salutation`	`nvarchar(255)`	Job Title	-
Description:The job title of the person.
	`SearchSuggestion`Obsolete	`nvarchar(150)`	Search Suggestion	-
Description:No description available
	`Selected`Nonexistent in DB	`bit`	Selected	-
Description:No description available
	`Source` API	`char(1)`	Source	-
Description:The source of the contact. If a contact was created from a lead, the value is copied from the lead related to the contact. The field can have one of the values listed in the CRMSourcesAttribute class.
	`Spouse`	`nvarchar(255)`	Spouse/Partner Name	-
Description:The name of the spouse or partner of the contact.
	`Status` API	`char(1)`	Status	-
Description:The status of the contact. The field values are controlled by the workflow engine, and the field is not used by the application logic directly.
	`Synchronize` API	`bit`	Synchronize with Exchange	-
Description:Specifies whether the contact should be included in exchange synchronization. The value is used in the exchange integration (see FeaturesSet.ExchangeIntegration). The default value is .
	`Title` API	`nvarchar(50)`	Title	-
Description:The title of the person. The predefined values are listed in the TitlesAttribute class, but this field can have any value.
	`tstamp`	`timestamp`		-
Description:No description available
	`UserID`	`uniqueidentifier`		Users
Description:The identifier of the user associated with the contact. Corresponds to the Users.PKID field.
	`WebSite` API	`nvarchar(255)`	Web	-
Description:The URL of the contact website. The field should contain a valid URL.
	`WorkgroupID`Default Navigation	`int`	Workgroup	EPCompanyTree
Description:No description available