Table

Change

AdpExportLog

New table storing information on exports through the ADP Integration. (MOV-6455).

ItemCode

Removed VLItemCode since there are new mappings to each interface (van line) available with the new SIRVA Agent Statement Import feature. (MOV-6355).

ItemCodeVanlineMapping

New table storing the mapping records created for each Item Code through the Add Van Line Service Code to Item Code Mapping dialog. This table was added as part of the SIRVA Agent Statement Import feature. (MOV-6355).

OrderStatus

Added HideFromMssWebOrderList to capture what is set for the “Hide orders with this status from MSWeb orders listing?” flag within Order Status Setup. This flag was added as part of the improvements made to MSWeb. (MOV-6370)

PMImportDetailDist

Removed ServiceCodeFID since this value is now identified through the VanlineStatementDetailDist table. This field was removed as part of the SIRVA Agent Statement Import feature. (MOV-6355).

PMImportHeader

Added VanlineGroupExternalCode to capture the External Code set through the Van Line Group Setup that identifies the particular sender of the statement. This field was added as part of the SIRVA Agent Statement Import feature. (MOV-6355).

RevenueImportType

Added VanlineGroupExternalCode to record the group name associated to a record through the Van Line Group Setup. This setting identifies the particular sending group associated to the statement. This field was added as part of the SIRVA Agent Statement Import feature. (MOV-6355).

SysUser

Added XmlSystemTimeclockFid to link crew to a XmlSystemTimeclock record for managing their MSCrew punch activity for payroll processing. This table change was added as part of the ADP Integration. (MOV-6455).

VanlineGroup

New table storing the records managed through the Van Line Group Setup. This table was added as part of the SIRVA Agent Statement Import feature. (MOV-6355).

VanlineStatementDetail

New table storing the details of statement imported from a van line through Cloud Statements in Payment Management. This table was added as part of the SIRVA Agent Statement Import feature. (MOV-6355).

VanlineStatementDetailDist

New table storing the details of the distributions associated to a statement imported from a van line through Cloud Statements in Payment Management. This table was added as part of the SIRVA Agent Statement Import feature. (MOV-6355).

VanlineStatementDownloadLog

New table storing the download information associated to a statement imported from a van line through Cloud Statements in Payment Management. This table was added as part of the SIRVA Agent Statement Import feature. (MOV-6355).

VanlineStatementHeader

New table storing the header details of a statement imported from a van line through Cloud Statements in Payment Management. This table was added as part of the SIRVA Agent Statement Import feature. (MOV-6355).

VanlineStatementImport

New table storing the import details of a statement imported from a van line through Cloud Statements in Payment Management. This table was added as part of the SIRVA Agent Statement Import feature. (MOV-6355).

VanLineStatements

Increased the size of the Description field to 64 characters (from 16 characters) to allow for more data.

Added AccountingServiceCodeFID to identify the Service Code associated to accounting transaction processing for a statement. This identifier references entries defined within the Service Code (Accounting) Setup.

These changes were made as part of the SIRVA Agent Statement Import feature. (MOV-6355).

VanlineStatementStageDetail

New tables storing the details imported for a statement through Cloud Statements in Payment Management. These are temporary tables referenced when sending and receiving cloud data for statement import. These tables were added as part of the SIRVA Agent Statement Import feature. (MOV-6355).

VanlineStatementStageDetailDist

VanlineStatementStageErrorLog

VanlineStatementStageHeader

XmlSystemTimeclock

New table storing punch information on crew that is sent to an external data processor, such as ADP. (MOV-6455).