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).