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

Home

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
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	Date	3	Activity Code
RESULTCODE	String	3	Result Code
STATUS	Date	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	Memo	15	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

I Hope you find something usefull here

Your IP Address is: 38.103.63.56

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

Marriage certificate is just another word for a work permit.