| |
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.
|
|
|
I'm dating a girl now.Evidently she's not aware of it.
-- Garry Shandling
|
|
|
|
|