Salesware Reporting : Performance reports : Specials Report : The essential tables that the report accesses are the following:
 
The essential tables that the report accesses are the following:
 
Table
Description
Transact
Holds all salespoint line items as well as transactions to account invoices.
Sp_group
Salespoint groups.
Op_group
Operator groups.
Sales_pt
Settings specific to each salespoint. Each salespoint keeps only one record from this table locally – its own.
Operator
Operators/employees.
Specials
Specials (pre-defined discounts) that can be granted at the Sales screen. Each item can also have specials associated with it.
Departme
List of all departments in the DCI.
Category
List of all categories in the DCI.
Items
List of all items in the DCI.