TruSoft Consulting

CONTSUPP - Additional Contacts

RecType in Table: C
GoldMine Location: Contacts Tab

Most of the field names in this table are designed for additional contacts. There is one field you will not see in this table that you will see when looking at the additional contacts screen in GoldMine – that is, the e-mail address. This is handled as a separate ContSupp record and is described in more detail here. For the most part, the other fields on the screen in GoldMine matchup with the fields in this table.

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	C
CONTACT	Name	User	Contact Name
TITLE	Title	User	Title
CONTSUPREF	Ref	User	Reference
DEAR	Dear	User	Salutation
PHONE	Phone	User	Phone Number
EXT		User	Phone Extension
FAX	Fax	User	Fax Number
LINKACCT
NOTES	Notes	User	Notes
ADDRESS1	Address 1	User	Address Line 1
ADDRESS2	Address 2	User	Address Line 2
ADDRESS3	Address 3	User	Address Line 3
CITY	City	User	City
STATE	State / County	User	State / County
ZIP	Zip / Post Code	User	Zip / Post Code
COUNTRY	Country	User	Country
MERGECODES	Mail Merge Codes	User	Merge Code
STATUS		System	Position 1 = ‘1’ if Email Address, Otherwise 0 Position 2 = ‘1’ if Notes, Otherwise 0
LINKEDDOC
LASTUSER
LASTEDATE
LASTTIME
RECID		System	Record ID