Department turnover (DeptTurnMix)

The following describes the record layout for the abstract database table DeptTurnMix in which the data for the following statistics is stored:

Additional data fields will be transferred from the database table CondsTurnMix.

The field names, the data type and the field size as well as a short review of the field content are described below.


Quantity

Decimal (11,3)

All recordings in this department


Invoice quantity

Decimal (11,3)

Count for all invoices in this department


Turnover in department

Decimal (12,2)

Turnover recorded directly via the department


Quantity in department

Decimal (11,3)

Count of direct department recordings


Count takeaway

Decimal (11,3)

Number of takeawy recording in this department which  stem from direct department or item recordings.


Quantity on the house

Decimal (11,3)

Quantity of on the house recording in this department which stem from direct departments and items.


MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin