TruGOLDCRM Consulting

Finding Gold with your CRM

Google


GoldMine Table Structures.

CONTSUPP - Alerts

RecType in Table: A
GoldMine Location: Edit Menu | Record Properties, Alerts Tab

Each assigned alert generates a detail record in the ContSupp table. The Alert information is stored in the Notes field.

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 A
CONTACT      
TITLE      
CONTSUPREF      
DEAR      
PHONE      
EXT      
FAX      
LINKACCT      
NOTES   User/System See Below
ADDRESS1      
ADDRESS2      
ADDRESS3      
CITY      
STATE      
ZIP      
COUNTRY      
MERGECODES      
STATUS      
LINKEDDOC      
LASTUSER      
LASTEDATE      
LASTTIME      
RECID   System Record ID


Alert Code, the Username who assigned the alert and whether to log alerts in history. This field shows all alerts assigned to this record.

The format is as follows:

~ALERTCODE~USERNAME{Tab Character}{Log in History Code}{Line Feed Character} followed by the next alert, if any.

The third parameter is a blank space or ‘0’ if “Log Alert in History” is not selected. If “Log Alert” is selected, this parameter is ‘1’. So a typical Alert record might look like this:

~SH~JOE 0 ~TA~DAVE 1

Note, this identifies two alerts, one for SH and the other for TA. The second alert has been marked to log alerts made in history.


Your IP Address is: 54.146.28.90