The following describes the record layout for the
abstract database table BookStMix
which stores the data for the following statistics:
The following describes the field names, the data type
and the field size together with a short review of the field content.
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Total turnover operator
Entry range permitted:
decimal max. 11 digits with max. 3 decimal places
No. of article and department bookings
Entry range permitted:
decimal max. 11 digits with max. 3 decimal places
No. of articles scanned
Customer count. This number increases by one from
entry of guest count and from finalisation of an itemised receipt.
Entry range permitted:
numeric 0 - 99999999
Number of No Sale receipts
Entry range permitted:
numeric 0 - 99999999
Time worked in seconds starting with the 1st
operator sign-on until the interdiate/end sign-off (only relevant in SS mode).
Entry range permitted:
numeric, 0 - 99999999
Active time in seconds during which the operator was
signed on at the terminal (only relevant in SS mode).
Number
Money handling time in seconds. This is the time
worked with an open drawer (only relevant in SS mode).
Number
booking time in seconds. This is the time during which
the operator made active bookings on the terminal.
Number
Idle time in seconds. This is the time the operator
was signed on, but did not make any bookings.
Number
Training mode time in seconds. The time in which the
operator worked in training mode on the terminal.
Entry range permitted: decimal max. (12,2)
Total of all error correct operations
Number 0 99999999
Count of all error correct operations
Entry range permitted:
decimal max. 12 with max. 2 digits
Total of all line void operations
Entry range permitted: numeric,
0 - 99999999
Count of all line void operations
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Total of all receipt void operations
Entry range permitted:
numeric, 0 - 99999999
Count of all receipt void operations
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Total of all GC voids. These are void transactions
carried out during GC booking.
Entry range permitted: numeric,
0 - 99999999
Count of GC void operations carried out during GC
booking.
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Total of all receipt discontinuations
Entry range permitted:
numeric, 0 - 99999999
Count of receipt discontinuations
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Value of articles recorded as bottle deposit articles.
Entry range permitted:
numeric, 0 - 99999999
Count of articles recorded as bottle deposit articles.
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Total of articles recorded with Deposit. Only
articles marked as such can be recorded with Deposit.
Entry range permitted:
numeric, 0 - 99999999
Count of deposit transactions
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Total of takeaway bookings (<TA>).
Entry range permitted:
numeric, 0 - 99999999
Count of takeaway transactions
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Total of on-the-house bookings (<OTH>).
Entry range permitted:
numeric 0 - 99999999
Count on-the-house bookings
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Total of returns bookings (<RET>).
Entry range permitted:
numeric, 0 - 99999999
Count of returns bookings
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Total of all financial transactions of type Extras
(<fFIN>). The
appropriate data records must have been stored in the system and parametered
for this type of terminal.
Entry range permitted:
numeric 0 - 99999999
Count of financial transactions of type
"Extras" (<fFIN>).
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Total of amounts paid in and recorded with key <SECPAY>. A
finance type GC advance payment must have been programmed in the system.
Entry range permitted:
numeric 0 - 99999999
Count of pay in bookings made with key <SECPAY>.
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Total of all received on account bookings with <fPAYIN>. A finance type Credit with
option customer-related must have been programmed in the system.
Entry range permitted:
numeric, 0 - 99999999
Count of the received on account bookings.
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Total of customer credits recorded with key <CREDSALE>. A finance type Credit with
option Credit and customer-related must have been programmed in the system.
Entry range permitted:
numeric 0 - 99999999
Count of customer credit bookings
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Entry range permitted:
numeric 0 - 99999999
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Entry range permitted:
numeric 0 - 99999999
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Total of all voucher sales bookings via finance type
"Voucher" (<fFIN>).
Entry range permitted: numeric
0 - 99999999
Count of voucher sales bookings with finance type
"Voucher"(<fFIN>).
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Total of vouchers cashed in via a payment mode of type
Voucher (<fPM>).
Entry range permitted:
numeric 0 - 99999999
Count of cashed in vouchers with a payment mode of
type Voucher (<fPM>).
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Total of all guest check bookings
Entry range permitted:
numeric, 0 - 99999999
Count of recorded guest checks
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Total of all guest checks recorded as a GC copy
Entry range permitted:
numeric, 0 - 99999999
Count of recorded GC copies
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Total of all turnover stemming from guest check
splitting
Entry range permitted:
numeric, 0 - 99999999
Count of guest check splitting operations
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Total of all turnover recorded on guest checks opened
by a particular person
Entry range permitted:
numeric, 0 - 99999999
Count of bookings recorded on guest checks opened by a
particular person
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Total of all turnover recorded on a guest check opened
by someone else.
Entry range permitted:
numeric, 0 - 99999999
Count of bookings on guest checks opened by someone
else.
Entry range permitted: decimal
max. 12 digits with max. 2 decimal places
Total of turnover recorded by others on a guest opened
by a particular person.
Entry range permitted:
numeric, 0 - 99999999
Count of bookings made by others on a guest check
opened by a particular person.
Entry range permitted:
decimal max. 12 digits with 2 decimal places
Turnover of guest checks ensuing from finalisation of
guest checks of other operators.
Entry range permitted:
numeric, 0 - 99999999
Count of guest checks ensuing from finalisation of
guest checks from other operators.
Entry range permitted:
decimal max. 12 digits with 2 decimal places
Turnover of guest checks finalised by the particular
person concerned.
Entry range permitted:
numeric, 0 - 99999999
Count of guest checks finalised by the particular
person concerned.
Entry range permitted:
decimal max.12 digits with max. 2 decimal places
Turnover of own guest checks finalised by another
operator
Entry range permitted:
numeric, 0 - 99999999
Count of own guest checks which other operators have
finalised.
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Total of tips recorded.
Entry range permitted:
numeric, 0 - 99999999
Count of tip bookings
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Total of commission
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Turnover recorded in training mode. Please note the
training mode surcharge which applies to the branch in question.
Entry range permitted:
decimal max. 1 digits with max. 2 decimal places
Turnover stemming from rounding differences
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Turnover stemming from discounts
Entry range permitted:
numeric, 0 - 99999999
Count of discounts recorded.
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Total of receipts postponed (<RECLS>).
Entry range permitted: numeric,
0 - 99999999
Count of receipts postponed.
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Total of price surcharges recorded.
Entry range permitted:
numeric, 0 - 99999999
Count of price surcharges recorded
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Total of entries recorded via key <PAYIN>. A
finance type without the option Credit and customer-related must have been
programmed in the system.
Entry range permitted:
numeric, 0 - 99999999
Count of pay in operations recorded with key <PAYIN>.
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Total of paid out bookings via key <PAYOUT>.
Entry range permitted:
numeric, 0 - 99999999
Count of paid out operations
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Turnover of aborted receipts during power failure
Number
Count of aborted receipts which occurred during a
power failure
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Turnover of unfinalised guest checks at the beginning
of a new shift
Number
Count of unfinalised guest checks at the beginning of
a new shift
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Turnover of unfinalised guest checks at the end of a shift
Number
Count of unfinalised guest checks at the end of a
shift
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Total of float entered
Entry range permitted:
decimal max. 12 digits with max. 2 decimal places
Entry range permitted:
numeric, 0 - 99999999