Table of Contents

SPQ - Print Queue Entry

Module SPQ

Description

Printqueue of print requests handled via remote client printing.


Datafields

Name Description Data Type Len Dec. View lines View type Inst. Visible Codetable
INR Internal Unique ID of Queue Entry Text 8 1 Edit Yes Public
NAM Name to Identify Document Text 40 1 Edit Yes Public
DOCPTH Document Path (relative to 'data' partition) Text 80 1 Edit Yes Public
DOCFIL Document Name (File ID) Text 32 1 Edit Yes Public
DOCFXT Format and File Extension Text 3 1 Edit Yes Public
DOCETY Entity ID that specifies letter head Text 8 1 Edit Yes Public
CREDATTIM Timestamp Created Datetime 15 0 Unknown Yes Public
USR User ID Text 8 1 Edit Yes Public
TEF Technical Form Text 3 1 Edit Yes Public <fixed-length>
CPYCNT Number of Copies to print Numeric 4 0 Edit Yes Public
PRTSTA Item is printed Text 1 1 Edit Yes Public Embedded
PRTSSNINR INR of Session Text 8 1 Edit Yes Public
PRTDATTIM Timestamp Printed Datetime 15 0 Unknown Yes Public
PRTPRT Printer on which document was printed Text 80 1 Edit Yes Public
ETGEXTKEY Entity Group of Print Queue Entry Text 8 1 Edit Yes Public

Indices

Name Fields Properties
SPQ_ETGEXTKEY ETGEXTKEY

/


Lock

INR

Datafield Description and Properties


Datafield INR Internal Unique ID

Description

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 SPQ. The field INR is used to maintain links from other tables into this table.

Helpinformation

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

Description

This field contains the descriptive name to identify the print request within selection lists.

Helpinformation

This field contains the descriptive name to identify the print request within selection lists.


Datafield DOCPTH Document Path (relative to 'tmp' partition)

Description

Path where the document is stored. The path should be relative to the data partition of the application. If the path is specified absolute this document might not be relocated.

Helpinformation

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)

Description

File ID of the document.

Helpinformation

File ID of the document.


Datafield DOCFXT Format and File Extension

Description

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

Helpinformation

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

Description

Externally used descriptive key to identify an entity.

Helpinformation

Externally used descriptive key to identify an entity.


Datafield CREDATTIM Timestamp Created

Description

The date and time when the print request was created.

Helpinformation

The date and time when the print request was created.


Datafield USR User ID

Description

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.

Helpinformation

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

Description

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.

Helpinformation

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

Description

Number of printouts.

Helpinformation

Number of printouts.


Datafield PRTSTA Print status

Description

If set to a non empty content the entry is not active anymore (i.e. printed). To reactivate the entry the flag has to be cleared.

Helpinformation

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

Description

Session in which entry was printed.

Helpinformation

Session in which entry was printed.


Datafield PRTDATTIM Timestamp Printed

Description

Date and time when this request was printed. The printer used for the real printout is stored in PRTPRT.

Helpinformation

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.

Helpinformation

Printer on which the document was printed.


Datafield ETGEXTKEY Entitygroup

Description

This table is defined on entity group level with separate entries for each entity group. This field holds the EXTKEY of the entity group which is 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 entity group of the currently active entity are visible to the user.

Helpinformation

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.