User Tools
Add this page to your book 
Remove this page from your book 
Manage book (
Help Table of Contents
SPQ - Print Queue Entry
Module SPQ
Datafields
| Name | Helptext Description | Data Type | Len | Codetable |
|---|---|---|---|---|
| INR | Internal Unique ID | Text | 8 | |
| NAM | Name to Identify Document | Text | 40 | |
| DOCPTH | Document Path (relative to 'tmp' partition) | Text | 80 | |
| DOCFIL | Document Name (File ID) | Text | 32 | |
| DOCFXT | Format and File Extension | Text | 3 | |
| DOCETY | Entity ID that specifies letter head | Text | 8 | |
| CREDATTIM | Timestamp Created | Datetime | 15 | |
| USR | User ID | Text | 8 | |
| TEF | Technical Form | Text | 3 | <fixed-length> |
| CPYCNT | Number of Copies to print | Numeric | 4 | |
| PRTSTA | Print status | Text | 1 | Embedded |
| PRTSSNINR | INR of Session | Text | 8 | |
| PRTDATTIM | Timestamp Printed | Datetime | 15 | |
| PRTPRT | Printer on which the document was printed. | Text | 80 | |
| ETGEXTKEY | Entitygroup | Text | 8 |
Datafield Description and Properties
Datafield INR Internal Unique ID
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter of this table. The field INR is used to enable links from other tables to this table.
For contractdata the INR also links the two tables xxD and xxT as associated entries hold the same INR.
Datafield NAM Name to Identify Document
This field contains the descriptive name to identify the print request within selection lists.
Datafield DOCPTH Document Path (relative to 'tmp' partition)
Path where the document is stored. The path should be relative to the tmp partition of the application. If the path is specified absolute this document might not be relocated.
Datafield DOCFIL Document Name (File ID)
File ID of the document.
Datafield DOCFXT Format and File Extension
File extension of the document. This file extension is used to determine the type of document. The file extension is stored without the delimiting dot. To build the real file name DOCFIL has to be concatenated with a dot and with DOCFXT.
Typically TMF
Datafield DOCETY Entity ID that specifies letter head
Externally used descriptive key to identify an entity.
Datafield CREDATTIM Timestamp Created
The date and time when the print request was created.
Datafield USR User ID
This is the technical short name used to identify a user within an installation. Initially this is the user who created this print request. This user id is one of the filter criteria to determine who should execute the real printout.
Datafield TEF Technical Form
This field defines the technical form to be used for the real printout. This field is one of the filter criteria used for the selection of the printrequests. The valid values are defined in the embedded codetable in APF:TEF.
Datafield CPYCNT Number of Copies to print
Number of printouts.
Datafield PRTSTA Print status
If this field is not blank, then the entry will not be active or not printed. Possible values are: E = Error, P = Printed, queue empty = waiting.
Codetable
| Code | Text |
|---|---|
| Waiting | |
| P | Printed |
| E | Error occurred |
Datafield PRTSSNINR INR of Session
Session in which entry was printed.
Datafield PRTDATTIM Timestamp Printed
Date and time when this request was printed. The printer used for the real printout is stored in PRTPRT.
Datafield PRTPRT Printer on which the document was printed.
Printer on which the document was printed.
Datafield ETGEXTKEY Entitygroup
This field holds the external key of the owning entity group to identify the logical owner of this entry. This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the currently active entity group are visible to the user.
