Spreadsheet: 871238d1717616655-lookup-table-to-determine-unit-price-using-width-length-and-quantity-revised-test-file
Sheet: Sales Invoice List

Customer ID | Customer Name | Invoice No. | Customer PO No. | Date | Ship Date | Invoice Total | Net Due | Status
MC | MERSS CORPORATION | 350030 | 5904 | 2009-03-02 00:00:00 | 2009-02-27 00:00:00 | 711.92 | 0 | Paid in full
MC | MERSS CORPORATION | CR-79452 | 5820 | 2009-03-03 00:00:00 |  | -28 | 0 | Paid in full
MC | MERSS CORPORATION | CR-81394 | 5864 | 2009-03-03 00:00:00 |  | -22.3 | 0 | Paid in full
MC | MERSS CORPORATION | 350101 | 5904 | 2009-03-09 00:00:00 | 2009-03-06 00:00:00 | 1726.38 | 0 | Paid in full
MC | MERSS CORPORATION | 350369 | 5820 | 2009-04-02 00:00:00 | 2009-04-01 00:00:00 | 33.78 | 0 | Paid in full
MC | MERSS CORPORATION | 350370 | 5864 | 2009-04-02 00:00:00 | 2009-04-01 00:00:00 | 28 | 0 | Paid in full
MC | MERSS CORPORATION | 351787 | 5912 | 2009-08-14 00:00:00 | 2009-08-13 00:00:00 | 703.29 | 0 | Paid in full
MC | MERSS CORPORATION | 352348 | 5949 | 2009-10-14 00:00:00 | 2009-10-13 00:00:00 | 831.92 | 0 | Paid in full
MC | MERSS CORPORATION | 353549 | 5960 | 2010-02-08 00:00:00 | 2010-02-05 00:00:00 | 2788.11 | 0 | Paid in full
MC | MERSS CORPORATION | 354556 | 5978 | 2010-05-05 00:00:00 | 2010-05-04 00:00:00 | 521.87 | 0 | Paid in full
MC | MERSS CORPORATION | 357674 | 6056 | 2011-02-09 00:00:00 | 2011-02-08 00:00:00 | 894.06 | 0 | Paid in full
MC | MERSS CORPORATION | 359588 | 6085 | 2011-07-22 00:00:00 | 2011-07-21 00:00:00 | 618.82 | 0 | Paid in full
MC | MERSS CORPORATION | 360113 | 6099 | 2011-09-08 00:00:00 | 2011-09-07 00:00:00 | 581.91 | 0 | Paid in full
MC | MERSS CORPORATION | 360304 | 6119 | 2011-09-23 00:00:00 | 2011-09-22 00:00:00 | 259.59 | 0 | Paid in full
MC | MERSS CORPORATION | 363582 | 6141 | 2012-07-19 00:00:00 | 2012-07-18 00:00:00 | 1701.01 | 0 | Paid in full
MC | MERSS CORPORATION | 364570 | 6086 | 2012-10-29 00:00:00 | 2012-10-26 00:00:00 | 1129.05 | 0 | Paid in full
MC | MERSS CORPORATION | 365730 | 6230 | 2013-03-01 00:00:00 | 2013-02-28 00:00:00 | 116.45 | 0 | Paid in full
MC | MERSS CORPORATION | 366491 | 6239 | 2013-05-13 00:00:00 | 2013-05-10 00:00:00 | 581.09 | 0 | Paid in full
MC | MERSS CORPORATION | 367643 | 6273 | 2013-09-09 00:00:00 | 2013-09-06 00:00:00 | 1578.14 | 0 | Paid in full
MC | MERSS CORPORATION | 368728 | 6290 | 2013-12-23 00:00:00 | 2013-12-20 00:00:00 | 751.05 | 0 | Paid in full
MC | MERSS CORPORATION | 369679 | 6327 | 2014-03-31 00:00:00 | 2014-03-28 00:00:00 | 1200.4 | 0 | Paid in full
MC | MERSS CORPORATION | 370259 | 6338 | 2014-05-22 00:00:00 | 2014-05-21 00:00:00 | 688.28 | 0 | Paid in full
MC | MERSS CORPORATION | 370337 | 6346 | 2014-05-30 00:00:00 | 2014-05-29 00:00:00 | 97.04 | 0 | Paid in full
MC | MERSS CORPORATION | 370563 | 6350 | 2014-06-23 00:00:00 | 2014-06-20 00:00:00 | 96.1 | 0 | Paid in full
MC | MERSS CORPORATION | 370882 | 6353 | 2014-07-24 00:00:00 | 2014-07-23 00:00:00 | 2213.07 | 0 | Paid in full
MC | MERSS CORPORATION | 371608 | 6377 | 2014-10-06 00:00:00 | 2014-10-03 00:00:00 | 614.32 | 0 | Paid in full
MC | MERSS CORPORATION | 373346 | 6422 | 2015-04-02 00:00:00 | 2015-04-01 00:00:00 | 850.23 | 0 | Paid in full
MC | MERSS CORPORATION | 373636 | 6416 | 2015-04-29 00:00:00 | 2015-04-28 00:00:00 | 616.92 | 0 | Paid in full
MC | MERSS CORPORATION | 373737 | 6429 | 2015-05-07 00:00:00 | 2015-05-06 00:00:00 | 581.73 | 0 | Paid in full
MC | MERSS CORPORATION | 373855 | 6440 | 2015-05-18 00:00:00 | 2015-05-15 00:00:00 | 202.2 | 0 | Paid in full
MC | MERSS CORPORATION | 373959 | 6443 | 2015-05-27 00:00:00 | 2015-05-26 00:00:00 | 447.55 | 0 | Paid in full
MC | MERSS CORPORATION | 374326 | 6453 | 2015-06-30 00:00:00 | 2015-06-29 00:00:00 | 447.98 | 0 | Paid in full
MC | MERSS CORPORATION | 374471 | VERBAL POLK | 2015-07-15 00:00:00 | 2015-07-14 00:00:00 | 450.81 | 0 | Paid in full
MC | MERSS CORPORATION | 375561 | 6479-2 | 2015-11-06 00:00:00 | 2015-11-05 00:00:00 | 1409.14 | 0 | Paid in full
MC | MERSS CORPORATION | 379168 | 6541 | 2016-11-23 00:00:00 | 2016-11-22 00:00:00 | 704.56 | 0 | Paid in full
MC | MERSS CORPORATION | 379575 | 6553 | 2017-01-18 00:00:00 | 2017-01-17 00:00:00 | 361.95 | 0 | Paid in full
MC | MERSS CORPORATION | 380482 | 6572-1 | 2017-04-17 00:00:00 | 2017-04-13 00:00:00 | 1129.9 | 0 | Paid in full
MC | MERSS CORPORATION | 380913 | 6572-1 | 2017-05-25 00:00:00 | 2017-05-24 00:00:00 | 572.18 | 0 | Paid in full
MC | MERSS CORPORATION | 382128 | 6598 | 2017-09-29 00:00:00 | 2017-09-28 00:00:00 | 658.27 | 0 | Paid in full
MC | MERSS CORPORATION | 382526 | 6602 | 2017-11-09 00:00:00 | 2017-11-08 00:00:00 | 926.46 | 0 | Paid in full
MC | MERSS CORPORATION | 383107 | 6613R | 2018-01-13 00:00:00 | 2018-01-12 00:00:00 | 756.77 | 0 | Paid in full
MC | MERSS CORPORATION | 383778 | 6631 | 2018-03-16 00:00:00 | 2018-03-15 00:00:00 | 706.74 | 0 | Paid in full
MC | MERSS CORPORATION | 389178 | 6716 | 2019-09-23 00:00:00 | 2019-09-20 00:00:00 | 743.5 | 0 | Paid in full
MC | MERSS CORPORATION | 393485 | 6778 | 2021-01-27 00:00:00 | 2021-01-26 00:00:00 | 1147.5 | 0 | Paid in full