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 API
     »GoldMine Tables
     »GoldMine INI
     »Free Tools

»NETUpdate Suite«
     »Admin Part1
     »Admin Part2
Old Projects
»Visual Basic Stuff«

»Work In Progress«

» Downloads



DBase Directory Location: COMMON
Table Description: Contact history file—contains a record for each completed activity

Table Indexes
Name DBase Index SQL Index ID

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
F Literature " Red
L Form # Cyan
M Sent Message $ Green
MG E-Mail Message % Yellow
MI Received E-mail & Dark Cyan
MO Sent E-Mail ‘ (Apostrophe) White
O Other ( Light Grey
S Sale ) Maroon
T Next Action * Dark Green
U Unknown + Dark Yellow
Character 3 (Result of the Activity) , Dark Blue
Character Description - Purple
(Space) Successful . Dark Grey
U Unsuccessful / Black


Enter a long URL and get it shortened using


Your IP Address is:

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

EnigmaWare Products - Home of IRCDominatorXT

File not found. Should I fake it? (Y/N)


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

  This site is copyright © 2005-2008 EnigmaWare Software Inc