GoldMine Table Definitions

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 Enigma NETUpdate automatic web update, GoldFORM and GMGoldLINK the new GoldMine API wrapper

» Home Page
» Forum Pages
» Email Me
» Online eShop

»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«

» Downloads

Home

CONTSUPP

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	SQL Index
CONTSUPP	ACCOUNTNO+RECTYPE+U_CONTACT+RECID
CONTSPFD	RECTYPE+U_CONTACT+U_CONTSUPREF
CNTSUPADDR	RECTYPE+U_ADDRESS1
CSUPREFIDX	U_CONTSUPREF
CNSRECID	RECID

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

Table Fields Structure

ACCOUNTNO

String

Account Number

RECTYPE

String

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

Contact Name

TITLE

String

Contact Title

CONTSUPREF

String

Reference

DEAR

String

Dear (Salutation)

PHONE

String

Phone

EXT

String

Phone Extension

FAX

String

Fax number

LINKACCT

String

Linked Account

NOTES

Memo

Notes

ADDRESS1

String

Additional Contact Address 1

ADDRESS2

String

Additional Contact Address 2

ADDRESS3

String

Additional Contact Address 3

CITY

String

Additional Contact City

STATE

String

Additional Contact State

ZIP

String

Additional Contact Zip (Post Code)

COUNTRY

String

Additional Contact Country

MERGECODES

String

Merge Codes

STATUS

String

First character is flag, second char =1 if notes exist

LINKEDDOC

Memo

Linked Document

LASTUSER

String

Last Modified By

LASTEDATE

Date

Last Modified Date

LASTTIME

String

Last Modified Time

U_CONTACT

String

Upper-case shadow of Contact Name

U_CONTSUPREF

String

Upper-case shadow of Reference

U_ADDRESS1

String

Upper-case shadow of Address1

RECID

String

Record ID

Questions Answered

Articles Written

Overall Points

Do you want to
exchange links?
Click on my banner
for more information.

Why is the man who invests all your money called a broker?
George Carlin

Your IP Address is: 38.107.179.210