Excercise Audit Trail

Excercise Audit Trail - ACCT-361: In-class Exercise Audit...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
ACCT-361: In-class Exercise – Audit Trail Sales Event Table Sales Event # Date Terms Salesperson ID Customer ID 1 11/5 2 10, net 30 3 2543 2 11/5 2 10, net 30 5 635 3 11/5 COD 7 1845 Sale-Inventory Table Sale Event # Inventory Item # Inventory Quantity Price each 1 876 10 1.25 1 674 8 0.875 1 451 30 0.995 2 887 54 1.475 2 513 188 0.525 3 736 36 24.995 3 001 58 7.875 3 302 16 8.00 3 224 114 8.75 Cash Receipts Event Table Cash Receipt # Date Check # Cashier ID Sales Event # Customer ID Cash Account # Amount Received 1001 11/6 11097 1 2 635 110146758 $ 178.35 Customer Table Customer ID Last Name First Name Address City State Zip 101 Conrad Chris 5629 Longfellow Dr. Paragould AK 65323 183 Anderson Paul 674 Sunderland Lane Sioux City IA 63126 635 Padgham Donna 1264 Algonquin Road Mason MI 48854 1845 Oliver Andrew 8512 Bonita Dr. Clearwater FL 33051 2543 Cook Carol 536 Secondary Ave. Fremont CA 75518
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Salesperson Table Salesperson ID Last Name First Name 1 Cleaves Mateen 3 Warrick Peter 5 Peterson
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/05/2011 for the course SOM 492 taught by Professor Minecar during the Spring '11 term at George Mason.

Page1 / 2

Excercise Audit Trail - ACCT-361: In-class Exercise Audit...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online