Skip to main content
Deutsch (Deutschland) Français (France) Italiano Polski

Search

search shadow

Articles in this section

See more

Shipment Filter Types

Rich Hellinga
Rich Hellinga
Updated

In this article

The following types of criteria in the Filters panel can be used to sort the Shipments List.

Activity Filters

There are three Activity Filters: Milestones, Current State, and Connectivity.

(For information on how the filter logic works together with all of the activities refer to Shipment Filter Logic and Interaction Patterns.)

Milestones

The Milestones filter queries against the event list of each shipment. The event list contains all events for a shipment and each event contains contains three key attributes: event type, timestamps (estimated, actual, and planned), and locations. By combining these attributes via filtering, users can query for shipments that are hitting key milestones. For example:

  • I care about shipments that are departing this week from China.

  • I care about shipments that are estimated to arrive tomorrow in the Port of LA.

  • I care about shipments that are 5 days late to discharge at the Port of Memphis

Select an Event type.

  • Events: Any specific event that occurs around a shipment. The drop-down list provides the following choices.

    • Arrival

    • Departure

    • Load

    • Load onto Vehicle

    • Unload from Vehicle

    • Manifest

    • Delivery

    • Discharge

    • Available

    • Dispatch

    • Picked Up

    • Out for Delivery

    • Flight Booked

    • Consignee Notified

    • Received from Shipper

    • Returned to Sender

    • Gate in Empty

    • Gate in Full

    • Gate out Empty

    • Gate out Full

    • Last Free Day: Only the Planned Time condition applies. This isn't provided by default from Ocean carriers; it must come from terminal visibility or the customer must provide it. 

Once an Event type is selected, you can apply timing and location criteria.

  • Timing Criteria: Users may indicate the timing of an event via specified time parameters for Minutes, Hours, Days, Weeks, or Months.

    Note

    The time zones used in Movement are based on the user time zone. When using the static filter capabilities ("between" criteria), the selected dates are applied to the user’s time zone, not the time zone where the selected event takes place. This could potentially provide results that do not match with someone in a separate time zone than you. project44 recommends using the relative date capabilities when sharing timing criteria across time zones since that will give you the most similar results returned.

    • Estimated Time conditions:

      • Between: A specified date range. Opens a calendar selector. Selected date range goes from 12:00 AM on the start date to 11:59 PM on the end date.

      • Is in the Next: A relative range. Opens a threshold input with minutes, hours, days, weeks, or months parameters. Selected date range goes from current date + selected threshold.

      • Is in the Last: A relative range. Opens a threshold input with minutes, hours, days, weeks, or months parameters. Selected date range goes from current date - selected threshold

      • Is Late by: A comparison between the Actual time and Planned Time of the event. Opens a threshold input with minutes, hours, days, weeks, or months parameters. Selected threshold returns shipments where the selected event was late by the selected threshold or more. For example, if I select Is Late By 5 days, shipments that were 5 or more days late are returned.

      • Is Early by: A comparison between the Actual time and Planned Time of the event. Opens a threshold input with minutes, hours, days, weeks, or months parameters. Selected threshold returns shipments where the selected event was early by the selected threshold or more. For example, if I select Is Early by 5 days, shipments that were 5 or more days early are returned.

    • Actual time conditions:

      • Between: A specified date range. Opens a calendar selector. Selected date range goes from 12:00 AM on the start date to 11:59 PM on the end date.

      • Is in the Next: A relative range. Opens a threshold input with minutes, hours, days, weeks, or months parameters. Selected date range goes from current date + selected threshold.

      • Is in the Last: A relative range. Opens a threshold input with minutes, hours, days, weeks, or months parameters. Selected date range goes from current date - selected threshold

      • Is Late by: A comparison between the Actual time and Planned Time of the event. Opens a threshold input with minutes, hours, days, weeks, or months parameters. Selected threshold returns shipments where the selected event was late by the selected threshold or more. For example, if I select Is Late By 5 days, shipments that were 5 or more days late are returned.

      • Is Early by: A comparison between the Actual time and Planned Time of the event. Opens a threshold input with minutes, hours, days, weeks, or months parameters. Selected threshold returns shipments where the selected event was early by the selected threshold or more. For example, if I select Is Early by 5 days, shipments that were 5 or more days early are returned.

    • Planned Time conditions:

      • Between: A specified date range. Opens a calendar selector. Selected date range goes from 12:00 AM on the start date to 11:59 PM on the end date.

      • Is in the Next: A relative range. Opens a threshold input with minutes, hours, days, weeks, or months parameters. Selected date range goes from current date + selected threshold.

      • Is in the Last: A relative range. Opens a threshold input with minutes, hours, days, weeks, or months parameters. Selected date range goes from current date - selected threshold

  • Location Criteria: Specifying location criteria within the event filter allows users to query for events happening at specific locations.

    • Location Name

    • Address

    • City

    • State

    • Country

    • Zip Code

    • Port Code

    • Location Code

    • Stop Type

  • Conditions: is or is not.

  • Values: This field is searchable. If more than one value is applied, then OR logic is applied.

    All values are NOT standardized by project44 and display what is provided by the customer or carrier (except for country code, which validates that they are in ISO standard). Therefore, you might see multiple options for one entity such as ‘Memphis’, ‘memphis’, or ‘Meemphis’ if that is what is submitted.

Tip

If the Milestone and Route filters are used together, AND logic is applied. However, if there are a multiple of the same event happening at different locations along the route, there is no guarantee that the event is happening at the stops specified in the location filter.

The Route Filter queries the route stop list of the shipment and returns shipments that match the specified route criteria. The Milestone Filter queries the event list of the shipment and returns shipments where the selected event is present within the specified timeframe.

For example, a user may query for shipments with an Origin of China and a Destination of LA AND with a departure event in the next five days. This query for shipments moving along that route and that has a departure event happening in the next five days anywhere along the route. So the departure could be happening at the origin or a transshipment port. In order to specify where the event is happening along the route, you need to add that criteria to the Milestones filter using the location options (event stop type, event port code, etc).

The choices in the drop-down lists that are available are determined by which Event is selected. For examples on using this filter, refer to Filter Shipments by Milestones.

Current State

Status for active shipments within the last 90 days. This includes the state that a shipment is currently in during its lifecycle within the last 90 days.

  • Unknown: Shipment is awaiting an event to be pushed to it to begin tracking.

  • In Transit: Shipment has been pushed an event that indicates it is in transit from its current point to its next point.

  • Completed: Shipment has completed its journey and will now cease tracking.

  • Idle: Shipment is not moving.

    Note

    Idle only applies to Truckload.

  • Scheduled: Connection with the carrier established, but no events, stops, or locations are available yet.

  • At Stop: Shipment has been pushed an event that indicates it has entered one of the stops along its route.

  • Action Required: A carrier identifier or (unknown) equipment identifier is missing.

Connectivity

Connectivity status for Truckload shipments.

  • Tracking Started: The shipment is being tracked.

  • Unknown Equipment Identifier: Shipment has not been tracked because the equipment identifier is unknown to project44. Current state is Action Required.

  • Tracking Ended by User: Shipment tracked. Current state is Completed.

  • Driver Denied Tracking: Shipment has not been tracked. Current state is Action Required.

  • Tracking Failed: Tracking failed. Current state is Completed.

  • Missing Equipment Identifier: Shipment has not been tracked because there is no equipment identifier. Current state is Action Required.

  • Tracking Timeout: Shipment tracking started but has stopped. Current state is completed.

Attribute Filters

There are five attribute filters: Route, Related Entities, Properties, Mode of Shipment, and Identifier Type.

Route

Route filters are applied to the entire route of the shipment. Select from the following options:

  • Origin: Shipments that are originating from a specified location. This filter will always apply against the absolute origin.

  • Destination: Shipments that are destined for a specified location. This filter will always apply against the absolute destination. 

  • Current Stop: Shipments at or in transit to a specified location.

  • Any Stop: Shipments that have a specific location in the route, regardless of origin or destination. Additionally, when selecting the underlying conditions and criteria, they will be applied to the entire route. For example, if you filter by Any Stop that is not country code US, if a shipment has a stop in the US it will be excluded from the results.

  • All Stops: Shipments at all location types.

Once a stop is selected, apply location criteria.

  • Criteria: There are several location types to choose from the drop-down. If more than one is selected AND logic is applied. 

    • Location Name

    • Address

    • City

    • State

    • Country

    • Zip Code

    • Port Code

    • Location Code

    • Stop Type (more granular stop types than in the above selection such as transshipment port and transfer).

  • Conditions: There are three choices: is, is not, or contains.

  • Values: This field is searchable. If more than one value is applied, then OR logic is applied.

    • The suggestion fields are populated by values that shipments have had historically. For example, a shipment that has a value of city "Memphis" will cause the suggestion to appear in the city drop-down.

    • Suggestions that are stop-specific will only populate if they appeared at that stop. For example, if "Chicago" has only ever been an origin, it will not appear as a suggestion when Destination is selected.

    • All values are NOT standardized by project44. What is displayed is what is provided by the customer or carrier (except for country code, which validates that they are in ISO standard). Therefore, you might see multiple options for one entity such as ‘Memphis’, ‘memphis’, or ‘Meemphis’ if that is what is submitted.

For more information on using this filter, refer to Filter Shipments by Route Location.

Related Entities

The Related Entitles filter queries against related attributes, especially orders. This drop-down list has the following choices.

  • Order Identifier: Ways to identify an order. The drop-down list contains the following choices.

    • Purchase Order

    • Sales Order

    • Advanced Shipment Notice

    • Warehouse Movement Order

  • Order Reference Key: The drop-down list contains the following choices.

    • Contract

    • Order Load

    • Manufacturer

    • Promotion

    • Season

    • Vendor

    • Analyst

    • Order Carrier

    • Category

    • Commodity

    • Department

    • Director

    • Family

    • Group

    • Manager

    • Sector

  • Load Item: The drop-down list contains the following choices.

    • SKU

    • UPC

    • Description

  • Order Date: The drop-down list contains the following choices.

    • Supplier Ready Date

    • Order Due Date

  • Conditions: There are three choices: is, is not, or contains.

    For Order Date the conditions are: between, in the next, or in the last.

  • Values: This field is searchable. If more than one value is applied, then OR logic is applied.

    For Load Item, more than one identifier number can be entered, separated by commas.

    For Order Date, the choice is a Date Range selected in a calendar.

Properties

The drop-down list has the following choices.

  • Carrier: Carrier that appears anywhere along the route. Can be: Name, IATA, ICAO SCAC, US DOT Number, MC Number, NMC ID, or Master ID.

  • Identifiers: Any Identifier for a shipment. Can be: Bill of Lading, Booking Number, Container ID, Order Number, Pro Number, Tracking Number, Air Waybill, House Air Waybill, Rail Car ID, Waybill, Train Number, or Wagon ID.

  • Reference Key: Customer specific reference keys and their corresponding values (if they are using attributes on their shipments).

    Note

    These values are NOT standardized by project44. Therefore you could see "Memphis" or "memphis" as two separate reference keys.

  • Vessel or Vehicle ID: Specific Vessel or Vehicle assigned to a shipment. Can be: Vessel Name, Vessel MMSI, Vessel IMO, Vessel Call Sign, Trailer ID, Vehicle ID, or License Plate. 

  • Shared Visibility: The tenant names with which a shipment was shared. The choices are: Shared with or Visibility Provided by.

  • Conditions: is, is not, or contains.

  • Values: This field is searchable. If "contains" is selected as the condition, more than one value can be entered (separated by commas), and OR logic is applied.

    When Identifier is selected as the Property, click Click to Add in order to add up 200 different identifiers. For more information refer to Add Multiple Shipment Identifiers to a Filter.

Mode of Shipment

Mode of transport anywhere along the route. Provides you with shipments where this mode has existed at any point along the route. You can select the following Modes.

  • LTL

  • TL

  • Parcel

  • Air

  • Ocean

  • Rail

  • Barge

After you have selected a mode (or modes), use the Only show shipments currently in this mode of transport toggle switch to view shipments that are currently in those selected modes of transport.

Identifier Type

The type of shipment identifier. Provides you with shipments based on the identifiers associated with the shipment. The same shipment can be returned given different identifiers if those identifiers are attached to the shipment. For example, filtering for BOL could return a given shipment while filtering for CONT would provide the same shipment as that shipment would have both attributes attached to it.

You can filter the following ID Types.

  • Bill of Lading

  • Container ID

  • PRO Number

  • Air Waybill

  • Rail Car ID

  • Train Number

  • Serial Number

  • Booking Number

  • Order Number

  • Tracking Number

  • House Air Waybill

  • Waybill

  • Wagon ID

  • Vehicle Identification number

Click Apply Filters to sort the Shipment List by the selected criteria.

Click Clear All to remove all selections.

Click Save View to save a filtered view for future use. For more information refer to Manage Views.

Click the X to close the Filter panel.

You can sort the filtered list.

Related articles