Salesware Reporting : Performance reports : Zip Codes Report : The essential tables that the report accesses are the following:
 
The essential tables that the report accesses are the following:
 
Table
Description
Zipcode
Used to fill in city and state when zip code is entered.
Transact
Holds all salespoint line items as well as transactions to account invoices.
Sale_hdr
Header record for Sales. Related to Transact.
Sp_group
Salespoint groups.
Op_group
Operator groups.
Sales_pt
Settings specific to each location. Each salespoint keeps only one record from this table locally – its own.
Operator
Operators/employees.