Schema Changes Version 2022R18

 

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

 

Table

Change

MSSDocument

Added DocByteSize to store the size of a file stored within the Document Management system. This update was added to protect the processes involved with managing documents through MSWeb.

(MOV-6513)

OutgoingEmailAddress

Replaced OutgoingEmailQueueID with OutgoingEmailFID. This is part of the improvements made around managing emails through MSWeb.

MOV-5997, MOV-6445, MOV-6446)

OutgoingEmailQueue

Replaced FromAddress with OutgoingEmailFID  to remove to reference the new table for storing the email addresses. This is part of the improvements made around managing emails through MSWeb.

MOV-5997, MOV-6445, MOV-6446)

Removed FromName. This is part of the improvements made around managing emails through MSWeb.

MOV-5997, MOV-6445, MOV-6446)

Added EnqueueAt to identify the date and time that an email has been queued in the service. This is part of the improvements made around managing emails through MSWeb.

MOV-5997, MOV-6445, MOV-6446)

SysFile

Added MoversConnectTraceId to provide system tracing for MoversConnect. This is part of the improvements made around managing emails through MSWeb.

(MOV-5997, MOV-6445, MOV-6446)

OutgoingEmailQueueAttachment

This table has been removed as part of the improvements made around managing emails through MSWeb.

MOV-5997, MOV-6445, MOV-6446)

OutgoingEmail

New tables storing information on emails sent through the MoversSuite Email Service, such as information on email details, email failures, email sending status, etc. This change is part of the improvements made around managing emails through MSWeb.

MOV-5997, MOV-6445, MOV-6446)

OutgoingEmailBatchFailure

OutgoingEmailDocumentAttachment

OutgoingEmailFailure

OutgoingEmailFileAttachment

OutgoingEmailFailure

OutgoingEmailInlineAttachment

OutgoingEmailInvoiceAttachment

OutgoingEmailOrderMap

OutgoingEmailStatus

OutgoingEmailFileSuccess

 

View MoversSuite Database Tables (2022R18)