Home > Technical > Table Definitions > POSKEYDTL

POSKEYDTL

Holds POS keyboard format details.

Column

Type

Description

LINTKBCODE

INT(4)

Keyboard identifier

POSKEYHDR.LintKBCode

STRLEVELGUID

VARCHAR(38)

Unique grid identifier for the panel

POSKEYLEVEL.StrGuid

INTCOL

INT(4)

Column number 0 – 3

INTROW

INT(4)

Row number 0-8

INTKEYTYPE

INT(4)

Type of contents

0 = Blank button or a title field
1 = IPN
2 = Fast key link
3 = Multisize Modifier 1 link
4 = Multisize Modifier 2 link
5 = Item Modifier link

STRKEYLABEL

VARCHAR(20)

Description.

STRVALUE

VARCHAR(50)

APN reference (PLU or barcode)
Fast key panel LEVEL # if it’s a fast key link
Null for all other STRVALUE's

STRFONTNAME

VARCHAR(20)

Font name.

INTFONTSIZE

INT(4)

Font size.

YSNBOLD

VARCHAR(1)

T = Bold font
F = Normal font

YSNITALIC

VARCHAR(1)

T = Italic font
F = Normal font

INTFOREGROUNDCOLOUR

INT(4)

Text colour, defined by an 8 digit number.

INTBACKGROUNDCOLOUR

INT(4)

Cell colour, defined by an 8 digit number, only used if button images are not in use.
The value held in System Settings for Default Keyboard State Button Colour will be written here if the STRVALUE is the Fast key panel.

STRIMAGENAME

VARCHAR(20)

Bitmap image linked to the cell, it will refer to the c:/drsapps/bitmaps folder to retrieve the image.

STRBUTTONIMAGE

VARCHAR(10)

Cell background colour, defined from the drop down rather than the windows colour card.

STRSIZETAG

VARCHAR(4)

Button size.

1x1 = 101
1x2 = 102
2x1 = 201
2x2 = 202

 

Primary Key: LINTKBCODE + STRLEVELGUID + INTCOL + INTROW

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