Home > Technical > Table Definitions > TILLREADDETAIL

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.
TILLREADREQUEST.ctrCode
TILLDECLARATION.ctrCode

STRDETAILTYPE

VARCHAR(1)

Indicates the usage of the record:

D=Till Declaration
Z=Z-Read
X=X-Read
F=Internal Use

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.

TENDER.intTenderCode

STRCURRENCYCODE

VARCHAR(5)

The currency code. Used if the tender is a foreign currency tender.
CURRENCYCODE.strCurrencyCode

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)