You are here: More > Supplemental Documents > Report Columns Index

Report Columns Index

This Report Columns Index provides a comprehensive list of columns used in report and on screens.

Avg Cost

Average cost of the item

Avg Sale Price

 

Avg Sold Price

Total sold price divided by the number of items sold

COGS

Average cost of the item at the time of the treansaction

Date

Date of the transaction

Department

Department attribute descriptor assigned to the item

Discount Type

Type of discount applied to the item.

Discounts

Amount of discount applied to the item

Excluded On Order

Number of items on order but not to be included in QoH calculations

Ext Avg Cost

 

Ext Last Cost

Extended Last Cost; Ext Last Cost = Last Cost x Qty

Ext Retail Price

 

First Name

First name of the customer

GP $

Gross Profit Dollars; GP$ = Price - Cost

GP %

Gross Profit Percentage; GP% = (Price - Cost) / Price

Item

Item attribute descriptor assigned to the item

Item Description

Description for the item

Last Cost

Last cost associated with the item

Last Name

Last name of the customer

Last Received Date

Last date on which the item was received

Manufacturer

Manufacturer attribute descriptor assigned to the item

Max Qty

Current Maximum quantity value

MFG #

Manufacturer reference number

Min Qty

Current Minimum quantity value

MTD Qty Sold

Number of items sold to date during the current month

Non Taxable Sales

Total non-taxable sales for the tax type.

On Order

Number of items that are on order 

PY MTD Qty Sold

Number of items sold to date during the corresponding month for today's date in the previous year

PY Qty Sold

Number of items sold during the previous year

QoH

Quantity on hand

Qty Sold

Total number of items sold

Register

Logical machine name

Retail Price

Retail price for the item

Sold Price

Price the item was sold for

Tax Amt

Amount of taxes paid on the item

Tax Collected

Taxes collected for each tax type

Tax Exempt Sales

 

Tax Rate

Tax rate for the tax type

Tax Type

Tax types that had sales

Taxable Sales

Total taxable sales for the tax type

Time

Time of the transaction

Total Sales

Total sales before tax

Total Sales w/Tax

Total sales plus taxes paid for the tax type

TRX #

Transaction number

TRX Type

Transaction type (i.e., Sale, Return, Special Order Sale, Layaway Sale, Work Order Sale)

UPC

Item's product UPC

User ID

Employee who sold the item

YTD Qty Sold

Number of items sold to date during the current year

 

 

 

 

 

© 2016 AcuSport Corporation
All rights reserved