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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
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 |
| 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 |
|---|
| 62 | 63 | C-0154 | Green Valley Cooperative Market | 1220 S.E. Hawthorne Boulevard | Portland | OR | 97214 | US | accounts@greenvalley.coop | XX-XXX8447 | USD | Net 30 | Active | 09/18/2025 |
|---|
| 63 | 64 | C-0155 | Lodestar Cafe | 1816 Front Ave | Meridian | ID | 83612 | US | billing@lodestarcafe.com | XX-XXX9611 | USD | Net 15 | Active | 01/30/2024 |
|---|
| 64 | 65 | C-0156 | Hollow Noodle House | 1760 Pacific Ave | Hillsboro | OR | 97153 | US | billing@hollownoodlehouse.com | XX-XXX4760 | USD | Net 15 | Active | 06/05/2017 |
|---|
| 65 | 66 | C-0158 | Umber Grill | 6987 Market St | Lake Oswego | OR | 97094 | US | billing@umbergrill.com | XX-XXX8451 | USD | Net 15 | Active | 02/27/2022 |
|---|
| 66 | 67 | C-0161 | Bramble Noodle House | 2454 Riverside Dr | Seattle | WA | 98186 | US | billing@bramblenoodlehouse.com | XX-XXX1575 | USD | Net 15 | Active | 08/29/2011 |
|---|
| 67 | 68 | C-0163 | Elk Rock Provisions | 9511 Rainier Ave S | Gresham | OR | 97047 | US | ap@elkrockprovisions.com | XX-XXX7959 | USD | Net 30 | Active | 10/01/2019 |
|---|
| 68 | 69 | C-0171 | Dune Cantina | 1576 Capitol Blvd | Lake Oswego | OR | 97017 | US | billing@dunecantina.com | XX-XXX1632 | USD | Net 15 | Active | 04/20/2021 |
|---|
| 69 | 70 | C-0172 | Driftless Tavern | 9354 Evergreen Pkwy | Hillsboro | OR | 97123 | US | billing@driftlesstavern.com | XX-XXX9575 | USD | Net 15 | Active | 07/15/2017 |
|---|
| 70 | 71 | C-0177 | Quarterdeck Tavern | 6657 Pacific Ave | Corvallis | OR | 97331 | US | billing@quarterdecktavern.com | XX-XXX6711 | USD | Net 15 | Active | 09/18/2014 |
|---|
| 71 | 72 | C-0182 | Jasper Bakery | 6779 Center St | Salem | OR | 97300 | US | billing@jasperbakery.com | XX-XXX2586 | USD | Net 15 | Active | 08/09/2020 |
|---|
| 72 | 73 | C-0183 | Madrona Food Co-op | 2889 Market St | Portland | OR | 97275 | US | ap@madronafoodcoop.com | XX-XXX1449 | USD | Net 30 | Active | 08/13/2025 |
|---|
| 73 | 74 | C-0185 | Gristmill Supper Club | 2421 Pearl St | Olympia | WA | 98520 | US | billing@gristmillsupperclu.com | XX-XXX2414 | USD | Net 15 | Active | 12/01/2024 |
|---|
| 74 | 75 | C-0186 | Hawthorne Fresh Market | 7480 Broadway | Eugene | OR | 97462 | US | ap@hawthornefreshmark.com | XX-XXX2759 | USD | Net 30 | Active | 08/13/2018 |
|---|
| 75 | 76 | C-0189 | Ironclad Brasserie | 7458 Center St | Lake Oswego | OR | 97040 | US | billing@ironcladbrasserie.com | XX-XXX3490 | USD | Net 15 | Active | 12/26/2022 |
|---|
| 76 | 77 | C-0190 | Magpie Tavern | 4498 SE Division St | Corvallis | OR | 97385 | US | billing@magpietavern.com | XX-XXX3208 | USD | Net 15 | Active | 08/18/2015 |
|---|
| 77 | 78 | C-0191 | Riverstone Smokehouse | 4816 SE Belmont St | Corvallis | OR | 97352 | US | billing@riverstonesmokehou.com | XX-XXX7993 | USD | Net 15 | Active | 10/17/2015 |
|---|
| 78 | 79 | C-0193 | Quinault Country Store | 7073 SE Division St | Seattle | WA | 98192 | US | ap@quinaultcountrysto.com | XX-XXX6947 | USD | Net 30 | Active | 10/20/2014 |
|---|
| 79 | 80 | C-0197 | Elderberry Deli | 1505 Market St | Lake Oswego | OR | 97070 | US | billing@elderberrydeli.com | XX-XXX4498 | USD | Net 15 | Active | 09/03/2015 |
|---|
| 80 | 81 | C-0198 | GREEN VALLEY COOP #2 | 7815 N Lombard St | Portland | OR | 97203 | US | store2.accounts@greenvalley.coop | XX-XXX8447 | USD | Net 30 | Active | 08/03/2021 |
|---|
| 81 | 82 | C-0200 | Ember Lane Grocers | 9320 NE Alberta St | Idaho Falls | ID | 83485 | US | ap@emberlanegrocers.com | XX-XXX3838 | USD | Net 30 | Active | 02/22/2021 |
|---|
| 82 | 83 | C-0204 | Foundry Bakery | 9797 Rainier Ave S | Vancouver | WA | 98678 | US | billing@foundrybakery.com | XX-XXX7091 | USD | Net 15 | Active | 03/12/2014 |
|---|
| 83 | 84 | C-0206 | Otter Brasserie | 6950 SE Belmont St | Idaho Falls | ID | 83439 | US | billing@otterbrasserie.com | XX-XXX5822 | USD | Net 15 | Active | 05/30/2014 |
|---|
| 84 | 85 | C-0207 | Wildwood Tavern | 6693 Oak St | Seattle | WA | 98171 | US | billing@wildwoodtavern.com | XX-XXX6344 | USD | Net 15 | Active | 06/02/2023 |
|---|
| 85 | 86 | C-0208 | Ursa Noodle House | 4997 Capitol Blvd | Portland | OR | 97273 | US | billing@ursanoodlehouse.com | XX-XXX4015 | USD | Net 15 | Active | 09/08/2012 |
|---|
| 86 | 87 | C-0209 | Kelp Grill | 5311 Harbor Dr | Boise | ID | 83731 | US | billing@kelpgrill.com | XX-XXX4653 | USD | Net 15 | Active | 06/02/2020 |
|---|
| 87 | 88 | C-0214 | Nectar Noodle House | 9325 Oak St | Seattle | WA | 98167 | US | billing@nectarnoodlehouse.com | XX-XXX3499 | USD | Net 15 | Active | 11/16/2011 |
|---|
| 88 | 89 | C-0215 | Nook Eatery | 3554 Main St | Gresham | OR | 97015 | US | billing@nookeatery.com | XX-XXX5797 | USD | Net 15 | Active | 09/15/2021 |
|---|
| 89 | 90 | C-0216 | Arbor Kitchen | 9774 Harbor Dr | Lake Oswego | OR | 97051 | US | billing@arborkitchen.com | XX-XXX5506 | USD | Net 15 | Active | 06/25/2013 |
|---|
| 90 | 91 | C-0217 | Paddle Eatery | 8379 Broadway | Corvallis | OR | 97346 | US | billing@paddleeatery.com | XX-XXX5306 | USD | Net 15 | Active | 05/16/2023 |
|---|
Showing 41–90 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 |
|---|