Schema Changes Version 2018R04

 

The following table lists changes made to the MoversSuite database for this release.

 

Table

Change

Orders

A trigger was added to this table to mark the order as completed based on data input through the Local Service Information API connector. This trigger updates the new OrderCompletedStatusHistory table based on the Global System Option value of OrderCompletedStatusHistory. (4909)

OrderCompletedStatusHistory

New internal table storing information on when an order is considered completed as part of the Local Service Information API connector. (4909)

WorkTickets

Index added on the WorkTicketNumber column for use with the Local Service Information API connector. (4909)

 

View MoversSuite Database Tables (2018R04)