Home > Technical > Table Definitions > TILLREADDETAIL
Contains the details of tenders in TILLREADREQUEST and TILLDECLARATION.
Column |
Type |
Description |
LINTREQUESTCODE |
INT |
The code of either the TILLDECLARATION or TILLREADREQUEST to
which this detail belongs. |
STRDETAILTYPE |
VARCHAR(1) |
Indicates the usage of the record: D=Till Declaration |
INTSECTION |
INT |
Usually 1 to indicate the main tender details for the tillread/ declaration. A value of 2 indicates summarised paid in/out type information. |
INTSEQUENCE |
INT |
Sequence of the record within the tillread/ declaration. |
INTSUBSECTION |
INT |
Not used. Defaults to 0. |
STRDESCRIPTION |
VARCHAR(20) |
A description of the tender. |
CURVALUE |
DECIMAL(19,4) |
The value of the tender. |
INTCOUNT |
INT |
The number of instances of this tender. This is populated automatically from till reads. Not required for till declarations. |
INTTENDERCODE |
INT |
The code of the tender. |
STRCURRENCYCODE |
VARCHAR(5) |
The currency code. Used if the tender is a foreign currency
tender. |
CURFOREIGNAMT |
DECIMAL(19,4) |
The original foreign amount tendered. |
DBLEXCHANGERATE |
DECIMAL(19,4) |
The exchange rate used to convert the currencies. |
Primary Key: LINTREQUESTCODE + STRDETAILTYPE + INTSECTION + INTSEQUENCE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |