The following describes the record layout for the
abstract database table ArtTurnMix
in which the data for the following statistics is stored:
The field names, the data type and the field size as well
as a short review of the field content are detailed below.
Decimal (12,2)
Total of all item turnover including the assigned menu
parts.
The turnover of the menu items is shown separately.
Decimal (12,2)
Total of all turnover for menu items.
Decimal (12,2)
Total of all price changes (markup and markdown).
Decimal (12,2)
Total of the profit calculation base. This value is
only shown if the item is a stock item and if a calculated cost price is
available for the stock item.
Decimal (11,3)
Count of all items sold. The count for menu items sold
will be shown separately.
Decimal (12,2)
Item turnover at special price 1
Decimal (12,2)
Item turnover at special price 2
Decimal (12,2)
Item turnover at special price 3
Decimal (12,2)
Item turnover at special price 4
Decimal (12,2)
Item turnover at special price 5
Decimal (12,2)
Turnover of all items with customer price
Decimal (12,2)
Turnover merchandise returns items
Decimal (12,2)
Count of menu items sold.
Number 0 - 99999999
Count of all items scanned.
Decimal (12,2)
Turnover VAT.
Decimal (20,2)
Count of merchandise returns items sold.