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)