Field
Name: |
Type: |
Length: |
Index: |
Description: |
| CON_SEQ |
Sequence |
|
|
|
| CON_C_NUM |
char |
10 |
|
client number (if a client contact) |
| CON_V_NUM |
char |
10 |
|
vendor number (if a vendor contact) |
| CON_KIND |
short int |
(0 to 255) |
|
/0=Past client/1=Current client/2=Hot! lead/3=Prospect/4=Cu
rious/5=Cold Call/10=Vendor |
| CON_FIRST_NAME |
National |
25 |
|
first name |
| CON_LAST_NAME |
National |
40 |
|
last name |
| CON_MID_INITIAL |
char |
5 |
|
middle initial (optional) |
| CON_SAL |
char |
20 |
|
saluatation |
| CON_TITLE |
char |
25 |
|
person's title |
| CON_DECISION_MAKER |
short int |
(0 to 255) |
|
yes/no |
| CON_PHONE_WORK |
char |
20 |
|
the contact's direct line |
| CON_PHONE_HOME |
char |
20 |
|
home phone |
| CON_PHONE_MOBILE |
char |
20 |
|
mobile number |
| CON_FAX_WORK |
char |
20 |
|
work fax number |
| CON_PAGER |
char |
20 |
|
pager number |
| CON_NOTE |
char |
2000 |
|
notes/comments |
| CON_EMAIL_WORK |
char |
40 |
|
work e-mail address |
| CON_EMAIL_HOME |
char |
40 |
|
home/personal e-mail address |
| CON_DATE_ADDED |
Short date |
1980..2079 |
|
date the contact was added |
| CON_ADDED_BY |
char |
4 |
|
who added contact - initials |
| CON_LAST_CALL |
Date and time |
(#FDT) |
|
date/time of last call with this person |
| CON_LAST_BY |
char |
4 |
|
initials of person who made the last call |
| CON_FAX_HOME |
char |
20 |
|
home fax number |
| CON_SALES_EMAIL |
short int |
(0 to 255) |
|
ok to send sales e-mail? |
| CON_ORG |
National |
100 |
|
organization name |
| CON_FULL_NAME |
char |
66 |
4 |
first name + last name |
| CON_ADDRESS1 |
char |
60 |
|
this contact's address 1 (if blank, C_ADDRESS1 will be used) |
| CON_ADDRESS2 |
char |
60 |
|
|
| CON_ADDRESS3 |
char |
60 |
|
|
| CON_ADDRESS4 |
char |
60 |
|
|
| CON_ADDRESS5 |
char |
60 |
|
|
| CON_ADDRESS6 |
char |
60 |
|
|
