Google
 
Return Home  
GoldMine web import forms and GoldMine API programming, Automatic Web Update software

NETUpdate Suite -
GMGoldLINK™ a new GoldMine API wrapper and GoldFORM the GoldMine webimport form builder

   The home of Enigma NETUpdate automatic web update, GoldFORM and GMGoldLINK a GoldMine API wrapper

Hot Links

» Home Page
» Forum Pages
» Email Me

Site Menu
»GoldMine«
     »GoldFORM
     »GMCrystalView
     »GoldMine API
     »GoldMine Tables
     »GoldMine INI
     »Downloads
     »Free Tools

»NETUpdate Suite«
     »Client
     »Admin Part1
     »Admin Part2
     »ActiveX
     »Features
     »News
     »Downloads
Old Projects
»Visual Basic Stuff«
     »CodeSmartX
     »PikLink
     »Links
»IRCDominatorXT«

»Work In Progress«
Links

» Downloads

Home

CONTSUPP - Details / Profiles

RecType in Table: P
GoldMine Location: Details Tab, Extended Tabs

This is the “catch all” location for storing any records that may exist multiple times for the associated contact. Examples of this might be Serial #s, Products purchased, Equipment used, etc. This tab is used for anything that does not fit well in custom fields in the Contact2 database. Each detail record can be “extended” to include 8 additional fields. In GoldMine, this is accessible via the Info tab of a Detail record. The Setup tab of this same Detail record identifies the field names for each of these 8 fields. You only need to save these once and they will be used for this same profile record (identified by the value in the Contact field) in the future. This information is stored in a Header record in the ContSupp table, identified by an H rectype (more details here).

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 Profile Name
TITLE Field 1 User Extended Detail Data
CONTSUPREF Reference User Reference
DEAR Field 4    
PHONE   System Link to Lookup.LookupSupp
EXT Field 7 User Extended Detail Data
FAX Field 5    
LINKACCT Field 2    
NOTES Notes User Notes
ADDRESS1 Field 10 User Extended Detail Data
ADDRESS2 Field 11 User Extended Detail Data
ADDRESS3 Field 12    
CITY Date User Create By, Date, Time (under Audit Tab)
STATE Field 8 User Extended Detail Data
ZIP Field 6 User Extended Detail Data
COUNTRY Field 3 User Extended Detail Data
MERGECODES Field 9    
STATUS   System Position 1 = ‘0’
Position 2 = ‘1’ if Notes, Otherwise 0
LINKEDDOC      
LASTUSER User User Audit Tab, Last Update Section
LASTEDATE Date User Audit Tab, Last Update Section
LASTTIME Time User Audit Tab, Last Update Section
RECID   System Record ID

Welcome

Enter a long URL and get it shortened using MyURL.online

Information

Your IP Address is: 54.242.94.204

Experts Exchange
#1
#2
#3
Questions Answered
Overall Points
Exchange Links
Do you want to
exchange links?
Click on my banner
for more information.

EnigmaWare Products - Home of IRCDominatorXT
Messages


Optimist: Someone who doesn't know all the facts yet.

 

Other great places to visit
   
Silver Sphere Designs
VPOP3 Mail Server Software  
 
Site Meter  
News

     
  This site is copyright © 2005-2008 EnigmaWare Software Inc