Skip to main content

Controlant Support Center

Shipments table

In this section:

The Shipments table contains information about ongoing and finished shipments - e.g. origin, destination, configuration, excursion threshold and inspection status.

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 1. Shipments

Item

Data type

Description

shipment_reference

string

Reference to unique identifier of shipment in customer's system.

Primary key.

description

string

Description of shipment.

Blank if no description was included when shipment was created.

timestamp_deliver_by

ts

Date shipment should be delivered by, in YYYY-MM-DDTHH:MM:SSZ format.

timestamp_created

ts

Date shipment was created in database, inYYYY-MM-DDTHH:MM:SSZ format.

timestamp_shipped

ts

Date shipment was shipped, in YYYY-MM-DDTHH:MM:SSZ format.

Blank if shipment has not been shipped.

timestamp_delivered

ts

Date shipment was delivered to destination, in YYYY-MM-DDTHH:MM:SSZ format.

Blank if shipment has not been delivered.

timestamp_closed

ts

Date shipment was marked as closed post delivery, in YYYY-MM-DDTHH:MM:SSZ format.

Blank if shipment has not been closed.

Origin location

from_location_reference

string

Origin location - customer defined name for location.

from_name

string

Name of shipment origin location.

If source is empty, the value of from_location_reference will be used as location name.

from_phone

string

Phone number of shipment origin location.

from_address_line_1

string

Postal address of shipment origin location, line 1.

from_address_line_2

string

Postal address of shipment origin location, line 2.

from_address_line_3

string

Postal address of shipment origin location, line 3.

from_city

string

City of shipment origin location.

from_region

string

Region of shipment origin location.

from_postcode

string

Postcode of shipment origin location.

from_country

string

Country code for country of shipment origin location.

from_latitude

decimal

Latitude coordinates for the shipment origin location's center-mass.

Must adhere to the World Geodetic System 1984 (WGS 84) standard.

from_longitude

decimal

Latitude coordinates for the shipment origin location's center-mass.

Must adhere to the World Geodetic System 1984 (WGS 84) standard.

from_radius

bigint

Radius of shipment origin location's center-mass. If shipment is found within this radius of shipment location's center-mass, it is considered at origin location.

Destination location

to_location_reference

string

Destination location - customer defined name for location.

to_name

string

Name of shipment destination location.

If source is empty, the value of to_location_reference will be used as location name.

to_phone

string

Phone number of shipment destination location.

to_address_line_1

string

Postal address of shipment destination location, line 1.

to_address_line_2

string

Postal address of shipment destination location, line 2.

to_address_line_3

string

Postal address of shipment destination location, line 3.

to_city

string

City of shipment destination location.

to_region

string

Region of shipment destination location.

to_postcode

string

Postcode of shipment destination location.

to_country

string

Country code for country of shipment destination location.

to_latitude

decimal

Latitude coordinates for the shipment destination location's center-mass.

Must adhere to the World Geodetic System 1984 (WGS 84) standard.

to_longitude

decimal

Latitude coordinates for the shipment destination location's center-mass.

Must adhere to the World Geodetic System 1984 (WGS 84) standard.

to_radius

bigint

Radius of shipment destination location's center-mass. If shipment is found within this radius of shipment location's center-mass, it is considered at destination location.

Shipment details

status

string

Current status of shipment:

delivery_method

string

Stop method of shipment:

  • Geofence and Button - Shipment closed when button has been pressed AND logger has left the configured geofence location.

  • Geofence - Shipment closed when logger has left the configured geofence location.

  • Geofence or Button - Shipment closed when button has been pressed OR logger has left the configured geofence location.

  • Button - Shipment closed when button has been pressed.

  • Time - Shipment closed on the date and time configured.

shipping_method

string

Start method of shipment:

  • Geofence - Shipment started when logger left the configured geofence location.

  • Button - Shipment started when button has been pressed

  • Geofence or Button - Shipment started when button has been pressed OR logger has left the configured geofence location.

  • Time - Shipment started on the date and time configured.

inspection_status

string

The status of the shipment inspection process after arriving at destination:

  • NotInspected

  • UnderInspection

  • Inspected

inspection_quality

string

Quality of the shipment contents determined during inspection:

  • Released

  • Undecided

  • Rejected

  • PartlyReleased

inspection_comment

string

Comments or details related to the shipment inspection.

Blank if no comment or detail.

excursion_severity_threshold

string

Threshold for raising alerts for this shipment:

  • NoExcursion

  • Level1

  • Level2

  • Level3

warning_ignore_period_start

bigint

A period (in seconds) at the beginning of shipment where the alarm functionality is inactive.

Note

Temperature data is recorded during the ignore period and will be available, but no alarms will be triggered for excursions.

warning_ignore_period_end

bigint

A period (in seconds) at the end of shipment where the alarm functionality is inactive.

Note

Temperature data is recorded during the ignore period and will be available, but no alarms will be triggered for excursions.