Home > Technical > Table Definitions > TILLOUTREQUESTDETAIL

TILLOUTREQUESTDETAIL

Contains specific messages to be sent to POS. Programs will write general requests to TILLOUTREQUEST and TillIncoming.exe will process these records into TILLOUTREQUESTDETAIL records. So one TILLOUTREQUEST record for a location will result in one TILLOUTREQUESTDETAIL for each POS in the location.

Column

Type

Description

STRTILLCODE

VARCHAR(10)

The till to which this record belongs.
TILL.strTillCode

CTRCODE

INT

A unique number assigned by the system.

INTUPDATECODE

INT

For new records this will be 0. When POS picks up the records, it will write a number to this field to show it has been processed.

DTMCREATED

DATETIME

The date the record was created.

DTMPROCESSED

DATETIME

The date/time the record was picked up by the POS.

STRTYPE

VARCHAR(10)

The type of data contained in STRMESSAGE/ memFullMessage.

STRMESSAGE

VARCHAR(600)

The actual content of the message. Used for non-XML formatted messages.

DTMCREATEDTIME

DATETIME

 

MEMFULLMESSAGE

TEXT

The actual content of the message. Used for XML formatted messages.

 

Primary Key: STRTILLCODE + INTUPDATECODE + CTRCODE

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)