GoldMine Table Definitions

NETUpdate Suite -
GMGoldLINK™ a new GoldMine API

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

»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«

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

Your IP Address is: 216.73.216.59

Questions Answered

Articles Written

Overall Points

Do you want to
exchange links?
Click on my banner
for more information.

The attention span of a computer is only as long as its electrical cord.

Darren Lawrence aka MrEnigma/AbsoluteGenius