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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
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 |
| 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 |
|---|
| 91 | 92 | C-0218 | Undertow Bakery | 4803 SE Division St | Eugene | OR | 97401 | US | billing@undertowbakery.com | XX-XXX7397 | USD | Net 15 | Active | 09/06/2015 |
|---|
| 92 | 93 | C-0219 | Huckleberry Grill | 4233 Olive Way | Eugene | OR | 97420 | US | billing@huckleberrygrill.com | XX-XXX9405 | USD | Net 15 | Active | 04/26/2012 |
|---|
| 93 | 94 | C-0221 | Kiln Deli | 4539 Harbor Dr | Nampa | ID | 83613 | US | billing@kilndeli.com | XX-XXX5015 | USD | Net 15 | Active | 08/20/2016 |
|---|
| 94 | 95 | C-0233 | Rose City Market Hall | 405 NE Couch St | Portland | OR | 97232 | US | payables@rosecitymarkethall.com | XX-XXX7054 | USD | Net 30 | Active | 01/21/2019 |
|---|
| 95 | 96 | C-0237 | Plover Supper Club | 5933 Riverside Dr | Nampa | ID | 83674 | US | billing@ploversupperclub.com | XX-XXX7199 | USD | Net 15 | Active | 12/14/2020 |
|---|
| 96 | 97 | C-0239 | Larkspur Noodle House | 9708 Front Ave | Boise | ID | 83794 | US | billing@larkspurnoodlehous.com | XX-XXX4207 | USD | Net 15 | Active | 06/29/2012 |
|---|
| 97 | 98 | C-0242 | Pumice Cantina | 2252 SW Barbur Blvd | Hood River | OR | 97006 | US | billing@pumicecantina.com | XX-XXX9510 | USD | Net 15 | Active | 09/09/2012 |
|---|
| 98 | 99 | C-0247 | Wren Noodle House | 6634 Market St | Meridian | ID | 83690 | US | billing@wrennoodlehouse.com | XX-XXX1340 | USD | Net 15 | Active | 06/12/2016 |
|---|
| 99 | 100 | C-0250 | Nettle Cantina | 2862 Industrial Way | Eugene | OR | 97469 | US | billing@nettlecantina.com | XX-XXX7041 | USD | Net 15 | Active | 09/26/2021 |
|---|
| 100 | 101 | C-0261 | Harbor Tavern | 4865 Oak St | Boise | ID | 83725 | US | billing@harbortavern.com | XX-XXX4299 | USD | Net 15 | Active | 09/19/2013 |
|---|
| 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 |
|---|
| 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 |
|---|
Showing 80–129 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 |
|---|