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

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
Information

Your IP Address is: 35.172.201.102

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


If I'd known I was going to live this long, I'd have taken better care of myself.

-- Eubie Blake, on his 100th birthday

 

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