|  |
CONTSUPP
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+U_CONTACT+RECID |
|
| CONTSPFD |
RECTYPE+U_CONTACT+U_CONTSUPREF |
|
| CNTSUPADDR |
RECTYPE+U_ADDRESS1 |
|
| CSUPREFIDX |
U_CONTSUPREF |
|
| CNSRECID |
RECID |
|
| AccountNo |
Contact1->AccountNo |
M-1 |
|
| ACCOUNTNO |
String |
20 |
Account Number |
| RECTYPE |
String |
1 |
Record Type
|
| CONTACT |
String |
40 |
Contact Name |
| 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 |
- |
Linked Document |
| LASTUSER |
String |
8 |
Last Modified By |
| LASTEDATE |
Date |
8 |
Last Modified Date |
| LASTTIME |
String |
5 |
Last Modified Time |
| U_CONTACT |
String |
40 |
Upper-case shadow of Contact Name |
| U_CONTSUPREF |
String |
35 |
Upper-case shadow of Reference |
| U_ADDRESS1 |
String |
40 |
Upper-case shadow of Address1 |
| RECID |
String |
15 |
Record ID |
|
 |
Do you want to
exchange links?
Click on my banner
for more information.
|
|
|
Wedding: A funeral where you smell your own flowers.
|
|
|
|
|
This site is copyright © 2005 EnigmaWare Software Inc - 
