CONTHIST

Table Description: Contact history file—contains a record for each completed activity

Table Indexes
Name SQL Index  
CONTHIST ACCOUNTNO+ONDATE+RECID  
CONTHUSR USERID+SRECTYPE+ONDATE+RECID  
CNHRLINK LOPRECID+ONDATE  
CNHLSDT LASTDATE  
CNHRECID RECID  

Table Relationships
Field Related Table to Field Type Notes
AccountNo Contact1->AccountNo M-1  
LopRecID OpMgr->RecID M-1 Records related to opportunities/projects
RecID MailBox->LinkRecID 1-1  
LinkRecID MailBox->RecID 1-1  

Table Fields Structure
Field Name Field Type Length Description
USERID String 8 User
ACCOUNTNO String 20 Account Number. If '--' and the record is an Email then the email was linked but then subsequently unlinked
SRECTYPE String 1 First character of RecType
RECTYPE String 10 Record Type. Contains up to 5 characters. The following are definitions for each segment of this field. See Table Below
ONDATE Date 8 Action Date
ONTIME String 5 Action Time
ACTVCODE String 3 Activity Code
RESULTCODE String 3 Result Code
STATUS String 2 First character is flag, second char =1 if notes exist
DURATION String 8 Duration of activity. Formatted as hh:mm:ss. If none, either blank or ‘0’. Also used for forecasted sale value.
UNITS String 8 Units of a Forecasted Sale
REF String 65 Reference. Contact name is stored at end in parenthesis, preceeded by ‘oc:’.
Example: ‘This is the reference (oc: Bob Smith)’.
NOTES Image - Notes
LINKRECID String 15 E-Mail Linked Record ID
LOPRECID String 8 Linked Opportunity. Manager. Record
CREATEBY String 8 Creation User
CREATEON Date 8 Creation Date
CREATEAT String 6 Creation Time
LASTUSER String 8 Last Modified By
LASTDATE Date 8 Last Modified Date
LASTTIME String 6 Last Modified Time
RECID String 15 Record ID

RecType Field Definitions
Characters 1-2 (Record Type) Character 4 (Private, RSVP Flags)
Character Description Character Description
A Appointment (Space) Non-Private, Non-RSVP
C Phone call P Private
CC Call Back R RSVP
CI Incomming Call B Private and RSVP
CM Returned Message Character 5 (Colour of Original Activity)
CO Outgoing Call Character Description
D To-Do (Space) Blue (Default)
E Event ! Magenta
L Form " Red
M Sent Message # Cyan
MG E-Mail Message $ Green
MI Received E-mail % Yellow
MO Sent E-Mail & Dark Cyan
O Other ‘ (Apostrophe) White
S Sale ( Light Grey
T Next Action ) Maroon
U Unknown * Dark Green
Character 3 (Result of the Activity) + Dark Yellow
Character Description , Dark Blue
(Space) Successful - Purple
U Unsuccessful . Dark Grey
    / Black