Glossary of Report Columns
| Column Name | Description |
| # of Customers | The number of customers who have used the discount |
| # of Orders | The number of orders associated with this row in the report |
| # of Returns | The number of returns for that item/day/customer depending on the report |
| # of Units | The number of units associated with the given row in the report |
| # of Units Sold | The number of units sold for the given day |
| Avg. Cost | The average cost of a product |
| Avg. Order Value | Sum of order total / total number of orders |
| Avg. Price | The average price of a product |
| Avg. Return Value | The average value of returned products |
| Avg. Total | The average order total amount of the orders this customer has made |
| Bin Number | The location of the item within the warehouse |
| COGS | Cost Of Goods Sold: Costs associated with a particular product which may include things like material, labor, and allocated overhead |
| Company Name | Name of the vendor company |
| Cost | The cost of a product |
| Cost of Inv. On Hand | The cost of the inventory of the associated product that is on hand |
| Cost of Inv. Sold | The cost of the inventory of the associated product that has been sold |
| Coupon Code | The coupon code for the associated discount |
| Current Qty. On Hand | Amount of current inventory that is either available or committed |
| Customer Name | Name of a customer |
| Customer Number | The store ID number for a customer |
| Discounts | Total discounts applied to orders the customer has returned |
| Discount Amount | The amount of money that the discount lowers the price |
| Discount Created Date | The date the discount was created |
| Discount Name | The name of the discount |
| Discount Type | Type of discount: Percentage, free shipping, buy one get one % off, etc. |
| First Redeemed Date | The date of the first instance that a discount was used by a customer |
| Gross Profit | Gross Sales - Total Costs |
| Gross Profit % | The percentage of Net Sales that is attributed to Gross Profit |
| Gross Return Amount | Total amount that all returns are worth for that day/customer depending on the report |
| Gross Sales | Sum of [(Price - DiscountAmont) * QtyOrdered] |
| Items Sold | The number of items sold |
| Last Received Date | The most recent date the item was received into stock |
| Last Redeemed Date | The date of the most recent instance that a discount was used by a customer |
| Last Return Date | The date of the most recent instance that a product was returned |
| Last Sold Date | The date of the most recent instance that a product was sold |
| Location Name | The name of the location where the inventory is kept |
| Net Sales | |
| Order Date | The date the order was placed |
| Order Number | The ID number of the order |
| Order Tax | The total tax applied to the order |
| Order Total | The total cost to the customer of the order |
| Payment Status | Status of a payment: Unpaid, Paid, Overpaid |
| Payment Type | The type of method used to pay |
| Preferred Location | The preferred location for a product to be located |
| Preferred Stock Level | The preferred amount of inventory of a specific product to be maintained at a location |
| Preferred Vendor | The preferred vendor for this product |
| Preferred Vendor SKU | The SKU of the preferred vendor for this product |
| Product Name | The name of the product |
| Product Type | The type of the product (example: Inventory Item) |
| Profit | The surplus after total costs have been deducted from total revenue |
| Purchases | The number of times the product was purchased |
| Qty. Available | The amount of this product in inventory that is available to sell |
| Qty. Backordered | The amount of this out-of-stock product that has been ordered to ship once inventory has been restocked |
| Qty. Committed | Quantity on order which has not yet been shipped |
| Qty. Fulfilled | Quantity on order which has been shipped |
| Qty. On Hand | Quantity in inventory that is either available or committed |
| Qty. On Order | Quantity that has been placed on a purchase order to refill inventory |
| Qty. Ordered | The quantity of the product which has been ordered |
| Qty. Sold | The quantity of the product which has been sold |
| Re-Order Point | Once the stock level for a product reaches this amount, an order will automatically be placed to replenish stock |
| Restocking Fee | The fee that will be charged to a customer to accommodate the cost of restocking a returned product |
| Return Date | The date which the product was returned |
| Sale Price | The price of the product after the sale discount is applied |
| Sales Order # | The ID number of the sales order |
| Shipping & Handling | The amount of shipping and handling fees applied to an order |
| Shipping Cost | The cost to ship the order |
| Shipping State | The state in the United States from which an order is being shipped |
| SKU | Stock Keeping Unit: a unique identifier for each product |
| Tax | The amount of tax added to an order |
| To Order | Preferred stock level - quantity available - quantity backordered |
| Total Cost | Sum of (Cost * QtyOrdered) |
| UPC Code | Universal Product Code: the barcode number used for tracking products |
| Value of Inventory | The value of the inventory of a product |
| Vendor Contact | The person to contact who represents the vendor |
| Vendor Name | The name of the vendor |
| Vendor Number | The ID number of the vendor |
| Warehouse Location | The location of the warehouse where a product is being stored |