Home > Technical > Table Definitions > TILLOUTREQUEST

TILLOUTREQUEST

This tables stores requests for various data that needs to be send down to POS, for example item updates. These are processed by TillIncoming.exe which will generate specific TILLOUTREQUESTDETAIL records. The POS will then pick up its own TILLOUTREQUESTDETAIL records. TILLOUTREQUEST records only contain a key of the data to be processed. TillIncoming.exe will read the relevant data and write TILLOUTREQUESTDETAIL records that have the full data details.

Column

Type

Description

INTUPDATECODE

INT

When the record is first created, this will be 0. When it has been processed, it will be set to a unique number by the system.

CTRCODE

INT

A unique number assigned by the system.

DTMCREATED

DATETIME

The date the request was created.

DTMPROCESSED

DATETIME

The date/time the record was processed.

STRTYPE

VARCHAR(10)

The type of action to be processed.

AUSER  

Details about a specific user

CRELOAD  

Request a configuration reloads

DISC  

Details about a specific discount

ITEMPOSM  

Details about a specific item POS message

LEVEL  

Change the POS price level.

MSG  

Details about a specific POS BE message

PRELOAD  

Request a prepared reloads

REBOOT  

Request reboots of the POS hardware

RELOAD  

Request a full reload

SHUTDOWN  

Request a shutdown of the POS computer

RESTART  

Request a restart of the POS software

RETAX  

Tells POS to change to a different tax system

TRIP  

Change to a specific trip

UPDATE  

Notify POS that software updates are available to be downloaded.

UPDATEMED  

Notify POS that media files are available to be downloaded.

STRKEY1

VARCHAR(20)

The data value to be used as a key for the strType. If strType was a AUSER, this would be the user number.

STRKEY2

VARCHAR(20)

The second data value to be used as a key for the action.

STRKEY3

VARCHAR(20)

The third data value to be used as a key for the action.

STRMESSAGE

VARCHAR(250)

Can be used to record more specific information about the strType.

 

Primary Key: INTUPDATECODE + CTRCODE

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