Finance statistic/Company

The following describes the record layout for the database table FinanceTurnComp in which the data for statistics Finance statistic/Company is stored.

Additional data fields are transferred from database table FinanceTurnMix.

The following description shows the field names, the data type and the field size together with a short description of the field content.

The following categories can be stored under any number for Finance type:

  1. Credit
  2. Voucher
  3. Payed in
  4. Payed out
  5. Tips
  6. GC prepayment
  7. Extras
  8. Deposit
  9. Customer fin.mode

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


Finance no.

Number 1 9999

Number of finance type under which this Finance type is stored in the system.


MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin