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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12 | 13 | C-0037 | Bellwether Tavern | 4159 Center St | Corvallis | OR | 97357 | US | billing@bellwethertavern.com | XX-XXX4485 | USD | Net 15 | Active | 04/16/2016 |
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 |
| 13 | 14 | C-0040 | Parsnip Pizzeria | 4927 Rainier Ave S | Hood River | OR | 97033 | US | billing@parsnippizzeria.com | XX-XXX1238 | USD | Net 15 | Active | 03/14/2012 |
|---|
| 14 | 15 | C-0045 | Bridgetown Pantry | 5415 SW Barbur Blvd | Bellevue | WA | 98087 | US | ap@bridgetownpantry.com | XX-XXX2712 | USD | Net 30 | Active | 07/18/2013 |
|---|
| 15 | 16 | C-0046 | Yakima Orchard Market | 1877 Main St | Everett | WA | 98200 | US | ap@yakimaorchardmarke.com | XX-XXX4984 | USD | Net 30 | Active | 04/26/2013 |
|---|
| 16 | 17 | C-0047 | Gable Brasserie | 8184 SE Division St | Seattle | WA | 98156 | US | billing@gablebrasserie.com | XX-XXX1000 | USD | Net 15 | Active | 08/04/2011 |
|---|
| 17 | 18 | C-0049 | Portland Catering Collective | 4271 Center St | Portland | OR | 97210 | US | ap@portlandcateringco.org | XX-XXX4131 | USD | Net 30 | Active | 06/10/2012 |
|---|
| 18 | 19 | C-0050 | Aster Kitchen | 2816 Center St | Eugene | OR | 97405 | US | billing@asterkitchen.com | XX-XXX9017 | USD | Net 15 | Active | 05/17/2016 |
|---|
| 19 | 20 | C-0055 | Lumen Kitchen | 5165 Commercial St NE | Beaverton | OR | 97006 | US | billing@lumenkitchen.com | XX-XXX5673 | USD | Net 15 | Active | 07/25/2018 |
|---|
| 20 | 21 | C-0056 | Granary Pizzeria | 3256 Market St | Nampa | ID | 83617 | US | billing@granarypizzeria.com | XX-XXX3538 | USD | Net 15 | Active | 03/10/2013 |
|---|
| 21 | 22 | C-0064 | Juniper Hill Foods | 5921 Main St | Beaverton | OR | 97070 | US | ap@juniperhillfoods.com | XX-XXX5598 | USD | Net 30 | Active | 03/26/2017 |
|---|
| 22 | 23 | C-0066 | Keel Smokehouse | 9647 Evergreen Pkwy | Idaho Falls | ID | 83446 | US | billing@keelsmokehouse.com | XX-XXX2631 | USD | Net 15 | Active | 12/02/2022 |
|---|
| 23 | 24 | C-0069 | Riverbend Natural Grocers | 5461 Market St | Seattle | WA | 98196 | US | ap@riverbendnaturalgr.com | XX-XXX2439 | USD | Net 30 | Active | 03/14/2015 |
|---|
| 24 | 25 | C-0074 | Estuary Smokehouse | 673 Broadway | Hood River | OR | 97006 | US | billing@estuarysmokehouse.com | XX-XXX3869 | USD | Net 15 | Active | 06/29/2016 |
|---|
| 25 | 26 | C-0075 | Vesper Pizzeria | 8154 N Mississippi Ave | Everett | WA | 98248 | US | billing@vesperpizzeria.com | XX-XXX8821 | USD | Net 15 | Active | 12/31/2024 |
|---|
| 26 | 27 | C-0076 | Thimbleberry Eatery | 3849 Center St | Boise | ID | 83773 | US | billing@thimbleberryeatery.com | XX-XXX8655 | USD | Net 15 | Active | 01/22/2019 |
|---|
| 27 | 28 | C-0081 | Fernwood Grill | 7989 Olive Way | Hillsboro | OR | 97161 | US | billing@fernwoodgrill.com | XX-XXX7774 | USD | Net 15 | Active | 07/18/2025 |
|---|
| 28 | 29 | C-0082 | Chanterelle Supper Club | 9326 Market St | Boise | ID | 83714 | US | billing@chanterellesupperc.com | XX-XXX5416 | USD | Net 15 | Active | 03/29/2012 |
|---|
| 29 | 30 | C-0083 | Acorn Supper Club | 1758 Industrial Way | Hood River | OR | 97015 | US | billing@acornsupperclub.com | XX-XXX5412 | USD | Net 15 | Active | 12/07/2012 |
|---|
| 30 | 31 | C-0087 | Inkwell Supper Club | 3631 Evergreen Pkwy | Eugene | OR | 97483 | US | billing@inkwellsupperclub.com | XX-XXX5614 | USD | Net 15 | Active | 03/13/2016 |
|---|
| 31 | 32 | C-0088 | Palouse Provisions | 2379 NE Alberta St | Meridian | ID | 83663 | US | ap@palouseprovisions.com | XX-XXX3827 | USD | Net 30 | Active | 07/02/2022 |
|---|
| 32 | 33 | C-0089 | Kinfolk Pizzeria | 6184 W Idaho St | Vancouver | WA | 98687 | US | billing@kinfolkpizzeria.com | XX-XXX2988 | USD | Net 15 | Active | 11/10/2018 |
|---|
| 33 | 34 | C-0090 | Zigzag Mountain Grocery | 5578 Center St | Vancouver | WA | 98682 | US | ap@zigzagmountaingroc.com | XX-XXX3181 | USD | Net 30 | Active | 09/27/2012 |
|---|
| 34 | 35 | C-0093 | Heron Cafe | 225 Pacific Ave | Gresham | OR | 97044 | US | billing@heroncafe.com | XX-XXX2008 | USD | Net 15 | Active | 03/13/2012 |
|---|
| 35 | 36 | C-0096 | Pioneer Square Provisions | 7733 Riverside Dr | Beaverton | OR | 97004 | US | ap@pioneersquareprovi.com | XX-XXX8751 | USD | Net 30 | Active | 07/20/2021 |
|---|
| 36 | 37 | C-0100 | Copperleaf Brasserie | 3520 SE Division St | Idaho Falls | ID | 83491 | US | billing@copperleafbrasseri.com | XX-XXX9841 | USD | Net 15 | Active | 06/29/2016 |
|---|
| 37 | 38 | C-0102 | Indigo Deli | 5439 Pearl St | Eugene | OR | 97412 | US | billing@indigodeli.com | XX-XXX2129 | USD | Net 15 | Active | 06/26/2021 |
|---|
| 38 | 39 | C-0103 | Salem Campus Dining | 9204 Industrial Way | Boise | ID | 83768 | US | ap@salemcampusdining.org | XX-XXX8140 | USD | Net 30 | Active | 12/06/2021 |
|---|
| 39 | 40 | C-0105 | Whidbey Harvest Co-op | 969 SW Barbur Blvd | Tacoma | WA | 98406 | US | ap@whidbeyharvestcoop.com | XX-XXX3479 | USD | Net 30 | Active | 04/11/2013 |
|---|
| 40 | 41 | C-0106 | Fiddlehead Taproom | 6600 Pearl St | Bellevue | WA | 98081 | US | billing@fiddleheadtaproom.com | XX-XXX1143 | USD | Net 15 | Active | 07/13/2014 |
|---|
| 41 | 42 | C-0107 | Green Valley Co-op | 1220 SE Hawthorne Blvd | Portland | OR | 97214 | US | ap@greenvalley.coop | XX-XXX8447 | USD | Net 30 | Active | 05/12/2014 |
|---|
| 42 | 43 | C-0108 | Millrace Pizzeria | 9724 Olive Way | Portland | OR | 97222 | US | billing@millracepizzeria.com | XX-XXX2154 | USD | Net 15 | Active | 09/30/2021 |
|---|
| 43 | 44 | C-0112 | Loam Bakery | 3900 Broadway | Corvallis | OR | 97388 | US | billing@loambakery.com | XX-XXX1215 | USD | Net 15 | Active | 09/08/2023 |
|---|
| 44 | 45 | C-0113 | Willet Cafe | 210 E Fairview Ave | Idaho Falls | ID | 83420 | US | billing@willetcafe.com | XX-XXX8326 | USD | Net 15 | Active | 01/29/2025 |
|---|
| 45 | 46 | C-0115 | Gull Eatery | 6665 Capitol Blvd | Idaho Falls | ID | 83435 | US | billing@gulleatery.com | XX-XXX5889 | USD | Net 15 | Active | 01/01/2025 |
|---|
| 46 | 47 | C-0116 | Ember Eatery | 4101 SE Belmont St | Salem | OR | 97349 | US | billing@embereatery.com | XX-XXX4646 | USD | Net 15 | Active | 07/01/2014 |
|---|
| 47 | 48 | C-0120 | Saltbox Kitchen | 2214 NW Thurman St | Portland | OR | 97210 | US | owner@saltboxkitchen.com | XX-XXX1967 | USD | Net 15 | Active | 07/29/2018 |
|---|
| 48 | 49 | C-0121 | Upland Kitchen | 4842 Market St | Eugene | OR | 97424 | US | billing@uplandkitchen.com | XX-XXX1284 | USD | Net 15 | Active | 07/28/2021 |
|---|
| 49 | 50 | C-0122 | Owyhee Mercantile | 9188 Oak St | Nampa | ID | 83666 | US | ap@owyheemercantile.com | XX-XXX6891 | USD | Net 30 | Active | 10/09/2023 |
|---|
| 50 | 51 | C-0129 | Anchor Pizzeria | 579 SW Barbur Blvd | Gresham | OR | 97041 | US | billing@anchorpizzeria.com | XX-XXX5083 | USD | Net 15 | Active | 04/02/2011 |
|---|
| 51 | 52 | C-0130 | Cinder Kitchen | 1653 Broadway | Idaho Falls | ID | 83466 | US | billing@cinderkitchen.com | XX-XXX3051 | USD | Net 15 | Active | 02/26/2012 |
|---|
| 52 | 53 | C-0132 | Jubilee Cantina | 4328 Front Ave | Tacoma | WA | 98442 | US | billing@jubileecantina.com | XX-XXX7268 | USD | Net 15 | Active | 05/19/2014 |
|---|
| 53 | 54 | C-0133 | Sawtooth Natural Foods | 7612 SW Barbur Blvd | Boise | ID | 83707 | US | ap@sawtoothnaturalfoo.com | XX-XXX8929 | USD | Net 30 | Active | 03/01/2024 |
|---|
| 54 | 55 | C-0135 | Vine Bistro | 2990 NW 23rd Ave | Seattle | WA | 98160 | US | billing@vinebistro.com | XX-XXX1146 | USD | Net 15 | Active | 05/05/2024 |
|---|
| 55 | 56 | C-0136 | Redtail Brasserie | 9661 Pacific Ave | Everett | WA | 98286 | US | billing@redtailbrasserie.com | XX-XXX5768 | USD | Net 15 | Active | 04/27/2021 |
|---|
| 56 | 57 | C-0139 | Greenhouse Bistro | 9562 SE Belmont St | Boise | ID | 83738 | US | billing@greenhousebistro.com | XX-XXX4385 | USD | Net 15 | Active | 01/25/2022 |
|---|
| 57 | 58 | C-0142 | Sextant Bakery | 5789 E Fairview Ave | Olympia | WA | 98573 | US | billing@sextantbakery.com | XX-XXX3512 | USD | Net 15 | Active | 06/27/2015 |
|---|
| 58 | 59 | C-0143 | Gorge Valley Co-op | 2339 Olive Way | Eugene | OR | 97434 | US | ap@gorgevalleycoop.com | XX-XXX3683 | USD | Net 30 | Active | 11/27/2018 |
|---|
| 59 | 60 | C-0145 | Hearth Cantina | 171 N Mississippi Ave | Meridian | ID | 83620 | US | billing@hearthcantina.com | XX-XXX8600 | USD | Net 15 | Active | 11/20/2012 |
|---|
| 60 | 61 | C-0146 | Jetty Tavern | 1031 Pacific Ave | Tacoma | WA | 98471 | US | billing@jettytavern.com | XX-XXX7392 | USD | Net 15 | Active | 04/18/2019 |
|---|
| 61 | 62 | C-0147 | Vashon Island Market | 4937 Riverside Dr | Bellevue | WA | 98062 | US | ap@vashonislandmarket.com | XX-XXX8634 | USD | Net 30 | Active | 03/04/2025 |
|---|
Showing 12–61 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 |
|---|