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

NETUpdate Suite -
GMGoldLINK™ a new GoldMine API

   The home of IRCDominatorXT, NETUpdate automatic web update and GMGoldLINK the new GoldMine API

Hot Links

» Home Page
» My Forum
» Email Me
» My Shop

Site Menu

»Affiliate Market«
     »Featured Product


»GoldMine«
     »GoldFORM
     »GoldMine API
     »GoldMine Tables
     »Services
     »Downloads

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

»Fun Stuff«

Old Projects
»IRCDominatorXT«
     »Latest
     »Known Bugs
     »Using Passport
     »Trouble Shoot
     »Downloads
»Legend Of Mir2«
     »Server Config
     »Converter
     »Browser
     »Other

»Work In Progress«
Links

» Downloads

 

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


Welcome
Information

Your IP Address is: 18.218.184.214

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


Handwritten on a condom machine; "This gum tastes funny"

 

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

     
  This site is copyright © 2005 EnigmaWare Software Inc - Darren Lawrence aka MrEnigma/AbsoluteGenius