Schema Changes Version 2017R08

 

The following table lists changes made to the MoversSuite database for this release.

 

Table

Change

AccountProfilePreset

Added BuildingFID. Stores a pointer to the Buildings table. This pointer links a selected Building within the Account Profile Preset section of Account Profile Setup to a Building Setup record. (8337)

BuildingAddress

New table storing the address records assocaited with a Building Setup record. (8337)

BuildingConstraingItems

New table storing the records defined within Building Constraints Setup. (8337)

Buildings

New table storing the records defined within Building Setup record. (8337)

InternationalBookingNumber

Added EquipmentReturned. New flag storing the value entered for the Equipment Returned setting within Pickup/Delivery Information. (8741)

Added LiveLoadUnLoad. New flag storing the value entered for the Live Load Unload setting within Pickup/Delivery Information. (8741)

Added InternationalBookingNumber TransitTypeFID. New field storing the selection made within the Transit Type field within Pickup/Delivery Information. Transit Type values are defined within the InternationalBookingNumberTransitTypetable (see below). (8741).

Added TransitAgentFID. If Agent is selected for the Transit Type set within Pickup/Delivery Information, then you can associate an Agent to the record. This setting stores which agent is selected from those defined within Agent Setup. (8741)

Added CarrierCode. If Linehaul Carrier is selected for the Transit Type set within Pickup/Delivery Information, then you can provide a Carrier Code (up to 32 characters). (8741)

Added TransitName. New field capturing the Name set within the Transit section within Pickup/Delivery Information (up to 64 characters). (8741)

Added TransitContact. New field capturing the Contact Name set within the Transit section within Pickup/Delivery Information (up to 64 characters). (8741)

Added TransitEmail. New field capturing the Email address set within the Transit section within Pickup/Delivery Information (up to 50 characters). (8741)

InternationalBookingNumber

LocationType

New internal table storing the values available through the Location Type setting within the Pickup or Delivery section within Pickup/Delivery Information. (8741)

InternationalBookingNumberAddress

Added Name. New field caputuring the Name of the company under the Pickup or Delivery section within Pickup/Delivery Information (up to 64 characters). (8741)

Added Email. New field caputuring the Email of the company under the Pickup or Delivery section within Pickup/Delivery Information (up to 50 characters). (8741)

Added InternationalBookingNumberTypeFID. New file storing the selected Location Type within the Pickup or Delivery section within Pickup/Delivery Information. The values available for selection within this field are defined within the internal InternationalBookingNumber LocationType table. (8741)

Added LocationCode. New field capturing the Location Code data entered within the Pickup or Delivery section within Pickup/Delivery Information (up to 32 characters). (8741)

InternationalBookingNumber

TransitType

New internal table storing the values available through the Transit Type setting within the Transit sections within Pickup/Delivery Information. (8741)

InternationalShippingDate

Added ReadyToBillDate. New field storing the Date associated to a Ready to Bill setting within Financial Information. (8750)

Added CertificateDate. New field storing the Date associated to a Certification Number setting within Financial Information. (8750)

InternationalShippingInformation

Added CostPlus. New flag storing what is set for the Cost Plus field within Financial Information. (8750)

Added ReadyToBill. New flag storing what is set for the Ready to Bill field within Financial Information. (8750)

Added ReadyToBillUploaded. New internal flag storing an indicator that the Ready to Bill data is uploaded and therefore you are not able to set the Move Manager Released to Bill field within Financial Information. (8750)

Added ReleasedToBill. New flag storing what is set for the Move Manager Released to Bill field within Financial Information. (8750)

Added TariffIndicator. New flag storing what is set for the Tariff Indicator field within Financial Information. (8750)

Added GppApplies. New flag storing what is set for the GPP Applies field within Financial Information. (8750)

Added InternationalValuation

DeclineReasonFID. New field storing the selection made within the Reason Declined field within Financial Information. The values available to this setting are defined within Valuation Declined Reason Setup. (8750)

Added CertificationNumber. New field storing the value entered for the Certification Number within Financial Information (up to 64 characters). (8750)

Added DeductibleAmount. New field storing the dollar amount for the Deductible Amount field within Financial Information. (8750)

Added InternationValueTypeFId. New field storing the selection made within the Value Type field within Financial Information. The values available to this setting are defined within Value Type Setup. (8750)

Added TotalLossCoverage. New flag storing what is set for the Total Loss Coverage field within Financial Information. (8750)

Added MechanicalMalfunction. New flag storing what is set for the Mechanical Malfunction field within Financial Information. (8750)

Added PairOrSets. New flag storing what is set for the Pairs or Sets field within Financial Information. (8750)

Added MoldOrMildew. New flag storing what is set for the Mold or Mildew field within Financial Information. (8750)

Added InsuredRate. New dollar amount of what is set for the HHGD Insured Rate within Financial Information. (8750)

Added InternalRate. New dollar amount of what is set for the HHGD Internal Rate within Financial Information. (8750)

Added BilledRate. New dollar amount of what is set for the HHGD Billed Rate within Financial Information. (8750)

InternationalValuation

DeclinedReason

New administrative table storing the values defined within the Valuation Declined Reason Setup. (8741)

InternationalValueType

New administrative table storing the values defined within the Value Type Setup. (8741)

OrderLocationBuildingConstraint

New internal table storing the setting made within the Building Constraints within the Job Information tab. (8337)

OrderLocations

Added BuildingFID. New field storing the Building selected within Add/Edit Order Location for an Office & Industrial order. Values available for this setting are defined within Building Setup. (8337)

Added CrossStreet. New field storing what is entered for Cross Street(s) information within the Building Constraints on the Job Information tab (up to 1,024 characters). (8337)

Added ServiceEntrance. New field storing what is entered for Service Entrance information within the Building Constraints on the Job Information tab (up to 1,024 characters). (8337)

Added SiteNote. New field storing what is entered for Site Notes(s) information within the Building Constraints on the Job Information tab (up to 1,024 characters). (8337)

Orders

Added AutoColor. New field storing the Color of an Automobile within the Move Information tab (up to 30 characters). (8725)

Added AutoMileage. New field storing the Mileage of an Automobile within the Move Information tab. (8725)

Added AutoCubicFeet. New field storing the Cubic Feet of an Automobile within the Move Information tab. (8725)

QuoteDetail

Added QuoteServiceProviderBillToFID. New field storing what is selected for the Bill To associated to a Service Provider on a Quote detail record. The values available to this field are stored within the QuoteServiceProviderBillTo Internal table and include Agent, National Account, and Shipper. (8752)

QuoteGroup

Added QuoteServiceProviderBillToFID. New field storing what is selected for the Bill To associated to a Service Provider on a Quote group record. The values available to this field are stored within the QuoteServiceProviderBillTo Internal table and include Agent, National Account, and Shipper. (8752)

QuoteHeader

Added VanLineLinked. If a quote is uploaded to a van line, then a phrase of “Connected” appears within the Quote tab next to the Status field. This new internal flag stores whether the record is connected (True) or not. (8754)

QuoteServiceProviderBillTo

New internal table storing the values available to assign to the Bill To option within the Service Provider section of a Quote. (8754)

SysFile

Added EnableDuplicateOrder. New flag storing the value set for the Enable Duplicate Order setting within the System Wide Options. Checking this flag disables the Create Duplicate Order functionality within MoversSuite. (8656)

UserAccess

Added DomainUserName. Internal field storing the domain user associated to a Personnel Setup record (up to 256 characters). (8638)

Added DomainUserNameS. Internal field storing the domain user S data associated to a Personnel Setup record (up to 12 characters). (8638)

Added DomainUserNameH. Internal field storing the domain user H data associated to a Personnel Setup record (up to 44 characters). (8638)

XmlAuotClassMap

New administrative mapping added to Auto Class Setup. This mapping allows you to associate an Auto Class to an External Code supported by an external interface. (8725)

XmlInternationalBookingNumber

LocationTypeMap

New internal table storing the values available to assign to the Location Type within the Pickup or Delivery section within Pickup/Delivery Information. (8741)

XmlInternationalBookingNumber

TransitTypeMap

New internal table storing the values available to assign to the Transit Type within the Transit section within Pickup/Delivery Information. (8741)

XmlInternationalConsolidatorMap

New administrative mapping added to Consolidator Setup. This mapping allows you to associate a Consolidator record to an External Code supported by an external interface. (8728)

XmlInternationalContainer

LoadTypeMap

New administrative mapping added to Container Load Type Setup. This mapping allows you to associate a Container Load Type record to an External Code supported by an external interface. (8749)

XmlInternationalCustomsAgentMap

New administrative mapping added to Customs Agent Setup. This mapping allows you to associate a Customs Agent record to an External Code supported by an external interface. (8749)

XmlInternationalValuationDecline

ReasonMap

New administrative mapping added to Valuation Declined Reason Setup. This mapping allows you to associate a Valuation Declined Reason record to an External Code supported by an external interface. (8749)

XmlInternationalValueTypeMap

New administrative mapping added to Value Type Setup. This mapping allows you to associate a Value Type record to an External Code supported by an external interface. (8749)

 

View MoversSuite Database Tables (2017R08)