Sales Report Customer Number: 19321 Customer Name : Jon Smith : 520 Main St.,City Address Unit Price $20 Invoice Num Date 11/11/09 Quantity Ext'd Price $100 500 250 Invoice Total Part Num 12390 $850 2 5 1 3 10 25 50 10 12912 11/21/09 $300 10 $30 $300 Customer Total: $1,150 *** Customer Number: 19322 Customer Name : Mary Smith Address : 2289 Elm St., City Invoice Num Date 11/13/09 Invoice Total Part Num Quantity 10 Unit Price Ext'd Price 12421 $200 100 700 $1,000 6 $20 50 1 2 5 7 100 11/20/09 $30 $300 200 12901 $500 4 10 2 10 20 Customer Total: $1,500 Next Customer Next Customer

Quickbooks Online Accounting
3rd Edition
ISBN:9780357391693
Author:Owen
Publisher:Owen
Chapter5: Operating Activities: Purchases And Cash Payments
Section: Chapter Questions
Problem 2.11C
icon
Related questions
Question

Prepare the 3NF base tables needed to produce the sales report view shown in the diagram.

Sales Report
Customer Number: 19321
Customer Name : Jon Smith
: 520 Main St.,City
Address
Unit Price
$20
Invoice Num
Date
11/11/09
Quantity
Ext'd Price
$100
500
250
Invoice Total Part Num
12390
$850
2
5
1
3
10
25
50
10
12912
11/21/09
$300
10
$30
$300
Customer Total: $1,150
***
Customer Number: 19322
Customer Name : Mary Smith
Address
: 2289 Elm St., City
Invoice Num
Date
11/13/09
Invoice Total
Part Num
Quantity
10
Unit Price
Ext'd Price
12421
$200
100
700
$1,000
6
$20
50
1
2
5
7
100
11/20/09
$30
$300
200
12901
$500
4
10
2
10
20
Customer Total: $1,500
Next Customer
Next Customer
Transcribed Image Text:Sales Report Customer Number: 19321 Customer Name : Jon Smith : 520 Main St.,City Address Unit Price $20 Invoice Num Date 11/11/09 Quantity Ext'd Price $100 500 250 Invoice Total Part Num 12390 $850 2 5 1 3 10 25 50 10 12912 11/21/09 $300 10 $30 $300 Customer Total: $1,150 *** Customer Number: 19322 Customer Name : Mary Smith Address : 2289 Elm St., City Invoice Num Date 11/13/09 Invoice Total Part Num Quantity 10 Unit Price Ext'd Price 12421 $200 100 700 $1,000 6 $20 50 1 2 5 7 100 11/20/09 $30 $300 200 12901 $500 4 10 2 10 20 Customer Total: $1,500 Next Customer Next Customer
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Knowledge Booster
Cash Flows
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage