Google
 
Return Home  
GoldMine web import forms and GoldMine API programming, Automatic Web Update software

NETUpdate Suite -
GMGoldLINK™ a new GoldMine API wrapper and GoldFORM the GoldMine webimport form builder

   The home of Enigma NETUpdate automatic web update, GoldFORM and GMGoldLINK a GoldMine API wrapper

Hot Links

» Home Page
» Forum Pages
» Email Me

Site Menu
»GoldMine«
     »GoldFORM
     »GMCrystalView
     »GoldMine API
     »GoldMine Tables
     »GoldMine INI
     »Downloads
     »Free Tools

»NETUpdate Suite«
     »Client
     »Admin Part1
     »Admin Part2
     »ActiveX
     »Features
     »News
     »Downloads
Old Projects
»Visual Basic Stuff«
     »CodeSmartX
     »PikLink
     »Links
»IRCDominatorXT«

»Work In Progress«
Links

» Downloads

Home

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 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
RECID String 15 Record ID


Welcome

Enter a long URL and get it shortened using MyURL.online

Information

Your IP Address is: 54.80.123.20

Experts Exchange
#1
#2
#3
Questions Answered
Overall Points
Exchange Links
Do you want to
exchange links?
Click on my banner
for more information.

EnigmaWare Products - Home of IRCDominatorXT
Messages


DEFINITION OF THE DAY:

ILLEGAL: A sick bird.

 

Other great places to visit
   
Silver Sphere Designs
VPOP3 Mail Server Software  
 
Site Meter  
News

     
  This site is copyright © 2005-2008 EnigmaWare Software Inc