CRMarketingMemberForImport

PX.Objects.CRRelease 2025.2

No summary is documented for this DAC in the release source.

Select a row for its description 114 of 114 fields

	Field Name	Type	Display Name	Foreign Key
	`AddressLine1`	`nvarchar(50)`	Address Line 1	-
Description:No description available
	`AddressLine2`	`nvarchar(50)`	Address Line 2	-
Description:No description available
	`AddressLine3`	`nvarchar(50)`	Address Line 3	-
Description:No description available
	`AddressType`	`char(2)`	AddressType	-
Description:No description available
	`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.
	`BuildingName`	`nvarchar(35)`	Building Name	-
Description:Name of the building or house (ISO 20022).
	`BuildingNumber`	`nvarchar(16)`	Building Number	-
Description:Number that identifies the position of a building on a street (ISO 20022).
	`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
	`City`	`nvarchar(50)`	City	-
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`	Member Name	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.
	`CountryID`Default Navigation	`nvarchar(100)`	Country	Country
Description:No description available
	`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.
	`DefaultTeamsClient`	`char(1)`	Teams Client	-
Description:No description available
	`DeletedDatabaseRecord`	`bit`		-
Description:No description available
	`Department`	`nvarchar(70)`	Department	-
Description:Identification of a division of a large organization or building (ISO 20022).
	`Description`	`nvarchar(255)`	Description	-
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.
	`DistrictName`	`nvarchar(35)`	District Name	-
Description:Identifies a subdivision within a country sub-division (ISO 20022).
	`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.
	`Floor`	`nvarchar(70)`	Floor	-
Description:Floor or storey within a building (ISO 20022).
	`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. It is used only by the BusinessAccountMaint graph.
	`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.
	`Latitude`	`decimal`	Latitude	-
Description:The latitude coordinates that are entered for a location if the location does not contain the postal address or the postal address cannot be validated. The field value is filled using the Google or Bing lookup.
	`LinkCampaignID`Default Navigation	`nvarchar(15)`	Campaign ID	CRCampaign
Description:No description available
	`LinkMarketingListID`Default Navigation	`int`	Marketing List ID	CRMarketingList
Description:No description available
	`Longitude`	`decimal`	Longitude	-
Description:The longitude coordinates that are entered for a location if the location does not contain the postal address or the postal address cannot be validated. The field value is filled using the Google or Bing lookup.
	`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.
	`PostBox`	`nvarchar(16)`	Post Box	-
Description:Numbered box in a post office, assigned to a person or organisation, where letters are kept until called for (ISO 20022).
	`PostalCode`	`nvarchar(20)`	Postal Code	-
Description:No description available
	`PreferredName`	`nvarchar`	Preferred Name	-
Description:No description available
	`PreviousEmail`Nonexistent in DB	`string`	Previous Email	-
Description:No description available
	`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
	`Room`	`nvarchar(70)`	Room	-
Description:Floor or storey within a building (ISO 20022).
	`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.
	`State`Default Navigation	`nvarchar(50)`	State	State
Description:No description available
	`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.
	`StreetName`	`nvarchar(70)`	Street Name	-
Description:Name of a street or thoroughfare (ISO 20022).
	`SubDepartment`	`nvarchar(70)`	Subdepartment	-
Description:Identification of a sub-division of a large organization or building (ISO 20022).
	`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.
	`TownLocationName`	`nvarchar(35)`	Town Location Name	-
Description:Specific location name within the town (ISO 20022).
	`TriggerEmailChange`Nonexistent in DB	`string`	Trigger Email Change	-
Description:No description available
	`UnitNumber`	`nvarchar(16)`	Unit Number	-
Description:Identifies a flat or dwelling within the building (ISO 20022).
	`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