The following describes the record layout of the
abstract database table CondsTurnMix
in which the data for the following statistics is stored:
The description below details the field names, the
data type and the field size and provides a short review of the field contents.
Decimal (12,2)
Turnover of all recordings in this department
(including the turnover customer credit).
Decimal (12,2)
Turnover of all invoiced recordings in this
department.
Decimal (12,2)
Turnover of all takeaway recordings in this
department.
Number -99999999 99999999
Customer count
Decimal (12,2)
Turnover service charge in this department.
Decimal (12,2)
Turnover of on-the-house recordings in this
department.
Decimal (12,2)
Turnover of discounts and price markups in this
department.
Decimal (12,2)
Calculated cost price.
Decimal (12,2)
Turnover VAT in this department.
Decimal (12,2)
Turnover of takeaway VAT in this department.
Decimal (12,2)
Turnover at special price 1 in this department.
Decimal (12,2)
Turnover at special price 2 in this department.
Decimal (12,2)
Turnover at special price 3 in this department.
Decimal (12,2)
Turnover at special price 4 in this department.
Decimal (12,2)
Turnover at special price 5 in this department.