Spreadsheet: 144824d1331151034-taking-a-list-building-a-total-sales
Sheet: Original

Flag | SONum | Status | CustomerName | CustomerContact | BillToName | BillToAddress | BillToCity | BillToState | BillToZip | BillToCountry | ShipToName | ShipToAddress | ShipToCity | ShipToState | ShipToZip | ShipToCountry | CarrierName | TaxRateName | PONum | VendorPONum | Date | Salesman | ShippingTerms | PaymentTerms | FOB | Note | QuickBooksClassName | LocationGroupName | FulfillmentDate | URL
Flag | SOItemTypeID | ProductNumber | ProductQuantity | UOM | ProductPrice | Taxable | Note | QuickBooksClassName | FulfillmentDate | ShowItem | KitItem
SO | 27662 | 70 | Analog Devices | [NAME] | Analog Devices | 804 Woburn Street | [NAME] | MA | 1887 | UNITED STATES | Analog Devices | 804 Woburn Street | [NAME] | MA | 1887 | UNITED STATES | Best Way | None | 45184695 |  | 2006-12-20 00:00:00 | Daryl | Freight Collect | 1% 10 Net 30 | Origin |  | None | Main | 2007-01-31 00:00:00
Item | 10 | PD574 | 5 | ea | 958 | False |  | None | 2007-01-11 00:00:00 | True | False
SO | 27812 | 70 | Vactor Manufacturing | [NAME] | Vactor Manufacturing | 1621 South Illinois Street | Streator | IL | 61364 |  | Vactor Manufacturing | 1621 South Illinois Street | Streator | IL | 61364 |  | Fed Ex Freight | None | MWB091700 |  | 2006-11-20 00:00:00 | [NAME] | Freight Collect | 1% 10 Net 30 | Origin |  | None | Main | 2007-12-31 00:00:00
Item | 10 | 48920A | 0 | ea | 138 | False |  | None | 2007-12-31 00:00:00 | True | False
Item | 10 | 49015 | 0 | ea | 41 | False |  | None | 2007-12-31 00:00:00 | True | False
Item | 10 | 49016 | 0 | ea | 86.5 | False |  | None | 2007-12-31 00:00:00 | True | False
Item | 10 | 99602 | 640 | Sqft | 5.95 | False |  | None | 2007-12-31 00:00:00 | True | False
Item | 10 | 500272A | 80 | ea | 89.75 | False |  | None | 2007-12-31 00:00:00 | True | False
Item | 10 | 49015-A | 15 | ea | 43.5 | False |  | None | 2007-12-31 00:00:00 | True | False
SO | 27815 | 70 | Lytron, Inc. | [NAME] | Lytron, Inc. | 55 Dragon Court | Woburn | MA | 1801 |  | Lytron, Inc. | 55 Dragon Court | Woburn | MA | 1801 |  | UPS Collect | None | 270316 |  | 2006-11-28 00:00:00 | [NAME] | Freight Collect | 1% 10 Net 30 | Origin |  | None | Main | 2007-04-30 00:00:00
Item | 10 | 340-0054 | 56 | ea | 29.41 | True |  | None | 2007-04-30 00:00:00 | True | False
SO | 27993 | 70 | Intel Massachusetts, Inc. | Elias Mirabal | Intel Massachusetts, Inc. | 75 Reed Road | Hudson | MA | 1749 |  | Intel Massachusetts, Inc. | 75 Reed Road | Hudson | MA | 1749 |  | UPS | None | Credit Card |  | 2007-01-08 00:00:00 | Kurt | Prepaid & Billed | Credit Card | Origin |  | None | Main | 2007-01-12 00:00:00
Item | 10 | PD630 | 14 | ea | 35 | False |  | None | 2007-01-12 00:00:00 | True | False
Item | 10 | PD631 | 1 | ea | 28.88 | False |  | None | 2007-01-12 00:00:00 | True | False
SO | 28016 | 70 | Microsemi Microwave Products, Inc. | [NAME] | Microsemi Microwave Products, Inc. | 75 Technology Drive | Lowell | MA | 1851 |  | Microsemi Microwave Products, Inc. | 75 Technology Drive | Lowell | MA | 1851 |  | Best Way | None | 109683 |  | 2007-01-11 00:00:00 | Kurt | Freight Collect | 1% 10 Net 30 | Origin |  | None | Main | 2007-01-30 00:00:00
Item | 10 | PD665 | 1 | ea | 145 | False | 1/4" Tk. White polypropylene 5" x 5" x 14-1/2", all inside dimension with mounting flange | None | 2007-01-30 00:00:00 | True | False
Item | 10 | LTV115 | 0 | ea | 59.95 | False |  | None | 2007-01-30 00:00:00 | True | False
SO | 28038 | 70 | [NAME], Inc. | [NAME] | [NAME], Inc. | 100 Research Drive | Worcester | MA | 1604 | UNITED STATES | [NAME], Inc. | [NAME] Center\ 100 Research Drive | Worcester | MA | 1605 |  | Best Way | None |  |  | 2007-01-15 00:00:00 | Kurt | Freight Collect | 1% 10 Net 30 | Origin |  | None | Main | 2007-04-30 00:00:00
Item | 10 | PD688 | 0 | ea | 156 | False | 1-1/4" ID polycarbonate hollow rod with 1/8" Tk. wall, 32-7/8" long with appropriate slot and notches per dimensions taken on-site | None | 2007-04-30 00:00:00 | True | False
Item | 10 | PD689 | 0 | ea | 156 | False | Same as above, 36-5/8" long | None | 2007-04-30 00:00:00 | True | False
Item | 10 | PD690 | 1 | ea | 156 | False | Same as above, 34" long | None | 2007-04-30 00:00:00 | True | False
Item | 10 | PD691 | 0 | ea | 148 | False | Same as above, 22-1/4" | None | 2007-04-30 00:00:00 | True | False