Schema Changes Version 2018R12

 

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

 

Table

Change

ServiceCode

Changed the size of ServiceCode to be four characters in length from 10. Transactions cannot accept a code larger than four characters, therefore to prevent further errors, the size is restricted to four. Old codes referenced that exceeded four characters are stored within the new OldServiceCode field. The Service Code is defined within the Service Code Setup and is referenced throughout the MoversSuite application. (4897)

Added OldServiceCode. New internal field storing the value of any code existing prior to the addition of the ServiceCode field. (4897)

 

View MoversSuite Database Tables (2018R12)