Schema Changes Version 5.04

 

Listed in the table below are the database changes made this MoversSuite.

 

Table

Field

Description

AccountProfiles

BillToContact

Increased field size from 30 to 61 characters to accommodate larger vendor data. (6334)

AcctTransactions

Driver

Increase field size from 42 to 43 characters to avoid truncation errors in transaction processing. The established maximum represents the maximum FirstName plus LastName from Sysuser. (6786)

SalesPerson

Increase field size from 42 to 43 characters to avoid truncation errors in transaction processing. The established maximum represents the maximum FirstName plus LastName from Sysuser. (6786)

BATProcess

Driver

Increase field size from 42 to 43 characters to avoid truncation errors in transaction processing. The established maximum represents the maximum FirstName plus LastName from Sysuser. (6786)

SalesPerson

Increase field size from 42 to 43 characters to avoid truncation errors in transaction processing. The established maximum represents the maximum FirstName plus LastName from Sysuser. (6786)

StatementDetail

CRPrinted

New field capturing the printing status of a Cash Receipt statement item. This flag is set when the receipt has been printed and can no longer be edited. (6713)

StatementPayable

DocumentNumber

New field as part of the project to display and apply credits to payables generated in Microsoft Dynamics GP. (5194)

ApplyAmount

New field as part of the project to display and apply credits to payables generated in Microsoft Dynamics GP. (5194)

GPFlag

New field as part of the project to display and apply credits to payables generated in Microsoft Dynamics GP. (5194)

StatementDetailDistInvoice

 

New table linking an invoice record to a customer and order associated to a Cash Receipt. (6709)

 

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