TruGOLDCRM Consulting

Finding Gold with your CRM

Google


GoldMine Table Structures.

GMTLOG

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

NOTE: Some table changes do not generate GMTLog entries.

Table Indexes
Name DBase Index SQL Index ID
GTLOGDAT TABLEID+SYNCSTAMP TABLEID+SYNCSTAMP -
GTLOGTRN TABLEID+FRECID+FIELDNAME TABLEID+FRECID+FIELDNAME -

Table Relationships
Field
None

Table Fields Structure
Field Name Field Type Length Description
SYNCSTAMP String 7 Encrypted date and time that the activity occurred during processing.
LOGSTAMP String 7 Encrypted date and time that GoldSync or GoldMine recorded the activity.
ACTION String 2 Code indicating action taken ((N)ew, (D)elete, (U)pdate)
TABLEID String 1 Code indicating table in which action occurred.
Value Description
“ (quote) Cal
R Cases (GoldMine 8.5.x)
6 Fields5
+ Filters
# Forms
2 ImpExp
3 InfoMine
! (exclamation) Lookup
; (semi-colon) MailBox
W Notes (GoldMine 8.5.x)
B OpMgr
/ PerPhone
5 Report32
1 ResItems
4 Scriptsw
 - (hyphen) SpFiles
= Syslog
7 Tracks
9 UserLog
. (period) Users
FRECID String 15 RecID in table. This identifies the specific record affected.
FIELDNAME String 10 Fieldname that was changed or code indicating type of New or Deleted record. Codes used are listed below.
     zsNew
     zzNew
     zzzDel
     zzzDelCOMP
USERID String 9 Username (preceeded by a tilde ‘~’) or license # that created this record.

Your IP Address is: 54.146.28.90