Schema Changes Version 2018R23

 

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

 

Table

Change

CommodityDetail

New administrative table storing the data set within Commodity Detail Setup. This mapping information is needed to support the Atlas SUDS Order Upload process. (4961)

HaulMode

New administrative table storing the data set within Haul Mode Setup. This mapping information is needed to support the Atlas SUDS Order Upload process. (4961)

OrderNoteDetail

Added SendToVanline. New column storing the selection made for the Enabled flag within an order note (through the Add Note dialog) associated to an Atlas SUDS Order Upload. (4961)

Added Initials. New column storing what was set for Initials within an order note (through the Add Note dialog) associated to an Atlas SUDS Order Upload (up to four characters). (4961)

Added VanlinePub. New column storing the selection made for the Private flag within an order note (through the Add Note dialog) associated to an Atlas SUDS Order Upload. (4961)

OrdersExtended

New internal table storing extended mappings set for an order specifically through the COD Collection Amount, Commodity Detail, Haul Mode, and Will Advise settings within the Billing Information tab for an Atlas SUDS Order Upload.  (4961)

XmlImportError

Added IsVanLineOrderErrors. New column storing the value set for a flag indicating whether the error occurred during a van line order import. (4961)

XmlInterfaceCommodityDetailMap

New internal table storing the Interface Item mappings set within Commodity Detail Setup. (4961)

XmlInterfaceHaulModeMap

New internal table storing the Interface Item mappings set within Haul Mode Setup. (4961)

XmlOrderAddressMap

Internal table storing address information for an order imported through the Atlas SUDS Order Upload process. (4961)

XmlXtraStopDeleteMap

Internal table storing deleted Extra Stops information for an order imported through the Atlas SUDS Order Upload process. (4961)

XmlXtraStopMap

Internal table storing Extra Stops information for an order imported through the Atlas SUDS Order Upload process. (4961)

 

View MoversSuite Database Tables (2018R23)