Confused Please Help
cruzbusiness
valleeproducts.accdb| CoffeeCode | CoffeeName | CoffeeType | Decaf |
|---|---|---|---|
| AMAR | Amaretto | Flavored | true |
| BNUT | Banana Nut | Flavored | true |
| BRUM | Butter Rum | Flavored | true |
| BRZM | Brazilian Margopipe | Central & South American | false |
| CARC | Caramel Creme | Flavored | true |
| CCHR | Chocolate Cherry | Flavored | true |
| CELT | Celebes Toraja | Special Import | false |
| CINN | Cinnamon Stick | Flavored | true |
| COCO | Coconut Creme | Flavored | true |
| COLA | Colombian Aged Crop | Central & South American | true |
| COLF | Colombian French Roast | Central & South American | true |
| COLS | Colombian Supremo | Central & South American | true |
| COSC | Costa Rica Cartago | Central & South American | false |
| DUTB | Dutch Breakfast | Blended | true |
| ETHH | Ethiopian Harrar | African | true |
| FVAN | French Vanilla | Flavored | true |
| GEOR | Georgia Peach | Flavored | true |
| GERC | German Chocolate | Flavored | true |
| GUAC | Guatemala Coban | Central & South American | false |
| HAWK | Hawaiian Kona | Special Import | true |
| HAZL | Hazelnut Creme | Flavored | true |
| IRSH | Irish Creme | Flavored | true |
| JAMB | Jamaica Blue Mountain | Special Import | false |
| JRUM | Jamaican Rum | Flavored | true |
| KENA | Kenya AA | African | true |
| KENP | Kenya Peaberry | African | false |
| KONB | Kona Blend | Blended | true |
| MEXC | Mexican Cafe Pluma | Central & South American | false |
| MINT | Chocolate Mint | Flavored | true |
| MNUT | Macadamia Nut | Flavored | true |
| MOCH | Mocha Java Blend | Blended | true |
| NEYB | New York Blend | Blended | false |
| PAND | Peak of Andes | Central & South American | true |
| RASP | Black Raspberry | Flavored | true |
| SAFB | San Francisco Blend | Blended | true |
| SALM | Swiss Chocolate Almond | Flavored | true |
| SCHR | Sweet Cherry | Flavored | true |
| SPEC | Southern Pecan | Flavored | true |
| SUMM | Sumatra Mountain | Special Import | false |
| TANK | Tanzania Kibo Chagga | African | true |
| TANP | Tanzania Peaberry | African | false |
| VALD | Valle Dinner Blend | Blended | true |
| VALG | Valle Gourmet Blend | Blended | true |
| YEMM | Yemen Mocha | Special Import | false |
| CustomerNum | CustomerName | Street | City | State | ZipCode | OwnerName | Phone | FirstContact |
|---|---|---|---|---|---|---|---|---|
| 104 | Meadows Restaurant | Pond Hill Road | Monroe | MI | 48161 | Mr. Ray Suchecki | (313) 792-3546 | 2/28/91 |
| 107 | Cottage Grill | 82 Mix Avenue | Bootjack | MI | 49945 | Ms. Doris Reaume | (616) 643-8821 | 4/3/91 |
| 122 | Roadhouse Restaurant | 8408 E. Fletcher Road | Clare | MI | 48617 | Ms. Shirley Woodruff | (517) 966-8651 | 4/12/91 |
| 123 | Bridge Inn | 400 Salmon Street | Ada | MI | 49301 | Mr. Wayne Bouwman | (616) 888-9827 | 4/17/91 |
| 128 | Grand River Restaurant | 37 Queue Highway | Lacota | MI | 49063 | Mr. John Rohrs | (313) 729-5364 | 4/20/91 |
| 129 | Sandy Lookout Restaurant | 95 North Bay Boulevard | Jenison | MI | 49428 | Ms. Michele Yasenak | (616) 111-9148 | 4/27/91 |
| 131 | Bunker Hill Grill | 15365 Old Bedford Trail | Eagle Point | MI | 49031 | Mr. Ronald Kooienga | (906) 895-2041 | 5/1/90 |
| 133 | Florentine Restaurante | 2874 Western Avenue | Drenthe | MI | 49464 | Mr. Donald Bench | (616) 111-3260 | 5/3/91 |
| 135 | Topview Restaurant | 2840 McClain Road | Zeeland | MI | 49464 | Ms. Janice Stapleton | (616) 643-4635 | 5/11/91 |
| 136 | Cleo's Downtown Restaurant | 4090 Division Street NW | Borculo | MI | 49464 | Ms. Joan Hoffman | (616) 888-2046 | 5/11/91 |
| 163 | Bentham's Riverfront Restaurant | 1366 36th Street | Roscommon | MI | 48653 | Mr. Joe Markovicz | (517) 792-8040 | 5/18/91 |
| 165 | Sullivan's Restaurant & Lounge | 1935 Snow Street SE | Saugatuck | MI | 49453 | Ms. Dawn Parker | (616) 575-6731 | 5/19/91 |
| 201 | Wagon Train Restaurant | 5480 Alpine Lane | Selkirk | MI | 48661 | Mr. Carl Seaver | (517) 111-5545 | 5/25/92 |
| 202 | Extra Helpings Restaurant | 2140 Edgewood Road | Five Lakes | MI | 48446 | Ms. Deborah Wolfe | (517) 889-6003 | 5/25/92 |
| 203 | Mountain Lake Restaurant | 701 Bagley Street | Grand Rapids | MI | 49571 | Mr. Donald MacPherson | (616) 532-4499 | 5/25/92 |
| 322 | Alto Country Inn | 114 Lexington Parkway | Alto | MI | 49302 | Mr. James Cowan | (616) 888-7111 | 6/2/93 |
| 325 | Best Bet Restaurant | 56 Four Mile Road | Grand Rapids | MI | 49505 | Ms. Rebecca Van Singel | (616) 415-7294 | 6/12/93 |
| 407 | Jean's Country Restaurant | 44 Tower Lane | Mattawan | MI | 49071 | Ms. Jean Brooks | (517) 620-4431 | 9/18/93 |
| 423 | Bay Pointe Restaurant | 11456 Marsh Road | Shelbyville | MI | 49344 | Mr. Janosfi Petofi | (616) 679-5681 | 10/24/93 |
| 515 | Cheshire Restaurant | 8200 Baldwin Boulevard | Burlington | MI | 49029 | Mr. Jeffrey Hersha | (517) 717-9855 | 12/24/93 |
| 597 | Around the Clock Restaurant | 3333 Bradford Farms | Copper Harbor | MI | 49918 | Ms. Jennifer Lewis | (906) 273-9465 | 6/24/94 |
| 620 | Brandywine Restaurant | 150 Hall Road | Kearsarge | MI | 49942 | Mr. Walter Reed | (906) 124-1824 | 7/3/94 |
| 624 | South Bend Brewing Company | 431 North Phillips Road | South Bend | IN | 46611 | Mr. Toby Stein | (219) 332-4847 | 7/17/94 |
| 625 | Maxwell's Restaurant | 230 South Phillips Road | South Bend | IN | 46623 | Ms. Barbara Feldon | (219) 333-0000 | 7/19/94 |
| 627 | Monarch Restaurant | 3915 Hawthorne Avenue | Toledo | OH | 43603 | Mr. Gilbert Scholten | (419) 332-2681 | 7/29/94 |
| 635 | Oaks Restaurant | 3300 West Russell Street | Maumee | OH | 43537 | Ms. Julie Pfeiffer | (419) 336-9000 | 9/13/94 |
| 646 | Golden Gate Restaurant | 2890 Canyonside Way | Romulus | MI | 48174 | Ms. Nancy Mills | (313) 888-7778 | 11/12/94 |
| 650 | The Peppermill | 109 East Monroe Avenue | Elkhart | IN | 46515 | Ms. Tara Jerentowski | (219) 334-3980 | 10/10/94 |
| 652 | Apple Blossom Inn | 915 South Creek Drive | Grand Rapids | MI | 49587 | Ms. Pam Leonard | (616) 755-1736 | 12/8/94 |
| 687 | The Brittany Restaurant | 6 Bayberry Pointe Drive | Topaz | MI | 49925 | Mr. Ken Hodge | (517) 331-7388 | 1/5/95 |
| 726 | Four Star Steakhouse | 1925 Bridge Street | Halfway Corner | MI | 48441 | Mr. Gregory Olson | (906) 434-4192 | 1/3/95 |
| 741 | Prime Cut Steakhouse | 2819 East 10 Street | Mishawaka | IN | 46544 | Ms. Gretchen Fletcher | (219) 336-0900 | 1/18/95 |
| 742 | Cherry Creek Inn | 4005 West Madison Road | Toledo | OH | 43617 | Mr. Douglas Viereck | (419) 336-2333 | 2/22/95 |
| 750 | Grain Bin Inn | 5013 North Cliff Avenue | LaPorte | IN | 46351 | Ms. Bridgit Feeney | (219) 339-1264 | 5/19/95 |
| 779 | Gateway Lounge | 3408 Gateway Boulevard | Sylvania | OH | 43560 | Ms. Susan Mouw | (419) 361-1137 | 3/5/96 |
| 783 | First Edition Restaurant | 3509 Garfield Avenue | Romulus | MI | 48174 | Mr. Shannon Petree | (313) 461-8899 | 5/12/96 |
| 788 | The Empire | 10 Sycamore Street | Grand Rapids | MI | 49509 | Ms. Curtis Haiar | (616) 762-9144 | 9/16/96 |
| 798 | Embers Restaurant | 4004 West 41st Street | Goshen | IN | 46526 | Mr. Clifford Merritt | (219) 816-2456 | 3/2/97 |
| ProductCode | CoffeeCode | WeightCode | Price | Decaf |
|---|---|---|---|---|
| 2301 | COLA | A | ¤ 7.99 | |
| 2303 | MOCH | A | ¤ 7.99 | |
| 2304 | CINN | A | ¤ 8.99 | |
| 2306 | AMAR | A | ¤ 8.99 | |
| 2309 | COCO | A | ¤ 8.99 | |
| 2310 | BRUM | A | ¤ 8.99 | |
| 2313 | GEOR | A | ¤ 8.99 | |
| 2316 | JRUM | A | ¤ 8.99 | |
| 2318 | CCHR | A | ¤ 8.99 | |
| 2320 | MNUT | A | ¤ 9.99 | |
| 2322 | KENP | A | ¤ 8.99 | |
| 2324 | RASP | A | ¤ 8.99 | |
| 2329 | COLS | A | ¤ 7.99 | |
| 2330 | TANP | A | ¤ 8.99 | |
| 2331 | COSC | A | ¤ 7.99 | |
| 2334 | VALD | A | ¤ 7.99 | |
| 2336 | DUTB | A | ¤ 7.99 | |
| 2338 | SALM | A | ¤ 8.99 | |
| 2342 | GUAC | A | ¤ 7.99 | |
| 2344 | ETHH | A | ¤ 8.99 | |
| 2345 | CELT | A | ¤ 11.99 | |
| 2346 | BRZM | A | ¤ 7.99 | |
| 2349 | COLF | A | ¤ 7.99 | |
| 2350 | GERC | A | ¤ 8.99 | |
| 2352 | KONB | A | ¤ 7.99 | |
| 2354 | HAZL | A | ¤ 8.99 | |
| 2357 | IRSH | A | ¤ 8.99 | |
| 2359 | TANK | A | ¤ 8.99 | |
| 2360 | JAMB | A | ¤ 42.99 | |
| 2362 | BNUT | A | ¤ 8.99 | |
| 2363 | VALG | A | ¤ 7.99 | |
| 2365 | KENA | A | ¤ 8.99 | |
| 2367 | HAWK | A | ¤ 16.99 | |
| 2372 | CARC | A | ¤ 8.99 | |
| 2374 | NEYB | A | ¤ 7.99 | |
| 2376 | MEXC | A | ¤ 7.99 | |
| 2377 | SCHR | A | ¤ 8.99 | |
| 2380 | YEMM | A | ¤ 12.99 | |
| 2381 | SPEC | A | ¤ 8.99 | |
| 2386 | PAND | A | ¤ 8.49 | |
| 2388 | SUMM | A | ¤ 10.99 | |
| 2395 | MINT | A | ¤ 8.99 | |
| 2396 | FVAN | A | ¤ 8.99 | |
| 2398 | SAFB | A | ¤ 7.99 | |
| 2401 | COLA | B | ¤ 38.00 | |
| 2403 | MOCH | B | ¤ 36.00 | |
| 2404 | CINN | B | ¤ 42.00 | |
| 2406 | AMAR | B | ¤ 42.00 | |
| 2409 | COCO | B | ¤ 42.00 | |
| 2410 | BRUM | B | ¤ 42.00 | |
| 2413 | GEOR | B | ¤ 42.00 | |
| 2416 | JRUM | B | ¤ 42.00 | |
| 2418 | CCHR | B | ¤ 42.00 | |
| 2420 | MNUT | B | ¤ 45.00 | |
| 2422 | KENP | B | ¤ 42.00 | |
| 2424 | RASP | B | ¤ 42.00 | |
| 2429 | COLS | B | ¤ 36.00 | |
| 2430 | TANP | B | ¤ 42.00 | |
| 2431 | COSC | B | ¤ 38.00 | |
| 2434 | VALD | B | ¤ 34.00 | |
| 2436 | DUTB | B | ¤ 36.00 | |
| 2438 | SALM | B | ¤ 42.00 | |
| 2442 | GUAC | B | ¤ 38.00 | |
| 2444 | ETHH | B | ¤ 42.00 | |
| 2445 | CELT | B | ¤ 61.00 | |
| 2446 | BRZM | B | ¤ 38.00 | |
| 2449 | COLF | B | ¤ 38.00 | |
| 2450 | GERC | B | ¤ 42.00 | |
| 2452 | KONB | B | ¤ 36.00 | |
| 2454 | HAZL | B | ¤ 42.00 | |
| 2457 | IRSH | B | ¤ 42.00 | |
| 2459 | TANK | B | ¤ 42.00 | |
| 2460 | JAMB | B | ¤ 234.00 | |
| 2462 | BNUT | B | ¤ 44.50 | |
| 2463 | VALG | B | ¤ 34.00 | |
| 2465 | KENA | B | ¤ 42.00 | |
| 2467 | HAWK | B | ¤ 86.00 | |
| 2472 | CARC | B | ¤ 42.00 | |
| 2474 | NEYB | B | ¤ 36.00 | |
| 2476 | MEXC | B | ¤ 38.00 | |
| 2477 | SCHR | B | ¤ 42.00 | |
| 2480 | YEMM | B | ¤ 66.00 | |
| 2481 | SPEC | B | ¤ 42.00 | |
| 2486 | PAND | B | ¤ 41.00 | |
| 2488 | SUMM | B | ¤ 55.00 | |
| 2495 | MINT | B | ¤ 42.00 | |
| 2496 | FVAN | B | ¤ 42.00 | |
| 2498 | SAFB | B | ¤ 36.00 | |
| 2506 | AMAR | C | ¤ 21.00 | |
| 2538 | SALM | C | ¤ 21.00 | |
| 2554 | HAZL | C | ¤ 21.00 | |
| 2557 | IRSH | C | ¤ 21.00 | |
| 2596 | FVAN | C | ¤ 21.00 | |
| 2634 | VALD | D | ¤ 33.50 | |
| 2663 | VALG | D | ¤ 33.50 | |
| 2706 | AMAR | E | ¤ 38.00 | |
| 2729 | COLS | E | ¤ 36.00 | |
| 2734 | VALD | E | ¤ 35.00 | |
| 2738 | SALM | E | ¤ 38.00 | |
| 2754 | HAZL | E | ¤ 38.00 | |
| 2757 | IRSH | E | ¤ 38.00 | |
| 2763 | VALG | E | ¤ 35.00 | |
| 2796 | FVAN | E | ¤ 38.00 | |
| 2834 | VALD | F | ¤ 50.00 | |
| 2863 | VALG | F | ¤ 50.00 | |
| 2929 | COLS | G | ¤ 60.00 | |
| 2934 | VALD | G | ¤ 58.50 | |
| 2963 | VALG | G | ¤ 58.50 | |
| 9301 | COLA | A | ¤ 8.99 | D |
| 9303 | MOCH | A | ¤ 8.99 | D |
| 9304 | CINN | A | ¤ 9.99 | D |
| 9306 | AMAR | A | ¤ 9.99 | D |
| 9309 | COCO | A | ¤ 9.99 | D |
| 9310 | BRUM | A | ¤ 9.99 | D |
| 9313 | GEOR | A | ¤ 9.99 | D |
| 9316 | JRUM | A | ¤ 9.99 | D |
| 9318 | CCHR | A | ¤ 9.99 | D |
| 9320 | MNUT | A | ¤ 10.99 | D |
| 9324 | RASP | A | ¤ 9.99 | D |
| 9329 | COLS | A | ¤ 8.99 | D |
| 9334 | VALD | A | ¤ 8.99 | D |
| 9336 | DUTB | A | ¤ 8.99 | D |
| 9338 | SALM | A | ¤ 9.99 | D |
| 9344 | ETHH | A | ¤ 9.99 | D |
| 9349 | COLF | A | ¤ 8.99 | D |
| 9350 | GERC | A | ¤ 9.99 | D |
| 9352 | KONB | A | ¤ 8.99 | D |
| 9354 | HAZL | A | ¤ 9.99 | D |
| 9357 | IRSH | A | ¤ 9.99 | D |
| 9359 | TANK | A | ¤ 9.99 | D |
| 9362 | BNUT | A | ¤ 9.99 | D |
| 9363 | VALG | A | ¤ 8.99 | D |
| 9365 | KENA | A | ¤ 9.99 | D |
| 9367 | HAWK | A | ¤ 17.99 | D |
| 9372 | CARC | A | ¤ 9.99 | D |
| 9377 | SCHR | A | ¤ 9.99 | D |
| 9381 | SPEC | A | ¤ 9.99 | D |
| 9386 | PAND | A | ¤ 9.49 | D |
| 9395 | MINT | A | ¤ 9.99 | D |
| 9396 | FVAN | A | ¤ 9.99 | D |
| 9398 | SAFB | A | ¤ 8.99 | D |
| 9401 | COLA | B | ¤ 44.00 | D |
| 9403 | MOCH | B | ¤ 41.00 | D |
| 9404 | CINN | B | ¤ 46.50 | D |
| 9406 | AMAR | B | ¤ 46.50 | D |
| 9409 | COCO | B | ¤ 46.50 | D |
| 9410 | BRUM | B | ¤ 46.50 | D |
| 9413 | GEOR | B | ¤ 46.50 | D |
| 9416 | JRUM | B | ¤ 46.50 | D |
| 9418 | CCHR | B | ¤ 46.50 | D |
| 9420 | MNUT | B | ¤ 49.50 | D |
| 9424 | RASP | B | ¤ 46.50 | D |
| 9429 | COLS | B | ¤ 41.00 | D |
| 9434 | VALD | B | ¤ 39.50 | D |
| 9436 | DUTB | B | ¤ 41.00 | D |
| 9438 | SALM | B | ¤ 46.50 | D |
| 9444 | ETHH | B | ¤ 46.50 | D |
| 9449 | COLF | B | ¤ 44.00 | D |
| 9450 | GERC | B | ¤ 46.50 | D |
| 9452 | KONB | B | ¤ 41.00 | D |
| 9454 | HAZL | B | ¤ 46.50 | D |
| 9457 | IRSH | B | ¤ 46.50 | D |
| 9459 | TANK | B | ¤ 46.50 | D |
| 9462 | BNUT | B | ¤ 48.00 | D |
| 9463 | VALG | B | ¤ 39.50 | D |
| 9465 | KENA | B | ¤ 46.50 | D |
| 9467 | HAWK | B | ¤ 91.00 | D |
| 9472 | CARC | B | ¤ 46.50 | D |
| 9477 | SCHR | B | ¤ 46.50 | D |
| 9481 | SPEC | B | ¤ 46.50 | D |
| 9486 | PAND | B | ¤ 45.00 | D |
| 9495 | MINT | B | ¤ 46.50 | D |
| 9496 | FVAN | B | ¤ 46.50 | D |
| 9498 | SAFB | B | ¤ 41.00 | D |
| 9554 | HAZL | C | ¤ 22.00 | D |
| 9596 | FVAN | C | ¤ 22.00 | D |
| 9634 | VALD | D | ¤ 35.50 | D |
| 9663 | VALG | D | ¤ 35.50 | D |
| 9729 | COLS | E | ¤ 37.50 | D |
| 9734 | VALD | E | ¤ 36.50 | D |
| 9754 | HAZL | E | ¤ 40.00 | D |
| 9763 | VALG | E | ¤ 36.50 | D |
| 9796 | FVAN | E | ¤ 40.00 | D |
| 9834 | VALD | F | ¤ 53.00 | D |
| 9863 | VALG | F | ¤ 53.00 | D |
| 9929 | COLS | G | ¤ 63.00 | D |
| 9934 | VALD | G | ¤ 61.00 | D |
| 9963 | VALG | G | ¤ 61.00 | D |
| WeightCode | Weight/Size |
|---|---|
| A | 1 lb pkg |
| B | 6 lb case |
| C | 24 ct 1.5 oz pkg |
| D | 44 ct 1.25 oz pkg |
| E | 44 ct 1.5 oz pkg |
| F | 88 ct 1.25 oz pkg |
| G | 88 ct 1.5 oz pkg |
