Finance statistic/Prof.center

The following describes the record layout for the database table FinanceTurnProC in which the data for statistics Finance statistic/Prof.center is stored.

Additional data fields are transferred from database table FinanceTurnMix.

The description below shows the field names, the type of data 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
  10. Invoice fee
  11. Coupon
  12. Trans.order costs
  13. Web Shop delivery cost

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


Profit center

Number 1 9999

Number of profit center


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