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)