TruGOLDCRM Consulting

Finding Gold with your CRM

Google


GoldMine Table Structures.

CONTSUPP - Detail Header Records

RecType in Table: H
GoldMine Location: Used by Detail Records (Not visible)

Contains the information for extended detail tabs (see here). This includes the names of the fields as well as the width of columns. Extended detail tabs are viewable by clicking the small arrows to the right of the tabs. They are created by entering field names under the Setup tab of a Detail record. The column widths are set by adjusting the column widths, then opening the Detail record, clicking the Setup tab and checking the option to “Save Tab column positions”.

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 ‘H’ and Lookup.LookupSupp value
RECTYPE   System H
CONTACT      
TITLE      
CONTSUPREF   System Profile Name/Tab Name
DEAR      
PHONE   System ‘0’ if there is a tab name
EXT      
FAX      
LINKACCT      
NOTES   User/System Field Labels
ADDRESS1      
ADDRESS2      
ADDRESS3      
CITY      
STATE      
ZIP      
COUNTRY   User/System Column Widths
MERGECODES      
STATUS      
LINKEDDOC      
LASTUSER      
LASTEDATE      
LASTTIME      
RECID   System Record ID

Your IP Address is: 54.158.253.134