Dept.time.turn/branch

The description below deals with the record layout for the database table DeptTimTBrch in which the data for the statistics Dept.time.turn./branch is stored.

Additional data fields are transferred from database tables DeptTurnMix and CondsTurnMix.

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


Period

Number 1 - 9

The following values are possible depending on the Statistic parameter set:

  1. = Year
  2. = Month
  3. = Week
  4. = Day

Date

Date

Recording date


Company

Number 1 - 9999

Number of company.


Branch

Number 1 - 99999

Number of branch.


Time period

Number 1 - 99

Number under which this period has been stored in the system (see program Period).


Department

Number 1 - 999999

Number of department.


MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin