Home > Technical > Table Definitions > 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 |
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. |
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. |
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. |
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) |