How can query the database so that I can get the data Z report has? I am trying to get these data for a given month.
- Returns $ amount
- # of transactions
- # of 'aborted' and 'no sale' transaction (are those numbers included in #2 above?)
- # of customers (Is this the same as #2?)
- $ amount and # of credit card transactions
- $ amount and # of cash transactions
- # of items sold
I look at the XML code for the Z report but it refers to Report.Sales, Report.Cost, etc which I do not know where in the database exist. Thx.