GoldMine Table Definitions

NETUpdate Suite -
GMGoldLINK™ a new GoldMine API

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

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

DBase Directory Location: GMBASE
Table Description: Queue of mail-merged documents waiting to be sent.

Table Indexes
Name	DBase Index	SQL Index	ID
FQDATE	RECTYPE+DTOS(ONDATE)+FORMNO+ROUTING	RECTYPE+ONDATE+FORMNO+ROUTING	-
FQFORMNO	FORMNO+RECTYPE+DTOS(ONDATE)	FORMNO+RECTYPE+ONDATE	-
FQUSERID	USERID+RECTYPE+DTOS(ONDATE)+ROUTING	USERID+RECTYPE+ONDATE+ROUTING	-
FQRECID	RECID	RECID	-

Table Relationships
Field	Related Table to Field	Type	Notes
FormNo	Forms->RecID	M-1	Links the queued form to the original form.

Table Fields Structure
Field Name	Field Type	Length	Description
RECTYPE	String	1	Record Type. Q=Queue record (standard).
ROUTING	String	1	Routing flag (where it’s going to) 0=Printer 1=Fax
FORMNO	String	15	Identifies form queued. Links to RecID of Forms table.
ACCOUNTNO	String	20	AccountNo of the Contact record that is queued. If the record is an additional contact, this is the RecID of the associated ContSupp record.
USERID	String	8	Username that queued this record.
ONDATE	Date	8	Date the queued form is scheduled to be run (printed, faxed, etc)
TRACKNO	String	15	If created by automated process, the RecID of the AP.
DIRCODE	String	10	If created by an AP, the File Code associated with the database (File \| Open Database - Properties - File Code).
CREATEBY	String	8	Username that created this record.
STATUS	String	1	If 1, record queued is an additional contact, if blank, a primary.
PRINTERID	String	60	Printer ID
PRTYID	String	15	Priority ID
LASTUSER	String	8	Last Modified By
LASTDATE	Date	8	Last Modified Date
LASTTIME	String	5	Last Modified Time
RECID	String	15	Record ID

Your IP Address is: 216.73.216.59

Questions Answered

Articles Written

Overall Points

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

Life is what happens to you while you're making other plans.

Darren Lawrence aka MrEnigma/AbsoluteGenius