Spreadsheet: 860172d1708371739-match-city-and-return-multiple-agents-v1-index-and-match-copy
Sheet: Raw Data

Vendor Who Owes US | Vendor Name Who Owes Us | Invoice No | Post Date | Invoice Date | Due Date | Total | SCAC | Type | Age | 0-30 Days | 31-60 Days | 61-90 Days | 90 Days | Do Not Pay | Status | Vendor Type | City | State | Country | Match Origin City | Booked Agent(s) - Origin | Note
5331 | AES (Cyprus) Limited | 28237 | 2014-03-28 00:00:00 | 2014-03-28 00:00:00 | 2014-03-28 00:00:00 | -145.5 | CRWV | Claims | 3597 | - | - | - | -145.5 | OK to Pay | InActive | AGT | Limassol |  | Cyprus |  |  | 3/29/2012 juliepe CHANGED Email Address FROM [EMAIL] TO [EMAIL];
22470 | Freight Force | 29788 | 2014-03-28 00:00:00 | 2014-03-28 00:00:00 | 2014-03-28 00:00:00 | -75 | CRWV | Claims | 3597 | - | - | - | -75 | OK to Pay | Active | FRT-AIR | Revere | Massachusetts | United States
5327 | SDV Transami |  | 2014-07-03 00:00:00 | 2014-06-25 00:00:00 | 2014-07-23 00:00:00 | -500 | CRWV | Claims | 3480 | - | - | - | -500 | Do Not Pay | Active | AGT | Nairobi |  | Kenya |  |  | 6/17/2010 juliepe CHANGED Email Address FROM [EMAIL] TO [EMAIL]; 6/28/2007 michst CHANGED Email Address FROM [EMAIL] TO [EMAIL];
8244 | All Points Moving & Storage, | JE31-132959-1-824 | 2014-10-10 00:00:00 | 2014-10-10 00:00:00 | 2014-10-10 00:00:00 | -187.57 | CRWV | A/P | 3401 | - | - | - | -187.57 | OK to Pay | Out of Service | AGT | Jacksonville | Florida | United States
7606 | Downey Moving of Searcy, Inc. | CB-CLM612902 | 2015-02-17 00:00:00 | 2015-01-19 00:00:00 | 2015-03-09 00:00:00 | -98.75 | CRWV | Claims | 3251 | - | - | - | -98.75 | Do Not Pay | InActive | AGT | Searcy | Arkansas | United States
5569 | Tampa Airlines Cargo | MADJ31-256 | 2015-03-27 00:00:00 | 2015-03-24 00:00:00 | 2015-03-27 00:00:00 | -1447.76 | CRWV | Shipment | 3233 | - | - | - | -1447.76 | Do Not Pay | Active | AIR-PORT | Miami | Florida | United States |  |  | 04/26/17 - RAR - general contact updated to [EMAIL].
9106 | IntuiShip Shipping Solutions | MADJ31-576 | 2015-12-11 00:00:00 | 2015-11-22 00:00:00 | 2015-12-11 00:00:00 | -210.31 | CRWV | Shipment | 2974 | - | - | - | -210.31 | OK to Pay | Active | TL | Orem | Utah | United States
8472 | Guardian Mvg & Stg Company, | CB-CLM630918 | 2015-11-24 00:00:00 | 2015-11-05 00:00:00 | 2015-12-14 00:00:00 | -150 | CRWV | Claims | 2971 | - | - | - | -150 | Do Not Pay | Active | AGT | Baltimore | Maryland | United States |  |  | Agent Not Servicing Mil shipments RR 4.3.19_x000D_ updated zip to 21230 from 21221RR 6.19.17_x000D_ Hunt Valley is the Corp Office_x000D_ 11.9.16 Only DPM, NO MIL RR
8472 | Guardian Mvg & Stg Company, | CB-CLM630841 | 2015-12-03 00:00:00 | 2015-11-14 00:00:00 | 2015-12-23 00:00:00 | -380 | CRWV | Claims | 2962 | - | - | - | -380 | Do Not Pay | Active | AGT | Baltimore | Maryland | United States |  |  | Agent Not Servicing Mil shipments RR 4.3.19_x000D_ updated zip to 21230 from 21221RR 6.19.17_x000D_ Hunt Valley is the Corp Office_x000D_ 11.9.16 Only DPM, NO MIL RR
9106 | IntuiShip Shipping Solutions | MADJ31-672 | 2016-02-03 00:00:00 | 2016-02-03 00:00:00 | 2016-02-03 00:00:00 | -403.65 | CRWV | Shipment | 2920 | - | - | - | -403.65 | OK to Pay | Active | TL | Orem | Utah | United States
9106 | IntuiShip Shipping Solutions | MADJ31-673 | 2016-02-03 00:00:00 | 2016-02-03 00:00:00 | 2016-02-03 00:00:00 | -180.88 | CRWV | Shipment | 2920 | - | - | - | -180.88 | OK to Pay | Active | TL | Orem | Utah | United States
5834 | Foxlog S.R.L. Societa A [NAME] | CB-CLM630244 | 2016-02-11 00:00:00 | 2016-02-08 00:00:00 | 2016-03-02 00:00:00 | -500 | CRWV | Claims | 2892 | - | - | - | -500 | OK to Pay | Active | AGT-EUR | [NAME] |  | Italy
8472 | Guardian Mvg & Stg Company, | CB-CLM630316 | 2016-02-11 00:00:00 | 2016-02-09 00:00:00 | 2016-03-02 00:00:00 | -37.5 | CRWV | Claims | 2892 | - | - | - | -37.5 | Do Not Pay | Active | AGT | Baltimore | Maryland | United States |  |  | Agent Not Servicing Mil shipments RR 4.3.19_x000D_ updated zip to 21230 from 21221RR 6.19.17_x000D_ Hunt Valley is the Corp Office_x000D_ 11.9.16 Only DPM, NO MIL RR
5834 | Foxlog S.R.L. Societa A [NAME] | CB-CLM632402 | 2016-05-10 00:00:00 | 2016-04-26 00:00:00 | 2016-05-30 00:00:00 | -500 | CRWV | Claims | 2803 | - | - | - | -500 | OK to Pay | Active | AGT-EUR | [NAME] |  | Italy
6653 | Olympic Moving and Storage - | CB-CLM653425 | 2016-07-21 00:00:00 | 2016-07-08 00:00:00 | 2016-08-10 00:00:00 | -133.49 | CRWV | Claims | 2731 | - | - | - | -133.49 | Do Not Pay | InActive | AGT | Federal Way | Washington | United States |  |  | Inactivated duplicate. Use V# 8016 RR _x000D_ cleaned up email ctc RR 10.6.16_x000D_ 6/29/2011 maryat CHANGED Warehouse Zip Code FROM 98505 TO 98003;
5727 | Gulf Express Cargo | MADJ31-1047 | 2016-11-14 00:00:00 | 2016-11-14 00:00:00 | 2016-11-14 00:00:00 | -1132.32 | CRWV | A/P | 2635 | - | - | - | -1132.32 | Do Not Pay | Active | LH-PORT-AGT | Kuwait |  | Kuwait
8034 | Klein's Moving & Storage, Inc. | CB-CLM656395 | 2016-10-31 00:00:00 | 2016-10-12 00:00:00 | 2016-11-20 00:00:00 | -135 | CRWV | Claims | 2629 | - | - | - | -135 | Do Not Pay | InActive | AGT | Brooklyn | New York | United States |  |  | Agent is Closing 10.13.16 RR try Trans Union V# 6007_x000D_ chg WH close time from 4 to 3 per Vic RR 4.21.16
9306 | A2B Moving | CB-CLM655468 | 2016-12-06 00:00:00 | 2016-11-28 00:00:00 | 2016-12-26 00:00:00 | -529.99 | AMWD | Claims | 2593 | - | - | - | -529.99 | Do Not Pay | InActive | AGT-NMA | Hopkinsville | Kentucky | United States
9306 | A2B Moving | CB-CLM655032 | 2017-01-03 00:00:00 | 2016-12-12 00:00:00 | 2017-01-23 00:00:00 | -129.07 | AMWD | Claims | 2565 | - | - | - | -129.07 | Do Not Pay | InActive | AGT-NMA | Hopkinsville | Kentucky | United States