Schema Changes Version 2018R11

 

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

 

Table

Change

Orders

Added TenderedDate. New date field storing what is set for an order within Tendered Date field within Billing Information the and Billing Information (Revenue Entry) tabs. (4946)

RateEffectiveDateBasis

New internal table storing the values available through the Effective Date Basis setting within Rate Matrix Setup. (4946)

RateMatrixRangeX

Added MinCharge. New administrative field storing the value entered for the Minimum Charge on Range X item within Rate Matrix Setup. (4943)

Added MaxCharge. New administrative field storing the value entered for the Maximum Charge on Range X item within Rate Matrix Setup. (4943)

Added Note. New administrative field storing the value entered for the Note (up to 128 characters) associated to a Range X item within Rate Matrix Setup. (4943)

RateMatrixRangeY

Added Note. New administrative field storing the value entered for the Note (up to 128 characters) associated to a Range X item within Rate Matrix Setup. (4943)

RateMatrixRate

Added ForeignID. New internal field storing the values supplied by a third-party to identified imported Rate Matrix Setup records (up to 64 characters). (4943)

RatePlans

Added RateEffectiveDateBasisFID. New administrative field storing the selection made through the Effective Date Basis setting within Rate Matrix Setup. (4946)

 

View MoversSuite Database Tables (2018R11)