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

CONTHIST

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

Table Indexes
Name DBase Index SQL Index ID
CONTHIST ACCOUNTNO+DTOS(ONDATE)+RECID ACCOUNTNO+ONDATE+RECID 33
CONTHUSR USERID+SRECTYPE+DTOS(ONDATE)+RECID USERID+SRECTYPE+ONDATE+RECID 34
CNHRLINK LOPRECID+DTOS(ONDATE) LOPRECID+ONDATE 35
CNHRECID RECID RECID 36

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

Welcome

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

Information

Your IP Address is: 54.198.134.104

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


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

 

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

     
  This site is copyright © 2005-2008 EnigmaWare Software Inc