Column
|
Definition
|
Time
|
Local time the order was placed
|
Order ID
|
City Hive ID for the order
|
Transaction ID
|
ID provided by our Processor (Braintree), one order can have multiple Transaction IDs (e.g., if processing refunds)
|
Merchant Name
|
Name of the merchant that processed the order
For chains, this specifies the location that processed the order
|
Merchant ID
|
ID of merchant who processed the order
|
Confirmed At
|
Local time the order was approved
(Note: This action submits the order for settlement)
|
[Subtotal, Discount, Delivery Fee, Shipping Fee, Tax, Tip, Total] Price When Confirmed
|
This is a snapshot of the prices at time of confirmation
|
Sub-Total Amount
|
Sub-total amount of the order
|
[First Time, City Hive, Other] Coupon
|
Coupon amount if a coupon of specific type was applied
|
Referral Discount
|
Discount amount from a referral code
|
Split Coupon City Hive
|
City Hive’s portion of the split coupon
|
Split Coupon You
|
The merchant's portion of the split coupon
|
Coupon Name
|
Name of coupon
|
Underlying Discount Rule
|
These are automatic discounts of the store. This shows the price of any auto discounts that were applied
|
Underlying Discount Name
|
Name of automatic discount
|
Manual Discount
|
Price of discount that is applied through the Universal Dashboad
|
Discounted Subtotal
|
Subtotal amount less any applied discount
|
Store Credit Used
|
Amount of store credit applied to this order
|
Tax Amount
|
Amount of taxes
|
Tip Amount
|
Amount of tip
|
Delivery Fee
|
Amount of delivery fee
|
Shipping Fee
|
Amount of shipping fee
|
Drivers Tip
|
Amount applied to driver
|
Delivery Driver
|
Name of delivery driver
|
Delivery Service Fee
|
Fee from the delivery service used
|
Delivery Service Name
|
Name of delivery service used
|
City Hive Fee
|
Amount of City Hive fee for the order
|
Credit Card Fee
|
Amount of Credit Card Fee for the order
|
Fraud Insurance
|
Amount of Insurance Fee for the order
|
Total Amount
|
Total amount charge to the customer
|
Total Collected
|
Total amount to be disbursed to merchant (this amount will populate prior to disbursement, whereas "Disbursed to Your Account" will only populate after disbursement occurs)
|
Standing Balance
|
Total amount without City Hive Credit
|
Disbursement Date
|
Date the transaction was disbursed
|
Disbursed to your account
|
Final amount that was disbursed to the merchant's bank account
|
City Hive Credit
|
Amount of city hive credit applied to the order
|
Disbursement Plus City Hive Credit
|
Disbursement amount plus the credit earned from city hive discount credit
|
Number of Products
|
Number of products in the order
|
Product Barcodes
|
List of barcodes on this order
|
Product Names
|
List of names of products on this order
|
Original Product Quantity
|
Number of products before order edit
|
Original Product Subtotal
|
Sub-total of order before edit
|
Current Product Quantity
|
Number of products after edits
|
Current Product Subtotal
|
Sub-total of order after edit
|
Order Status
|
State the order is in (Confirmed/Declined/Refunded)
|
Order Type
|
What type of order (Shipping/Delivery/Pick Up)
|
Order Options
|
List of order options applied to this order
|
Customer Address
|
Address of customer
|
Customer Address District
|
County of customer’s address
|
Customer Phone Number
|
Phone number of customer
|
Customer Email
|
Email of customer
|
Customer Name
|
Name of customer
|
Tracking Number
|
Tracking number of shipping order
|
Weight x Size
|
Dimensions and weight of package
|