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

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

»Fun Stuff«

Old Projects
     »Known Bugs
     »Using Passport
     »Trouble Shoot
»Legend Of Mir2«
     »Server Config

»Work In Progress«




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


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

I married the first man I ever kissed. When I tell this to my children, they just about throw up.
~ Barbara Bush


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

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