Stop Confirmation Reversal can be used to reverse the confirmation for the most recently confirmed pickup stop.
Establish eligibility to perform the operation
The Stop Confirmation Reversal operation will be disallowed if any of the following requirements cannot be satisfied:
Stop Itinerary Sequence: The operation can only be performed for the last pick-up stop on the load's itinerary where Stop Confirmation has been previously performed.
Load Financial Status: The Financial Status for the corresponding load must be Ineligible or Voucher Pending.
Load Operational Status: The Operational Status for the corresponding load must not be Completed.
Shipment Financial Status: Financial Status for the shipment corresponding to each of the legs on the load must be either Ineligible or Eligible.
Trip Itinerary Sequence: If the load is attached to a trip, you can only perform Stop Confirmation Reversal for the last confirmed stop on the last load on the trip to have started or moved through the load confirmation process. If another load attached to the same trip is in Confirming status, or higher, you cannot perform Stop Confirmation Reversal if the other load has a higher Trip Sequence Number.
Trigger updates
The following updates will be performed, as required, when Stop Confirmation Reversal is triggered for a specific pick-up stop for a load. This will reverse confirmation for the designated pick-up stop only.
The user will have the option of triggering the Load Confirmation Reversal process for the entire load, or for only the most recently confirmed pick-up stop, using Stop Confirmation Reversal. If the load has only one pick-up stop, or confirmation has only been performed for the first pick-up stop at the time Stop Confirmation Reversal is requested, the updates that would be triggered would be identical to those described in "Load Confirmation Reversal". However, if confirmation is required for a stop other than the first pick-up stop for the load, the updates that will be triggered will be a subset of those performed when the entire load confirmation is reversed.
Load
The following columns in the load table will be impacted:
Operational Status: If the first pickup stop on the load is being reversed:
The Operational Status of the load will revert to Tender Accepted.
A row in the A/P operational transition table will be recorded to provide a permanent audit trail.
The Carrier ID associated with the load prior to reversal will be recorded in the A/P operational transition table.
The status for the tender request will revert to Tender Accepted.
Financial Status: If the Financial Status is not already Ineligible, it must be changed to that status.
Continuous Moves Eligibility: If necessary, the Continuous Moves Eligibility flag in the load header will be reset based on the value defined for the carrier currently assigned to the load.
Shipped Date / Time: If the first pickup stop on the load is being reversed, the Shipped Date / Time for the load will be cleared.
MBOL: If the first pickup stop on the load is being reversed, the MBOL number that was assigned to the load during confirmation will be cleared. If BOL numbers have been assigned to individual shipment legs, these will also be cleared. The corresponding rows will also be cleared from the Reference Numbers table.
Event Notification
If enabled, the Event Notification message LoadConfirmationReversal will be generated if the load had previously been confirmed.
Archived Reference Numbers
If Bill of Lading Numbers have been assigned for any of the shipment legs to be picked-up at the stop being reversed and the Archive Deleted flag is enabled for the corresponding reference number qualifier, a row will be created in the archived reference numbers table to capture each BOL before it is cleared.
Stop
The following columns in the stop table will be impacted for the row for the load with the highest Stop Sequence Number where the Confirmed Flag is True. Updates will be triggered for the identified stop entry only.
Confirmed: The Boolean flag that designates whether confirmation has been performed will be set to False.
Confirmed Date/Time: The Confirmed Date/Time will be cleared.
Trip
If the load is attached to a trip, the following columns in the trip table might be impacted:
Operational Status: The Operational Status of the Trip will be returned to Open. This is only necessary if the reversal is performed for the final pick stop on the final load on the trip; otherwise, the trip will already be in Open status. If the status does need to be modified, an row will be created in the A/P operational transition table to provide a permanent audit trail.
Financial Status: If the Financial Status is not already Ineligible, it will be changed to that status.
Continuous Moves Eligibility: If necessary, the Continuous Moves Eligibility flag in the trip header will be reset based on the value defined for the carrier currently assigned to the trip.
Trip Initiation Date / Time: If confirmation is being reversed for the first stop on the first load in the trip's itinerary (the load with the lowest Trip Sequence Number), the Trip Initiation Date/Time for the trip will be cleared. This date/time duplicates the Shipped Date/Time for the first load in the trip's itinerary.
Shipment
The following columns in the shipment table will be impacted for the shipment where the legs to be picked-up at the stop where confirmation is being reversed:
Financial Status: The Financial Status for the shipments corresponding to each of the shipment legs loaded at the identified stop must be set back to Ineligible. If other legs for these shipments have not yet gone through the confirmation process, the shipments will already be in the required status.
Number of Times Confirmed Counter: The counter in the shipment table which records the number of legs for the shipment that have moved through the confirmation process will be reduced by one for the shipments corresponding to each of the shipment legs loaded at the identified stop.
Operational Status: If the Number of Times Confirmed counter in the shipment table is reduced to zero the Shipment operational status will be reversed back to Processed.
Shipment Leg
The following column in the shipment leg table will be impacted for the shipment legs to be picked-up at the stop where confirmation is being reversed:
Operational Status: The Operational Status for each shipment leg loaded at the stop being reversed will be moved back to Processed. A row in the A/P operational transition table will be recorded to provide a permanent audit trail.
Proactive Monitoring Alerts
The Load Confirmation Reversal monitoring situation will be generated, if enabled. This will be used to reinstate Alerts for Pick-up Overdue and cancel Alerts for Late Pick-Up violation for the pick-up stop on the load where confirmation is being reversed. The Monitoring Situation can also be used to trigger user-enabled Notification Alerts.