Schema Changes Version 2021R07

 

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

 

Table

Change

MilitaryBase

Index added on the BaseName and BaseCode columns.

MilitaryCarrier

Index added on the SCACNumber and Name columns.

MSSDocumentImage

Added a trigger that deletes any documents that are stored in external document databases that are linked to MSSDocumentImage records getting deleted.

PM00200

Index added on the VendName and VendorID columns.

StatementDocument

Added a new column OnApplyAmount that stores on apply amounts in Payment Management. (5745)

 

View MoversSuite Database Tables (2021R07)