TruGOLDCRM Consulting

Finding Gold with your CRM

Google


GoldMine Table Structures.

INFOMINE

DBase Directory Location: GMBASE
Table Description: InfoCenter file—stores all data for the InfoCenter

Table Indexes
Name DBase Index SQL Index ID
INFOMINE UPPER(RECTYPE+LEFT(TSECTION,80)+LEFT(TOPIC,10) RECTYPE+U_TSECTION+U_TOPIC 57
INFOSORT SORTKEY SORTKEY 58
INFOTRAN RECTYPE+RECID RECTYPE+RECID 59
INFRECID RECID RECID 60

Table Relationships
Field
None

Table Fields Structure
Field Name Field Type Length Description
ACCOUNTNO String 20 Account Number of contact if linked
CREATEBY String 8 Creation User
RECTYPE String 10 Record Type (‘IO1’=Global, ‘P0’Username=Private to specified user)
SORTKEY String 20 Unique Sort Key. Formatted as date and time the record was created
TSECTION String 100 Section
TOPIC String 80 Topic
KEYWORDS String 80 Keywords
OPTIONS String 10 Options
OPTIONS1 String 20 Options1
OPTIONS2 String 20 Options2
LINKEDDOC Memo - Several parameters, each separated by two tildes (~~) before and a line feed (ASCII 10) after. Parameters include: SYNC={0/1 – No/Yes},
CREATETIME=YYYYMMDDHHMMSS, FILENAME={Full path of directory and linked file name}.
NOTES Memo - Notes (formatted as RTF)
USERREAD String 8 User/Group with read access (Blank=Public)
USERWRITE String 8 User/Group with write access (Blank=Public)
LASTUSER String 8 Last Modified By
LASTDATE Date - Last Modified Date
LASTTIME String 5 Last Modified Time
U_TSECTION String 100 Upper-case shadow of Section (SQL Only)
U_TOPIC String 80 Upper-case shadow of Topic (SQL Only)
RECID String 15 Record ID

Your IP Address is: 54.156.67.122