Schema Changes Version 2017R12

 

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

 

Table

Change

Agent

 

Added IsForwardingAgent. Stores the setting made for the Is Forwarding Agent flag within Agent Setup. (8874)

BranchAddress

Changed the size of the Title field to 255 characters from 50. This field stores the Title set for Branch Address within Branch Setup. (8892)

InternationalBookingNumber

Renamed CarrierCode to ConsolidatorBookingNumber. This field stores the value set for the HAWB field within Pickup/Delivery Information, available for Transport Type of Air. (8866)

Added InternationalLinehaulCarrierFID. Stores the primary key of the value selected for the Carrier field within Pickup/Delivery Information. The options reference for this setting are defined within Linehaul Carrier Setup. (8873)

InternationalLinehaulCarrier

New table storing the values defined within Linehaul Carrier Setup. (8873)

InternationalLinehaulCarrierAddress

New table storing the values set for the Linehaul Address within Linehaul Carrier Setup. (8873)

InternationalLinehaulCarrierPhoneNumber

New table storing the values set for the Linehaul Address within Linehaul Carrier Setup. (8873)

InternationalShippingInformation

Added OriginLinehaulCarrierFID. Stores the primary key of the value selected for the Origin Linehaul Carrier field within Shipping Information. The options reference for this setting are defined within Linehaul Carrier Setup. (8873)

Added DestinationLinehaulCarrierFID. Stores the primary key of the value selected for the Destination Linehaul Carrier field within Shipping Information. The options reference for this setting are defined within Linehaul Carrier Setup. (8873)

Added OverlandCarrier. Allows you to document the Overland Carrier on the Shipping Information tab when the Transportation Mode is set to Overland (up to 64 characters).

Removed ConsolidatorBookingNumber. This field moved to the InternationalBookingNumber table. (see above). (8866)

InvoicedHeader

Changed the size of the HeaderTitle field to 255 characters from 50. This field stores the Header branch name that displays on an invoice, set within New Complete Invoice (pulled from the Title set for a Branch Address within Branch Setup. (8892)

Changed the size of the RemittanceTitle field to 255 characters from 50. This field stores the Remit-To branch name that displays on an invoice, set within New Complete Invoice (pulled from the Title set for a Branch Address within Branch Setup. (8892)

SalesTeamSplit

New table storing the data set for Sales Team Split records within the Order Defaults of an Account Profile Setup record. (8613)

XmlInternationalLinehaulCarrierMap

New table storing the Interface Item data set for a Linehaul Carrier Setup record. (8873)

XmlQuoetLink

New internal table storing a mapping between a quote for a particular order linked to the UniGroup International system. (8873)

XmlShipmentTypeMap

New table storing the Interface Item data set for a Shipment Type Setup record. (8916)

 

View MoversSuite Database Tables (2017R12)