Schema Changes Version 2019R02

 

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

 

Table

Change

BillingMajorReduction

Updated Percentage. This field was updated to allow for three (3) decimal places to support reductions based on three decimal places, such as new PowerTrack fees. Field size changed from decimal(9,2) to decimal (10,3). (5195)

BillingMinorReduction

Updated Percentage. This field was updated to allow for three (3) decimal places to support reductions based on three decimal places, such as new PowerTrack fees. Field size changed from decimal(9,2) to decimal (10,3). (5195)

ReductionTemplateDetail

Updated Percentage. This field was updated to allow for three (3) decimal places to support reductions based on three decimal places, such as new PowerTrack fees. Field size changed from decimal(9,2) to decimal (10,3). (5195)

ReductionTemplateRateLookupRange

Updated Rate. This field was updated to allow for three (3) decimal places to support reductions based on three decimal places, such as new PowerTrack fees. Field size changed from decimal(9,2) to decimal (10,3). (5195)

RevenueRatingImportDetailReduction

Updated Percentage. This field was updated to allow for three (3) decimal places to support reductions based on three decimal places, such as new PowerTrack fees. Field size changed from decimal(9,2) to decimal (10,3). (5195)

RevenueRatingImportedDetailReduction

Updated Percentage. This field was updated to allow for three (3) decimal places to support reductions based on three decimal places, such as new PowerTrack fees. Field size changed from decimal(9,2) to decimal (10,3). (5195)

RevenueRatingImportedHeaderReduction

Updated Percentage. This field was updated to allow for three (3) decimal places to support reductions based on three decimal places, such as new PowerTrack fees. Field size changed from decimal(9,2) to decimal (10,3). (5195)

RevenueRatingImportHeaderReduction

Updated Percentage. This field was updated to allow for three (3) decimal places to support reductions based on three decimal places, such as new PowerTrack fees. Field size changed from decimal(9,2) to decimal (10,3). (5195)

 

View MoversSuite Database Tables (2019R02)