Reporting Glossary-What Does Your Report Column Mean?

Quick guide to define the event report and order listing.

ORDERS DETAILS LISTING GLOSSARY

Column Headings Column Definition
Order ID Order number used to identify a unique order within the internal system
ConfirmationCode The code sent to customers to identify their order
Order Date Local Date and Time the order was taken
Payment Method Type of payment used
Venue Name of Venue
Event ID Event number
Event Date of the event
Event Is Deleted True/False fill as to whether the Event was deleted
Event Is Demo True/False fill as to whether the Event was created for Demo purposes
Vendor ID Assigned number to a specific vendor
Vendor Name Name of the vendor
Vendor Site ID Assigned number given to a specific vendor site
Vendor Site Name Name of the vendor site
Service Type Describes if the service was Pickup or Delivery
Order Status Describes if the order was Paid, Closed, Partial Refunded or Refunded
Delivery Status Describes if the order was Received, Delivered, Cancelled, or  Refunded
Section ID Assigned number given to a specific section 
Section Name of Section 
Row Row label
Seat Seat label
Customer First Name Customer First Name label
Customer Last Name Customer Last Name label
Customer Email Customer Email label
Customer Phone Customer Phone label
Member ID Assigned number given to a specific member
Member Email Member Email 
Member Is Demo Member Is Demo user only
Member Since Date and time the user became a member
Product Category Describes if the produce is Food, beverage, alcohol or merchandise
Product Master Product Master label
Product ID Product ID label
Product SKU Product SKU label
Product Product label
Quantity Number of items
Promo Code Unique code use to identify specific discount codes

Below section definitions apply to all columns labeled as Product and Modifiers.  Total columns are the combination of Product and Modifier columns 

Column Headings Column Definition
Product Pre-Discounted Price Price of the product before discount
Product Pre-Discounted Total Price of the product * quantity
Product Pre-Discounted Sales Tax Calculation of sales tax on pre discounted product
Product Pre-Discounted Alcohol Tax Calculation of Alcohol tax on pre discounted product
Product Pre-Discounted Subtotal Price of the product * quantity + pre tax fee
Product Pre-Discounted Post-Tax Fee Rivalry Convenience fee on item pre discounted
Product Pre-Discounted Net Sum of all order price, taxes, fees that are being discounted
Product Price Price of the product after discount if any
Product Gross Revenue Sum of the products price *quantity - Discounts
Product Revenue Share Rivalry portion of the transaction revenue 
Product Pre-Tax Fee Any fee attached to the product before taxes
Product Sales Tax Calculation of sales tax on products that are being discounted
Product Alcohol Tax Calculation of Alcohol tax on alcohol products that are being discounted
Product Subtotal Total of ordered product plus any pre tax fees (rev share maybe included in the product price)
Product Post-Tax Fee Rivalry Convenience fee
Product Final Collected Amount Sum of all order price, taxes, fees and tips
Product Gross Sales Sum of order price+taxes+fees- discounts
Product Net Order Sales Sum of price*quantity - discounts

 


EVENT SUMMARY REPORT IN MANAGEMENT APP

Summary Sections Column Definition
EVENT REVENUE
Sales Sum of the ordered products price including taxes
Customer Fees Total Rivalry Convenience fee
Tips Total collected tips for all event orders
Promotions Total discount amount applied to orders for the event
Total Collections Total amount of money Rivalry has collected
   
SERVICE STATS
Order Count Total number of orders for the event
Non-members Total number of orders placed outside of the Mlb app 
Members Total number of orders placed through the Mlb app 
Assigned Average time it took to assign an order
Completion Average time it took to complete an order
   
CATEGORY SUBTOTALS
Food Total Food sales for the event including taxes
Beverages  Total non alcohol drinks sales for the event including taxes
Alcohol Total alcohol drinks sales for the event including taxes
Merchandise Total Merchandise sales for the event including taxes
   
INVOICE SUMMARY
Rev Share Total amount of revenue sharing for the event; Rev share Calculation is an agreed upon % of each item sold using product price.   
Fees Total Rivalry Convenience fee
Invoice Total Total amount Rivalry will bill the client