August 22 2021 conversion using file provided by Tim
Trux | Navusoft | |
|---|---|---|
Customers | 320 7 Trux customers had no records on CM04 table | 313 |
Sites | 3453 | 3453 |
Services | Data appears to include duplicate records | |
Charge codes | ||
Total recurring revenue | ||
Routing | ||
AR |
Customers
7 customers have not sites on data file provided
select count(*) from [JLT_Aug_21_2021_CM03-Cust]
select count(*) from account where external_id_alpha is not null
Sites
All Sites imported
Services --- Data includes illogical data --- Duplicate records
