Schema Changes Version 5.01

 

Listed in the table below are the database changes made at Version 5.01 of MoversSuite.

 

Table

Field

Description

BATProcess

TempForeignID

New field storing the vendor identifier for the driver associated to a statement import when the Always Associate Driver flag is set (6474).

BATProcessApplyToInfo

ApplyToBATProcessID

New field storing the identifier linked to the BAT process associated to an Apply To transaction (4881).

PaymentCode

PaymentCode

Field replaced by the Description field in this same table. A company can define its own Payment Code values up to 26-characters (6315)

StatementDocument

BranchFID

New field to record the branch set on a statement document.

 

SDWPriKey

Removed pointer to the now obsolete StatementServiceCode table (6315).

SysFile

PaymentCodeFID

Added pointer to the appropriate Payment Code identifying the payment code set on an import where this record corresponds to the driver referenced on a statement import (6474).

XmlPaymentCodeMap

AlwaysAttachDriver

New administrative field instructing MoversSuite to reference the driver from statement imports for the corresponding Payment Code. This field is set through the Always Attach Driver flag in Statement Payment Code Setup (6474).

StatementInvoice

 

Table deleted. Functionality moved to the BATProcess and StatementDocument tables (4881).

StatementServiceCode

 

Table deleted. Functionality moved to the BATProcess and StatementDocument tables (4881).

VanLineCodes

 

Table deleted. Functionality moved to the BATProcess and StatementDocument tables (4881).

ReportGroup

 

New administrative table that allows a system to group reports into groups displaying in the Reports menu in MoversSuite (6413). See Report Group Setup for details.

ReportGroupMap

 

New table storing the links between Reports and Report Groups (6413). This link is created through Report Profile Setup definitions.

 

Click here for a graphical interpretation of the MoversSuite database schema (5.01).