Home > Technical > Table Definitions > SYSTEMTABLE

SYSTEMTABLE

This table is used like an INI file but it enjoys the benefits of database transaction support.

Column

Type

Description

STRKEY

VARCHAR(30)

The key to find/update the value for, for example LoyaltyRounding, LoyaltyEmailNewCust, DefaultStocktake, NCRPOS functionality, NCRDEFKSBUTTONCOLOUR, ImageVersionFile, OnlyMandStockForPO.

STRVALUE

VARCHAR(200)

The current value for the corresponding key.

 

STRKEY

STRVALUE

LoyaltyRounding

0 = Always round up
1 = Always round down
2 = Round to nearest
3 = Do not round

LoyaltyEmailNewCust

T = True
F = False

DefaultStocktake

Store, Direct, Bar, Bar Direct.

NCRPOS functionality

T = True
F = False

NCRDEFKSBUTTONCOLOUR

Default button colour for Debenhams Keyboard States - 13348743 light blue.

ImageVersionFile

c:\version.txt
c:\imageversion.txt
c:\imagevsn.txt

OnlyMandStockForPO

F = False

 

Primary Key: STRKEY

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