MemberDataset.MemberDataTable
Column Name | Type | Max Length | Default Value | Allow Null | Read Only |
---|
AdditionalData | String | 2147483647 | | X | |
Comment | String | 2147483647 | | X | |
Comment2 | String | 1000 | | X | |
Comment3 | String | 1000 | | X | |
Comment4 | String | 1000 | | X | |
Comment5 | String | 1000 | | X | |
Comment6 | String | 1000 | | X | |
Comment7 | String | 1000 | | X | |
ConfirmDate | DateTime | | | X | X |
DateBounced | DateTime | | | X | X |
DateHeld | DateTime | | | X | X |
DateJoined | DateTime | | | X | |
DateUnsubscribed | DateTime | | | X | X |
DomainName | String | 250 | | X | X |
EmailAddress | String | 100 | | | |
FullName | String | 100 | | X | |
List | String | 60 | | X | X |
MailFormatPreferred | String | 1 | | X | X |
MemberID | Int32 | | 0 | X | X |
MemberType | String | 20 | | X | |
NumberBounces | Int16 | | | X | X |
SubType | String | 20 | | X | X |
UserID | String | 50 | | X | |
UserNameLowerCase | String | 100 | | X | X |
FirstName | String | 50 | | X | |
LastName | String | 50 | | X | |
Company | String | 50 | | X | |
Address | String | 100 | | X | |
AddressCity | String | 50 | | X | |
AddressState | String | 50 | | X | |
AddressZip | String | 10 | | X | |
AddressPhone | String | 15 | | X | |
ProfileIndustry | String | 50 | | X | |
ProfileDepartment | String | 50 | | X | |
ProfileTitle | String | 50 | | X | |
ProfileCompanySize | String | 50 | | X | |
AddressAltPhone | String | 15 | | X | |
UserDate | DateTime | | | X | |
UserDate1 | DateTime | | | X | |
UserDate2 | DateTime | | | X | |
UserDate3 | DateTime | | | X | |
UserDate4 | DateTime | | | X | |
UserDate5 | DateTime | | | X | |
Number1 | Int32 | | | X | |
Number2 | Int32 | | | X | |
Number3 | Int32 | | | X | |
Number4 | Int32 | | | X | |
Number5 | Int32 | | | X | |
Text1 | String | 200 | | X | |
Text2 | String | 200 | | X | |
Text3 | String | 200 | | X | |
Text4 | String | 200 | | X | |
Text5 | String | 200 | | X | |
UnsubMessageID | Int32 | | | X | X |
Text6 | String | 200 | | X | |
Text7 | String | 200 | | X | |
Text8 | String | 200 | | X | |
Text9 | String | 200 | | X | |
Text10 | String | 200 | | X | |
Text11 | String | 200 | | X | |
ExpireDate | DateTime | | | X | X |
Source | String | 200 | | X | |
LastModifiedDate | DateTime | | | X | |
Decimal1 | Decimal | | | X | |
Decimal2 | Decimal | | | X | |
Decimal3 | Decimal | | | X | |
Decimal4 | Decimal | | | X | |
Decimal5 | Decimal | | | X | |
UnicodeText1 | String | 4000 | | X | |
UnicodeText2 | String | 4000 | | X | |
UnicodeText3 | String | 4000 | | X | |
UnicodeText4 | String | 4000 | | X | |
UnicodeText5 | String | 4000 | | X | |
UnicodeText6 | String | 4000 | | X | |
UnicodeText7 | String | 4000 | | X | |
UnicodeText8 | String | 4000 | | X | |
UnicodeText9 | String | 4000 | | X | |
UnicodeText10 | String | 4000 | | X | |
Birthday | DateTime | | | X | |
Country | String | 100 | | X | |
AddressLine2 | String | 100 | | X | |
LifetimeValue | Decimal | | | X | |
LastPurchaseDate | DateTime | | | X | |
Salutation | String | 20 | | X | |
Suffix | String | 20 | | X | |
AgeRange | String | 50 | | X | |
Gender | String | 20 | | X | |
County | String | 50 | | X | |
HouseholdIncome | String | 50 | | X | |
HomeOwnershipStatus | String | 20 | | X | |
ChildrenPresent | String | 20 | | X | |
RepFirstName | String | 50 | | X | |
RepLastName | String | 50 | | X | |
RepEmail | String | 100 | | X | |
RepPhone | String | 15 | | X | |
RepPhoto | String | 4000 | | X | |
LeadPipelineStatus | String | 50 | | X | |
StoreNumber | String | 50 | | X | |
RewardsAccountNumber | String | 50 | | X | |
RewardsLevel | String | 50 | | X | |
RewardPoints | Decimal | | | X | |
SICCode | String | 15 | | X | |
TrackingAuthorization | Boolean | | | X | |
PreferredName | String | 100 | | X | |
ProfileRole | String | 50 | | X | |
UnsubReason | String | 1000 | | X | |
LeadStage | String | 50 | | X | |
LeadDisqualifiedReason | String | 50 | | X | |
LeadSourceFirstTouch | String | 100 | | X | |
LeadSourceLastTouch | String | 100 | | X | |
LeadSourceUrl | String | 1000 | | X | |
LeadSourceGCLID | String | 255 | | X | |
LeadSourceFBCLID | String | 255 | | X | |
LeadSourceLandingUrl | String | 1000 | | X | |