CR
CRMarketingMemberForImport
PX.Objects.CR105 of 105 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ContactID | int | Member Name | - | |
Description:No description available | ||||
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 | ||||
AnniversaryObsolete | datetime2 | Wedding Date | - | |
Description:No description available | ||||
AssignDate | datetime2 | Assignment Date | - | |
Description:No description available | ||||
Attention | nvarchar(255) | Attention | - | |
Description:No description available | ||||
AttributesNonexistent in DB | unspecified | - | ||
Description:No description available | ||||
BAccountID | int | Business Account | BAccount | |
Description:No description available | ||||
BuildingName | nvarchar(35) | Building Name | - | |
Description:No description available | ||||
BuildingNumber | nvarchar(16) | Building Number | - | |
Description:No description available | ||||
CampaignID | nvarchar(15) | Source Campaign | CRCampaign | |
Description:No description available | ||||
CanBeMadePrimaryNonexistent in DB | bit | Can be made Primary | - | |
Description:No description available | ||||
City | nvarchar(50) | City | - | |
Description:No description available | ||||
ClassID | nvarchar(10) | Contact Class | CRContactClass | |
Description:No description available | ||||
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:No description available | ||||
CountryID | nvarchar(100) | Country | Country | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
DateOfBirth | datetime2 | Date Of Birth | - | |
Description:No description available | ||||
DefAddressID | int | Address | Address | |
Description:No description available | ||||
DeletedDatabaseRecord | bit | - | ||
Description:No description available | ||||
Department | nvarchar(70) | Department | - | |
Description:No description available | ||||
Description | nvarchar(255) | Description | - | |
Description:No description available | ||||
DisplayName | nvarchar(255) | Contact | - | |
Description:No description available | ||||
DistrictName | nvarchar(35) | District Name | - | |
Description:No description available | ||||
DuplicateFound | bit | Duplicate Found | - | |
Description:No description available | ||||
DuplicateStatus | char(2) | Duplicate | - | |
Description:No description available | ||||
EMail | nvarchar(255) | - | ||
Description:No description available | ||||
ExtRefNbr | nvarchar(40) | Ext. Ref. Nbr. | - | |
Description:No description available | ||||
Fax | nvarchar(50) | Fax | - | |
Description:No description available | ||||
FaxType | varchar(3) | Fax Type | - | |
Description:No description available | ||||
FirstName | nvarchar(50) | First Name | - | |
Description:No description available | ||||
Floor | nvarchar(70) | Floor | - | |
Description:No description available | ||||
FullName | nvarchar(255) | Account Name | - | |
Description:No description available | ||||
Gender | char(1) | Gender | - | |
Description:No description available | ||||
GrammValidationDateTime | datetime2 | - | ||
Description:No description available | ||||
Img | nvarchar(MAX) | Image | - | |
Description:No description available | ||||
IsActive | bit | Active | - | |
Description:No description available | ||||
IsAddedAsExtNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsAddressSameAsMainNonexistent in DBObsolete | bit | Same as in Account | - | |
Description:No description available | ||||
IsConvertableObsolete | bit | Can Be Converted | - | |
Description:No description available | ||||
IsMeaningfull | bit | - | ||
Description:No description available | ||||
IsNotEmployeeNonexistent in DB | bit | Is Not Employee | - | |
Description:No description available | ||||
IsPrimaryNonexistent in DB | bit | Primary | - | |
Description:No description available | ||||
LanguageID | nvarchar(10) | Language/Locale | Locale | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LastName | nvarchar(100) | Last Name | - | |
Description:No description available | ||||
Latitude | decimal | Latitude | - | |
Description:No description available | ||||
LinkCampaignID | nvarchar(15) | Campaign ID | CRCampaign | |
Description:No description available | ||||
LinkMarketingListID | int | Marketing List ID | CRMarketingList | |
Description:No description available | ||||
Longitude | decimal | Longitude | - | |
Description:No description available | ||||
MaritalStatus | char(1) | Marital Status | - | |
Description:No description available | ||||
MemberName | nvarchar(255) | Member Name | - | |
Description:No description available | ||||
Method | char(1) | Contact Method | - | |
Description:No description available | ||||
MidName | nvarchar(50) | Middle Name | - | |
Description:No description available | ||||
NoCall | bit | Do Not Call | - | |
Description:No description available | ||||
NoEMail | bit | Do Not Email | - | |
Description:No description available | ||||
NoFax | bit | Do Not Fax | - | |
Description:No description available | ||||
NoMail | bit | Do Not Mail | - | |
Description:No description available | ||||
NoMarketing | bit | No Marketing | - | |
Description:No description available | ||||
NoMassMail | bit | No Mass Mail | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | NoteID | - | |
Description:No description available | ||||
OverrideAddressNonexistent in DB | bit | Override Address | - | |
Description:No description available | ||||
OverrideSalesTerritory | bit | Override Territory | - | |
Description:No description available | ||||
OwnerID | int | Owner | Contact | |
Description:No description available | ||||
ParentBAccountID | int | Parent Account | BAccount | |
Description:No description available | ||||
Phone1 | nvarchar(50) | Phone 1 | - | |
Description:No description available | ||||
Phone1Type | varchar(3) | Phone 1 Type | - | |
Description:No description available | ||||
Phone2 | nvarchar(50) | Phone 2 | - | |
Description:No description available | ||||
Phone2Type | varchar(3) | Phone 2 Type | - | |
Description:No description available | ||||
Phone3 | nvarchar(50) | Phone 3 | - | |
Description:No description available | ||||
Phone3Type | varchar(3) | Phone 3 Type | - | |
Description:No description available | ||||
PostalCode | varchar(20) | Postal Code | - | |
Description:No description available | ||||
PostBox | nvarchar(16) | Post Box | - | |
Description:No description available | ||||
PseudonymizationStatus | int | Pseudonymized | - | |
Description:No description available | ||||
Resolution | char(2) | Reason | - | |
Description:No description available | ||||
RevisionID | int | - | ||
Description:No description available | ||||
Room | nvarchar(70) | Room | - | |
Description:No description available | ||||
SalesTerritoryID | nvarchar(15) | Sales Territory | SalesTerritory | |
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 | bit | Selected | - | |
Description:No description available | ||||
Source | char(1) | Source | - | |
Description:No description available | ||||
Spouse | nvarchar(255) | Spouse/Partner Name | - | |
Description:No description available | ||||
State | nvarchar(50) | State | State | |
Description:No description available | ||||
Status | char(1) | Status | - | |
Description:No description available | ||||
StreetName | nvarchar(70) | Street Name | - | |
Description:No description available | ||||
SubDepartment | nvarchar(70) | Subdepartment | - | |
Description:No description available | ||||
Synchronize | bit | Synchronize with Exchange | - | |
Description:No description available | ||||
Title | nvarchar(50) | Title | - | |
Description:No description available | ||||
TownLocationName | nvarchar(35) | Town Location Name | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnitNumber | nvarchar(16) | Unit Number | - | |
Description:No description available | ||||
UserID | uniqueidentifier | Users | ||
Description:No description available | ||||
WebSite | nvarchar(255) | Web | - | |
Description:No description available | ||||
WorkgroupID | int | Workgroup | EPCompanyTree | |
Description:No description available | ||||