Micros 9700 Reporting

[davidstanley01]

Hi,
I'm trying to recreate the system financial summary report using SQL on a Micros 9700 v3.x system. The back-end is on MSSQL 2005. The specific data fields I'm looking for are the major group totals. Within the location_activity_db schema I've found the employee daily totals for netsales and such, but I need the values for the major group items, the various tender/media items, etc. All by Cashier/employee. Not sure where to go. Any help would be much appreciated.

Thanks.

 

[davidstanley01]

UPDATE:
Ok. So I've found the major item sales and tender types by rvc and can tie that to the system financial report. I still can't find a way to put together the employee/cashier sales reports. Any ideas?