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