|  |
CONTTLOG
COMMON
Log file of field/record changes to all COMMON tables. Used for synchronization.
| 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 |
- |
| 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.
|
|
|
The human mind is like a parachute - it functions best when it is open.
|
|
|
|
|
This site is copyright © 2005 EnigmaWare Software Inc - 
