Schema Changes Version 2017R09

 

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

 

Table

Change

InternationalShippingDate

Removed PortSalingCutoffEstimatedDate and InlandDepartureCutoffEstimatedDate. Estimates for cutoff dates within Shipping Information are deemed unnecessary. (8831)

InternationalVoyage

Added InternationalOriginPortFID. Stores the Origin Port associated to a Vessel/Voyage and Flight Information record. (8824)

InternationalBookingNumberDate

New table storing the estimated and actual dates for the Pickup and Delivery associated to an International Orders record. (8829)

InternationalCustoms

InspectionDate

New table storing the dates set within the Customs Inspection Information screen. (8731)

InternationalCustoms

InspectionInformation

New table storing data set within the Customs Inspection Information screen. (8731)

InternationalCustoms

InspectionLocation

New admin table storing the options defined within Customs Inspection Location Setup. (8731)

InternationalCustoms

InspectionType

New admin table storing the options defined within Customs Inspection Type Setup. (8731)

MobileSetup

Added LastSyncDate. Stores the value set for the Last Synced with MoversConnect On date within Mobile API Setup. (8803)

MoveType

Added InternationalAutoRegister. Stores what is set for the International Auto Register flag within Move Type Setup. (8828)

OrderStatus

Added IsCancelled. Stores the information on whether the Is Cancelled Status flag within Order Status Setup is set. (8737)

XmlInterfaceCredentialMap

New admin table storing the credentials defined within the Interface section of the Interface Mapping tab within Personnel Setup. (8825)

XmlInternationalCarrierMap

New admin table storing the Interface Item options defined within Carrier Setup (International Orders). (8731)

XmlInternationalCustoms

InspectionLocationMap

New admin table storing the Interface Item options defined within Customs Inspection Location Setup. (8731, 8744)

XmlInternationalCustoms

InspectionTypeMap

New admin table storing the Interface Item options defined within Customs Inspection Type Setup. (8731, 8744)

 

View MoversSuite Database Tables (2017R09)