TruGOLDCRM Consulting

Finding Gold with your CRM

Google


GoldMine Table Structures.

FORMSQUE

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: 54.158.253.134