Access Chapter 8 Capstone - Registry (PC only)
suman13
gurung_Exp19_Access_Ch8_Cap_Registry.accdb| CustomerNum | LastName | FirstName | BillingAddress | ShippingAddress | City | State | PostalCode | Phone | mSysRowId |
|---|---|---|---|---|---|---|---|---|---|
| 0510050 | Jeffries | Luke | 4337 NANTUCKET DRIVE NW | 2714 VON THURINGER CT | GREENSBORO | NC | 27455-1509 | 3.362187311E9 | ujb9Qyp3kVIwQ7bkis4tt4QJuU5Ex3Cc7L7ap/5sKwE=-~WSAcI/5ynyOOOQnHlz2i8A== |
| 0510350 | Strader | Cathy | 1257 TULA LAMBERT RD | 517 SOUTH 3RD AVENUE | WILMINGTON | NC | 28403 | 9.103956053E9 | ujb9Qyp3kVIwQ7bkis4tt4QJuU5Ex3Cc7L7ap/5sKwE=-~WSAcI/5ynyOOOQnHlz2i8A== |
| 0510850 | Ormsby | Hank | 606 17TH AVENUE DR SE | 403 THE CAPE BLVD. | FARMVILLE | NC | 27828 | 2.527536988E9 | ujb9Qyp3kVIwQ7bkis4tt4QJuU5Ex3Cc7L7ap/5sKwE=-~WSAcI/5ynyOOOQnHlz2i8A== |
| 0510950 | Blanchard | Walter | 103 MEADOWGLADES LN | 4126 BARRETT DR. | WILMINGTON | NC | 28412 | 9.103929761E9 | ujb9Qyp3kVIwQ7bkis4tt4QJuU5Ex3Cc7L7ap/5sKwE=-~WSAcI/5ynyOOOQnHlz2i8A== |
| 0512950 | Moyers | Jane | 4451 SHIMPOCK ROAD | 2867 TREESTEAD CIRCLE | GREENSBORO | NC | 27410-8312 | 3.366681063E9 | ujb9Qyp3kVIwQ7bkis4tt4QJuU5Ex3Cc7L7ap/5sKwE=-~WSAcI/5ynyOOOQnHlz2i8A== |
| 0513350 | Ritzema | Doris | 710 DARWIN DRIVE | 4632 LONG LEAF HILLS DR | CLEARWATER | FL | 34624 | 8.135311845E9 | ujb9Qyp3kVIwQ7bkis4tt4QJuU5Ex3Cc7L7ap/5sKwE=-~WSAcI/5ynyOOOQnHlz2i8A== |
| 0514450 | Moyers | Jane | 4451 SHIMPOCK ROAD | 2856 PARK PL | GREENSBORO | NC | 27410-8312 | 3.366681063E9 | ujb9Qyp3kVIwQ7bkis4tt4QJuU5Ex3Cc7L7ap/5sKwE=-~WSAcI/5ynyOOOQnHlz2i8A== |
| 0515050 | Lee | Kathy | 2109 B HARKEY AVE. | 1200 WOODACRE CIRCLE | RALEIGH | NC | 27614 | 9.096766373E9 | ujb9Qyp3kVIwQ7bkis4tt4QJuU5Ex3Cc7L7ap/5sKwE=-~WSAcI/5ynyOOOQnHlz2i8A== |
| 0516650 | Amdahl | Rammy | 5001 BRENWOOD CT | 3116 LANTERN WAY | GREENSBORO | NC | 27409 | 3.366680262E9 | ujb9Qyp3kVIwQ7bkis4tt4QJuU5Ex3Cc7L7ap/5sKwE=-~WSAcI/5ynyOOOQnHlz2i8A== |
| 0519250 | Oates | Helen | 6840 THAMES DR | 4414 DRIFTWOOD DR | CONCORD | NC | 28027 | 7.04786861E9 | ujb9Qyp3kVIwQ7bkis4tt4QJuU5Ex3Cc7L7ap/5sKwE=-~WSAcI/5ynyOOOQnHlz2i8A== |
| 0521850 | Ketner | Leonard | 1236 TOMMIES DRIVE | 5105 HUNTINGDON DR | WILMINGTON | NC | 28403 | 9.103933441E9 | ujb9Qyp3kVIwQ7bkis4tt4QJuU5Ex3Cc7L7ap/5sKwE=-~WSAcI/5ynyOOOQnHlz2i8A== |
| 0521950 | Gergens | Phyllis | 3600 OPEN SIGHT COURT | 212 DAVIS ST | KANNAPOLIS | NC | 28083 | 7.049328212E9 | ujb9Qyp3kVIwQ7bkis4tt4QJuU5Ex3Cc7L7ap/5sKwE=-~WSAcI/5ynyOOOQnHlz2i8A== |
| 0542850 | Lewis | Karen | PO BOX 123 | 8837 CAMPFIRE TR | BROWNS SUMMIT | NC | 27214 | 3.366570115E9 | ujb9Qyp3kVIwQ7bkis4tt4QJuU5Ex3Cc7L7ap/5sKwE=-~WSAcI/5ynyOOOQnHlz2i8A== |
| 0546950 | Sink | Dale | 5201 FIELDBROOK DR | 3400 STALLION COURT | GREENSBORO | NC | 27406 | 3.366740627E9 | ujb9Qyp3kVIwQ7bkis4tt4QJuU5Ex3Cc7L7ap/5sKwE=-~WSAcI/5ynyOOOQnHlz2i8A== |
| 0553950 | Wessell | Becky | 635 ISLAND DRIVE | 4215 BRINGLE FERRY ROAD | DALLAS | TX | 75231-4016 | 2.143492669E9 | ujb9Qyp3kVIwQ7bkis4tt4QJuU5Ex3Cc7L7ap/5sKwE=-~WSAcI/5ynyOOOQnHlz2i8A== |
| 0571350 | Wertz | Becky | 7753 ALEXANDER RD #6 | 502 N FRANKLIN ST | CHARLOTTE | NC | 28215 | 7.045363158E9 | ujb9Qyp3kVIwQ7bkis4tt4QJuU5Ex3Cc7L7ap/5sKwE=-~WSAcI/5ynyOOOQnHlz2i8A== |
| 0578850 | Donohoe | S Suzanne | 1018 WENTWORTH DR. | 4101 PALMETTO PL | WILMINGTON | NC | 28412-0976 | 9.103950765E9 | ujb9Qyp3kVIwQ7bkis4tt4QJuU5Ex3Cc7L7ap/5sKwE=-~WSAcI/5ynyOOOQnHlz2i8A== |
| 0579550 | Peterson | George | 9228 LIGON CT | 5905 SUNCREEK CT | CANTON | GA | 30114-4509 | 7.044362517E9 | ujb9Qyp3kVIwQ7bkis4tt4QJuU5Ex3Cc7L7ap/5sKwE=-~WSAcI/5ynyOOOQnHlz2i8A== |
| 0588050 | Jackson | Lynn | 1506 SCALES ST | 5906 MARSHBANK LANE | SUMMERFIELD | NC | 27358 | 3.366440157E9 | ujb9Qyp3kVIwQ7bkis4tt4QJuU5Ex3Cc7L7ap/5sKwE=-~WSAcI/5ynyOOOQnHlz2i8A== |
| 0598050 | Wessenauer | Becky | 6340 STAPLETON DRIVE | 421 BLUE ROCK DR | DALLAS | TX | 75231-4016 | 2.143492669E9 | ujb9Qyp3kVIwQ7bkis4tt4QJuU5Ex3Cc7L7ap/5sKwE=-~WSAcI/5ynyOOOQnHlz2i8A== |
| 0598150 | Steffen | Chip | 703 SOUTHERN CHARM DR | 4524 VITEX STREET | CONCORD | NC | 28025 | 7.047864701E9 | ujb9Qyp3kVIwQ7bkis4tt4QJuU5Ex3Cc7L7ap/5sKwE=-~WSAcI/5ynyOOOQnHlz2i8A== |
| 0599950 | Amerson | Paul | 5001 KOREM DRIVE | 312 BROOK STREET | GREENSBORO | NC | 27409 | 3.366680262E9 | ujb9Qyp3kVIwQ7bkis4tt4QJuU5Ex3Cc7L7ap/5sKwE=-~WSAcI/5ynyOOOQnHlz2i8A== |
| TitleID | Description | mSysRowId |
|---|---|---|
| 0610465 | Showroom Assistant Trainee | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 0610466 | Showroom Assistant | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 0614066 | Supervisor, Sales | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 062366 | Coordinator, Call Collects | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 0626266 | Sales Associate 1 | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 0628866 | Showroom Sales Associate | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 0629066 | Supervisor, Showroom | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 063566 | Customer Service Representative | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 0648266 | Internet Services Associate 1 | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 0648366 | Call Center Administrator | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 0649065 | Online Auctions Trainee | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 0649066 | Online Auctions Specialist | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 0652066 | Inv Customer Service Rep 1 | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 0653366 | Shelver | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 0657666 | Lead, Internet Services | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 0660466 | Mail Processing Technician | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 0663766 | Lead, Showroom Sales | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 0664966 | Customer Service Representative-Online Auctions | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 0666566 | Order/Report Care Specialist | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 06666 | Administrative Assistant | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 0666766 | Manager, Call Center | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 0667066 | Telephone Sales Trainer | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 0669066 | VP, Customer Service Operations | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 0671166 | Chairman and CEO | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 0671466 | Executive Assistant, Senior VP's & CIO | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 067466 | Manager, Showroom | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 068765 | Purchasing Agent Trainee | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 068766 | Purchasing Agent | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| 069266 | Returns Specialist | tnslafOHUtjQNihdjn6/T8so1vhib3y/zdArz7cCYF8=-~HuN3npH5klHA1tt0rbplSw== |
| UserID | TitleID | LastName | FirstName | Address | City | State | PostalCode | Phone | HireDate | TermDate | TermReason |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 81094880 | 0649066 | Cox | Tim | 1012 TRADERS TRAIL | SAN FRANCISCO | CA | 94116-3039 | 9195671893 | 1/31/09 | ||
| 81095180 | 0648266 | Bowman | Jeanette | 1018 WENTWORTH DR. | SALISBURY | NC | 28146-8856 | 9198512318 | 4/16/06 | ||
| 81105880 | 069266 | Rhynes | Judy | 100 CIRCLEVIEW DR | STEAMBOAT SPRING | CO | 80488-1895 | 9103926711 | 12/12/04 | ||
| 81112780 | 0626266 | Bolick | Marion | 1101 CENTENNARY DRIVE | RALEIGH | NC | 27609-3625 | 9198472095 | 2/9/11 | ||
| 81115580 | 0626266 | Bailey | Ray | 1102 KINDLEY CT | RALEIGH | NC | 27609-2884 | 9198705744 | 3/6/14 | ||
| 81117480 | 0626266 | Lynn | Susan | 11001 W DEKALB PL | RALEIGH | NC | 27609-4422 | 9197820804 | 7/13/11 | ||
| 81125580 | 06666 | Waters | Susan | 101 COLCHIS COURT | SOUTHPORT | NC | 28461 | 9102536345 | 2/28/08 | ||
| 81129580 | 0667066 | Galloway | Judy | 10008 WHITESTONE RD | SOUTHPORT | NC | 28461 | 9104576031 | 8/12/11 | ||
| 81131080 | 0626266 | Chut Jr. | Carol | 1100 GLENCASTLE WAY | RALEIGH | NC | 27609-5578 | 9197826075 | 7/23/13 | ||
| 81133680 | 0626266 | Chesson | Edna | 1100 GLENCASTLE WAY | RALEIGH | NC | 27609-5578 | 9197826075 | 5/7/11 | ||
| 81137380 | 0610466 | Myers | Carol | 1108 BANCROFT DR | RALEIGH | NC | 27604-3363 | 9198727659 | 6/21/15 | ||
| 81140980 | 0652066 | Cowan | David | 1012 TRADERS TRAIL | SAN FRANCISCO | CA | 94116-3039 | 9198469158 | 8/11/12 | ||
| 81148980 | 0626266 | Williams | Janet | 110 WEST A STREET | RALEIGH | NC | 27612-6543 | 9197874242 | 6/30/08 | ||
| 814780 | 063566 | Alphin | Bonnie | 103 MEADOWGLADES LN | RODANTHE | NC | 27968 | 7037775229 | 3/22/13 | ||
| 814980 | 0626266 | Behrend | Dottie | 11 ROBERT E LEE DR | RALEIGH | NC | 27613-9652 | 9198467704 | 3/22/13 | ||
| 817580 | 0626266 | Pence | Lisa | 109 DEER COVE RD | RALEIGH | NC | 27614-9020 | 9198460562 | 3/6/18 | ||
| 836880 | 0648266 | Abdel-Hameed | Nancy | 102 DEER SPRING LN | SALISBURY | NC | 28146 | 7048552579 | 8/11/13 | ||
| 8728480 | 0614066 | Hartis | Keith | 1105 CASTALIA DR | RALEIGH | NC | 27606-2656 | 9197724131 | 8/12/12 | ||
| 8772880 | 0614066 | Hudspeth | Marianne | 11029 SOUTHWALK LN | RALEIGH | NC | 27607-6700 | 9198348710 | 10/30/11 |
| PatID | SKU | PieceName | RlPceCode | OnHandQty | Retail | ProdCategoryID | mSysRowId |
|---|---|---|---|---|---|---|---|
| 031063830 | 2117195120 | MAGNIFYING GLASS/STERLING HDL | MGS | 59.0 | 19.995 | 3.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 032478530 | 213619420 | CUP AND SAUCER SET (FLAT) | CSFL | 670.0 | 4.995 | 1.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 032478530 | 213619620 | PLATE-DINNER | DP | 748.0 | 8.995 | 1.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 032478530 | 213620020 | SAUCER ONLY | SAU | 83.0 | 1.495 | 1.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 032478530 | 213624320 | PLATTER-OVAL SERVING | PL14 | 60.0 | 19.995 | 1.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 032478530 | 213629320 | VEGETABLE-ROUND | RV9 | 62.0 | 12.995 | 1.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 032551630 | 214373520 | CHEESE & CRACKER SET | CCHC | 58.0 | 32.975 | 2.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 032551630 | 214376520 | PLATE-DINNER | DP | 204.0 | 19.995 | 2.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 033079630 | 217509120 | SPOON-SOUP/ROUND BOWL (C) | CSS | 122.0 | 20.995 | 3.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 033079630 | 217511220 | BUTTER SPREADER/FLAT HANDLE | BSF | 204.0 | 13.495 | 3.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 033079630 | 217535520 | KNIFE-NEW FRENCH/HOLLOW | K2NF | 66.0 | 23.995 | 3.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 033116630 | 218135220 | SPOON-TEASPOON | TS | 96.0 | 7.995 | 3.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 033116630 | 218142120 | TABLESPOON (SERVING SPOON) | TAS | 67.0 | 39.975 | 3.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 031446130 | 2181758520 | BOWL-SOUP/CEREAL | SOCE | 206.0 | 2.995 | 1.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 031109830 | 2193049920 | PLATE-LUNCHEON | LP | 166.0 | 19.995 | 2.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 033301130 | 219719120 | CUP AND SAUCER SET (FLAT) | CSFL | 298.0 | 22.495 | 1.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 033301130 | 219719820 | SAUCER ONLY | SAU | 136.0 | 7.495 | 1.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 032478530 | 2243615220 | VEGETABLE-OVAL DIVIDED 10" | ODV10 | 111.0 | 15.995 | 1.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 034640230 | 228500120 | PLATTER-OVAL SERVING | PL11 | 190.0 | 28.495 | 1.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 033079630 | 2347373220 | FORK-COCKTAIL/SEAFOOD | CF | 113.0 | 10.995 | 3.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 033079630 | 2349395420 | KNIFE-BLUNT/HOLLOW-BOLSTER | K1BB | 65.0 | 14.995 | 3.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 039650530 | 2382241720 | LEMON DISH | LD | 58.0 | 59.98 | 1.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 031109630 | 2446403920 | BUTTER-COVERED/QUARTER POUND | CBD4 | 60.0 | 54.975 | 2.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 033079630 | 2539314520 | LADLE-MAYONNAISE | LAMA | 0.0 | 44.975 | 3.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 031446130 | 2541350720 | DEVILED EGG & COV BOWL-SCULPTD | EGGPB | 0.0 | 7.495 | 1.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 039569030 | 2544208920 | CANDLESTICK - 6" | CNSS6 | 58.0 | 20.0 | 1.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 038497930 | 2548636920 | VASE-CHELSEA W/LID | VACH | 60.0 | 39.975 | 1.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 032551630 | 2553736620 | CHAMPAGNE/TALL SHERBET | SM2 | 0.0 | 4.995 | 2.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 033116630 | 2574819020 | SPOON-INFANT FEEDING HC | INSR | 0.0 | 13.495 | 3.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 038497930 | 261862920 | SUGAR BOWL LID ONLY | SUL | 59.0 | 17.995 | 1.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 039650530 | 268651220 | PLATTER-OVAL SERVING | PL12 | 60.0 | 199.98 | 1.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 039650530 | 268651920 | TUREEN-UNDERPLATE ONLY | TUP | 0.0 | 249.98 | 1.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 039803030 | 269388020 | SUGAR BOWL AND LID | SU | 80.0 | 19.995 | 1.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 031109630 | 276454220 | CLARET WINE | CLA | 1062.0 | 19.995 | 2.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 031109630 | 276457220 | SALT & PEPPER SET | CSAP | 71.0 | 54.975 | 2.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 031109630 | 276457620 | SHOT GLASS | CSH | 74.0 | 22.495 | 2.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 031109630 | 276459820 | DECANTER-WINE WITH/STOPPER | CDECWI | 78.0 | 109.975 | 2.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| 033079630 | 295646620 | SPOON-BON BON | BONS | 61.0 | 19.995 | 3.0 | hU5dSF2wo3d8tpQ4Vl7GUJSItO9MtJetz9eXPmG8hAo=-~TSCW7P3c4jbFX+AvJ5RSYQ== |
| MfgID | Alias | RlMfgCode |
|---|---|---|
| 800338.0 | DANSK CHINA | DAN |
| 800460.0 | FRANCISCAN CHINA | FN |
| 800470.0 | FOSTORIA | FOS |
| 800546.0 | GORHAM SILVER | GS |
| 800552.0 | HAVILAND | H |
| 800661.0 | JOHNSON BROTHERS | JB |
| 800712.0 | LENOX CHINA | L |
| 800890.0 | ONEIDA/HEIRLOOM SLVR | OHS |
| 800917.0 | PFALTZGRAFF CHINA | PFA |
| 801049.0 | ROYAL ALBERT CHINA | ROA |
| 801190.0 | SPODE CHINA | SP |
| 801210.0 | STAFFORDSHIRE | STF |
| 801305.0 | TOWLE | TWS |
| 801352.0 | WATERFORD CRYSTAL | WAT |
| 801403.0 | WEDGWOOD CHINA | WW |
| ID | mSysRowId |
|---|---|
| 1 | cWxpTcAbso0jdFnmm5g+XFqP7iYaUdsqIup2507OkAA=-~xxeG6rhbobFyOlZLdABhmQ== |
| OrderID | CustomerNum | OrderDate | UserID | mSysRowId |
|---|---|---|---|---|
| 44745937840 | 0588050 | 5/30/19 | 81129580 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44745939840 | 0510850 | 5/30/19 | 81137380 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44745940840 | 0579550 | 5/30/19 | 814980 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44745951140 | 0598050 | 5/30/19 | 81117480 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44745954740 | 0553950 | 5/30/19 | 814780 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44745971040 | 0510350 | 5/30/19 | 81095180 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44745985940 | 0510850 | 5/30/19 | 836880 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44748453740 | 0542850 | 6/18/19 | 81112780 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44748480440 | 0571350 | 6/18/19 | 81137380 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44748493240 | 0515050 | 6/18/19 | 81125580 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44748496240 | 0510050 | 6/19/19 | 81105880 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44748498640 | 0516650 | 6/19/19 | 817580 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44748505740 | 0599950 | 6/19/19 | 81125580 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44748508640 | 0514450 | 6/19/19 | 81133680 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44748528340 | 0512950 | 6/19/19 | 81125580 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44748532640 | 0546950 | 6/19/19 | 81115580 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44750449840 | 0598150 | 7/4/19 | 81133680 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44750466240 | 0519250 | 7/4/19 | 81125580 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44751104940 | 0521950 | 7/8/19 | 81148980 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44751181140 | 0578850 | 7/9/19 | 81131080 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44751182040 | 0510850 | 7/9/19 | 81105880 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44753104040 | 0510850 | 7/24/19 | 8728480 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44753105640 | 0510950 | 7/24/19 | 8772880 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44753129140 | 0510950 | 7/24/19 | 81125580 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44753140840 | 0510350 | 7/24/19 | 81125580 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44753146140 | 0510950 | 7/24/19 | 81117480 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44753162640 | 0510950 | 7/24/19 | 81125580 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44753177640 | 0513350 | 7/25/19 | 81140980 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| 44753203540 | 0521850 | 7/25/19 | 81094880 | ffjKMWDkvGxm+AAuxsaHge2M72tBsUFRQhQGNoyjjCU=-~MOXvpReEc38hTpkBe5knlQ== |
| OrderID | LineNum | Qty | Price | SKU | ProdCategoryID | mSysRowId |
|---|---|---|---|---|---|---|
| 44745940840 | 1.0 | 1.0 | 19.995 | 269388020 | 1.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44745954740 | 1.0 | 2.0 | 8.995 | 213619620 | 1.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44748496240 | 1.0 | 1.0 | 7.495 | 2541350720 | 1.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44748498640 | 1.0 | 1.0 | 249.975 | 268651920 | 1.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44748498640 | 2.0 | 1.0 | 59.975 | 2382241720 | 1.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44748498640 | 3.0 | 1.0 | 161.98 | 268651220 | 1.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44748505740 | 1.0 | 1.0 | 2.995 | 2181758520 | 1.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44748528340 | 1.0 | 1.0 | 25.645 | 228500120 | 1.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44751182040 | 1.0 | 1.0 | 7.495 | 219719820 | 1.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44753104040 | 1.0 | 2.0 | 5.995 | 2347373220 | 1.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44753104040 | 2.0 | 2.0 | 4.495 | 2349395420 | 1.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44753104040 | 3.0 | 1.0 | 15.995 | 2243615220 | 1.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44753104040 | 4.0 | 1.0 | 12.995 | 213629320 | 1.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44753104040 | 5.0 | 1.0 | 19.995 | 213624320 | 1.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44753129140 | 1.0 | 2.0 | 4.995 | 213619420 | 1.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44753146140 | 1.0 | 1.0 | 17.995 | 261862920 | 1.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44753177640 | 1.0 | 2.0 | 21.37 | 219719120 | 1.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44753203540 | 1.0 | 1.0 | 21.115 | 2349395420 | 1.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44753203540 | 2.0 | 2.0 | 1.495 | 213620020 | 1.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44745939840 | 1.0 | 8.0 | 22.495 | 276457620 | 2.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44745971040 | 1.0 | 1.0 | 19.995 | 276454220 | 2.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44748453740 | 1.0 | 1.0 | 109.975 | 276459820 | 2.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44748480440 | 1.0 | 1.0 | 32.975 | 214373520 | 2.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44748532640 | 1.0 | 1.0 | 54.975 | 276457220 | 2.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44750449840 | 2.0 | 2.0 | 18.995 | 2193049920 | 2.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44751181140 | 3.0 | 1.0 | 54.975 | 276457220 | 2.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44751181140 | 4.0 | 1.0 | 54.975 | 2446403920 | 2.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44753105640 | 1.0 | 28.0 | 4.995 | 2553736620 | 2.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44753162640 | 1.0 | 1.0 | 19.995 | 214376520 | 2.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44745937840 | 1.0 | 1.0 | 16.995 | 295646620 | 3.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44745937840 | 2.0 | 1.0 | 44.975 | 2539314520 | 3.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44745951140 | 1.0 | 1.0 | 23.995 | 217535520 | 3.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44745985940 | 1.0 | 1.0 | 19.995 | 2117195120 | 3.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44748493240 | 1.0 | 1.0 | 39.975 | 218142120 | 3.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44748508640 | 1.0 | 2.0 | 20.995 | 217509120 | 3.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44750466240 | 1.0 | 1.0 | 13.495 | 2574819020 | 3.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44750466240 | 2.0 | 1.0 | 4.995 | 2544208920 | 3.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44750466240 | 3.0 | 1.0 | 7.995 | 2548636920 | 3.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44750466240 | 4.0 | 1.0 | 7.495 | 2548636920 | 3.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44750466240 | 5.0 | 1.0 | 7.495 | 2548636920 | 3.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44751104940 | 1.0 | 4.0 | 13.495 | 217511220 | 3.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| 44753140840 | 1.0 | 8.0 | 7.995 | 218135220 | 3.0 | FWFOmLhh34JG/HZzQYNPNUi87n1qCHY0kbPmiEbUsPI=-~O/DgvfT5tZnN7nEyGxJjGA== |
| PatID | LongPatName | DESCR | RlPatCode | ProdCategoryID | MfgID | mSysRowId |
|---|---|---|---|---|---|---|
| 031063830 | FRENCH PROVINCIAL(STERLING,1948,NO MONO) | STERLING, 1948, NO MONOGRAMS | TWSFRP | 3.0 | 801305.0 | |
| 031109630 | LISMORE | VERTICAL CUT ON BOWL MULTISIDED STEM | WATLIS | 2.0 | 801352.0 | |
| 031109830 | MILLENNIUM SERIES | DIFFERENT DESIGN CUTS | WATMIL | 2.0 | 801352.0 | |
| 031144030 | STRAWBERRY & VINE (BONE) | ALL WHITE, RAISED BERRIES/LEAVES | WW STV | 1.0 | 801403.0 | |
| 031446130 | SUMMER BREEZE | BLUE FLOWERS, YELLOW PLAID & TRELLIS | PFASUB | 1.0 | 800917.0 | |
| 031901730 | BISSERUP WHITE | PORTUGAL, BISTRO, SOLID WHITE | DANBIW | 1.0 | 800338.0 | |
| 032103330 | BING | RED CHERRIES, RED BANDS | DANBIN | 1.0 | 800338.0 | |
| 032478530 | DESERT ROSE (USA BACKSTAMP) | USA BACKSTAMP, PINK ROSES | FN DERO | 1.0 | 800460.0 | |
| 032551630 | AMERICAN-CLEAR (STEM #2056) | STEM #2056, CLEAR, ALSO "EARLYAMERICAN" | FOSAME | 2.0 | 800470.0 | |
| 033079630 | CHANTILLY [F1](STR,1895,LION/ANC/G,NOMO) | STRL,1895-1950,LION/ANCHOR/G,NO MONOS | GS CHA | 3.0 | 800546.0 | |
| 033116630 | SUMMER BREEZE | BLUE FLOWERS | PFASUB | 1.0 | 800917.0 | |
| 033301130 | ROSALINDE (NEW YORK) | PINK,LAVENDER&WHITE FLOWERS,SCALLOPED | H ROSN | 1.0 | 800552.0 | |
| 034640230 | VICTORIAN CHRISTMAS | CHRISTMAS TREE HOLLY & RIBBONS | JB VICH | 1.0 | 800661.0 | |
| 034984230 | AMERICAN-CLEAR (STEM #2056) | STEM #2056, CLEAR, ALSO "EARLYAMERICAN" | FOSAME | 2.0 | 800470.0 | |
| 037255330 | DAMASK ROSE (STERLING,1946,NO MONOGRAMS) | STERLING, 1946, NO MONOGRAMS | OHSDAR | 3.0 | 800890.0 | |
| 037345730 | VENETIA (STNLS, GLOSSY BOWL) | STAINLESS,COMMUNITY,BURNISHED,GLOSSYBOWL | OHSVEN | 3.0 | 800890.0 | |
| 038497930 | OLD COUNTRY ROSES | MONTROSE SHAPE, RED & YELLOW ROSES | ROAOLCR | 1.0 | 801049.0 | |
| 039569030 | CHRISTMAS TREE-GREEN TRIM | NEWER BACKSTAMP,GREEN TRIM,TREE,TOYS | SP CHT | 1.0 | 801190.0 | |
| 039650530 | STAFFORD FLOWERS (BONE) | BONE,VARIOUS FLOWERS,GOLD SCROLLS | SP STF | 1.0 | 801190.0 | |
| 039803030 | LIBERTY BLUE | BLUE&WHITE FLORAL RIM,SCENE IN CENTER | STFLIB | 1.0 | 801210.0 |
SELECT Employees.LastName, Employees.FirstName, [Order Item].Qty, [Order Item].Price, Pattern.LongPatName, [Order Item].ProdCategoryID, [Employee Titles].Description, Pattern.DESCR, Customer.State, [Order Data].OrderDate, Manufacturer.Alias, [Price]*[Qty] AS Revenue
FROM (Manufacturer INNER JOIN Pattern ON Manufacturer.MfgID = Pattern.MfgID) INNER JOIN ((([Employee Titles] INNER JOIN Employees ON [Employee Titles].TitleID = Employees.TitleID) INNER JOIN (Customer INNER JOIN [Order Data] ON Customer.CustomerNum = [Order Data].CustomerNum) ON Employees.UserID = [Order Data].UserID) INNER JOIN (Inventory INNER JOIN [Order Item] ON Inventory.SKU = [Order Item].SKU) ON [Order Data].OrderID = [Order Item].OrderID) ON Pattern.PatID = Inventory.PatID;
