TruGOLDCRM Consulting

Finding Gold with your CRM

Google


GoldMine Table Structures.

CONTTLOG

DBase Directory Location: COMMON
Table Description: Log file of field/record changes to all COMMON tables. Used for synchronization.

Table Indexes
Name DBase Index SQL Index ID
CTLOGDAT TABLEID+SYNCSTAMP TABLEID+SYNCSTAMP -
CTLUSER USERID+TABLEID+FRECID USERID+TABLEID+FRECID -
CTLSTAMP SYNCSTAMP+TABLEID+FIELDNAME+FRECID SYNCSTAMP+TABLEID+FIELDNAME+FRECID -
CTLOGTRN TABLEID+FRECID+FIELDNAME TABLEID+FRECID+FIELDNAME -

Table Relationships
Field
None

Table Fields Structure
Field Name Field Type Length Description
SYNCSTAMP String 7 Date and time that the record was added to the contact set
LOGSTAMP String 7 Date and time that GoldMine recorded the activity
ACTION String 2 Code indicating action to take (New, Delete, Update)
TABLEID String 1 Code indicating table name
Value Description
& Contact1
Contact2
( ContSupp
) ContHist
* ContGrps
0 ContUDef
FRECID String 15 Record ID for the record affected
FIELDNAME String 10 Changed field name or action taken on record (New, Delete)
USERID String 9 License # or Username preceeded by tilde (~)

Your IP Address is: 54.145.16.43