Schema Changes Version 2025.07

 

The following table lists the latest changes made to the MoversSuite database.

 

Table

Change

OutgoingEmailPdfInput

New table that temporarily stores the PDF version of an email attached to an order after an email is sent. This change relates to the Send Email functionality within MSWeb (refer to MSWeb Send Email). MOV-6864.

Xgl

New table storing the transaction data for the information needed to post to accounts in Xledger. This table will be administrated through a new setup area (coming soon). This change is part of the ongoing Xledger changes.

XLedgerAuthorityTypeObjectValue

New table storing Authority Type details managed through Xledger. These details will link to the XLedgerAuthorityTypeObjectValueMap table which maps to MoversSuite Authority Setup records. These mappings will be managed through a new setup area (coming soon). This change is part of the ongoing Xledger changes.

XLedgerAuthorityTypeObjectValueMap

New table storing mappings between MoversSuite Authority Setup records and Authority Types managed through Xledger. These mappings will be managed through a new setup area (coming soon). This change is part of the ongoing Xledger changes.

XLedgerBranchObjectValue

New table storing the defined mapping of an Xleger company to branch records. These mappings will be defined within a new setup are (coming soon). This table also stores the identifier the branch within Xledger. This change is part of the development for the Xledger Integration.

XLedgerCommodityTypeObjectValue

New table storing Commodity Type details managed through Xledger. These details will link to the XLedgerCommodityTypeObjectValueMap table which maps to MoversSuite Commodity Setup records. These mappings will be managed through a new setup area (coming soon). This change is part of the ongoing Xledger changes.

XLedgerCommodityTypeObjectValueMap

New table storing mappings between MoversSuite Commodity Setup records and Commodity Types managed through Xledger. These mappings will be managed through a new setup area (coming soon). This change is part of the ongoing Xledger changes.

XLedgerExpenseType

New table storing the supported expense types for transactions posted to Xledger. These types include the following:

Claims

Contractor

MovingEmployee

None

OwnerOperator

Sales

ThirdParty

The Expense Type will link to supported accounts in Xledger through a new mapping setup area (coming soon). This change is part of the ongoing Xledger changes.

XLedgerMoveTypeObjectValue

New table storing Move Type details managed through Xledger. These details will link to the XLedgerMoveTypeObjectValueMap table which maps to MoversSuite Move Type Setup records. These mappings will be managed through a new setup area (coming soon). This change is part of the ongoing Xledger changes.

XLedgerMoveTypeObjectValueMap

New table storing mappings between MoversSuite Move Type Setup records and Move Types managed through Xledger. These mappings will be managed through a new setup area (coming soon). This change is part of the ongoing Xledger changes.

XLedgerCompanyBranchMap

Table removed. This recently added table has been replaced other tables in this listing that provide additional table connections. This change is part of the ongoing Xledger changes.

 

MOVERSSUITE DATABASE SCHEMA RESOURCES:

Tables Listing

Documents Table Listing

Data Views Listing