Home > Technical > Table Definitions > TILLSTATUS
This table stores the status (current and historical) of each till. Is it online? When was the last message received from it? etc
Some of the details are explained more fully in Till Status.
Column |
Type |
Description |
STRTILLCODE |
VARCHAR(10) |
The till for which this status is being recorded. |
INTSTATUS |
INT |
A code indicating whether this is a current or historical record. See Till Status for more details. |
CTRCODE |
INT |
A unique number assigned by the system. |
DTMLOCALDATETIME |
DATETIME |
The date/time at the client. |
DTMSERVERTIME |
DATETIME |
The date/time at the server. |
STRCOMPUTERID |
VARCHAR(38) |
Not currently used. |
STRIPADDRESS |
VARCHAR(25) |
Not currently used. |
STRSTATUS |
VARCHAR(5) |
A code indicating whether the POS is closed, opened, trading, and so on. See Till Status for more details. |
STRSTATUSEXTRA |
VARCHAR(10) |
Some STRSTATUS codes indicate there is additional information available. This additional information is stored here. |
Primary Key: STRTILLCODE + INTSTATUS + CTRCODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |