Salesware Reporting : Financial reports : Over/Short Report : The essential tables that the report accesses are the following:
 
The essential tables that the report accesses are the following:
 
Table
Description
Ovrshort
When cash drawers are closed out, the over and short for each payment type used in the cash out is recorded here.
Closeout
If the system is set up to allow cash drawers to be closed out, records of each closeout are stored here. Related to Sale_hdr and Ovrshort tables.
Prefs_sl
Preferences – Sales.
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.