Schema Changes Version 5.21

 

Listed in the table below are the database changes made at this version MoversSuite.

 

Table

Field

Description

Orders

SurveyStartTime

Stores the start time of the survey set through the Agents tab. (7195)

SurveyEndTime

Stores the end time of the survey set through the Agents tab. (7195)

VanLine

ClaimsCustomerNumber

The identifier associated to a customer as part of a claims statement import displays. (7296)

XmlImportError

OrderFID

Links this table to an order record (Orders.PriKey). (7195)

XmlImportHistoryFID

Links this table to an XmlImportHistory table. (7195)

XmlImportHistory

This table stores error information including the complete XML data from a failed import. The table links to a specific order (OrderFID) and interface (XmlInterfaceID). The data in this table is visible through Third Party Application Error Management. (7195)

XmlImportReprocessHistory

Stored in this table is information on reprocessing attempts made to an import through the Reprocess function in Third Party Application Error Management. The information in this table links back to the XmlImportHistory table, where more data on the imported file is available. (7195)