Process Status

 

Attribute

Description

Type (Length)

Example

Mandatory

Attribute

Description

Type (Length)

Example

Mandatory

delivery_number

Delivery number. Mandatory for statuses on delivery level

CHAR(50)

456

See description

carrier_creditor_number

Carrier creditor number1

CHAR(50)

CCN123

False

comment

Status comment

CHAR(255)

This is a comment

False

declared_timestamp

Date and time when the status took place.

CHAR(29)

2021-10-07T16:00:00+02:00

True

timezone

Timezone of the declared_timestamp, according to IANA tz database.

CHAR(50)

Europe/Berlin

False

id

Process status id1

CHAR(50)

452159023

False

latitude

Geographic coordinates (Latitude)

FP NUMBER

48.400002

False

longitude

Geographic coordinates (Longitude)

FP NUMBER

9.983333

False

parameters

List of parameters, see Parameter

False

qualifier

Status qualifier. The status should be allowed according to the delivery and transport process.

Mutually agreed, see also Automatic Road Process Statuses, Trucker App Process Statuses

CHAR(50)

status.loading.arrival

True

severity

Severity of the status

Severity

  • OK

  • FAILURE

  • PROBLEM

 

CHAR(20)

OK

False

source

The system has triggered a status1

Source

  • TP_TRUCKER

  • TP_CARRIER_API

  • TP_VISIBILITY_HUB

 

CHAR(20)

TP_TRUCKER

False

timestamp

Timestamp of the event that triggered the message (UTC + offset)1

CHAR(29)

2021-10-07T16:08:47+02:00

False

transport_number

Number of the transport that received the status

CHAR(50)

ABC123

True

trigger

Indicator if the status was triggered via GPS or EVENT1

Trigger

  • GPS

  • EVENT

 

CHAR(20)

EVENT

False

user_id

User that placed the status

INT(10)

2147483647

False

status

Describes if the status is set (N) or deleted (D). Defaults to N if not set.

 

CHAR(1)

N

False

1Note that not all fields are relevant when sending a status message to our system. A detailed description can be found here: Road Transports Tracking and Tracing