Shipment_properties table

In this section:

The Shipment_properties table contains custom properties for the shipment, for instance transportation mode, business unit, carrier etc.

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 16. Shipment_properties

Item	Data type	Description
shipment_reference	string	Unique identifier for shipment, as provided by customer when shipment was created. Primary key. Foreign key.
property_name	string	Name of the property. Example: Transportation Mode Business unit Carrier
property_value	string	The value of the property type defined in `property_name`. Example: Air Ocean

Item

Data type

Description

shipment_reference

string

Primary key. Foreign key.

property_name

string

Name of the property.

Example:

property_value

string

The value of the property type defined in property_name.

Example: