CAL

Table Description: Calendar file— contains a record for each scheduled activity. The different record types are distinguished by the contents of the RECTYPE field. Different RECTYPEs may use each field for a different purpose.

Table Indexes
Name SQL Index  
CAL RECTYPE+USERID+ONDATE+ONTIME+RECID  
CALCONT ACCOUNTNO+RECTYPE+ONDATE+ONTIME+RECID  
CALDATE USERDATE+ONDATE+ONTIME+RECID  
CALPROB RECTYPE+USERID  
CALALARM ALARMFLAG+USERID+ALARMDATE+ALARMTIME  
CALRLINK LOPRECID+RECTYPE+ONDATE+ONTIME  
CALLINKRECID LINKRECID  
CNURECID RECID  

Table Relationships
Field Related Table to Field Type Notes
AccountNo Contact1->AccountNo M-1 Only for activities linked to a contact record
RecID MailBox->LinkRecID 1-1  
LinkRecID MailBox->RecID 1-1  
LopRecID OpMgr->RecID M-1 Records related to opportunities/projects

Table Fields Structure
Field Name Field Type Length Description
USERID String 8 User Name or resource
ACCOUNTNO String 20 Account Number of linked contact. If blank, record is un-linked (typical of to-dos). If formatted as ‘PB:’Username then pegboard information. If '--' and the record is an Email then the email was linked but then subsequently unlinked
ONDATE Date 8 Activity Date
ONTIME String 5 Activity Time
ENDDATE Date 8 Ending date of scheduled activity
ALARMFLAG String 1 Alarm Flag (Y/N)
ALARMTIME String 5 Alarm Time
ALARMDATE Date 8 Alarm Date
ACTVCODE String 3 Activity Code
RSVP String 1 RSVP Notification (Y/N)
DURATION Integer 2 Duration (time in total minutes)/Forecasted sale probability
RECTYPE String 1 Record Type. Possible values are listed below.
Value Description
A Appointment
C Call Back
D To-do
E Event
M Message
O Other
Q Queued e-mail
S Sales potential
T Next action
{Blank} Peg Board record
ACONFIRM String 3 Meeting Confirmation
APPTUSER String 10 Meeting Confirmation User (Character 10 indicates color – options listed below)
Value Description
(Space) Blue (Default)
! Magenta
" Red
# Cyan
$ Green
% Yellow
& Dark Cyan
‘ (Apostrophe) White
( Light Grey
) Maroon
* Dark Green
+ Dark Yellow
, Dark Blue
- Purple
. Dark Grey
/ Black
STATUS String 4 First character is flag, second char =1 if notes exist
DIRCODE String 10 DirCode of the current contact file
EXT String 3 Notes Text Type "html" for Html style note content
NUMBER1 Integer/Float 8 Sales Potential. Also used to mark private records, if value is ‘16’.
NUMBER2 Integer/Float 8 Units of a Forecasted Sale
COMPANY String 60 Company/Contact Name (also used for pegboard times)
REF String 80 Reference
NOTES Image - Notes
LINKRECID String 15 Linked Record ID
LDOCRECID String 15 Reserved for future use
LOPRECID String 15 Linked Opportunity Manager Record ID
CREATEBY String 8 Created by 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 5 Last Modified Time
SERVICE Text -  
RECID String 15 Record ID