Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Querying a MICROS 9700 Database
OK, I figured it out. The data appears to be in the TOTALS table, on rows where ttltype = 4. When I constrain on transactiondate (adjusting by 8 hours for some reason) the sum of amount1 ties to the amount on the reports.- wrob
- Post #2
- Forum: Point of sale systems
-
Querying a MICROS 9700 Database
I'm being asked to produce some numbers that appear on the "Cashier Financial" report out of a MICROS 9700 v3.0 system. I've found that most figures I can reproduce accurately using CHECKS, CHECK_DETAIL, TENDER_MEDIA_DETAIL and a few others, but "Tips Paid" is stumping me. I notice that...- wrob
- Thread
- Replies: 1
- Forum: Point of sale systems
