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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
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 |
| 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 162–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 |
|---|