Brightwater Provisions, Inc.
LedgerPro to new ERP
- Cutover
- Go-live
- Books
- USD
Loading this view
Public demoView-only · fictional data
Brightwater Provisions, Inc.
LedgerPro to new ERP
The file exactly as the legacy system exported it. Rows are stored once and never edited, so this is the evidence every canonical record and every finding traces back to.
Values are shown verbatim, including the whitespace and formatting the export contained.
| Row | Lines | Customer ID | Customer Name | Address | City | State | Zip | Country | AP Email | Tax ID | Currency | Terms | Status | Created |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 101 | 102 | C-0264 | Vale Brasserie | 780 Pearl St | Portland | OR | 97254 | US | billing@valebrasserie.com | XX-XXX4720 | USD | Net 15 | Active | 06/20/2015 |
Lines the reader could not turn into a row. They are kept verbatim and excluded from every result, so anything here is missing from the migration.
What the reader observed per column, used to suggest a column mapping and to flag ambiguous dates.
| Column | Blank | Distinct | Max length | Patterns | Ambiguous dates |
|---|---|---|---|---|---|
| Customer ID | 0 | 171 | 6 | — | 0 |
| Customer Name | 0 | 171 | 31 | — | 0 |
| Address | 0 | 170 | 29 | — | 0 |
| City | 0 | 21 | 11 |
| 102 | 103 | C-0272 | Ramble Deli | 2958 Rainier Ave S | Salem | OR | 97324 | US | billing@rambledeli.com | XX-XXX7844 | USD | Net 15 | Active | 07/04/2014 |
|---|
| 103 | 104 | C-0273 | Coldwater Creek Market | 8677 Front Ave | Olympia | WA | 98577 | US | ap@coldwatercreekmark.com | XX-XXX5001 | USD | Net 30 | Active | 12/28/2017 |
|---|
| 104 | 105 | C-0275 | Tamarack Smokehouse | 4962 Market St | Portland | OR | 97201 | US | billing@tamaracksmokehouse.com | XX-XXX1738 | USD | Net 15 | Active | 12/20/2016 |
|---|
| 105 | 106 | C-0276 | Mossy Rock Taproom | 5799 Oak St | Gresham | OR | 97047 | US | billing@mossyrocktaproom.com | XX-XXX2480 | USD | Net 15 | Active | 05/21/2019 |
|---|
| 106 | 107 | C-0278 | Sorrel Cantina | 7670 Riverside Dr | Boise | ID | 83712 | US | billing@sorrelcantina.com | XX-XXX8851 | USD | Net 15 | Active | 02/11/2015 |
|---|
| 107 | 108 | C-0281 | Tidewater Deli | 9188 SW Barbur Blvd | Gresham | OR | 97005 | US | billing@tidewaterdeli.com | XX-XXX3576 | USD | Net 15 | Active | 04/25/2016 |
|---|
| 108 | 109 | C-0282 | Yarrow Deli | 6947 NW 23rd Ave | Idaho Falls | ID | 83413 | US | billing@yarrowdeli.com | XX-XXX6584 | USD | Net 15 | Active | 09/05/2014 |
|---|
| 109 | 110 | C-0283 | Yardarm Smokehouse | 2209 SW Barbur Blvd | Idaho Falls | ID | 83435 | US | billing@yardarmsmokehouse.com | XX-XXX7023 | USD | Net 15 | Active | 09/23/2015 |
|---|
| 110 | 111 | C-0287 | Tacoma Event Kitchens | 2863 Center St | Everett | WA | 98235 | US | ap@tacomaeventkitchen.org | XX-XXX4695 | USD | Net 30 | Active | 02/20/2021 |
|---|
| 111 | 112 | C-0291 | Lantern Supper Club | 9732 Pearl St | Beaverton | OR | 97023 | US | billing@lanternsupperclub.com | XX-XXX3550 | USD | Net 15 | Active | 09/04/2023 |
|---|
| 112 | 113 | C-0295 | Zephyr Bakery | 5557 W Idaho St | Lake Oswego | OR | 97030 | US | billing@zephyrbakery.com | XX-XXX4819 | USD | Net 15 | Active | 11/27/2015 |
|---|
| 113 | 114 | C-0296 | Bluebird Smokehouse | 2509 W Idaho St | Everett | WA | 98261 | US | billing@bluebirdsmokehouse.com | XX-XXX2817 | USD | Net 15 | Active | 08/15/2014 |
|---|
| 114 | 115 | C-0297 | Canopy Deli | 152 Center St | Olympia | WA | 98530 | US | billing@canopydeli.com | XX-XXX6972 | USD | Net 15 | Active | 06/12/2018 |
|---|
| 115 | 116 | C-0298 | Nimbus Cafe | 7692 W Idaho St | Seattle | WA | 98198 | US | billing@nimbuscafe.com | XX-XXX9219 | USD | Net 15 | Active | 09/11/2023 |
|---|
| 116 | 117 | C-0299 | Orchard Bakery | 2973 Olive Way | Idaho Falls | ID | 83463 | US | billing@orchardbakery.com | XX-XXX8675 | USD | Net 15 | Active | 07/23/2024 |
|---|
| 117 | 118 | C-0301 | Alpenkost GmbH | Leopoldstrasse 118 | Munich | BY | 80802 | DE | kreditoren@alpenkost.de | EUR | Net 90 | Active | 10/09/2023 |
|---|
| 118 | 119 | C-0303 | Trillium Bistro | 3276 Rainier Ave S | Meridian | ID | 83657 | US | billing@trilliumbistro.com | XX-XXX7245 | USD | Net 15 | Active | 05/08/2018 |
|---|
| 119 | 120 | C-0305 | Bittern Bistro | 7437 SE Belmont St | Gresham | OR | 97047 | US | billing@bitternbistro.com | XX-XXX7723 | USD | Net 15 | Active | 11/19/2013 |
|---|
| 120 | 121 | C-0306 | Tillamook Road Grocery | 3026 SW Barbur Blvd | Tacoma | WA | 98412 | US | ap@tillamookroadgroce.com | XX-XXX9169 | USD | Net 30 | Active | 05/02/2016 |
|---|
| 121 | 122 | C-0307 | Sparrow Tavern | 264 Evergreen Pkwy | Boise | ID | 83710 | US | billing@sparrowtavern.com | XX-XXX9325 | USD | Net 15 | Active | 08/10/2023 |
|---|
| 122 | 123 | C-0308 | Northstar Deli | 7238 Rainier Ave S | Tacoma | WA | 98420 | US | billing@northstardeli.com | XX-XXX8941 | USD | Net 15 | Active | 12/12/2015 |
|---|
| 123 | 124 | C-0323 | Waxwing Eatery | 423 Broadway | Olympia | WA | 98570 | US | billing@waxwingeatery.com | XX-XXX4066 | USD | Net 15 | Active | 01/06/2019 |
|---|
| 124 | 125 | C-0324 | Obsidian Grill | 846 SE Belmont St | Everett | WA | 98213 | US | billing@obsidiangrill.com | XX-XXX2149 | USD | Net 15 | Active | 02/02/2017 |
|---|
| 125 | 126 | C-0325 | Cobalt Cafe | 5512 Main St | Olympia | WA | 98518 | US | billing@cobaltcafe.com | XX-XXX1594 | USD | Net 15 | Active | 07/19/2016 |
|---|
| 126 | 127 | C-0328 | Drumlin Bakery | 4423 Center St | Idaho Falls | ID | 83446 | US | billing@drumlinbakery.com | XX-XXX1152 | USD | Net 15 | Active | 07/22/2015 |
|---|
| 127 | 128 | C-0329 | Oxbow Smokehouse | 7048 Capitol Blvd | Vancouver | WA | 98671 | US | billing@oxbowsmokehouse.com | XX-XXX3761 | USD | Net 15 | Active | 11/24/2024 |
|---|
| 128 | 129 | C-0330 | Alder Street Market | 6553 N Mississippi Ave | Eugene | OR | 97420 | US | ap@alderstreetmarket.com | XX-XXX4969 | USD | Net 30 | Active | 04/14/2020 |
|---|
| 129 | 130 | C-0331 | Ironwood Grocery | 241 Olive Way | Corvallis | OR | 97328 | US | ap@ironwoodgrocery.com | XX-XXX9098 | USD | Net 30 | Active | 08/23/2023 |
|---|
| 130 | 131 | C-0334 | Isle Smokehouse | 4707 Riverside Dr | Lake Oswego | OR | 97004 | US | billing@islesmokehouse.com | XX-XXX1260 | USD | Net 15 | Active | 12/14/2020 |
|---|
| 131 | 132 | C-0335 | Mountain Grocers Inc. | 61535 S Hwy 97 | Bend | OR | 97702 | US | office@mountaingrocersbend.com | XX-XXX2210 | USD | Net 30 | Active | 08/30/2012 |
|---|
| 132 | 133 | C-0337 | Saffron Taproom | 3309 NE Alberta St | Olympia | WA | 98528 | US | billing@saffrontaproom.com | XX-XXX9452 | USD | Net 15 | Active | 04/09/2018 |
|---|
| 133 | 134 | C-0340 | Eastside Cafe | 5375 Broadway | Lake Oswego | OR | 97007 | US | billing@eastsidecafe.com | XX-XXX5504 | USD | Net 15 | Active | 08/08/2015 |
|---|
| 134 | 135 | C-0348 | Foxglove Market | 3761 SE Belmont St | Boise | ID | 83736 | US | ap@foxglovemarket.com | XX-XXX4343 | USD | Net 30 | Active | 04/14/2014 |
|---|
| 135 | 136 | C-0349 | Dovetail Taproom | 3988 Broadway | Meridian | ID | 83678 | US | billing@dovetailtaproom.com | XX-XXX8670 | USD | Net 15 | Active | 02/23/2017 |
|---|
| 136 | 137 | C-0351 | Yeoman Brasserie | 7994 Main St | Hood River | OR | 97075 | US | billing@yeomanbrasserie.com | XX-XXX5472 | USD | Net 15 | Active | 12/30/2011 |
|---|
| 137 | 138 | C-0353 | Uproot Cafe | 8860 SE Division St | Eugene | OR | 97455 | US | billing@uprootcafe.com | XX-XXX5290 | USD | Net 15 | Active | 12/25/2017 |
|---|
| 138 | 139 | C-0355 | Jackdaw Kitchen | 6025 E Fairview Ave | Salem | OR | 97313 | US | billing@jackdawkitchen.com | XX-XXX5114 | USD | Net 15 | Active | 12/01/2020 |
|---|
| 139 | 140 | C-0357 | Mountain Grocers LLC | 1450 W Main St | Boise | ID | 83702 | US | ap@mtngrocersidaho.com | XX-XXX9043 | USD | Net 30 | Active | 12/22/2012 |
|---|
| 140 | 141 | C-0359 | Yew Grill | 9539 Harbor Dr | Boise | ID | 83754 | US | billing@yewgrill.com | XX-XXX3287 | USD | Net 15 | Active | 01/22/2013 |
|---|
| 141 | 142 | C-0362 | Quince Noodle House | 209 Riverside Dr | Corvallis | OR | 97368 | US | billing@quincenoodlehouse.com | XX-XXX9167 | USD | Net 15 | Active | 11/29/2023 |
|---|
| 142 | 143 | C-0365 | Quarry Bistro | 6181 Market St | Corvallis | OR | 97381 | US | billing@quarrybistro.com | XX-XXX8585 | USD | Net 15 | Active | 05/26/2020 |
|---|
| 143 | 144 | C-0366 | Kettle Bistro | 6627 Pacific Ave | Seattle | WA | 98109 | US | billing@kettlebistro.com | XX-XXX3259 | USD | Net 15 | Active | 01/27/2018 |
|---|
| 144 | 145 | C-0367 | Juniper Eatery | 6863 Riverside Dr | Bellevue | WA | 98075 | US | billing@junipereatery.com | XX-XXX6333 | USD | Net 15 | Active | 06/30/2011 |
|---|
| 145 | 146 | C-0369 | Eddy Pizzeria | 8037 Center St | Portland | OR | 97288 | US | billing@eddypizzeria.com | XX-XXX8661 | USD | Net 15 | Active | 06/01/2014 |
|---|
| 146 | 147 | C-0371 | Marrow Brasserie | 2243 Industrial Way | Portland | OR | 97213 | US | billing@marrowbrasserie.com | XX-XXX1379 | USD | Net 15 | Active | 09/09/2024 |
|---|
| 147 | 148 | C-0378 | Yellowjacket Taproom | 1284 Broadway | Beaverton | OR | 97019 | US | billing@yellowjackettaproo.com | XX-XXX4137 | USD | Net 15 | Active | 11/26/2014 |
|---|
| 148 | 149 | C-0379 | Filbert & Oak Market | 9626 Riverside Dr | Gresham | OR | 97052 | US | ap@filbertoakmarket.com | XX-XXX8363 | USD | Net 30 | Active | 01/23/2021 |
|---|
| 149 | 150 | C-0380 | Quill Grill | 4437 Broadway | Beaverton | OR | 97093 | US | billing@quillgrill.com | XX-XXX5625 | USD | Net 15 | Active | 04/04/2022 |
|---|
| 150 | 151 | C-0381 | Rookery Cafe | 2719 Industrial Way | Gresham | OR | 97028 | US | billing@rookerycafe.com | XX-XXX4366 | USD | Net 15 | Active | 10/30/2015 |
|---|
Showing 101–150 of 171 rows
| — |
| 0 |
| State | 0 | 4 | 2 | — | 0 |
|---|
| Zip | 0 | 155 | 5 | integer 171 | 0 |
|---|
| Country | 0 | 2 | 2 | — | 0 |
|---|
| AP Email | 0 | 171 | 32 | — | 0 |
|---|
| Tax ID | 1 | 168 | 10 | — | 0 |
|---|
| Currency | 0 | 2 | 3 | — | 0 |
|---|
| Terms | 0 | 3 | 6 | — | 0 |
|---|
| Status | 0 | 1 | 6 | — | 0 |
|---|
| Created | 0 | 166 | 10 | date mm dd yyyy 171 | 54 |
|---|