Skip to main content

Points of interest or legs table (shipments_pois_legs)

In this section:

The shipments_pois_legs table consolidates all POIs with arrival and departure details and builds the shipment legs, representing the source of truth for tracking shipments between locations.

Data type legend

Data type

Description

bigint

Big integer, large number.

decimal

Number with decimal point, in 11,7 format: 11 digits before decimal point, 7 digits after decimal point.

double

Double; 8-byte double-precision floating point numbers.

int

Integer, whole number.

string

String, text.

ts

Timestamp, in YYYY-MM-DDTHH:MM:SSZ format.

Table 23. shipments_pois_legs table

Item

Data type

Description

id

bigint

Unique identifier of this instance of a shipment arriving at this point of interest or leg.

Primary key. Foreign key.

shipment_reference

string

Unique identifier of shipment in Supply Chain Monitoring platform.

location_name

string

Name of this location. (Origin and Destination use the location_name as provided by the customer in the shipment).

location_group_id

bigint

Unique identifier of location group in location_groups table.

See Location groups table (location_groups).

location_type

string

Type of location, as configured by customer, but typically include:

begin_time

ts

Date and time of first location signal from a device in a shipment within a specific point of interest group.

Note

A device location signal indicates the device woke up and connected to the Controlant Cloud Platform.

end_time

ts

Date and time of last location signal from a device in a shipment within a specific point of interest group.

Note

A device location signal indicates the device woke up and connected to the Controlant Cloud Platform.

rank

int

Order rank of the point of interest or leg within the shipment.