Schema Changes Version 5.24

 

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

 

Table

Field

Description

OrderNoteDetail

TempID

New field storing the temporary identifier for an upload/download record. (7495)

OrderNoteHeader

TempID

New field storing the temporary identifier for an upload/download record. (7495)

ThirdParty

OriginalInvoiceNumber

When an adjustment or reversal is made to a third party item, MoversSuite creates an unique invoice number for the item and store the original invoice number associated to the transaction within this field (varchar(30). (7358)

OrderNoteDetailExternalMap

New table linking an upload/download record to an order note records. (7495)

ThirdPartyInvoiceSequence

This is a new table storing the unique sequence number for an adjustment/reversal to a third party item. This table also links the unique invoice number to an order. (7358)

XmlOrderPhoneTypeMap

New table storing the phone types connecting a shipper phone type to an external interface through the interface mappings within Shipper Phone Type Setup. (7495)