Schema Changes Version 2018R06

 

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

 

Table

Change

EmailMessage

Added DateQueuedUtc. New date and time field storing the UTC time that the email message associated to a Recurring Payments. (4893)

Added SendSilently. New date and time field storing the UTC time that the email message associated to a Recurring Payments. (4893)

Added SendException. New date and time field storing the UTC time that the email message associated to a Recurring Payments. (4893)

MobileCrewTimeActivity

Added ActivityCode. This field stores the value entered for the Activity Code setting within Crew Activity Setup (up to 32 characters). (4839)

MobileCrewTimeSentToXmlInterface

New internal table storing the punch information sent to an external interface through the Export Punches to Payroll dialog. (4839)

PlasticInstrument

Added OnlineOkForFutureInv. Flag indicating that the customer wishes to use the current payment on future recurring payments. This flag is set through the Online Payment screen. (4893)

Added OnlineOkDate. Date that the customer checked the flag to save the payment for recurring payments through the Online Payment screen. (4893)

Storage

Added UseOnlinePayment. New flag storing the value set for the Use Online Payment flag on the Payment Setup tab. (4893)

StorageInvoiceHistorical

Added OnlinePaymentCount. Internal counter tracking the number of payments made for the storage item using an Online Payment. (4893)

SystemEmail

Added UsageNote. This field store usage information for the different types of records available within System Email Setup. Specifically, the note displays within the When This Email Gets Used section for each established record. This internal message can be up to 255 characters in length. (4893)

Added HyperLinkText. This field stores what is set for the Hyperlink Text To Be Inserted Into Email option for each record defined within System Email Setup (up to 40 characters). (4893)

Added ValidTags. Stores the information that displays within the Tags allowed on this email option within System Email Setup. This internal message can be up to 512 characters in length. (4893)

SystemEmailType

Added DefaultSubject. The default email subject set by MoversSuite is stored within this new field. Specifically, this text is set within the Email Subject for each System Email Setup record. Optionally, you can press the Reset Email to Default button to restore what is set for this field onto the actual email record. (4893)

Added DefaultBodyText. The default email body set by MoversSuite is stored within this new field. Specifically, this text is set within the Email Message for each System Email Setup record. Optionally, you can press the Reset Email to Default button to restore what is set for this field onto the actual email record. (4893)

Added DefaultHyperLinkText. The default email link set by MoversSuite is stored within this new field. Specifically, this text is set within the Hyperlink Text To Be Inserted Into Email for each System Email Setup record. Optionally, someone can press the Reset Email to Default button to restore what is set for this field onto the actual email record. (4893)

XmlInterfaceBranchOption

New administrative table storing the values entered for Interface Branch Option values within Branch Setup. (4839)

XmlInterfaceBranchOptionType

New administrative table storing the options available to assign to a Branch Setup record through the Add Interface Branch Option dialog; specifically, the Option Type values are defined in this new table. (4839)

XmlInterfaceMobileCrewTimeActivityMap

New internal table storing the data sent through an Export Punches to Payroll. (4839)

 

View MoversSuite Database Tables (2018R06)