Schema Changes Version 5.22

 

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

 

Table

Field

Description

AcctTransactions

VendorInvoiceNumber

Field size increased to 48 characters (from 21) to accommodate displaying the order number followed by “/” and the invoice sequence number. (7347)

BATProcess

VendorInvoiceNumber

Field size increased to 48 characters (from 21) to accommodate displaying the order number followed by “/” and the invoice sequence number. (7347)

Branch

 

DefaultDriveTime

New field to store the default setting for the local service drive time, managed through Branch Setup. (7434)

ContainerizationStatus

New table storing the values defined within Containerization Status Setup. (7435)

LocServ

ContainerizationStatusFID

New field linking a local service record to a default container status as managed through Containerization Status Setup. (7435)

OrderStatus

ClearMoveDates

New field storing the option set for an Order Status Setup record allowing for a company to clear move dates when the order status changes. (7438)

ServType

ContainerizationEligibleFlag

New flag storing the administrative setting for the Containerization Eligible flag within Local Service Type Setup. (7435)

SITInformation

Weight

Stores the value of the SIT Weight field (Origin/Destination) within the SIT/Recurring Billing tab. (7459, 7462)

SITJointInfo

New table storing the SIT Discount set for an order through the SIT/Recurring Billing tab. (7459, 7077)