Home > Technical > Table Definitions > TILLSTATUS

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.
TILL.strTillCode

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)