Fields of OLAP Sales Report
| Field | Description |
| % by column | Percentage of the column to the left from the nearest subtotal per this column. The parameter cannot be used alone; there shall be a field to the left. |
| % by row | Percentage of the row to the left from the nearest subtotal per this row. The parameter cannot be used alone; there shall be a field to the left. |
| 1 level item group | Group hierarchy an item falls under Unlike the Item Hierarchy field, each group has its own field |
| 2 level item group | |
| 3 level item group | |
| 15-minute closing interval | Use it to get more details on the Closing time field. |
| 15-minute opening interval | Use it to get more details on the Opening time field. |
| Accounting day | The date as of which the sale was registered Subject to the Accounting day settings, it may not correspond to the actual sale date |
| Actual delivery time | The time when an order has been handed to a customer It is used to determine the Delivery delay(min) field This time is registered by a driver in the mobile app when setting the delivery status to Delivered Or by an operator in Syrve POS |
| Ad | Marketing source in the delivery card |
| Address | Full delivery address: Street+Building+Apartment |
| Address details | Address details: Apartment, Floor, Entrance, Intercom. New delivery address format can be enabled in the Delivery Address Format block found on the General Settings tab of the Store Settings. |
| Address ID | This code is set by an external mapping system upon checking |
| Amount after discount w/o VAT not included in cost | The field is used to run reports in cases when VAT is added at the time of sale rather than included in the item cost |
| Amount in currency of payment/order | How much was paid in terms of a certain currency Use this field for the purpose of analysis if you accept more than one currency, and you have a reference book and currency rates configured. |
| Amount w/o VAT not included in cost | Use this field when running reports in case VAT is added at the time of sale rather than included in the item cost |
| ASAP | An order takes this attribute If the delivery time is not specified. If ASAP is true, the order should be delivered as soon as possible. |
| Authorization card | Employee card No. who authorized the operation |
| Authorized by | Employee who authorized the order payment. |
| Avg. delay in delivery (min) | Average delivery delay per group It is calculated according to the following formula: Actual delivery time - Planned delivery time |
| Avg. number of guests per receipt | Average number of guests per one receipt within a group It is calculated according to the following formula: Number of guests / Orders (excluding canceled orders) |
| Avg. number of items per receipt | Average number of items in the receipt This value is defined within a group For instance, per month, shift, within one outlet, etc. It is calculated according to the following formula: Number of items / Orders (receipts) |
| Avg. serving time (min) | The indicator is an average value of the Serving time parameter within a group |
| Avg. time in guest bill (min) | The indicator is an average value of the Time in guest bill parameter within a group |
| Avg. travel time (min) | Average travel time of a delivery order within a group It is calculated according to the following formula: Actual delivery time - Dispatch time |
| Average delivery rating, % | Overall average rating in the delivery group |
| Average driver rating, % | Average rating of a driver in the delivery group (based on the Driver category questions) |
| Average kitchen rating, % | Average rating of items in the delivery group (based on the Kitchen in delivery questions) |
| Average operator rating, % | Average rating of call center operators in the delivery group (based on the Delivery operator questions) |
| Average price | It is calculated according to the following formula: Gross Sales (after discount) / Number of items |
| Average price before discount | It is calculated according to the following formula: Discount amount / Number of items |
| Average price w/o VAT | Amount after discount net of VAT It is calculated according to the following formula: |
| Average revenue per guest | Sum of orders with account of discounts and surcharges divided by the number of guests This value is important for a group For instance, you are able to learn an average revenue per guest at each cash register or as of given day, etc. |
| Average spend | Average bill The computation includes all closed orders except for the canceled ones. It is calculated according to the following formula: |
| Banquet | By the value specified in this field, one is able to determine whether an order is a regular one or it’s a banquet order. |
| Bills | Total number of bills posted as of the period including voided |
| Cash register | Name of the main cash register of the group |
| Cash register No. | Cash register number used to register the sale. The number is set in the device settings |
| Cashier | Order cashier |
| Cashier ID | Employee's ID specified in his or her file. |
| Category 1,2,3,4,5 | Advanced properties of an outlet that can be configured in Syrve HQ. For details, refer to the Outlet article. Use these fields to group or filter the report data If the categories are configured, they would have the names you specified. |
| City | Destination city |
| Closing hour | Order closing hour |
| Closing time | Order closing time accurate to a split second |
| Combo name | Name of a combo item sold at the store |
| Combo size | Size of a combo item sold at the store |
| Combo quantity | Number of combos sold at the store |
| Comment to customer | Comment posted in the guest card |
| Concept | Concept name to which an operation belongs |
| Concept code | Concept code in the reference book |
| Contractor | Name of a supplier or last name of an employee in the transaction. If the order includes an advance payment, the contractor's name is preceded by a comma. |
| Cooking delay (average) | Shows how fast the kitchen starts to cook new orders. It is the time from printing a dish to the start of cooking. Mean value is estimated by a group, i.e. according to the following formula: Total delays per group / Total delays The value is given in the mm:ss format That is, a 65 minutes and 30 seconds delay is given as 65:30 rather than 1:05:30. |
| Cooking time (average) | It shows how fast chefs prepare meals. It is the time from the start of dish preparation to finish. |
| Cooking time 1 (average) | Duration of separate preparation steps if configured. For example, for pizza restaurants: 1 - making, 2 - baking, 3 - cutting and packing |
| Cooking time 2 (average) | Duration of separate preparation steps if configured. For example, for pizza restaurants: 1 - making, 2 - baking, 3 - cutting and packing |
| Cooking time 3 (average) | Duration of separate preparation steps if configured. For example, for pizza restaurants: 1 - making, 2 - baking, 3 - cutting and packing |
| Cooking time 4 (average) | Duration of separate preparation steps if configured. For example, for pizza restaurants: 1 - making, 2 - baking, 3 - cutting and packing |
| Cooking time lag (average) | The parameter shows how mush the kitchen falls behind the standard cooking time. The standard time is set in the dish preparation chart. It is the gap between the end of the standard cooking time and the actual end of cooking. It is calculated according to the following formula: Actual time of cooking completion - Estimated time of cooking completion |
| Cooking finished at | The moment when an order has been cooked. This time is registered when a chef taps the Ready button or the cooking time specified in the stock list card elapses. |
| Cost | This parameter shows the total food cost of items in the report group. It is calculated according to the following formula: Write-off amount * Quantity in the group / Write-off quantity |
| Cost (%) | This parameter shows a share of an item cost in the selling price It is calculated according to the following formula: 100% * Cost / Amount after discounts and surcharges |
| Cost w/o VAT (%) | It is calculated according to the following formula: Food cost / Amount after discount net of VAT * 100% |
| Coupon No. | Coupon number activated at order payment. |
| Coupon Series | Coupon series activated at order payment. |
| Course No. | Course number in the order. The information is useful if the Restaurant mode is enabled. The course is a set of concurrently printed order items that should be served together. |
| Credited to... | Name of the contractor or employee an order was creditted to; which means that the “on credit” payment has been selected. |
| Credit card | Bank card type used to pay an order, e.g., Visa, MasterCard, Maestro, etc. |
| Customer ad | Marketing source in the customer card |
| Customer card No. | Card number used to provide a discount. If a customer has no card issued, the field is empty It shows only delivery customers cards |
| Customer card type | Name of the discount or surcharge in the customer record (Recommended discount) applied to the order |
| Customer full name | First name, last name and patronymic of the delivery customer |
| Customer price category | Name of the price category applied to an order |
| Customer registration date | The date when a customer card has been created in the database |
| Day of week | Name of a weekday (Monday, Tuesday, etc.) |
| Deliver to | Address details: Building No. and Street. New delivery address format can be enabled in the Delivery Address Format block found on the General Settings tab of the Store Settings. |
| Delivery | The field value shows if an order is a delivery order |
| Delivery area | A geographical zone where an order is delivered |
| Delivery cancellation comment | Delivery cancellation details |
| Delivery cancellation reason | Delivery cancellation reason name. Configured in the Delivery > General menu |
| Delivery closing time | Date and time when the Close button was hit |
| Delivery comment | Comment posted when creating a delivery order in the Order comment field |
| Delivery confirmation time | The time when the delivery order is confirmed by a store's employee or call center operator. |
| Delivery delay, actual vs forecast (min) | Variance between the estimated and actual delivery time. It is calculated according to the following formula: Actual delivery time - Estimated delivery time |
| Delivery delay (min) | Delivery delay is calculated according to the following formula: Actual delivery time - Planned delivery time |
| Delivery dispatch time | The time when an order has been dispatched |
| Delivery email | Delivery customer email |
| Delivery No. | Delivery index number |
| Delivery operator | Call-center employee who created a delivery order If a delivery is created via API, then it is an operator who first assigned the delivery to an outlet |
| Delivery packing end time | The time when a delivery order is bagged and can be dispatched to a customer. |
| Delivery phone number | Phone number of the customer in the delivery card used to make an order |
| Delivery print time | Time of sending an order to the kitchen |
| Delivery rating, % | Overall delivery rating It is calculated according to the following formula: Number of positive feedbacks / Total enquiries * 100% This computation includes responses to all question categories. |
| Delivery source | This is an API login on behalf of which a delivery has been created |
| Delivery type | Customer service mode Possible field values:
|
| Discount % | Discount value in % applied to an order/item |
| Discount amount | If an item is not deleted, the parameter value is calculated according to the following formula: (Discount rate * Amount net of discounts and surcharges) / 100 If it was deleted, the discount amount will be zero |
| Discount amount w/o VAT not included in cost | This parameter is similar to the Discount amount field Use it to run reports in case VAT is added at the time of sale rather than included in the item cost |
| Discount type | Name of the discount applied to the order. If there is more than one discount, they are given as a list in one row. Use the Name of discount or surcharge field to learn which item the discount is applied to. Check the OLAP Examples article for some examples. |
| Driver | Employee who delivered an order If a customer has picked up an order, this field has the “Collection” value. |
| Driver rating, % | Rating of a driver delivered an order (based on the Driver category questions) |
| Duration: last serv.print-sending | Order waiting time from cooking start to dispatching. This is the time between tapping the buttons Make and Dispatch |
| Duration: open-last serv.print. | Time from order opening to the last service printing |
| Estimated delivery time | Minimum time required for a delivery It is computed as sum of preparation time and the time of delivery to the specified address. |
| Estimated order readiness time | Estimated time of items preparation completion. This parameter is used to assess the kitchen load. |
| External order No. | Delivery order number assigned by a third-party system, e.g. food delivery platform |
| FCR serial No. | Serial number of the fiscal cash register used to print a receipt |
| Fiscal payment type | Fiscal payment attribute Possible field values:
|
| From storage | Storage specified in the order item or a default storage specified in the production place settings. |
| Full name of item | Full item name from a stock list card |
| Gross Sales (after discount) | Item cost with account of the discount applied It is calculated according to the following formula: Amount net of discount - Discount amount |
| Gross Sales (before discount) | Item cost net of discount or surcharge |
| Group | The group the outlet belongs to where an item was sold |
| Guest bill time | Guest bill printing time |
| Guest card | Discount card number applied to an order |
| Incentive bonus | Total bonuses charged to an employee subject to the terms of an incentive program |
| Invoice print time | The time when an invoice has been printed Configured in the Delivery > General |
| Item | Sold item name |
| Item accounting category | Accounting category specified in the stock list item card |
| Item category | Category in the item’s stock list card. |
| Item code | Item stock list code ‒ SKU |
| Item comment | Comment that can be posted when adding an item to the order. For instance, you can specify “Extra Ice” |
| Item deleted | Type of deleted item Possible field values:
|
| Item deletion comment | Additional data on the reasons for deletion of ordered items For instance, “dropped by waiter”, “canceled by guest”, etc. |
| Item deletion reason | This is the reason from the Reasons for deletion reference book selected at the time of deleting a printed order item |
| Item group | A stock list group an item falls under |
| Item group code | Stock list code (SKU) of a group |
| Item hierarchy | The entire path starting from the root stock list group to the current item Groups are separated by / |
| Item name in foreign language | Foreign name specified in the stock list item card |
| Item quick code | Syrve POS quick code specified in the item stock list card |
| Item service printing | Time of service printing of item (in the kitchen) |
| Item size | Name of an item size |
| Item size code | Item size name for the kitchen, for instance, S, M, L. |
| Item size No. | Item size sequence number in a reference book |
| Item sizes scale | Name of the item size scale |
| Item waiter | In the Restaurant and QSR modes, an employee that added an item to the order shall be specified. Delivery orders:
|
| Kitchen rating, % | Rating of a meal delivered to customer (based on the Kitchen in Delivery questions) |
| Kitchen uptime (average) | It enables to assess how much time the kitchen spends preparing meals, and in case of any service issues, it helps to understand if there are any kitchen-related mistakes. It is the time from printing an item to the end of cooking. |
| Last item service printing | Time of the last service printing |
| Legal entity | Legal entity name |
| Loyalty card holder | Name of the discount card holder in the Club cards directory. |
| Loyalty card No. | Customer card number bonuses accrued to This might be any bonus card system except for Syrve Loyalty |
| Markup | Markup value of an item It is calculated according to the following formula: Amount after discount - net cost |
| Markup (%) | Markup value in percent |
| Measurement unit | Basic measurement unit used when an item has been sold |
| Month | Number and name of the month a sale took place |
| Name of discount or surcharge | Shows a discount or surcharge applied to an item. If there is more than one of those, they are given in separate rows. Check the OLAP Examples article for some examples. |
| Net Sales (after discount) | It is calculated according to the following formula: Amount net of discount - Discount amount - Receipt VAT (Amount) |
| Non-cash payment type | Non-cash payment name Use it to get details on the Payment type if it is “without revenue” |
| Number of combo discounts | The number combos sold |
| Number of discounted items | The number of items sold at a discount. To learn how many combos are sold, use the Number of combo discounts field. |
| Number of guests | Number of guests specified by a waiter in the order In the QSR mode, this value is always 1 |
| Number of items | Number of items in the order, banquet or delivery |
| Number of vouchers | Number of vouchers used at order payment |
| Opening hour | Order opening hour (from 12am to 11pm) |
| Opening time | Order opening time (accurate to a split second) |
| Operation | Transaction type (payment) Possible field values:
|
| Operator rating, % | Rating of a call center operator who took an order (based on the Delivery Operator questions) |
| Orders | Number of orders over the period excluding canceled |
| Order deleted | Use it to filter deleted orders out The Order not deleted item is enabled in the filter by default |
| Order items | Number of items in the bill |
| Order source | Fields can be populated by plugins. Used by the delivery service, Orderman, etc. |
| Order type | Item name in the Order types reference book There are three items for each of the service modes specified in the system by default:
You are able to customize order types, then they will be given in this field |
| Order waiter | Employee who created an order |
| Outlet | Outlet name |
| Payment card No. | Card number of the contractor (guest, supplier or employee) used to pay an order In case of bank cards, the field has the “no card” value |
| Payment currency | ISO currency name used to pay an order |
| Payment exchange rate | Currency rate used to pay an order to the main currency This value can be set in the Finances > Currency rates directory. |
| Payment group | The group the payment type belongs to that was used at order closing Possible field values:
|
| Payment type | The method used to pay an order |
| Payment type (split) | Add this field to an order instead of Payment type if there are more than one payment methods used in the order, e.g., both cash and bank card or bonuses. |
| Planned delivery time | Promised time - the time an order was made on. For instance, a customer placed an order and requested a delivery by 5:00pm. |
| Postcode | Postal code |
| Price Category Card No. | Number of the card used to apply a price category |
| Price Category Cardholder | Name of the holder of the card used to apply a price category in the order |
| Price Category Contractor | Guest, employee or supplier whose card was used to apply a discount for the price category |
| Production place | Type of an item production place |
| Production place type | Type of the item production place specified in the stock list card |
| Quarter | Quarter No. |
| Receipt No. | Receipt number within a cash register shift |
| Receipt voiding | By the value specified in this field, one is able to determine whether or not a receipt was voided. Use the field to filter reversed orders. |
| Refund amount | Amount after discounts and surcharges a guest receives in case of voiding |
| Rewards total | Total bonuses accrued to a guest card This might be bonuses of any bonus card system except for Syrve Loyalty |
| Rewards type | External loyalty system type used to accrue rewards. |
| Section | Section name an item was sold in. |
| Service mode | Order-handling mode: Delivery, Collection, or Regular order. May be empty if the service mode has no default order type specified and the order has no type. |
| Serving delay (average) | This parameter shows how much a waiter lags behind the standard serving time. It is the gap between the standard serving time and the actual serving. The standard serving time consists of the standard time set in the preparation chart (10 minutes by default) and the time of tapping to select an item in the Syrve POS configuration file (1.5 minutes by default). The time is based on the standard cooking time, not the actual one. Estimated time is configured for a production place or for an item. |
| Serving time (average) | The parameter allows to assess the rate of service. It may take a long time for a waiter to take dishes as well as serve them. It covers the time from the end of dish preparation to the moment of serving it to a customer. |
| Serving time (min) | Time from opening to closing of order It is calculated according to the following formula: Serving time = Order сlosing time - Order opening time The parameter is a grouping field. Use it to group and filter the report data. |
| Serving time, overall (min) | Time from opening to closing of order This value is important for a group For instance, you are able to learn a serving time per day, shift, for an outlet, etc. |
| Shift No. | Number of the cash register shift, during which a sale took place |
| Sold with item | An item along which a modifier was sold |
| Stock list type | Type of the item stock list specified in the stock list record (product, item, modifier, semi-finished product) |
| Street | Street in the delivery address. |
| Subdivision code | Outlet code. It is assigned in the store settings |
| Surcharge % | Surcharge value in % applied to an order/item |
| Surcharge amount | It is calculated according to the following formula: (Surcharge rate * Amount net of discounts and surcharges) / 100 |
| Surcharge type | Name of the surcharge applied to the order. If there is more than one surcharge, they are given as a list in one row. Use the Name of discount or surcharge field to learn which item the surcharge is applied to. Check the OLAP Examples article for some examples. |
| Table No. | Number of the table where an order was registered. |
| Tax category | Tax category of a stock list item specified in the card or group card |
| Time in guest bill (min) | Guest bill time = Order сlosing time - Guest bill printing time Guest bill time does not match order opening time |
| To storage | Storage to which an item is transferred or where it is cooked For instance, in internal transfers, substitution records |
| Tot. travel time (min) | Total value for the Travel time parameter group For instance, when grouping by drivers or days. |
| Travel time (min) | Period of time from the moment a driver is dispatched, the Dispatch button is depressed, till an order is delivered (specified in Delivery Driver or Syrve POS) |
| Unit cost | Item cost It is calculated according to the following formula: Write-off amount / Write-off quantity |
| VAT (%) | VAT amount in % It is calculated based on the receipt data according to the following formula: Receipt VAT (amount) / Amount after discount net of VAT *100% |
| VAT by bill (Amount) | Total VAT of all items on the bill |
| Waiting time to be served (average) | This parameter shows the time a guest spent waiting for an order. It is the time from printing a dish to serving it to the customer. |
| Week No. | Week number an item was sold (1 through 53) |
| Week of month | Week number an item was sold (1 through 5) |
| Write-off reason | Comment posted at closing an order on the house You can enter such a comment if you select the Without Revenue payment type on the cash register screen of Syrve POS |
| Written off to employee | An employee a write-off was made to, e.g., lunch on the house |
| Year | Use this field to group the data by years |
| Zone | The value in the Delivery regions reference book (Delivery > General) specified manually in the delivery card |