The following describes the record layout for the
database table ArtTimTComp
which stores the data for the statistics Item
timeperiod/company.
The field names, the data type and the field size
together with a short description of the field content are described here.
Decimal (12,2)
Total of all item turnover including the assigned
parts of a menu.
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/markdown).
Decimal (12,2)
Total of the profit calculation base.
This value is only shown if a price for profit
calculation base has been assigned for this item or if it is a stock item and
if a cost price is available for this stock item.
Decimal (11,3)
Count of all items sold. The count for the menu items
sold is 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 at customer price.
Decimal (12,2)
Turnover of merchandise returns items.
Decimal (12,2)
Number of menu items sold.
Number 0 - 99999999
Count of all scanned items.
Decimal (12,2)
Turnover VAT.
Decimal (20,2)
Number of merchandise returns items.
Number 1 - 9
The following values can be entered depending on the statistic
parameters
set:
Date
Recording date
Number 1 - 9999
Number of company
Number 1 - 99
Number of period in which these items have been
recorded.
The appropriate time periods must have already been programmed.
Decimal (14,0)
Number of the item