TruGOLDCRM Consulting

Finding Gold with your CRM

Google


GoldMine Table Structures.

CONTSUPP - E-Mail Addresses

RecType in Table: P
GoldMine Location: Details Tab, E-Mail Manager

All e-mail addresses are stored in this table. There are different variations of emails and below are the settings of the various fields that define them. The Contact field is always “E-Mail Address” and the ContSupRef field is always the e-mail address.

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 Link to Contact1 Record
RECTYPE   System P
CONTACT Detail User ‘E-Mail Address’
TITLE      
CONTSUPREF Reference User E-Mail Address
DEAR      
PHONE   System If Un-Attached E-Mail, the Lookup.LookupSupp value for E-Mail addresses
EXT      
FAX      
LINKACCT     If E-Mail of secondary contact, then RecID of that contact record.
NOTES      
ADDRESS1   User If E-Mail address is too long, this stores the remainder of the address.
ADDRESS2   User Contact name for addressing e-mail. Shown in <> when viewing the E-Mail address in the Reference field.
ADDRESS3      
CITY   User  
STATE      
ZIP   User Binary Switch

Position 1 = TEXT (0) or HTML (1)
Position 2 = Primary address (1) or normal (0)
Position 3 = Wrap Lines(1) no wrap (0)
Position 4 = MIME(1) or not MIME(0) - if set to 0 then position 1 must also be 0

e.g.

1001 = MIME and HTML Email
1101 = MIME and HTML Email - Primary
COUNTRY      
MERGECODES      
STATUS   System Blank if attached Address, If Un-attached, ‘00’
LINKEDDOC      
LASTUSER      
LASTEDATE      
LASTTIME      
RECID   System Record ID

Your IP Address is: 54.146.28.90