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 |
|
X |
|
|
| 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 |
|
|
| MobilePhoneNumber |
String |
15 |
|
X |
|
|
| SMSMemberType |
String |
20 |
|
X |
|
|
| SMSLastSub |
DateTime |
|
|
X |
|
|
| SMSLastUnsub |
DateTime |
|
|
X |
|
|
| SMSLastPending |
DateTime |
|
|
X |
|
|
| SMSSource |
String |
50 |
|
X |
|
|
| SMSAddedBy |
String |
100 |
|
X |
|
|