What are the last routed and last visited columns in the address book?
Every time that an address is incorporated from the address book into a new route, the unique address book id is stored with the route. Once this happens, the ‘last routed’ column gets updated with the last known timestamp of the route that this address was part of. Similarly, once a route begins, and a driver visits a customer and marks a location as visited, the timestamp of this occurrence is stored in our database. Therefore, all the records in the address book list have the timestamp values that were generated and updated at the last time an address was added into a route, and the last known time the address was marked as visited.