Schema Changes Version 2017R06

 

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

 

Table

Change

Agent

Added HaulOwnAuthority. New administrative flag indicating whether the agent can haul under Own Authority (flag set) or not. This flag corresponds to the Haul Own Authority flag within Agent Setup.  (8682)

Added HaulVanLineAuthority. New administrative flag indicating whether the agent can haul under Van Line Authority (flag set) or not. This flag corresponds to the Haul Van Line Authority flag within Agent Setup. (8682). 

AgentMarket

New administrative table storing the Agent Market Items set on an Agent Setup. (8682)

HaulAs

Added IsOwnAuthority. New administrative flag indicating whether the agent is under Own Authority (flag set) or not. This flag corresponds to the Own Authority flag within Haul As Setup (8684). 

Added IsVanLineAuthority. New administrative flag indicating whether the agent is under Van Line Authority (flag set) or not. This flag corresponds to the Van Line Authority flag within Haul As Setup (8684). 

InternationalBillToType

New table storing the values available to assign to the Bill International To setting within the Billing Information tab. Currently this table stores two, hard-coded values (Agent, National Account). (8706)

InternationalRegion

New table storing the Region Description and primary identifier for Region Setup records. You can assign coordinators for availability within in a particular region for use by an UniGroup upload. (8709)

InternationalServiceType

New administrative table storing the primary key and description for Service Type Setup (International Orders) records. (8708)

InternationalShippingInformation

Added InternationalBillToTypeFID. Field to store the value set for the Bill International To setting within the Billing Information tab on an International Orders record. The values available to this setting link to the table and include Agent and National Account. (8706)

Added BillToAgentFID. Field to store the value set for the Bill To Agent setting within the Billing Information tab on an International Orders record. The values available to this setting link to the Agent Setup table. (8706)

Added ForwardingAgentFID. New field storing the value set for the Forwarding Agent set on the Shipping Information tab. The values available to this setting link to the Agent Setup table. (8707)

Added InternationalServiceTypeFID. New field storing the value set for the Service Type set on the Shipping Information tab. The values available to this setting are defined within the Service Type Setup (International Orders).(8708)

Market

New administrative table storing the settings established through Agent Market Setup. (8683)

Orders

Added BookingMarketFID. Stores the value assigned to an order for the Market set on the Booking Agent within the Agents tab. The values available to this field are defined in Agent Market Setup. Note: To be available for assignment, the Agent Market Setup records within must also link to the Agent Setup record. (8683)

Added OriginMarketFID. Stores the value assigned to an order for the Market set on the Origin Agent within the Agents tab. The values available to this field are defined in Agent Market Setup. Note: To be available for assignment, the Agent Market Setup records within must also link to the Agent Setup record. (8683)

Added DestinationMarketFID. Stores the value assigned to an order for the Market set on the Destination Agent within the Agents tab. The values available to this field are defined in Agent Market Setup. Note: To be available for assignment, the Agent Market Setup records within must also link to the Agent Setup record. (8683)

XmlInternationalDirectionMap

New administrative table storing the Interface Item set for a direction record through Direction Setup. This setting maps the direction to a supported external code for data exchange and verification with UniGroup. (8709)

XmlInternationalRegionCoorMap

New administrative table storing the Interface Item set for a Direction record through Direction Setup. This setting maps a direction to a supported external code for data exchange and verification with UniGroup. (8709)

XmlInternationalRegionMap

New administrative table storing the Employee Item set for a Region record through Region Setup. This setting maps a region to a supported external code for data exchange and verification with UniGroup. (8709)

XmlInternationalServiceTypeMap

New administrative table storing the Interface Item set for a Service Type record through the Service Type Setup (International Orders). This setting maps a type to a supported external code for data exchange and verification with UniGroup. (8709)

XmlInternationalTransportationModeMap

New administrative table storing the Interface Item set for a Transportation Mode record through Transportation Mode Setup. This setting maps a mode to a supported external code for data exchange and verification with UniGroup. (8709)

 

View MoversSuite Database Tables (2017R06)