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)