Schema Changes Version 2017R18

 

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

 

Table

Change

BuildingConstraintItemMap

New table storing the custom settings established for Building Constraints Items assigned to Building Setup record. (4073)

LocServ

 

Added Sort1 and Sort2. These two fields allow you to type an entry directly into the Dispatch Center grid for additional organization of data. You can specify up to 16 characters in each field. (4103)

MilitaryWeight

Added OrderAuditInfoFID. New field to link a Military/Government tab record to Order History data. (4116)

ReportingUser

New table storing the values assigned to a user through the Enterprise BI User Setup. (4683)

ReportingUserAccess

New table storing user credentials entered through the Enterprise BI User Setup. (4683)

SITInformation

Added OrderAuditInfoFID. New field to link a SIT Information record to Order History information. (4116)

Added OrderAuditInfoManualCleanup. Internal flag to manage cleaning up metadata when managing Order History records. (4116)

SysFile

Added Key3. Field storing encrypted key available through Licensing Setup to support Enterprise BI. (4683)

 

View MoversSuite Database Tables (2017R18)