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.
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|
|CONTACT||System||Date/Time AP was attached. In format:
|TITLE||System||Link to Tracks.TrackNo for associated AP track.|
|CONTSUPREF||Next Event||System||Next event to be triggered. Duplicate of Tracks.Name|
|PHONE||Duplicate of Tracks.Toption1.|
|EXT||Next Event Number. Duplicate of Tracks.EventNo.|
|LINKACCT||Last Event||System||Last time this event was processed. Format:
|ADDRESS1||Process||System||Process name. Duplicate of Tracks.Name for header record of AP track.|
|CITY||Action||System||Text description of next action type. Based on Tracks.ActnType.|
|ZIP||System||Username that assigned the track.|
|COUNTRY||Trigger||System||Number of days until event is triggered. Based on