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 |