Home > Technical > Table Definitions > TILLDEVICES

TILLDEVICES

Stores details of the various devices connected to a till, for example printers, customer displays, and so on.

Column

Type

Description

STRDEVICECODE

VARCHAR(10)

A unique code, assigned by the user, to identify a device. The code must be unique for all devices on all tills.

STRTILLCODE

VARCHAR(10)

The till to which this device is connected.
TILL.strTillCode

INTDEVICETYPE

INT

The type of device.

STRDEVICEPORT

VARCHAR(5)

The port (COM1,LPT2) to which the device is connected.

INTBAUDRATE

INT

The baud rate, if connected to a com port.

INTVERSAPORTDELAY

INT

The delay, in ms, between each character sent from a VersaTerm. Usually set to 0.

INTVERSAPORTTIMEOUT

INT

The timeout, in ms, between successive characters when receiving data from the device for a VersaTerm. 10 is usual for a Barcode Scanner.

INTDATAFORMAT

INT

The comms format used.

0  

8 NONE 1

1  

7 EVEN 1

STRNETWORKPRINTERPATH

VARCHAR(50)

The full name of a networked printer which can be used for printing.

INTCASHDRAWERNUMBER

INT

Some printers allow up to two cash drawers to be connected. This indicates the number of the cash drawer to be fired. 0=1st cash drawer, 1=2nd cash drawer.

STRDEVICETYPE

VARCHAR(20)

Indicates what type of device the printer or cash drawer is. If this is a cash drawer connected via a printer, the device type will be the printer, since this will do the actual controlling of the cash drawer.
POSDEVICETYPE.strCode

STRNETWORKADDRESS

VARCHAR(20)

Some devices require a network address to connect to,for example 212.189.212.189:5674

STRDEVICEBRAND

VARCHAR(30)

The brand of the device. Used for asset tracking purposes only.

STRDEVICEDESCRIPTION

VARCHAR(30)

A description of the device. Used for asset tracking purposes only.

STRMODEL

VARCHAR(30)

The model of the device. Used for asset tracking purposes only.

STRSERIALNUMBER

VARCHAR(50)

The serial number of the device. Used for asset tracking purposes only.

STRCOMMENT

VARCHAR(50)

A comment about the device. Used for asset tracking purposes only.

MEMNOTES

TEXT

Free format notes about the device. Used for asset tracking purposes only.

STRALTDEVICECODE

VARCHAR(10)

The code of a printer device to which a receipt will be redirected, if this device is not available for use.

INTHANDSHAKE

INTEGER

Indicates the type of handshaking which should be used when opening the till device.

0

Default. The POS will use whatever it thinks is the best choice for the device.

1

None

2

Software

3

Hardware

4

Both

YSNTRANSLATECODEPAGE

VARCHAR(1)

If 'T' POS will translate the text sent to the device using the windows and DOS code pages. Usually used for printers and customer displays.

STRCURRENCYCODES

VARCHAR(50)

Used for cashdrawers. A comma-delimited list of currency codes. If the transaction is paid with one of these currencies, this cash drawer will be opened.

STRBITMAP1

VARCHAR(100)

The location of a bitmap file that can be used for printing on the PoS Till Receipt

STRBITMAP2

VARCHAR(100)

The location of a bitmap file that can be used for printing on the PoS Till Receipt

STRBITMAP3

VARCHAR(100)

The location of a bitmap file that can be used for printing on the PoS Till Receipt

STRBITMAP4

VARCHAR(100)

The location of a bitmap file that can be used for printing on the PoS Till Receipt

STRLANGUAGECODE

VARCHAR(5)

Language code

INTCOMMANDTIMEOUT

INT

Timeout for Givex commands

STRLOGINID

INT

Givex Terminal ID

STRLOGINPASS

 INT

Givex Terminal Password
 

Primary Key: STRDEVICECODE

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