ContactAccount

PX.Objects.CRRelease 2025.2

The projection of the Contact table joined with the BAccount table (on the condition that Contact.BAccountID is equal to BAccount.BAccountID).

Select a row for its description 95 of 95 fields

	Field Name	Type	Display Name	Foreign Key
	`AccountStatus`	`char(1)`	Status	-
Description:No description available
	`AcctName`	`nvarchar(60)`	Account Name	-
Description:The full business account name (as opposed to the short identifier AcctCD).
	`Anniversary`Obsolete	`datetime`	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`	`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`Nonexistent in DB	`string`		-
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	`bool?`	Can be made Primary	-
Description:No description available
	`ClassID`Default Navigation	`nvarchar(10)`	Class ID	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`	`datetime`	Date of Consent	-
Description:No description available
	`ConsentExpirationDate`	`datetime`	Consent Expires	-
Description:No description available
	`ContactID`Default Navigation	`int`	Contact ID	ContactTypesAttribute
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".
	`ContactPriority`Nonexistent in DB	`int?`	Type	-
Description:The numeric representation of ContactType used to sort a grid containing contacts of different types. The value is used in the following graphs: OUSearchMaint, CampaignMaint, CRMarketingListMaint. The possible values match ContactType values as follows: - ContactTypesAttribute.BAccountProperty: ContactTypesAttribute.bAccountPriority - ContactTypesAttribute.SalesPerson: ContactTypesAttribute.salesPersonPriority - ContactTypesAttribute.Employee: ContactTypesAttribute.employeePriority - ContactTypesAttribute.Person: ContactTypesAttribute.personPriority - ContactTypesAttribute.Lead: ContactTypesAttribute.leadPriority
	`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`	`datetime`	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.
	`DefContactID`	`int`		-
Description:The identifier of the CR.Contact object used to store additional contact data of the business account. Corresponds to the value of the Contact.ContactID field. Also, the Contact.BAccountID value must be equal to the BAccount.BAccountID value of the current business account.
	`DefaultTeamsClient`	`char(1)`	Teams Client	-
Description:No description available
	`DeletedDatabaseRecord`	`bit`		-
Description:No description available
	`DisplayName`Default Navigation	`nvarchar`	Contact	Contact
Description:The display name of the contact. Its value is made up of the LastName, FirstName, MidName, and Title values. The format depends on the PreferencesGeneral.PersonNameFormat site setting. This field is changed when the fields it depends on are changed.
	`DuplicateFound`Nonexistent in DB	`bool?`	Duplicate Found	-
Description:Specifies whether DuplicateStatus is equal to DuplicateStatusAttribute.PossibleDuplicated when the FeaturesSet.ContactDuplicate feature is enabled.
	`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`	`nvarchar`	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`	`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`	`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`	`nvarchar(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`	`nvarchar(50)`	First Name	-
Description:The first name of the person.
	`FullName`	`nvarchar(255)`	Account Name	-
Description:The name of the company the contact works for.
	`Gender`	`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.
	`HasRigths`Nonexistent in DB	`bool?`		-
Description:No description available
	`Img`	`nvarchar`	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	`bool?`		-
Description:No description available
	`IsAddressSameAsMain`Nonexistent in DBObsolete	`bool?`	Same as in Account	-
Description:No description available
	`IsConvertable`Obsolete	`bit`	Can Be Converted	-
Description:No description available
	`IsMeaningfull`Nonexistent in DB	`bool?`		-
Description:No description available
	`IsNotEmployee`Nonexistent in DB	`bool?`	Is Not Employee	-
Description:Specifies whether the current contact's type is not the employee type. The value is true when the value of ContactType is not equal to ContactTypesAttribute.Employee.
	`IsPrimary`Nonexistent in DB	`bool?`	Primary	-
Description:Specifies (if set to true) that the contact, which the current ContactAccount represents, is primary for the business account, which the current ContactAccount also represents. The value is true when PrimaryContactID is equal to Contact.ContactID.
	`IsRelatedToProjectContact`Nonexistent in DB	`bool?`	Is Related To Project Contact	-
Description:No description available
	`LanguageID`Default Navigation	`nvarchar(10)`	Language/Locale	Locale
Description:The language in which the contact prefers to communicate. By default, the system fills in the box with the locale specified for the contact's country. This field is displayed on the form only if there are multiple active locales configured on the System Locales (SM200550) form (corresponds to the LocaleMaintenance graph).
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`	Last Modified On	-
Description:No description available
	`LastName`	`nvarchar(100)`	Last Name	-
Description:The last name of the person.
	`MaritalStatus`	`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`Nonexistent in DB	`string`	Member Name	-
Description:Similar to DisplayName, but unlike DisplayName, it is a calculated field. It is equal to DisplayName if the latter is not null, and to FullName otherwise.
	`Method`	`char(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 true) 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 true) 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 true 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 true) 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 true) 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`	`bit`	No Marketing	-
Description:Specifies (if set to true) that the email of the contact will not be involved in the mass email process. Contacts with this field set to true will not receive mass emails sent by the CRMassMailMaint graph (the Mass Emails (CR308000) form).
	`NoMassMail`	`bit`	No Mass Mail	-
Description:Specifies (if set to true) that the email of the contact will not be involved in the mass email process. Contacts with this field set to true will not receive mass emails sent by the CRMassMailMaint graph (the Mass Emails (CR308000) form).
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`OverrideAddress`Nonexistent in DB	`bool?`	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`	Business 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.
	`PersonalEMail`	`nvarchar`	Email (Personal)	-
Description:No description available
	`Phone1`	`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`	`nvarchar(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`	`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`	`nvarchar(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`	`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`	`nvarchar(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.
	`PreferredName`	`nvarchar`	Preferred Name	-
Description:No description available
	`PreviousEmail`Nonexistent in DB	`string`	Previous Email	-
Description:No description available
	`PrimaryContactID`	`int`	Primary Contact	Contact
Description:The identifier of the CR.Contact object linked with the business account and marked as primary. Corresponds to the value of the Contact.ContactID field. Also, the Contact.BAccountID value must equal to the BAccount.BAccountID value of the current business account.
	`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,
	`RolesCSV`Nonexistent in DB	`string?`	User Roles	-
Description:User Roles
	`SalesTerritoryID`Default Navigation	`nvarchar(15)`	Sales Territory	SalesTerritory
Description:The reference to SalesTerritory.salesTerritoryID. If overrideSalesTerritory is false 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`Nonexistent in DBObsolete	`string`	Search Suggestion	-
Description:No description available
	`Selected`Nonexistent in DB	`bool?`	Selected	-
Description:No description available
	`Source`	`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`	`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`	`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 true.
	`TeamsID`	`nvarchar(255)`	Override Teams ID	-
Description:No description available
	`Title`	`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.
	`TriggerEmailChange`Nonexistent in DB	`string`	Trigger Email Change	-
Description:No description available
	`Type`	`char(2)`	Type	-
Description:Represents the type of the business account. The field can have one of the values listed in the BAccountType class. The default value is BAccountType.ProspectType for a prospect, BAccountType.CustomerType for a customer, and BAccountType.VendorType for a vendor.
	`UserID`	`uniqueidentifier`		Users
Description:The identifier of the user associated with the contact. Corresponds to the Users.PKID field.
	`WebSite`	`nvarchar`	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
	`tstamp`	`timestamp`		-
Description:No description available