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 |