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.