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