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.
|
||||||||||||||||||||||||||||||||||||||||||
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. |