Schema Changes Version 2017R07

 

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

 

Table

Change

InternationalBOLConsignee

Added Name. Stores the value entered for the Contact field within the Bill of Lading Consignee screen (up to 65 characters). (8763)

Added Email. Stores the value entered for the Email field within the Bill of Lading Consignee screen (up to 120 characters). (8763)

InternationalContainer

Added SealNumber2. Stores the value entered for the Seal Number2 field within the Add Container screen (up to 32 characters). (8734)

Added InternationalContainerSizeTypeFID. Stores the value selected within the Size field within the Add Container screen. This field references data set within the Container Size Setup. (8733, 8734)

Added AutoInContainer. New flag storing the setting made for Auto in Container found within the Add Container screen. (8734)

InternationalContainerSizeType

New administrative table storing the values defined within Container Size Setup. (8733)

InternationalShippingDate

Added PortSailingCutoffEstimateDate. Stores the date entered for the Port of Sailing Cut-Off field (Estimated) within the Shipping Information tab. (8723)

Added PortSailingCutoffActualDate. Stores the date entered for the Port of Sailing Cut-Off field (Actual) within the Shipping Information tab. (8723)

Added InlandDepartureCutoffEsimatedDate. Stores the date entered for the Inland Departure Cut-Off field (Estimated) within the Shipping Information tab. (8723)

Added InlandDepartureCutoffActualDate. Stores the date entered for the Inland Departure Cut-Off field (Actual) within the Shipping Information tab. (8723)

Added InlandDepartureEsimatedDate. Stores the date entered for the Inland Departure Date field (Estimated) within the Shipping Information tab. (8723)

Added InlandDepartureAcutalDate. Stores the date entered for the Inland Departure Date field (Actual) within the Shipping Information tab. (8723)

Added InlandArrivalEsimatedDate. Stores the date entered for the Inland Arrival Date field (Estimated) within the Shipping Information tab. (8723)

Added InlandArrivalActualDate. Stores the date entered for the Inland Arrival Date field (Actual) within the Shipping Information tab. (8723)

Added DeliveryPermStgEstimatedDate. Stores the date entered for the Delivery to Perm Storage field (Estimated) within the Shipping Information tab. (8723)

Added DeliveryPermStgActualDate. Stores the date entered for the Delivery to Perm Storage field (Actual) within the Shipping Information tab. (8723)

InternationalShippingInformation

Added InlandDeparturePortFID. Stores the value selected for the Inland Port of Departure setting within the Shipping Information tab. This field links to values defined within the Port Setup. (8723)

Added InlandArrivalPortFID. Stores the value selected for the Inland Port of Arrival setting within the Shipping Information tab. This field links to values defined within the Port Setup. (8723)

Added SecurityFilingConfirmation. Stores the value entered for the Security Filing Confirmation field within the Shipping Information tab (up to 32 characters). (8723)

ServiceDetail

New administrative table storing the details defined within Service Group Setup. (8338)

ServiceDetailOrderMap

New table linking an Office & Industrial order to one or more records set within Service Group Setup. This mapping table documents the value set for the order within the Scope of Work section within the Job Information tab. (8338)

ServiceGroup

New administrative table storing the groups defined within Service Group Setup. (8338)

SITContact

New table storing the contact or contacts selected for the Contacts at Storage Facility setting within the SIT Information section of the SIT/Recurring Billing tab. Contacts are assignable from those available to the agent or carrier selected within the Stored at field. (8685)

SITInformation

Added SITNumbRequestedDate. Stores the date and time entered for the SIT # Requested field within the SIT Information section of the SIT/Recurring Billing tab. (8685)

Added SITNumbReturnedDate. Stores the date and time entered for the SIT # Returned field within the SIT Information section of the SIT/Recurring Billing tab. (8685)

Added SITNumbToAgentDate. Stores the date and time entered for the SIT # Returned field within the SIT Information section of the SIT/Recurring Billing tab. (8685)

Added DPSArrivalDate. Stores the date and time entered for the DPS Arrival field within the SIT Information section of the SIT/Recurring Billing tab. (8685)

Added ArrivalDate. Stores the date and time entered for the Date of Arrival field within the SIT Information section of the SIT/Recurring Billing tab (available only for Destination). (8685)

Added Overflow. Stores the setting made for the Overflow flag within the SIT Information section of the SIT/Recurring Billing tab (available only for Destination). (8685)

Added DANotificationDate. Stores the date and time for the DA Notification field within the SIT Information section of the SIT/Recurring Billing tab (available only for Destination). (8685)

Added TCNotificationDate. Stores the date and time for the TC Notification field within the SIT Information section of the SIT/Recurring Billing tab (available only for Destination). (8685)

XmlInternationalContainerSizeTypeMap

New administrative table storing the External Code and Interface values assigned to a Container Size Setup record. (8733)

 

View MoversSuite Database Tables (2017R07)