I am looking to view cashier transaction details in various Point of Sale Systems that use SQL Databases.
Is there a standard format of tables that hold these details? Where and how would i be able to see where certain keystrokes are recorded in a Database?
I am basically looking at exception based reporting on cashier behavior.
How or where can i get training or advice on pulling this data into a separate Database and then running various queries to determine fraudulent behavior (i.e. Cashier rings up 4 adult tickets, then as they are taking payment they remove 3 of the adult tickets and replace them with 3 child tickets.
Any advice or assistance would be greatly appreciated.