GoldMine Table Structures.
DBase Directory Location: GMBASE
Table Description: GoldSync Log File
|Name||DBase Index||SQL Index||ID|
|Table Fields Structure|
|Field Name||Field Type||Length||Description|
|RECTYPE||String||1||Record type of this log entry.
S=Log entry, Params contains entire log.
|ACCOUNTNO||String||20||Account Number of linked contact|
|TABLEID||String||1||Code indicating table in which action occurred.
|FRECID||String||15||RecID in table. This identifies the specific record affected.|
|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.|
|FIELDNAME||String||10||Fieldname that was changed or code indicating type of New or Deleted record. Codes used are listed below.
|OLDVALUE||String||40||Old Field Value|
|NEWVALUE||String||40||New Field Value|
|PARAMS||Memo||-||Contains entire log for ‘S’ RecTypes and other settings including license number for ‘D’ RecTypes.|