Schema Changes Version 2016R15

 

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

 

Table

Change

CRNumbers

Updated the constraints on the table to not allow duplicate Prefix values within Cash Receipt Numbers Setup. (8254)

HtmlLetter

New table storing the contents of an HTML document created through Forms Designer Templates.  This additional table, along with the data stored within HtmlLetter table, support the conversion of document templates stored previously as HTML prior to DOCX. (8270)

HtmlLetter

New table linking a HtmlLetter document to a particular ReportProfileFID record (Report Profile Setup).  (8270)

PlasticInstrument

Added NickName. This field captures the Nick Name assigned to a payment method through the Payment Management option from AutoPay Setup (Recurring Billing) screen (up to 40 characters).

ReportLetter

Moved MarginLeft, MarginRight, MarginTop, MarginBottom, PageWidth, PageHeight, and IsLandscape to the new HtmlLetter table.

Changed LetterContent from a nvarchar to a varbinary field to store the contents of DOCX template created through Forms Designer Templates. (8270)

SystemEmail

New table storing the contents of an automatic email generated through the Recurring Billing and Storage run. (8222)

SystemEmailType

New table storing the type of an automatic email generated through the Recurring Billing and Storage run as either a recurring billing invoice or recurring billing cash receipt. (8222)

 

View MoversSuite Database Tables (2016R15)

View MoversSuite Document Database Tables (2016R15)