Schema Changes Version 2019R05

 

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

 

Table

Change

CommissionedDetail

Added Miles. This new field stores the information entered for a mileage-based commission. This field links to the Miles field appearing on the Add Revenue Commission dialog. (5273)

CommStmtDetail

MobileSetup

Deleted ApiServiceURL. This field was moved to the MoversConnectSetup table as part of Text Messaging.

MoversConnectSetup

Added ApiServiceURL. This field was moved from the MobileSetup table as part of Text Messaging. This

SakariAccount

New administrative table storing the data set through Sakari Account Setup as part of Text Messaging. (5199)

SakariAccountBranchMap

New administrative table storing the data set through Sakari Account Branch Setup as part of Text Messaging. (5199)

SakariContact

New internal table storing the contact information for person associated with Text Messaging. (5199)

SakariContactOrderMap

New internal table storing which orders a contact links through Text Messaging. (5199)

SakariContactSysuserMap

New internal table storing which MoversSuite users a contact links through Text Messaging. (5199)

SakariConversation

New internal table storing the header information of a Text Messaging conversation. (5199)

SakariIncomingMessage

New internal table storing the detail information of an incoming Text Messaging message. (5199)

SakariMessageStatus

New internal table storing the status values associated to a Text Messaging message, e.g. New, Validated, Queued, Sent, Delivered, Error. (5199)

SakariOptions

New administrative table storing the data set through Sakari Options. (5199)

SakariOutgoingMessage

New internal table storing the detail information of an outgoing Text Messaging message. (5199)

SakariSyncSession

New internal tables storing the data associated to a sync performed through the Sakari Options. (5199)

SakariSyncSessionLog

 

View MoversSuite Database Tables (2019R05)