Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

...

...

August 22 2021 conversion using file provided by Tim

Trux

Navusoft

Customers

320

7 Trux customers had no records on CM04 table – Email sent to Tim

313

Sites

3453

3453

Services

Data appears to include duplicate records

Charge codes

Total recurring revenue

Routing

AR

Note

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

...

Tip

Sites

All Sites imported

Warning

Services --- Data includes illogical data --- Duplicate records

...