MemberDataset.MemberDataTable
Columns:
|
Name |
Type |
Max Length |
Default Value |
Allow Null |
Read Only |
Unique |
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 |
|
|