Home > Technical > Table Definitions > TILLREADREQUEST

TILLREADREQUEST

When ever a Z-Read is done, there will be a record written to this table. The actual details for each tender in the tillread will be stored in  TILLREADDETAIL.

Column

Type

Description

CTRCODE

INT

Unique number assigned by the system. This number is shared with TILLDECLARATION. So you can't have a record with code 1 in TILLDECLARATION and TILLREQDREQUEST.

STRREADTYPE

VARCHAR(1)

The type of till read being done.

Z=Z-Read

STRTRADECODE

VARCHAR(10)

The location from where the tillread was done. If this was a location-based tillread done from the back office, this will be the code of the location for which the tillread was done.
TRADUNIT.strTradeCode

STRTILLCODE

VARCHAR(10)

The till from where the tillread was done. If this was a till-based tillread done from the back office, this will be the code of the till for which the tillread  was done.

TILL.strTillCode

LINTFROMCODE

INT

The lowest DAILYSALES.ctrCode record processed on the report. This is only set for tillreads that read data from DAILYSALES. For local tillreads, this will be 0.

LINTTOCODE

INT

The highest DAILYSALES.ctrCode record processed on the report. This is only set for tillreads that read data from DAILYSALES. For local tillreads, this will be 0.

DTMFROMTIME

DATETIME

The lowest date/time of the transactions show on the report.

DTMTOTIME

DATETIME

The date/time the tillread was completed.

STRTILLDESCRIPTION

VARCHAR(30)

The name of the till where the till read took place.

STRTRADENAME

VARCHAR(50)

The name of the location where the till read took place.

LINTZREADRESETNUMBER

INT

Not used.

YSNPROCESSED

VARCHAR(1)

Always "T'

YSNBALANCEDTODECLARATION

VARCHAR(1)

Starts as 'F'. When a till declaration has been made for a Z-Read, the flag will be set to 'T'.

DTMTRADEDATE

DATETIME

The trading date of the tillread.

LINTFROMSALEID

INT

The lowest, non-zero receipt number processed on the tillread.

LINTTOSALEID

INT

The highest, non-zero receipt number processed on the tillread.

STRUSERCODE

VARCHAR(20)

The user who requested the z-read. If this was a user-based till read, this will be the code of the user for which the tillread  was done.

STRREPORTFILENAME

VARCHAR(38)

If doing a blind z-read, this is the name of the file of the report. When the till declaration is done for this till read, the status of this report will be changed so the report is visible in Report Manager.
REPORTS.strFileName

DTMTRANSSENT

DATETIME

The time the record was inserted into the database.

STRPOSGUID

VARCHAR(38)

A unique code assigned to this till read from the tillread program.

MEMUSERNAMES

TEXT

A comma-delimited list of users who made transactions that appear on tillread.

 

Primary Key: CTRCODE

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