Home > Technical > Data > TillStatus

TillStatus

The TILLSTATUS table tracks information about tills. There are two types of information tracked. Firstly, the current status of the till - whether it is turned on, trading, closed, and so on. Secondly it tracks last known time for certain events and config details for tills, for example last time a reload was done, last time a sale was sent, the current version of DynaPOSTouch.exe, and so on.

intStatus

The intStatus field determines the historical purpose of the record.

0

Every time the status of the POS is changed, for example opened, trading, locked, etc, it will write a record with an intStatus of '0'. These records will continue to grow.

1

The current status of the POS, for example opened, trading, locked, and so on. Where intStatus of 0, tracks each change of status, intStatus of 1 tracks the last status only. You can always look up an intStatus=1 to find the current status of the till.

2

This type is used for recording the last known times and configuration information. There will be one record with intStatus '2' for each till/ strStatus (see below). This works as a 'last known instance'. If you look up a record for intStatus=2 and strStatus='RECV', this will tell you the last time the POS contacted MCS for messages.

strStatus

The strStatus indicates the actual status of the till. Some of the codes indicate the current trading status. Others are used to indicate a specific piece of information, for example current DynaPOSTouch version.

CLOSE

The DynaPOSTouch.exe program has been closed.

EOD

A Z-Read has been done. Either a start of shift will need to be done or some one needs to log in to start trading.

LOCK

The POS is currently locked.

OPEN

The DynaPOSTouch.exe has been started. No one has logged in yet.

SOD

The POS is waiting for a start of shift float to be performed.

TRADE

An operator has logged in and is trading.

These status codes are used with intStatus of 2 to indicate a specific piece of information, for example time of last reload, current software version number, and so on.

CLOAD

When the POS last did a configuration reload.

POSLS

Indicates if the POS is connected to MerchantLocalService or not. The strStatusExt will be 'F' if not connected, 'T' if connected. This is updated when the POS does a reload.

POSVR

The version of the current POS. The actual version number is stored in strStatusExt. This is updated when the POS does a reload.

RECV

The last time that POS contacted MCS for any messages (such as item updates, new users, etc).

RLOAD

When the POS last did a full item reload.

SEND

Last time that a transaction was sent from POS to the server. Is used to determined the last time a transaction was received.

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