Return to DB
SALES REPRESENTATIVE FILE
| REP-ID |
LNAME |
FNAME |
REGION |
HDATE |
PHONE |
| 114 |
Abele |
Lori |
SW |
10-15-86 |
(602)624-9384 |
| 159 |
Higgins |
Heatheryn |
SE |
12-16-91 |
(404)524-8472 |
| 230 |
Sullivan |
Pat |
SE |
2-21-88 |
(305)734-2987 |
| 386 |
Speed |
Kristen |
NW |
6-14-90 |
(708)823-8222 |
| 349 |
Demaree |
Donn |
NW |
7-10-93 |
(206)634-1955 |
CUSTOMER FILE
| CUST-NO |
CNAME |
CITY |
REP-ID |
| 2934 |
Ballard Computer |
Seattle |
349 |
| 3007 |
Computer City |
Miami |
230 |
| 4987 |
LaserSystems |
Atlanta |
159 |
| 8987 |
Varner User Systems |
Naperville |
386 |
| 9185 |
CGI Computers |
Spokane |
349 |
| 9876 |
Computing Solutions |
Tucson |
114 |
ORDER FILE
| CUT-NO |
DATE |
ITEM-NO |
QTY |
| 3007 |
8-12-99 |
7639 |
11 |
| 4987 |
8-12-99 |
6720 |
15 |
| 8987 |
8-13-99 |
2378 |
14 |
| 9185 |
8-10-99 |
1628 |
10 |
| 9876 |
8-14-99 |
6720 |
20 |
INVENTORY FILE
| ITEM-NO |
DESCR |
QOH (Quantity on hands) |
| 1628 |
Hand scanner |
191 |
| 2378 |
Modem |
453 |
| 3457 |
Hard drive |
294 |
| 5647 |
Printer pack |
676 |
| 6720 |
3 1/2" disk holder |
982 |
| 6599 |
CD-ROM drive |
817 |
| 7639 |
Sound card |
0 |
| 8870 |
Mouse |
296 |
| 9037 |
Monitor |
152 |