Home > Technical > Table Definitions > FOREIGNEXCHANGE

FOREIGNEXCHANGE

This table is used to store the details of foreign currencies you can accept and their exchange rates.

Column

Type

Description

STRCODE

VARCHAR(5)

The code to identify the currency.

STRDESCRIPTION

VARCHAR(20)

A description of the currency.

INTORDER

INT(4)

The order in which the currency will be displayed on the POS. The lowest number will be displayed first.

DBLEXCHANGERATE

DECIMAL (9) 19,4

The exchange rate.

DTMLASTCHANGED

DATETIME(8)

When last changed.

STRFILENAME

VARCHAR(20)

The name of a BMP in the bitmaps directory. This will appear on the button on the POS.

YSNPOINTS

VARCHAR(1)

Not currently used.

STRCROSSCONVCODE

VARCHAR(5)

Not currently used.

 

Primary Key: STRCODE

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