Listed in the table below are the database changes made at this version MoversSuite.
|
Table |
Field |
Description |
|
InvoicedHeader |
GeneratingID |
New field (uniqueidentifier) needed to identify an invoice in process of being generated, providing the ability to prevent multiple users from access the same invoice prior to it being generated. (5945) |
|
LocServ |
VoidedBy |
New field (int) linking this table to the Sysuser table to identify the person that voided a Work Ticket associated to a particular service. (7644) |
|
VoidedOn |
New field (datetime) storing the date and time that the Work Ticket associated to a service was voided. (7644) | |
|
MilitaryOrder |
OrderAuditInfoFID |
New field (bigint) linking this table to the OrderAuditInfo table (and indirectly to the OrderHistory table) as part of the Order History project. (7638) |
|
OrderAddress |
OrderAuditInfoFID |
New field (bigint) linking this table to the OrderAuditInfo table (and indirectly to the OrderHistory table) as part of the Order History project. (7638) |
|
OrderAuditInfo |
New table storing the user identifier and the source of an Order History change. (7638) | |
|
OrderHistory |
New table storing the changes made to an order and documented through Order History. (7638) | |
|
OrderHistoryField |
New table storing the changes made to a particular field on an order and documented within the Order History. This table links back to the OrderHistory table. (7638) | |
|
OrderHistoryFieldType |
New table providing the field type description needed to support the OrderHistoryField table. (7638) | |
|
Orders |
OrderAuditInfoFID |
New field (bigint) linking this table to the OrderAuditInfo table (and indirectly to the OrderHistory table) as part of the Order History project. (7638) |
|
QuoteRevenueImport |
BillingMinorItemFID |
Changed this field to no longer be required, since we now allow the quote to link to a revenue group as well. (7643) |
|
SysuserSetting |
New table storing the file name and location of the last document stored within the Document Management Viewer. (7645) | |
|
TaskPriority |
New administrative table storing the priority value and description assigned to a Tasks to-do item. Access this new feature through the Tasks Setup. (7646) | |
|
Tasks |
TaskPriorityFID |
New field (int) linking a Tasks item on an order to the table. (7646) |
|
ToDo |
TaskPriorityFID |
New field (int) linking a Tasks Setup item on an order to the table. This setting represents the default value assigned to a Tasks to-do item. (7646) |