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«

Table Description: Contact history file—contains a record for each completed activity

Table Indexes
Name	SQL Index
CONTHIST	ACCOUNTNO+ONDATE+RECID
CONTHUSR	USERID+SRECTYPE+ONDATE+RECID
CNHRLINK	LOPRECID+ONDATE
CNHLSDT	LASTDATE
CNHRECID	RECID

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

Your IP Address is: 216.73.216.96

Questions Answered

Articles Written

Overall Points

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

Bare feet magnetize sharp objects so that they always point upward from the floor -- especially in the dark.

Darren Lawrence aka MrEnigma/AbsoluteGenius