Skip to main content
CR

CRLead

PX.Objects.CR
Field NameTypeDisplay NameForeign Key
ContactIDDefault Navigation
intLead ID-
Description:No description available
AnniversaryObsolete
datetime2Wedding Date-
Description:No description available
AssignDate
datetimeAssignment Date-
Description:No description available
Attention
nvarchar(255)Attention-
Description:No description available
Attributes API Nonexistent in DB
unspecified-
Description:The attributes available for the current contact. The field is preserved for internal use.
BAccountIDDefault Navigation
intBusiness AccountBAccount
Description:No description available
CampaignIDDefault Navigation
nvarchar(15)Source CampaignCRCampaign
Description:No description available
CanBeMadePrimaryNonexistent in DB
bitCan be made Primary-
Description:No description available
ClassIDDefault Navigation
nvarchar(10)Lead ClassCRLeadClass
Description:No description available
ConsentAgreement
bitConsented to the Processing of Personal Data-
Description:No description available
ConsentDate
datetime2Date of Consent-
Description:No description available
ConsentExpirationDate
datetime2Consent Expires-
Description:No description available
ContactPriority
intType-
Description:No description available
ContactType
char(2)Type-
Description:The type of the lead. The field can have one of the values listed in the ContactTypesAttribute class. The default value is ContactTypesAttribute.Lead. This field must be specified at the initialization stage and not be changed afterwards.
ConvertedBy API Default Navigation
uniqueidentifierConverted ByUsers
Description:No description available
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetimeCreated On-
Description:No description available
DateOfBirth
datetime2Date Of Birth-
Description:No description available
DefAddressIDDefault Navigation
intAddressAddress
Description:No description available
DeletedDatabaseRecord
bit-
Description:No description available
Description API
nvarchar(255)Description-
Description:No description available
DisplayNameDefault Navigation
nvarchar(255)ContactContact
Description:No description available
DuplicateFound API
bitDuplicate Found-
Description:No description available
DuplicateStatus
char(2)Duplicate-
Description:No description available
EMail API
nvarchar(255)Email-
Description:No description available
ExtRefNbr
nvarchar(40)Ext. Ref. Nbr.-
Description:No description available
nvarchar(50)Fax-
Description:No description available
FaxType API
varchar(3)Fax Type-
Description:No description available
FirstName API
nvarchar(50)First Name-
Description:No description available
FullName
nvarchar(255)Account Name-
Description:The name of the company the contact works for. Either this field or the Contact.LastName field must be specified to create the lead.
Gender
char(1)Gender-
Description:No description available
GrammValidationDateTime
datetime-
Description:No description available
Img
nvarchar(MAX)Image-
Description:No description available
IsActive
bitActive-
Description:No description available
IsAddedAsExtNonexistent in DB
bit-
Description:No description available
IsAddressSameAsMainNonexistent in DBObsolete
bitSame as in Account-
Description:No description available
IsConvertableObsolete
bitCan Be Converted-
Description:No description available
IsMeaningfull
bit-
Description:No description available
IsNotEmployeeNonexistent in DB
bitIs Not Employee-
Description:No description available
IsPrimaryNonexistent in DB
bitPrimary-
Description:No description available
LanguageIDDefault Navigation
nvarchar(10)Language/LocaleLocale
Description:No description available
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime API
datetimeLast Modified On-
Description:No description available
LastName API
nvarchar(100)Last Name-
Description:No description available
LeadContactID
intLeadContactID-
Description:No description available
LeadCreatedByIDDefault Navigation
uniqueidentifierCreated By-
Description:No description available
LeadCreatedByScreenID
char(8)-
Description:No description available
LeadCreatedDateTime
datetime-
Description:No description available
LeadLastModifiedByIDDefault Navigation
uniqueidentifierLast Modified By-
Description:No description available
LeadLastModifiedByScreenID
char(8)-
Description:No description available
LeadLastModifiedDateTime
datetime-
Description:No description available
LeadNoteID
uniqueidentifierLeadNoteID-
Description:No description available
MaritalStatus
char(1)Marital Status-
Description:No description available
MemberName
nvarchar(255)Member Name-
Description:No description available
Method
varchar(1)Contact Method-
Description:No description available
MidName
nvarchar(50)Middle Name-
Description:No description available
NoCall
bitDo Not Call-
Description:No description available
NoEMail
bitDo Not Email-
Description:No description available
NoFax
bitDo Not Fax-
Description:No description available
NoMail
bitDo Not Mail-
Description:No description available
NoMarketing API
bitNo Marketing-
Description:No description available
NoMassMail API
bitNo Mass Mail-
Description:No description available
NoteID API
uniqueidentifierNoteID-
Description:No description available
OverrideAddressNonexistent in DB
bitOverride Address-
Description:No description available
OverrideRefContact
bitOverride-
Description:No description available
OverrideSalesTerritory
bitOverride Territory-
Description:No description available
OwnerIDDefault Navigation
intOwnerContact
Description:No description available
ParentBAccountIDDefault Navigation
intParent AccountBAccount
Description:No description available
Phone1 API
nvarchar(50)Phone 1-
Description:No description available
Phone1Type API
varchar(3)Phone 1 Type-
Description:No description available
Phone2 API
nvarchar(50)Phone 2-
Description:No description available
Phone2Type API
varchar(3)Phone 2 Type-
Description:No description available
Phone3 API
nvarchar(50)Phone 3-
Description:No description available
Phone3Type API
varchar(3)Phone 3 Type-
Description:No description available
PseudonymizationStatus
intPseudonymized-
Description:No description available
QualificationDate API
datetimeQualification Date-
Description:No description available
RefContactID API Default Navigation
intContactContact
Description:No description available
Resolution
char(2)Reason-
Description:No description available
RevisionID
int-
Description:No description available
SalesTerritoryIDDefault Navigation
nvarchar(15)Sales TerritorySalesTerritory
Description:No description available
Salutation
nvarchar(255)Job Title-
Description:No description available
SearchSuggestionObsolete
nvarchar(150)Search Suggestion-
Description:No description available
SelectedNonexistent in DB
bitSelected-
Description:No description available
Source API
char(1)Source-
Description:No description available
Spouse
nvarchar(255)Spouse/Partner Name-
Description:No description available
Status API
char(1)Status-
Description:No description available
Synchronize
bitSynchronize with Exchange-
Description:No description available
Title API
nvarchar(50)Title-
Description:No description available
tstamp
timestamp-
Description:No description available
UserID
uniqueidentifier-
Description:No description available
WebSite API
nvarchar(255)Web-
Description:No description available
WorkgroupIDDefault Navigation
intWorkgroupEPCompanyTree
Description:No description available