|  |
CONTSUPP
COMMON
Supplementary contact set—contains a record for each additional contact record, referral and
profile record. The different record types are distinguished by the contents of the RecType field.
Different RecTypes may use each field for a different purpose. See the pages following this for
details about each RecType and the fields it uses.
| CONTSUPP |
ACCOUNTNO+RECTYPE+UPPER(CONTACT) |
ACCOUNTNO+RECTYPE+U_CONTACT+RECID |
30 |
| CONTSPFD |
UPPER(RECTYPE+CONTACT+CONTSUPREF) |
RECTYPE+U_CONTACT+U_CONTSUPREF |
31 |
| CNSRECID |
RECID |
RECID |
32 |
| AccountNo |
Contact1->AccountNo |
M-1 |
|
| ACCOUNTNO |
String |
20 |
Account Number |
| RECTYPE |
String |
1 |
Record Type
|
| CONTACT |
String |
30 |
Contact Name - Since GoldMine 8.5x the Length has been changed to 40 |
| TITLE |
String |
35 |
Contact Title |
| CONTSUPREF |
String |
35 |
Reference |
| DEAR |
String |
20 |
Dear (Salutation) |
| PHONE |
String |
20 |
Phone |
| EXT |
String |
6 |
Phone Extension |
| FAX |
String |
20 |
Fax number |
| LINKACCT |
String |
20 |
Linked Account |
| NOTES |
Memo |
- |
Notes |
| ADDRESS1 |
String |
40 |
Additional Contact Address 1 |
| ADDRESS2 |
String |
40 |
Additional Contact Address 2 |
| ADDRESS3 |
String |
40 |
Additional Contact Address 3 |
| CITY |
String |
30 |
Additional Contact City |
| STATE |
String |
20 |
Additional Contact State |
| ZIP |
String |
10 |
Additional Contact Zip (Post Code) |
| COUNTRY |
String |
20 |
Additional Contact Country |
| MERGECODES |
String |
20 |
Merge Codes |
| STATUS |
String |
4 |
First character is flag, second char =1 if notes exist |
| LINKEDDOC |
Memo |
10 |
Linked Document |
| LASTUSER |
String |
8 |
Last Modified By |
| LASTEDATE |
Date |
8 |
Last Modified Date |
| LASTTIME |
String |
5 |
Last Modified Time |
| U_CONTACT |
String |
30 |
Upper-case shadow of Contact Name (SQL Only) |
| U_CONTSUPREF |
String |
35 |
Upper-case shadow of Reference (SQL Only) |
| RECID |
String |
15 |
Record ID |
|
 |
Do you want to
exchange links?
Click on my banner
for more information.
|
|
|
The law of probable dispersal:
Whatever hits the fan will not be evenly distributed.
|
|
|
|
|
This site is copyright © 2005 EnigmaWare Software Inc - 
