CONTSUPP

Table Description: 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.

Table Indexes
Name SQL Index  
CONTSUPP ACCOUNTNO+RECTYPE+U_CONTACT+RECID  
CONTSPFD RECTYPE+U_CONTACT+U_CONTSUPREF  
CNTSUPADDR RECTYPE+U_ADDRESS1  
CSUPREFIDX U_CONTSUPREF  
CNSRECID RECID  

Table Relationships
Field Related Table to Field Type Notes
AccountNo Contact1->AccountNo M-1  

Table Fields Structure
Field Name Field Type Length Description
ACCOUNTNO String 20 Account Number
RECTYPE String 1 Record Type
Value Description
A Assigned Alert
C Additional contact record
E Automated Process attached event
H Extended profile header
L Linked document
O Organizational chart
P Profile record/extended profile record
R Referral record
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