| SalutationId |
Int32 |
|
N/A |
Salutation unique identifier |
| FirstName |
String |
|
N/A |
First Name |
| MiddleName |
String |
|
N/A |
Middle Name |
| LastName |
String |
✓ |
N/A |
Last Name |
| Address |
String |
|
N/A |
Customer Address |
| SecondAddress |
String |
|
N/A |
Second Address |
| SecondFirstName |
String |
|
N/A |
Second First Name |
| SecondMiddleName |
String |
|
N/A |
Second Middle Name |
| SecondLastName |
String |
|
N/A |
Second Last Name |
| ThirdAddress |
String |
|
N/A |
Third Address |
| Referal |
Int32 |
|
N/A |
Referal by id |
| Email |
String |
|
N/A |
Email |
| Mobile |
String |
|
N/A |
Mobile |
| HomePhone |
String |
|
N/A |
Home Phone |
| WorkPhone |
String |
|
N/A |
Work phone |
| WorkPhoneExt |
String |
|
N/A |
Work Phone Ext |
| FaxAttn |
String |
|
N/A |
Fax Attn |
| FaxLocation |
String |
|
N/A |
Fax Location |
| FaxPhone |
String |
|
N/A |
FaxPhone |
| City |
String |
|
N/A |
City |
| State |
String |
|
N/A |
State |
| Country |
String |
✓ |
N/A |
Country |
| County |
String |
|
N/A |
County |
| ZipCode |
String |
|
N/A |
Zip code |
| CallBackDate |
DateTime |
|
N/A |
Call back date |
| CallBackTime |
String |
|
N/A |
Call back time |
| CustAgeGroup |
String |
|
N/A |
Age group |
| EmpStatus |
Int32 |
|
N/A |
Employment Status |
| CustCitizenship |
String |
|
N/A |
Citizen ship |
| MaritalStatusId |
Int32 |
|
N/A |
Marital status Id |
| CustDOB |
DateTime |
|
N/A |
Date of birth |
| CustGender |
String |
|
N/A |
Gender |
| CustIncomeRange |
String |
|
N/A |
Income range |
| CustLanguageCode |
String |
✓ |
N/A |
Language code |
| CustOccupation |
String |
|
N/A |
Occupation |
| CustSSN |
String |
|
N/A |
SSN |
| InHouse_flag |
Boolean |
|
N/A |
In House |
| InHouse_Rep |
Int32 |
|
N/A |
In House Representative |
| LegacyKey |
String |
|
N/A |
Legacy Key |
| OriginalSalesPerson |
Int32 |
|
N/A |
Original Sales Person |
| PrivacyFlag |
Boolean |
|
N/A |
Privacy Flag |
| LastDispositionDate |
DateTime |
|
N/A |
Last Disposition Date |
| LastDispositionID |
Int32 |
|
N/A |
Last Disposition ID |
| DncEffectiveDate |
DateTime |
|
N/A |
Do not call Effective Date |
| DncFlag |
Boolean |
|
N/A |
Do not call flag |
| DncReason |
String |
|
N/A |
Do not call reason |
| DncTimeStamp |
DateTime |
|
N/A |
Do not call time stamp |
| DncUpdateBy |
String |
|
N/A |
Do not call update by |
| DnmEffectiveDate |
DateTime |
|
N/A |
Do not market call |
| DnmFlag |
Boolean |
|
N/A |
Do not market Flag |
| DnmReason |
String |
|
N/A |
Do not market reason |
| DnmTimeStamp |
DateTime |
|
N/A |
Do not market time stamp |
| DnmUpdatedBy |
String |
|
N/A |
Do not market updated by |
| SourceID |
Int32 |
|
N/A |
Source unique identifier |
| SourceDivisionID |
Int32 |
|
N/A |
Source Division |
| SourceGroupID |
Int32 |
|
N/A |
Source group unique identifier |
| SourceItemID |
Int32 |
|
N/A |
Source item unique identifier |
| SpouseAgeGroup |
String |
|
N/A |
Spouse age group |
| SpouseCitizenship |
String |
|
N/A |
Spouse citizen ship |
| SpouseDOB |
DateTime |
|
N/A |
Spouse date of birth |
| SpouseGender |
String |
|
N/A |
Spouse gender |
| SpouseIncomeRange |
String |
|
N/A |
Spouse income range |
| SpouseLanguageCode |
String |
|
N/A |
Spouse language code |
| SpouseOccupation |
String |
|
N/A |
Spouse occupation |
| EmpStatus2 |
Int32 |
|
N/A |
Spouse employment Status |
| NoChildren |
Int32 |
|
N/A |
No. of children |
| SpouseSSN |
String |
|
N/A |
Spouse SSN |