Home > Technical > Table Definitions > TILL

TILL

A record needs to be set up for each till /POS within a location.

Column

Type

Description

STRTILLCODE

VARCHAR(10)

Unique code assigned by the user.

INTTILLCODE

INT

A unique number to identify the till. Set by the user.

STRTILLDESCRIPTION

VARCHAR(20)

A description for this till.

STRTRADECODE

VARCHAR(10)

The location this till belongs in.
TRADUNIT.strTradeCode 

INTDEVICEID

INT

Used only if the till is a VersaTerm. Each VersaTerm has a unique number which is entered here.

DTMZREADDATETIME

DATETIME

No longer used

LINTZREADHEADERTO

INT

No longer used

LINTZREADHEADERFROM

INT

No longer used

LINTZREADRESETNUMBER

INT

No longer used

YSNLOCKED

VARCHAR(1)

No longer used

INTDISPLAYMODE

INT

Not currently used.

INTROUNDING

INT

The number of cents to round to. Used if INTROUNDTYPE is set to a non-zero value.

YSNZEROITEMSOK

VARCHAR(1)

Indicates if the operator can ring up an empty sale (sale with no items).  ???

LINTLASTSALEID

INT

No longer used

LINTKBCODE

INT

The code of the keyboard definition to be used for this till.
KBHEADER.ctrCode

STRPOSTYPE

VARCHAR(10)

The type of till. VERSA, VERSAMULTI, DYNAPOS, PWRTILL, INTOUCH. Not currently used.

STRRECEIPTPRINTER

VARCHAR(50)

The till device to be used for printing receipts, if any.
TILLDEVICES.strDeviceCode

STRDRSCOMPUTERNAME

VARCHAR(20)

The network name of the computer on which the POS software resides for this till.

YSNVERSACARDSWIPE

VARCHAR(1)

Only used for VersaTerm tills. ‘T’ if a card swipe is attached.

YSNVERSARAMCODE

VARCHAR(1)

‘T’ if new computer code to be loaded into the VersaTerm.

BLOBVERSARAMCODE

BINARY

The computer code to be loaded.

CURFLOAT

DECIMAL(19,4)

The value of the float for this till.

INTROUNDTYPE

INT

The method of rounding to be used at the till. 0= No rounding, 1= Round Up, 2=Round Down, 3=Round Up/Down.

YSNVERSASENDINACTIVEACCOUNTS

VARCHAR(1)

'T' if inactive accounts should be sent to the Versaterm till. Versaterms have limited memory and this flag can be set to 'F' to restrict the account details sent to the till.

INTPROFILECODE

INT

The DynaPOS profile used for this till.
DYNAPOSPROFILE.ctrCode

CURMINCASHOUT

DECIMAL(19,4)

The sale value must be at least this amount before extra cash can be given for EFTPOS.

CURMAXCASHOUT

DECIMAL(19,4)

The maximum amount of cash available on EFTPOS.

CURMAXFASTKEYAMT

DECIMAL(19,4)

DynaPOS displays various suggested values when tendering a sale. This is the maximum amount which will be suggested.

DTMLASTZREAD

DATETIME

No longer used.

YSNSECONDSCREEN

VARCHAR(1)

No longer used.

INTCHANGEFLAG

INT

An auto-incrementing flag which is updated each time the till is changed. This can be used by EOD processes to determine changes since the last EOD.

INTNEWFLAG

INT

Similar to INTCHANGEFLAG but is set each time a new till is added.

CURFLOAT2

DECIMAL(19,4)

The value of the float for the secondary currency (if any).

STRSTATUS

VARCHAR(5)

No longer used.

YSNACTIVE

VARCHAR(1)

'T' if the till is currently active.

STRSCHEDULECODE

VARCHAR(10)

The code of the media schedule that will control the media clips displayed by the multimedia customer display.

STRCOMMSCONFIG1

VARCHAR(10)

The primary communication configuration that POS should use to connect to Merchant Central Server.

COMMSCONFIG.strCode

STRCOMMSCONFIG2

VARCHAR(10)

The first backup communication configuration that POS should use to connect to Merchant Central Server if connection cannot be made using the primary communication configuration.

COMMSCONFIG.strCode

STRCOMMSCONFIG3

VARCHAR(10)

The second backup communication configuration that POS should use to connect to Merchant Central Server if connection cannot be made using the first backup communication configuration.

COMMSCONFIG.strCode

INTMODE

INT

Indicates the way the POS will be operated.

0

Operator/Touchscreen

1

Handheld

2

Self Service

3

Handheld (Full Screen)

4

Merchant Local Server

5

Operator/Keyboard

6

MPOS Handheld

STRALTRECEIPTPRINTER

VARCHAR(50)

A comma-delimited list of devices that are used as alternative printers in Taiwan.

INTROUNDTYPE2

INTEGER

The method of rounding to be used at the till for the secondary currency. 0= No rounding, 1= Round Up, 2=Round Down, 3=Round Up/Down.

INTROUNDING2

INTEGER

The number of cents to round the secondary currency to. Used if INTROUNDTYPE2 is set to a non-zero value.

 

Primary Key: STRTILLCODE

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