|  |
CONTTLOG
Log file of field/record changes to all COMMON tables. Used for synchronization.
| CTLOGDAT |
TABLEID+SYNCSTAMP |
|
| CTLUSER |
USERID+TABLEID+FRECID |
|
| CTLSTAMP |
SYNCSTAMP+TABLEID+FIELDNAME+FRECID |
|
| CTLOGTRN |
TABLEID+FRECID+FIELDNAME |
|
| CTLFREC |
FRECID |
|
| CTLOGFRECF |
FRECID+FIELDNAME |
|
| 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 (~) |
|
 |
Do you want to
exchange links?
Click on my banner
for more information.
|
|
|
Laocoon's Law of Improbable Generosity:
Don't look a gift horse in the mouth, but do check for Greek soldiers elsewhere in its anatomy.
|
|
|
|
|
This site is copyright © 2005 EnigmaWare Software Inc - 
