Schema Changes Version 2016R07

 

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

 

Table

Change

Agent

Removed the Contact field, replaced by a new contact entry within Agent Setup. (7363)

AgentContact

New administrative table storing contact records associated to an Agent Setup records. (7363)

AgentContactPhoneNumber

New administrative table storing the phone number associated to contact records defined for an Agent Setup record. (7363)

AgentContactPhoneType

New internal table storing the phone type needed for phone number entry within the Agent Setup. Currently, the application supports an Agent Contact Phone Type of “Main”. (7363)

InternationalCarrier

Added EMail field (varchar 128). This field stores the Email address associated to the Carrier Setup (International Orders) record. (7363)

InternationalConsolidator

Added EMail field (varchar 128). This field stores the Email address associated to the Consolidator Setup record. (7363)

InternationalCustomsAgent

Added EMail field (varchar 128). This field stores the Email address associated to the Customs Agent Setup record. (7363)

ShipmentStatusHistory

Changed the DriverID field from 6 characters to 15 characters (varchar 15). (8011)

SMTP

 

Added EnableSsl field (bit). This field stores the value set for the “Does the email server require SSL?” option within SMTP Setup. (7574, 7363)

SysFile

Added UseDefaultEmail field (bit). This field stores the value set for the Use computer’s default email service instead of MoversSuite email (all users) option within SMTP Setup. (7474, 7363)

Renamed Outlook to OutlookCalendar to better represent its usage (refer to the Microsoft Outlook Calendar Integration setting within System Wide Options).

Created a separate OutlookEmail flag. This flag corresponds to the new Microsoft Outlook Email Integration setting within System Wide Options. This flag, when set, instructs MoversSuite to fully utilize Outlook for mail management. (8061)

SysuserEmailSignature

New table storing the email signatures created for a particular user through the MoversSuite Email Service. (7465, 7363)

 

View MoversSuite Database Tables (2016 R07)

View MoversSuite Document Database Tables (2016 R07)