Data
Tables – IT Intranet (To be
used for VC 4)
prodid
|
prod |
cost |
onhand |
sellpr |
RD101 |
Rider |
$150.00 |
5 |
$275.00 |
MC201 |
MightyCat |
$165.50 |
4 |
$310.00 |
TB301 |
Trailblazer |
$203.00 |
3 |
$375.00 |
SF401 |
Starfire |
$223.00 |
2 |
$400.00 |
custid |
custlname |
custfname |
maddr |
city |
stateprov |
zippc |
country |
wphone |
hphone |
em |
bal |
R001 |
Rubic |
Wayne |
271
E River Road |
Green
Valley |
WI |
53190-4712 |
US |
262
734-2948 |
608
583-1506 |
coolcat@yahoo.com |
$318.00 |
M001 |
McRenolds |
Hayden |
367 Mattek Avenue |
DeKalb |
IL |
60115-4657 |
US |
815 753-6863 |
815 748-5671 |
hmcrenolds@niu.edu |
$283.00 |
K001 |
Knight
|
William |
412
Cokesbury Lane |
St.
Cloud |
MN |
56303-7012 |
US |
320
240-4894 |
Unlisted |
wknight@inmn.com |
|
A001 |
Atkins |
Kyle |
6W2756
Desert Blossom Road |
Phenox |
AZ |
65785-5627 |
US |
520
663-3455 |
520
906-0357 |
katkins@uplink.com |
$280.00 |
C001 |
Cybella |
Tom |
7215
Eastwood Drive |
Lincroft |
NY |
07378-1015 |
US |
908
422-9936 |
tdc@aol.com |
||
H001 |
Hopach |
Emily |
3072
Martha Lane |
Kent |
CT |
06577-6610 |
US |
860
927-6892 |
860
927-5821 |
snowbird@yahoo.com |
$320.00 |
K002 |
Kim |
Sam |
2226
Brookhill Close |
Pelican
Rapids |
MN |
56725-2077 |
US |
218
863-3489 |
218
863-6125 |
okim@inmn.org |
|
K003 |
Knight |
Susan |
19W632
Hogan Drive |
Cobb |
CA |
95426-9632 |
US |
707
982-7420 |
smknight@hotmail.com |
$405.00 |
|
S001 |
Swanson |
Rita |
10756
Bouchard Drive |
Iron
Mountain |
MI |
49801-3156 |
US |
906
677-4381 |
906
665-5868 |
rita_swanson@mn.bbb.gov |
|
C002 |
Chapman |
David |
9344
W Raintree Ave |
Scottsdale |
AZ |
85260-3459 |
US |
602
899-4718 |
638
898-7412 |
ddchapman@excite.com |
$405.00 |
Data
for Order Table
ordnumb |
custid |
prodid |
Saleamt |
ordate |
ordtype |
pay |
ctype |
cnumb |
expdate |
1 |
R001 |
RD101 |
$283.00 |
10/30/01 |
Sales Rep |
Card |
Vista |
38943267 |
12/2005 |
2 |
M001 |
RD101 |
$283.00 |
11/05/01 |
Internet |
Card |
Misery Card |
21845690 |
7/2005 |
3 |
K001 |
MC201 |
$318.00 |
11/07/01 |
Phone |
COD |
|||
4 |
A001 |
RD101 |
$280.00 |
11/10/01 |
Internet |
Card |
American Indebtedness |
99864572 |
9/2004 |
5 |
C001 |
TB301 |
$385.00 |
11/12/01 |
Sales Rep |
Check |
|||
6 |
H001 |
MC201 |
$320.00 |
11/15/01 |
Sales Rep |
Card |
Uncover |
22746981 |
6/2003 |
7 |
K002 |
RD101 |
$283.00 |
11/19/01 |
Phone |
Check |
|||
8 |
K003 |
SF401 |
$405.00 |
11/20/01 |
Internet |
Card |
Misery Card |
38902456 |
11/2004 |
9 |
S001 |
TB301 |
$383.00 |
11/26/01 |
Phone |
Check |
|||
10 |
C002 |
SF401 |
$405.00 |
11/28/01 |
Sales Rep |
Card |
Vista |
48239751 |
8/2002 |
11 |
R001 |
MC201 |
$318.00 |
12/04/01 |
Internet |
Card |
Vista |
38943267 |
12/2005 |