TruGOLDCRM Consulting

Finding Gold with your CRM

Google


GoldMine Table Structures.

CONTSUPP - Web Addresses

RecType in Table: P
GoldMine Location: Details Tab, Web Site Address

All web addresses are stored in this table. There are different variations of web addresses and below are definitions of how they are stored. The Contact field is always “Web Site” and the ContSupRef field is usually the web 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 ‘Web Site’
TITLE      
CONTSUPREF Reference User Web Site Address (See NOTES)
DEAR      
PHONE   System If Primary address, ‘mProfRef’, otherwise Lookup.LookupSupp value for Web Site.
EXT      
FAX      
LINKACCT      
NOTES   User If the entire web site address will exceed 40 characters,
the user must put the entire address in the Notes field instead.
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      
STATE      
ZIP      
COUNTRY      
MERGECODES      
STATUS   System ‘00’ for all addresses except those with address in Notes field, then ‘01’
(see Detail/Profile use of this field above).
LINKEDDOC      
LASTUSER      
LASTEDATE      
LASTTIME      
RECID   System Record ID

Your IP Address is: 54.158.253.134