Audience: Council Leaders only
Fields in Report with definitions:
System_Sale_ID: Transaction ID from system of record
Scout_Username: Username scout uses to log in to app
Scout_Name: Scout name provided in app
Scout_Code: Online code scout uses to track sales
Unit_Name: Unit scout is associated with
District_Name: District scout is associated with
Council_Name: Council scout is associated with
SKU_Name: Name of product sold
SKU: SKU of product sold
Quantity: Containers sold on order
Total_Line_Item_Amount: Total retail amount on order
Payment_Type: Cash or credit card.
Sale_Type: What type of sale was completed(Options listed below)
Wagon – sales made in app that are not associated with a storefront shift
Storefront – sales made in app that are associated with a storefront shift
Online – sales made on trails-end.com
UTC_Sale_Timestamp: Unix Timestamp of transaction
Sale_Status: Current status of the line item(Options listed below))
Completed – Order transaction has been completed
Pending – Wagon order has been taken but not completed in app
Partial Refund – Part of order was refunded
Refunded – Order transaction has been refunded
