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 |