Table

Change

BillingMajorItem

Added LaborRatingTypeFID. This new column stores the Labor Rate Type set for a billing item through the Rate As field within Add Revenue Group. Refer to Add Revenue Group and Rate Schedule for Labor. (8256)

BillingMinorItem

Added LaborRatingTypeFID. This new column stores the Labor Rate Type set for a billing item through the Rate As field within Add Revenue Item. Refer to Add Revenue Item and Rate Schedule for Labor. (8256)

CountryCodeStandard

Added Alpha2Code. New administrative column storing the Alpha 2 Code assigned to a Country Code Setup record. The Mobile API process utilizes this value to identify the appropriate country. (8319)

InvoicedDetail

Added LaborRatingTypeFID. This new column stores the Labor Rate Type set for an invoice item through the Rate As field within New Complete Invoice. Refer to New Complete Invoice and Rate Schedule for Labor. (8256)

InvoicedGroup

Added LaborRatingTypeFID. This new column stores the Labor Rate Type set for an invoice group through the Rate As field within New Complete Invoice. Refer to New Complete Invoice and Rate Schedule for Labor. (8256)

LSCrewTimes

Added ActualCreatedBy. New data column storing a link to the user (SysUser record) that entered actuals for the service request. (8244)

MoversConnectSetup

Added MoversConnectBaseUrl. New administrative column storing the base URL to for testing MoversConnect (up to 255 characters). This column is not exposed (available) through MoversConnect Setup and Administration. (8320)

QuoteDetail

Added LaborRatingTypeFID. This new column stores the Labor Rate Type set for a quote item through the Rate As field within the Quote tab. Refer to Quote and Rate Schedule for Labor. (8256)

QuoteGroup

Added LaborRatingTypeFID. This new column stores the Labor Rate Type set for a quote group through the Rate As field within the Quote tab. Refer to Quote and Rate Schedule for Labor. (8256)

Rates

Added DoubleRate. New administrative column storing the value entered for the Double Time field for a Rate item within the Rate Plan Setup. This is the default amount assigned to crew for double time work performed on a rated item. (8244)

RateTypes

Added ApplyLaborRatingType. New administrative flag storing whether the Apply Regular, OT and Double Rates option is checked or not within Rate Type Setup. When this flag is set, the application interprets rating values assigned to the Rate Plan to determine to make the Rate As option available in various rating locations within MoversSuite. (8244)

ServeqTimes

Added ActualCreatedBy. New data column storing a link to the user (SysUser record) that entered actuals for the equipment assignments that were dispatched by quantity. (8244)

StorageItems

Added LaborRatingTypeFID. This new column stores the Labor Rate Type set for a billed storage item within the Rate As field within the Billing Items tab. Refer to Billing Items and Rate Schedule for Labor. (8256)

SysUserPhoneType

Added MobileTypeName. This new column stores the name of the phone type that is supported by the MoversSuite API Service. This type is mapped to corresponding entries available when Phone Number Item within Personnel Setup. (8319)

MobileAccess

New administrative table storing the values entered within the Mobile User tab within Personnel Setup. (8319)

MobileSetup

New administrative table storing the values entered through the Mobile Api Setup tab within MoversConnect Setup and Administration. (8319)

MobileUserLog

New administrative table storing the logged values set for each Mobile API user. The logs are visible through the MoversConnect Log screen. (8319)

MobileUserType

New administrative table storing the values assignable through the Mobile User Type field within the Mobile User tab within Personnel Setup. The option available include the following:

Crew Time

Mobile Time

None

(8319)

ServeqQuantityActual

New table storing the actual data set for a service with equipment dispatched by quantity. This information is set within the Equipment Times tab of the Enter Actuals screen. (8244)

SysuserProfilePic

New table storing the picture associated to a user record. This data is utilized by the MoversSuiteCrew Mobile Application. (8319)