Salesware Reporting : Performance reports : Comps and Refunds 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
List of user-defined operator groups.
Sales_pt
Settings specific to each location. Each salespoint keeps only one record from this table locally – its own.
Operator
Operators/employees.
Compprsn
Name of person issuing a comp.
Refreasn
Reasons for refunds.
Compreas
Reason for comp.
Pictures
Contains company logo and other pictures which can be stored in this table instead of separately on disk.
Prefs
General system preferences.