Schema Changes Version 2018R09

 

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

 

Table

Change

BranchPackingCapacity

New administrative table storing the values set within the Daily Packing Capacity Setup. Refer to Capacity Planning for more information. (4912, 4928)

CapacityBucket

New administrative table storing the values set within the Capacity Bucket Setup. Refer to Capacity Planning for more information. (4912, 4928)

CapacityBucketType

New administrative table storing the values available within the Type setting in Capacity Bucket Setup. Refer to Capacity Planning for more information. (4912, 4928)

CapacityThreshold

New administrative table storing the values set within the Capacity Used Threshold Setup. Refer to Capacity Planning for more information. (4912, 4928)

EqType

Added CapacityBucketFID. Stores the value selected within the Capacity Bucket setting within Equipment Type Setup from a list of those defined within Capacity Bucket Setup. Refer to Capacity Planning for more information. (4912, 4928)

Added HoursAvailableDaily. Stores the value entered for the Hours Available Daily within Equipment Type Setup. Refer to Capacity Planning for more information. (4912, 4928)

Equip

Added CapacityBucketFID. Stores the value selected within the Capacity Bucket setting within the Other tab within Equipment Setup from a list of those defined within Capacity Bucket Setup. Refer to Capacity Planning for more information. (4912, 4928)

Added HoursAvailableDaily. Stores the value entered for the Hours Available Daily within the Other tab within Equipment Type Setup. Refer to Capacity Planning for more information. (4912, 4928)

LaborType

Added CapacityBucketFID. Stores the value selected within the Capacity Bucket setting within Labor Type Setup from a list of those defined within Capacity Bucket Setup. Refer to Capacity Planning for more information. (4912, 4928)

MaterialType

Added CapacityBucketFID. Stores the value selected within the Packing Capacity Bucket setting within Material Type Setup from a list of those defined within Capacity Bucket Setup. Refer to Capacity Planning for more information. (4912, 4928)

Sysuser

Added CapacityBucketFID. Stores the value selected within the Capacity Bucket setting within the Dispatch tab within Personnel Setup from a list of those defined within Capacity Bucket Setup. Refer to Capacity Planning for more information. (4912, 4928)

 

View MoversSuite Database Tables (2018R09)