Schema Changes Version 2016R19

 

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

 

Table

Change

AccountProfilePreset

New administrative table storing the top-level values entered within the Preset Addresses tab in Account Profile Setup, such as the Preset Name and Contact Name. Refer to Add Account Profile Preset. (7732)

AccountProfilePresetAddress

New administrative table storing the address information entered within the Preset Addresses tab in Account Profile Setup. This table links to (is a sub-table of) the AccountProfilePreset table. (7732)

AccountProfilePresetPhoneNumber

New administrative table storing the phone number information entered within the Preset Addresses tab in Account Profile Setup. This table links to (is a sub-table of) the AccountProfilePreset table. (7732)

Equip

Added RegisteredOwner. This column is a varchar 64 and stores the data entered for the Registered Owner field within the Other tab in Equipment Setup. (8343)

Added PurchasePrice. This column stores the data entered for the Purchase Price field within the Other tab in Equipment Setup. (8343)

SafetySystemEquipment

Added LicensePlateNumber. This column is a varchar 32 and stores the data entered for the License Plate Number field within the Safety tab in Equipment Setup. (8343)

Added DotInspectionDate. This column stores the data entered for the DOT Inspection Date field within the Safety tab in Equipment Setup. (8343)

Added DotExpirationDate. This column stores the data entered for the DOT Expiration Date field within the Safety tab in Equipment Setup. (8343)

SafetySystemPersonnel

Added LicenseNumber. This column is a varchar 32 and stores the data entered for the License Number field within the Safety tab in Personnel Setup. (8343)

Added LicenseClass. This column is a varchar 32 and stores the data entered for the License Class field within the Safety tab in Personnel Setup. (8343)

QuoteTemplate

New administrative table storing the data entered within Quote Template Setup. (8193)

QuoteTemplateDetail

New administrative table storing the detail items associated to a Quote Template Setup record. This table links to (is a sub-table of) the QuoteTemplate table. (8193)

 

View MoversSuite Database Tables (2016R19)