Last updated: 2025-06-09

Report tags for route optimisation and Home delivery

The following tags can be used in reports to show route optimisation information, such as the estimated delivery time in SMS notifications. The ETA has different tags depending on whether it comes from the manual or continuous optimisation:

  • Estimated: Times from manual route optimisations, i.e. when you have clicked on Arvutage sõidujärjekord in the route optimisation window.

  • AutomaticEstimated: Times from the continuous route optimisation. The times are updated continuously, but the notification is not sent out every time the ETA is updated. For more information, see Automatic route optimisation.

    For example, if you have notification subscriptions that are sent out when an order gets the status Korjatud and the ETA is updated at a later stage, because something else on the order is updated, no new notification is sent out (because the status is not updated to Korjatud). Include a link to Track & Trace in the notification and the recipient can follow all ETA updates there. For more information, see Notifications with links to Track & Trace.

  • Rounded: If you round off the ETA in , you must use the tags starting with Rounded in the table below. The rounded time is not shown anywhere in the Opter interface, but is only visible in the notifications. For more information, see Kojuveo seaded (window).

Tags

Tag

Returns

EstimatedPickupTime

AutomaticEstimatedPickupTime

Date and time of collection. Displayed in the format “YYYY-MM-DD hh:mm:ss”.

Example: "2025-06-29 14:57:23".

EstimatedPickupTime = the column Hinnanguline korje aeg in the dispatch of the first shipment on the order.

AutomaticEstimatedPickupTime = the column Hinnanguline korje aeg (automaatselt reguleeritud) in the dispatch of the first shipment on the order.

EstimatedDeliveryTime

AutomaticEstimatedDeliveryTime

Date and time of delivery. Displayed in the format “YYYY-MM-DD hh:mm:ss”.

Example: "2025-06-29 14:57:23".

EstimatedDeliveryTime = column Hinnanguline tarneaeg in the dispatch of the last shipment on the order.

AutomaticEstimatedDeliveryTime = column Hinnanguline tarneaeg (kohandatud automaatselt) in the dispatch of the last shipment on the order.

RoundedEstimatedPickupTimeString

RoundedAutomaticEstimatedPickupTimeString

Rounded time for collection. Displayed in the format "Today hh:mm" or "YYYY-MM-DD hh:mm", if the collection date is later than today.

Example: "Today 15:00".

RoundedEstimatedDeliveryTimeString

RoundedAutomaticEstimatedDeliveryTimeString

 

Rounded time for delivery. Displayed in the format "Today hh:mm" or "YYYY-MM-DD hh:mm", if the delivery date is later than today.

Example: "2025-06-29 15:00".

RoundedEstimatedPickupTimeOrTimeWindowString

RoundedAutomaticEstimatedPickupTimeOrTimeWindowString

 

Rounded time for collection.

If no route optimisation has been performed, the time window from the Order reception is displayed, which consists of the fields Aeg/Kuupäev /Aeg/Kuupäev under Saatja.

Displayed in the format "Today hh:mm - hh:mm" or "YYYY-MM-DD hh:mm - hh:mm", if the collection date is later than today.

Example: "Today 15:00 - 15:30".

RoundedEstimatedDeliveryTimeOrTimeWindowString

RoundedAutomaticEstimatedDeliveryTimeOrTimeWindowString

Rounded time for delivery.

If no route optimisation has been performed, the time window from the Order reception is displayed, which consists of the fields Aeg/Kuupäev /Aeg/Kuupäev under Saaja.

Displayed in the format “Today hh:mm - hh:mm” or “YYYY-MM-DD hh:mm - hh:mm”.

Example: "2025-06-29 15:00 - 15:30".

Shipments.SHI_EstimatedPickupTime

Shipments.SHI_AutomaticEstimatedPickupTime

Lists the pick-up time for all shipments on the order. Displayed in the format “YYYY-MM-DD hh:mm:ss”.

Example: "2025-06-29 14:57:23".

Shipments.SHI_EstimatedPickupTime = Hinnanguline korje aeg column in the dispatch.

Shipments.SHI_AutomaticEstimatedPickupTime = Hinnanguline korje aeg (automaatselt reguleeritud) column in the dispatch.

Shipments.SHI_EstimatedDeliveryTime

Shipments.SHI_AutomaticEstimatedDeliveryTime

Lists the delivery time for all shipments on the order. Displayed in the format “YYYY-MM-DD hh:mm:ss”.

Example: "2025-06-29 14:57:23".

Shipments.SHI_EstimatedDeliveryTime = Hinnanguline tarneaeg column in the dispatch.

Shipments.SHI_AutomaticEstimatedDeliveryTime = Hinnanguline tarneaeg (kohandatud automaatselt) column in the dispatch.

Example

The following paragraph returns the estimated pickup time of the first shipment on the order, and a list of delivery times for all the shipments on the order.

Report type HTML:

<p>Beräknad upphämtningstid: @Model.EstimatedPickupTime</p>
<p>
<b>Leveranser</b><br/>
@foreach(var item in Model.Shipments.ActiveItems)
{
   <text>- @item.SHI_EstimatedDeliveryTime</text><br/>
}
</p>

Report type Tekst:

Beräknad upphämtningstid: <item name="EstimatedPickupTime"/>

Leveranser: <query command="Shipments">
- <item name="SHI_EstimatedDeliveryTime"/>
</query>

Results:

Estimated pickup time: 03.09.2024 10:22:45

Deliveries:

– 03.09.2024 10:52:05

– 03.09.2024 11:16:25

See also