Schema Changes Version 2026.03

 

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

 

NOTE:

All changes are to support multiple accounting systems in MoversSuite (except where noted).

 

Table

Change

AccountingAccount

Added AccountingAccountTypeId.

AccountingAccountType

New table.

AccountingBankAccount

AccountingCustomer

Added AccountingCustomerCreditLimitTypeFid.

AccountingCustomerCreditLimitType

New table.

AcctTransactions

Added FullyAppliedTo as a flag to indicate when the transaction is fully applied.

AcctTransactionsApplyToInfo

BATProcess

Added RequestGroupIdentifier and AccountingBankAccountFID.

CommStmtDetail

Added AcctTransactionFid.

ErrorCodeStatistics

Renamed StartDate to be two new columns: FirstError and LastError.

GL00100

New table.

GL00105

GPCustomer

Added AccountingCustomerCreditLimitTypeFid.

GPWarehouse

Added AcctTransactionFid.

GPWarehouseStatus

Added the following:

LastStartTime

LastEndTime

LastExecRunTimeMilliSeconds

LastInvokedBy

MssWebSection

New table.

MssWebSectionPreference

PMPostingAccounts

Added AccountingAccountTypeId.

StatementChargeBack

StatementGLAllocation

StatementHeader

Added AccountingBankAccountFID.

XLedgerAccountingPeriodRange

New table.

XLedgerApplyToJournalDetail

XLedgerApplyToJournalDetailMap

XLedgerApplyToUploadInfo

XLedgerBankAccount

XLedgerJournalEntryBatch

Added RetryOfXLedgerJournalEntryBatchFid.

XLedgerJournalEntryBatchItem

Added the following:

XLedgerTransactionUploadFailureFid

Resolved

XLedgerBankAccountFid

ExternalIdentifier

PlaceOnHold

XLedgerSyncHistory

Added Bypass.

XLedgerTransactionHeader

Added the following:

ArApMatchIdentifier

ArApExternalIdentifier

SubledgerTransactionXLedgerDbId

XLedgerTransactionHoldStatusFid

XLedgerTransactionHoldStatus

New table.

XLedgerTransactionHoldSubmission

XLedgerTransactionUploadFailureMap

Table removed.

XLedgerTransactionUploadFailureSysUserMap

New table.

 

Tables Listing

Documents Table Listing

Data Views Listing