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

NETUpdate Suite -
GMGoldLINK™ a new GoldMine API

   The home of IRCDominatorXT, NETUpdate automatic web update and GMGoldLINK the new GoldMine API

Hot Links

 Home Page
 My Forum
 Email Me
» My Shop

Site Menu

»Affiliate Market«
     »Featured Product


»GoldMine«
     »GoldFORM
     »GoldMine API
     »GoldMine Tables
     »Services
     »Downloads

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

»Fun Stuff«

Old Projects
»IRCDominatorXT«
     »Latest
     »Known Bugs
     »Using Passport
     »Trouble Shoot
     »Downloads
»Legend Of Mir2«
     »Server Config
     »Converter
     »Browser
     »Other

»Work In Progress«
Links

 Downloads

 

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
Information

Your IP Address is: 54.81.195.140

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


Never, NEVER play leapfrog with a Unicorn.

 

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

     
  This site is copyright © 2005 EnigmaWare Software Inc - Darren Lawrence aka MrEnigma/AbsoluteGenius