|  |
FORMSQUE
GMBASE
Queue of mail-merged documents waiting to be sent.
| 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 |
- |
| FormNo |
Forms->RecID |
M-1 |
Links the queued form to the original form. |
| 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 |
|
 |
Do you want to
exchange links?
Click on my banner
for more information.
|
|
|
The statistics on sanity are that one out of every four Americans is suffering from some form of mental illness. Think of your three best friends. If they are okay, then it's you.
Jerry Seinfeld
|
|
|
|
|
This site is copyright © 2005 EnigmaWare Software Inc - 
