SQL FIDDLE DATABASE
helpneeded2016
20160219165658sales_order.docx|
|
Sales Order |
|||||
|
|
|
|
|
|
|
|
|
Donuts-R-Us |
|
Date: |
May 6, 2014 |
|||
|
You eat them fresh, we bake them fresh. |
|
Donut Order ID: |
[1] |
|||
|
|
|
Customer ID: |
[1] |
|||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Customer: |
[First Name] [Last Name] |
|
|
|||
|
|
[Street Address] [Apt. #] |
|
|
|
||
|
|
[City, ST ZIP Code] |
|
|
|
||
|
|
[Home Phone] [Mobile Phone] [Other Phone] |
|
|
|||
|
|
||||||
|
Qty |
Donut ID |
Name |
Description |
Unit Price |
Line Total |
|
|
1 |
1 |
Plain |
Plain Donut |
$1.50 |
$1.50 |
|
|
5 |
2 |
Glazed |
Glazed Donut |
$1.75 |
$8.75 |
|
|
12 |
3 |
Cinnamon |
Cinnamon Donut |
$1.75 |
$21.00 |
|
|
3 |
4 |
Chocolate |
Chocolate Donut |
$1.75 |
$5.25 |
|
|
4 |
5 |
Sprinkle |
Sprinkle Donut |
$1.75 |
$7.00 |
|
|
5 |
6 |
Gluten-Free |
Gluten-Free Donut |
$2.00 |
$10.00 |
|
|
|
Subtotal |
$53.50 |
||||
|
|
Sales Tax |
10% |
||||
|
|
Total |
$58.85 |
||||
|
Special Handling Notes: |
|
|||||
|
Please include plates and napkins. |
|
|||||
|
] Thank you for your business! |
||||||
|
|
