Home > Technical > Table Definitions > 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. |
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. |
VARCHAR(600) |
The actual content of the message. Used for non-XML formatted messages. |
|
DTMCREATEDTIME |
DATETIME |
|
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) |