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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
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 |
| 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 |
|---|
| 151 | 152 | C-0386 | Eugene Hospital Foodservice | 6390 Market St | Portland | OR | 97208 | US | ap@eugenehospitalfood.org | XX-XXX2892 | USD | Net 30 | Active | 07/24/2016 |
|---|
| 152 | 153 | C-0389 | Umpqua Valley Foods | 8609 Harbor Dr | Everett | WA | 98229 | US | ap@umpquavalleyfoods.com | XX-XXX9664 | USD | Net 30 | Active | 12/11/2011 |
|---|
| 153 | 154 | C-0390 | Dogwood Bistro | 2572 Oak St | Hillsboro | OR | 97118 | US | billing@dogwoodbistro.com | XX-XXX7946 | USD | Net 15 | Active | 09/12/2023 |
|---|
| 154 | 155 | C-0396 | Driftwood Pantry | 8231 Capitol Blvd | Hood River | OR | 97036 | US | ap@driftwoodpantry.com | XX-XXX3546 | USD | Net 30 | Active | 03/23/2021 |
|---|
| 155 | 156 | C-0397 | Fable Kitchen | 1284 Broadway | Bellevue | WA | 98062 | US | billing@fablekitchen.com | XX-XXX2825 | USD | Net 15 | Active | 07/23/2012 |
|---|
| 156 | 157 | C-0399 | Larch Mountain Mercantile | 7293 Market St | Corvallis | OR | 97339 | US | ap@larchmountainmerca.com | XX-XXX2485 | USD | Net 30 | Active | 11/13/2018 |
|---|
| 157 | 158 | C-0400 | Salmonberry Market | 5533 NE Alberta St | Tacoma | WA | 98417 | US | ap@salmonberrymarket.com | XX-XXX2543 | USD | Net 30 | Active | 03/13/2019 |
|---|
| 158 | 159 | C-0401 | Pinewood Kitchen | 8671 Pacific Ave | Boise | ID | 83704 | US | billing@pinewoodkitchen.com | XX-XXX2239 | USD | Net 15 | Active | 10/23/2017 |
|---|
| 159 | 160 | C-0402 | Verbena Supper Club | 4602 N Mississippi Ave | Salem | OR | 97319 | US | billing@verbenasupperclub.com | XX-XXX3750 | USD | Net 15 | Active | 12/15/2023 |
|---|
| 160 | 161 | C-0403 | Basalt Grill | 8274 Oak St | Everett | WA | 98288 | US | billing@basaltgrill.com | XX-XXX5179 | USD | Net 15 | Active | 06/04/2020 |
|---|
| 161 | 162 | C-0404 | Cairn Cafe | 3922 Industrial Way | Everett | WA | 98251 | US | billing@cairncafe.com | XX-XXX1657 | USD | Net 15 | Active | 10/24/2020 |
|---|
| 162 | 163 | C-0406 | Wharf Cantina | 8845 Market St | Olympia | WA | 98565 | US | billing@wharfcantina.com | XX-XXX5752 | USD | Net 15 | Active | 09/24/2023 |
|---|
| 163 | 164 | C-0411 | Iris Taproom | 8946 NE Alberta St | Eugene | OR | 97494 | US | billing@iristaproom.com | XX-XXX7708 | USD | Net 15 | Active | 08/16/2015 |
|---|
| 164 | 165 | C-0414 | Belmont Natural Foods | 9330 Riverside Dr | Beaverton | OR | 97089 | US | ap@belmontnaturalfood.com | XX-XXX9547 | USD | Net 30 | Active | 02/02/2024 |
|---|
| 165 | 166 | C-0415 | Kestrel Market Hall | 237 Pacific Ave | Hillsboro | OR | 97134 | US | ap@kestrelmarkethall.com | XX-XXX2232 | USD | Net 30 | Active | 05/06/2012 |
|---|
| 166 | 167 | C-0420 | Nehalem Bay Grocers | 8280 Commercial St NE | Beaverton | OR | 97097 | US | ap@nehalembaygrocers.com | XX-XXX1748 | USD | Net 30 | Active | 01/08/2021 |
|---|
| 167 | 168 | C-0423 | Salt Marsh Kitchen | 4576 Evergreen Pkwy | Tacoma | WA | 98408 | US | billing@saltmarshkitchen.com | XX-XXX8576 | USD | Net 15 | Active | 01/29/2025 |
|---|
| 168 | 169 | C-0425 | Thistle Pizzeria | 7630 Rainier Ave S | Meridian | ID | 83672 | US | billing@thistlepizzeria.com | XX-XXX3438 | USD | Net 15 | Active | 07/09/2018 |
|---|
| 169 | 170 | C-0427 | Deschutes Food Hall | 6302 Rainier Ave S | Vancouver | WA | 98668 | US | ap@deschutesfoodhall.com | XX-XXX7201 | USD | Net 30 | Active | 11/21/2022 |
|---|
| 170 | 171 | C-0428 | Birchwood Bistro | 7233 NW 23rd Ave | Hillsboro | OR | 97182 | US | billing@birchwoodbistro.com | XX-XXX5160 | USD | Net 15 | Active | 07/06/2024 |
|---|
| 171 | 172 | C-0429 | Seattle Farmers Guild | 7016 E Fairview Ave | Vancouver | WA | 98602 | US | ap@seattlefarmersguil.org | XX-XXX7457 | USD | Net 30 | Active | 08/23/2023 |
|---|
Showing 141–171 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 |
|---|