TruGOLDCRM Consulting

Finding Gold with your CRM

Google


GoldMine Table Structures.

CONTSUPP - Automated Process Attached Event

RecType in Table: E
GoldMine Location: Attached Automated Process tracks.

All assigned AP tracks are stored in ContSupp. This stores the details of where the track is at, what the next event is, who assigned the track and more.

Definitions/Descriptions:
GoldMine Field: Field name when viewed in GoldMine. If blank, not visible in GoldMine.
User/System: Defines whether the User or the System sets and maintains this value.
Used For: The type of data stored in this field. If a value in single quotes (' '), this is the actual value stored in this field.

Fields In Use in GoldMine
Field Name GoldMine Field Type Field Used For
ACCOUNTNO   System AccountNo of Linked Company
RECTYPE   System E
CONTACT   System Date/Time AP was attached. In format:
YYYYMMDDHH:MM:SS
TITLE   System Link to Tracks.TrackNo for associated AP track.
CONTSUPREF Next Event System Next event to be triggered. Duplicate of Tracks.Name
DEAR      
PHONE     Duplicate of Tracks.Toption1.
EXT     Next Event Number. Duplicate of Tracks.EventNo.
FAX      
LINKACCT Last Event System Last time this event was processed. Format:
YYYYMMDD.
NOTES      
ADDRESS1 Process System Process name. Duplicate of Tracks.Name for header record of AP track.
ADDRESS2      
ADDRESS3      
CITY Action System Text description of next action type. Based on Tracks.ActnType.
STATE      
ZIP   System Username that assigned the track.
COUNTRY Trigger System Number of days until event is triggered. Based on
Tracks.NextActn.
MERGECODES      
STATUS      
LINKEDDOC      
LASTUSER      
LASTEDATE      
LASTTIME      
RECID   System Record ID

Your IP Address is: 54.156.67.122