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

DBase Directory Location: COMMON
Table Description: Supplementary contact set—contains a record for each additional contact record, referral and profile record. The different record types are distinguished by the contents of the RecType field. Different RecTypes may use each field for a different purpose. See the pages following this for details about each RecType and the fields it uses.

Table Indexes
Name DBase Index SQL Index ID
CONTSUPP ACCOUNTNO+RECTYPE+UPPER(CONTACT) ACCOUNTNO+RECTYPE+U_CONTACT+RECID 30
CONTSPFD UPPER(RECTYPE+CONTACT+CONTSUPREF) RECTYPE+U_CONTACT+U_CONTSUPREF 31
CNSRECID RECID RECID 32

Table Relationships
Field Related Table to Field Type Notes
AccountNo Contact1->AccountNo M-1  

Table Fields Structure
Field Name Field Type Length Description
ACCOUNTNO String 20 Account Number
RECTYPE String 1 Record Type
Value Description
A Assigned Alert
C Additional contact record
E Automated Process attached event
H Extended profile header
L Linked document
O Organizational chart
P Profile record/extended profile record
R Referral record
CONTACT String 30 Contact Name - Since GoldMine 8.5x the Length has been changed to 40
TITLE String 35 Contact Title
CONTSUPREF String 35 Reference
DEAR String 20 Dear (Salutation)
PHONE String 20 Phone
EXT String 6 Phone Extension
FAX String 20 Fax number
LINKACCT String 20 Linked Account
NOTES Memo - Notes
ADDRESS1 String 40 Additional Contact Address 1
ADDRESS2 String 40 Additional Contact Address 2
ADDRESS3 String 40 Additional Contact Address 3
CITY String 30 Additional Contact City
STATE String 20 Additional Contact State
ZIP String 10 Additional Contact Zip (Post Code)
COUNTRY String 20 Additional Contact Country
MERGECODES String 20 Merge Codes
STATUS String 4 First character is flag, second char =1 if notes exist
LINKEDDOC Memo 10 Linked Document
LASTUSER String 8 Last Modified By
LASTEDATE Date 8 Last Modified Date
LASTTIME String 5 Last Modified Time
U_CONTACT String 30 Upper-case shadow of Contact Name (SQL Only)
U_CONTSUPREF String 35 Upper-case shadow of Reference (SQL Only)
RECID String 15 Record ID

Welcome

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

Information

Your IP Address is: 54.80.123.20

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


Wedding: A funeral where you smell your own flowers.

 

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

     
  This site is copyright © 2005-2008 EnigmaWare Software Inc