TruGOLDCRM Consulting

Finding Gold with your CRM

Google


GoldMine Table Structures.

CAL

DBase Directory Location: GMBASE
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 DBase Index SQL Index ID
CAL RECTYPE+USERID+DTOS(ONDATE)+ONTIME RECTYPE+USERID+ONDATE+ONTIME+RECID 02
CALCONT ACCOUNTNO+RECTYPE+DTOS(ONDATE)+ONTIME ACCOUNTNO+RECTYPE+
ONDATE+ONTIME+RECID
03
CALDATE USERID+DTOS(ONDATE)+ONTIME USERDATE+ONDATE+ONTIME+RECID 04
CALPROB RECTYPE+USERID+STR(999-DURATION,3) RECTYPE+USERID 05
CALALARM ALARMFLAG+USERID+
DTOS(ALARMDATE)+ALARMTIME
ALARMFLAG+USERID+ALARMDATE+ALARMTIME 06
CALRLINK LOPRECID+RECTYPE+DTOS(ONDATE)+ONTIME LOPRECID+RECTYPE+ONDATE+ONTIME 07
CNURECID RECID RECID 08

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 3 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
NUMBER1 Integer 8 Sales Potential. Also used to mark private records, if value is ‘16’.
NUMBER2 Integer 8 Units of a Forecasted Sale
COMPANY String 60 Company/Contact Name (also used for pegboard times)
REF String 80 Reference
NOTES Memo - 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
RECID String 15 Record ID

 


Your IP Address is: 54.145.16.43