Schema Changes Version 2016R25

 

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

 

Table

Change

AccountProfiles

Added LaborRatingGroupFID. Stores the administrative setting of Rate Schedule for Labor selected within the General tab on an Account Profiles record. This data references the values available through Rate Schedule for Labor. Refer to Job Costing. (8371)

AccountProfileDocument

New table storing the documents linked to an Account Profile Setup record through the Documents tab. The data in this table is also accessible through the Documents section within the Account Profile tab. (8381)

AccountProfileDocumentGroup

New administrative table storing the information set within Account Profile Document Group Setup. (8381)

AccountProfileDocumentType

New administrative table storing the information set within Account Profile Document Type Setup. (8381)

Branch

 

Added LaborRatingGroupFID. Stores the administrative setting of Rate Schedule for Labor selected within the General tab on a Branch Setup record. This data references the values available through Rate Schedule for Labor. Refer to Job Costing. (8371)

EquipmentDocument

New table storing the documents linked to an Equipment Setup record through the Documents tab. The data in this table is also accessible through the Documents tab within Equipment Information screen. (8382)

EquipmentDocumentGroup

New administrative table storing the information set within Equipment Document Group Setup. (8382)

EquipmentDocumentType

New administrative table storing the information set within Equipment Document Type Setup. (8382)

EquipmentDocumentTypeUserMap

New administrative table that specifies which users have permission to access secure documents. This table stores the link between an Equipment Setup and Equipment Document Type Security Setup record. (8382)

JobCostingItem

Added RatedAmount. This field stores the rating amount computed for a Job Costing item, as visible through Single Order tab. (8371)

LaborRatingDay

Added NumericValue. New field storing the numeric equivalent for the corresponding day of the week set through Day Item within the Rate Schedule for Labor. Refer to Job Costing. (8371).

LaborRatingScheduleQuery

New table storing data used internally by the Job Costing functionality. (8371)

MobileUserLogPullHistory

New administrative table storing the information retrieved for a MoversSuiteCrew Mobile Application user when they obtain a new token. The data displays and is manually updated through the Mobile User Log screen. (8548)

MobileSetup

Added DefaultDocumentTypeFID. New administrative field storing the value selected for the Mobile App Created Document Type field within the Mobile Api Setup. This is the default type set for documents added through the MoversSuiteCrew Mobile Application. The values available this field are those defined within Document Type Setup. (8548)

MobileUserLog

Added FeatureSet. New administrative field displaying the Feature item listed within th Mobile User Log screen. (8548)

SysFile

Added DefaultLaborRatingGroup. Default rating applied internally to a Personnel Setup record. This default pulls from those established within Rate Schedule for Labor and is set in the case where no rating group exists on an Account Profile Setup or Branch Setup record. (8371)

 

View MoversSuite Database Tables (2016R25)