Process Status
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
| CHAR(20) | OK | False |
source | The system has triggered a status1 Source
| 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
| 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