Transporeon Essentials Excel Template
- ser_hcskb_api
Analytics
This Excel template simplifies importing transport data into the exchange platform. The columns in the Excel file are described below.
Excel imports are categorized into three types: Transport, Delivery Only, and Open Booking. Only delivery imports don't require transport columns.
Transport imports with the “Transport - Status” 'OB' enable Open Booking imports.
You can access the Excel template, which includes example rows for all key business processes, at the following link: Technical Descriptions.
Column | Description | Type | Value / Example | Mandatory |
|
|
|
|
|
|---|---|---|---|---|---|---|---|---|---|
Transport - Number | Transport number, unique | STRING | 123456 | True |
|
|
|
|
|
Transport - Status | Transport status Status :
| STRING | N | True |
|
|
|
|
|
Transport - Scheduling unit | Scheduling unit | STRING | Ulm | False |
|
|
|
|
|
Transport - Carrier creditor number | Creditor number of an assigned carrier. Considered and mandatory for No-Touch Order assignment method, ignored otherwise. | STRING | CARRIER1 | False |
|
|
|
|
|
Transport - External carrier identifier | Identifier of external carrier | STRING | 222 | False |
|
|
|
|
|
Transport - External carrier name | Name of external carrier | STRING | External Transportation Inc. | False |
|
|
|
|
|
Transport - Carrier group | Carrier group name. Considered for Best Carrier assignment method if provided, ignored otherwise | STRING | Carriers-DE | False |
|
|
|
|
|
Transport - Reference price | Prices DTOs with price and surcharge information of the transport, see Prices | NUMBER | 250,00 | False |
|
|
|
|
|
Transport - Currency | Currency of price | STRING | EUR | False |
|
|
|
|
|
Transport - Vehicle type | Type of vehicle | STRING | V001 | False |
|
|
|
|
|
Transport - Load type | Transport load type | STRING | BULK | False |
|
|
|
|
|
Transport - Frigo | Is transport refrigerated | String | TRUE or FALSE | False |
|
|
|
|
|
Transport - Sea RTV enabled | Marking the Transport as an Ocean Transport | STRING | TRUE or FALSE | False |
|
|
|
|
|
Transport - Ocean SCAC | number of ocean carriers | STRING | ZZZZ | False |
|
|
|
|
|
Transport - Container ID | Id of container | STRING | XXXU123456 | False |
|
|
|
|
|
Transport - Ocean Booking number | Number of ocean booking | STRING | Z1234546 | False |
|
|
|
|
|
Transport - Master Bill of Lading | Number of master bill lading | STRING | GHC02557773 | False |
|
|
|
|
|
Transport - Air RTV enabled | visibility of air product | STRING | TRUE or FALSE | False |
|
|
|
|
|
Transport - Air Booking number | Number of air booking | STRING | AB001 | False |
|
|
|
|
|
Transport - Air SCAC | number of air carrier | STRING | AAAA | False |
|
|
|
|
|
Transport - Air Waybill number | Number of air waybill | STRING | 123-45678901 | False |
|
|
|
|
|
Transport - Slots | Number of slots | NUMBER | 1 | False | False |
|
|
|
|
Transport - Main modality | refers to the primary mode of transport | STRING | Intermodal | False |
|
|
|
|
|
Transport - Custom 1 | Using custom-defined, specific transport data. | STRING |
| False |
|
|
|
|
|
Transport - Custom 2 | Using custom-defined, specific transport data. | STRING |
| False |
|
|
|
|
|
Transport - Custom 3 | Using custom-defined, specific transport data. | STRING |
| False |
|
|
|
|
|
Transport - Custom 4 | Using custom-defined, specific transport data. | STRING |
| False |
|
|
|
|
|
Transport - Custom 5 | Using custom-defined, specific transport data. | STRING |
| False |
|
|
|
|
|
Transport - Autonomous Procurement Criticality | Criticality of autonomous procurement | STRING | 99 | False |
|
|
|
|
|
Transport - Comment | Transport comment | STRING |
| False |
|
|
|
|
|
Transport - Demuragge and Detention contract reference | Reference of demurrage and detention contract | STRING | Test Reference General | False |
|
|
|
|
|
Transport - Demurrage and Detention contract reference import | Import reference of demurrage and detention contract | STRING | Test Reference Import | False |
|
|
|
|
|
Transport - Demurrage and Detention contract reference export | Export reference of demurrage and detention contract | STRING | Test Reference export | False |
|
|
|
|
|
Transport - distance | Distance between loading and unloading stations. See Units, Statuses, and Enumerations | NUMBER | 352.0 | False |
|
|
|
|
|
Allocation - Vehicle license plate | Vehicle licence plate | STRING | UL TP 122 | False |
|
|
|
|
|
Delivery - Number | Delivery number, unique | STRING | D100 | True |
|
|
|
|
|
Delivery - Status | Status of delivery. Use “D“ to delete a delivery | STRING | one of : N, D | True |
|
|
|
|
|
Delivery - Scheduling unit | Scheduling unit of the delivery | STRING | Ulm | False |
|
|
|
|
|
Delivery - Main modality | Main modality of the delivery | STRING | Intermodal | False |
|
|
|
|
|
Delivery - Weight (in kg) | Load weight. See Units, Statuses, and Enumerations | NUMBER | 15,5 | False |
|
|
|
|
|
Delivery - Volume (in m³) | Load volume. See Units, Statuses, and Enumerations | NUMBER | 10,00 | False |
|
|
|
|
|
Delivery - Loading meters | Length of the load on vehicle. See Units, Statuses, and Enumerations | NUMBER | 25,00 | False |
|
|
|
|
|
Delivery - Storage Positions | Number of storage positions | NUMBER | 4,0 | False |
|
|
|
|
|
Delivery - Pallets Type | Pallet type | STRING | EP | False |
|
|
|
|
|
Delivery - Pileable | checking pileable of delivery | STRING | TRUE or FALSE | False |
|
|
|
|
|
Delivery - Incoterm | Incoterm of thedelivery | STRING | one of: EXW, FCA, CPT, CIP, DPU, DAP, DDP, FAS, FOB, CFR, CIF | False |
|
|
|
|
|
Delivery - Incoterm city | City of Incoterm | STRING | Ulm | False |
|
|
|
|
|
Delivery - Autonomous Procurement Cargo Type | Type of cargo | STRING | FTL | False |
|
|
|
|
|
Delivery - Autonomous Procurement Payload Capacity Min | Minimum vehicle payload capacity | NUMBER | 3 | False |
|
|
|
|
|
Delivery - Autonomous Procurement Payload Capacity Max | Maximum vehicle payload capacity | NUMBER | 20 | False |
|
|
|
|
|
Delivery - Autonomous Procurement Temperature Min | Minimum temperature requirement for goods or cargo within an autonomous procurement system | NUMBER | -3 | False |
|
|
|
|
|
Delivery - Autonomous Procurement Temperature Max | Maximum temperature requirement for goods or cargo within an autonomous procurement system | NUMBER | 35 | False |
|
|
|
|
|
Delivery - Autonomous Procurement Temperature Unit | Temperature unit | STRING | C | False |
|
|
|
|
|
Loading station - Place Reference Id | Loading station reference id | STRING | palye_1 | False |
|
|
|
|
|
Loading station - Company name | Company name | STRING | Transporeon GmbH | False |
|
|
|
|
|
Loading station - Country ID | Country code | STRING | DE | False |
|
|
|
|
|
Loading station - Postal code | Postal code | STRING | 10117 | False |
|
|
|
|
|
Loading station - City | City | STRING | Berlin | False |
|
|
|
|
|
Loading station - State | Federal state | STRING | BE | False |
|
|
|
|
|
Loading station - Street | Street name and number | STRING | Magirus-Deutz-Str. 16 | False |
|
|
|
|
|
Loading station - Ramp | Gate name | STRING | Main entrance | False |
|
|
|
|
|
Loading station - Start date | Loading period begin (date) | STRING | 15.01.2025 | False |
|
|
|
|
|
Loading station - Start time | Loading period begin (time) | STRING | 05:00 | False |
|
|
|
|
|
Loading station - End date | Loading period end (date) | STRING | 16.01.2025 | False |
|
|
|
|
|
Loading station - End time | Loading period end (time) | STRING | 18:00 | False |
|
|
|
|
|
Loading station - Latitude | Latitude coordinate of loading station | NUMBER | 52,52 | False |
|
|
|
|
|
Loading station - Longitude | Longitude coordinate of loading station | NUMBER | 13,41 | False |
|
|
|
|
|
Loading station - Comment | Loading station comment, free text | STRING | Comment text | False |
|
|
|
|
|
Unloading station - Place Reference Id | Unloading station reference id | STRING | PLACE_2 | False |
|
|
|
|
|
Unloading station - Company name | Company name | STRING | Transporeon GmbH | False |
|
|
|
|
|
Unloading station - Customer number | Customer number | STRING | 12345 | False |
|
|
|
|
|
Unloading station - Country ID | Country code | STRING | DE | False |
|
|
|
|
|
Unloading station - Postal code | Postal code | STRING | 89077 | False |
|
|
|
|
|
Unloading station - City | City | STRING | Ulm | False |
|
|
|
|
|
Unloading station - State | Federal state | STRING | BW | False |
|
|
|
|
|
Unloading station - Street | Street name and number | STRING | Magirus-Deutz-Str. 16 | False |
|
|
|
|
|
Unloading station - Ramp | Gate name | STRING | Main entrance | False |
|
|
|
|
|
Unloading station - Start date | Unloading period begin (date) | STRING | 17.01.2025 | False |
|
|
|
|
|
Unloading station - Start time | Unloading period begin (time) | STRING | 06:00 | False |
|
|
|
|
|
Unloading station - End date | Unloading period end (date) | STRING | 18.01.2025 | False |
|
|
|
|
|
Unloading station - End time | Unloading period end (time) | STRING | 19:00 | False |
|
|
|
|
|
Unloading station - Latitude | Station geographic coordinate that indicates the north-south position of a point relative to the Equator | STRING | 48,40 | False |
|
|
|
|
|
Unloading station - Longitude | Station geographic coordinate that specifies the east-west position of a point on the Earth's surface | STRING | 9,99 | False |
|
|
|
|
|
Unloading station - Comment | Unloading station comment, free text | STRING | Any comment text | False |
|
|
|
|
|
Delivery - Booking Group Id | Booking group unique identifier code. Open bookings belong together and form a booking group when they all have the same transport number and bookingGroupId values | STRING |
| False |
|
|
|
|
|
Delivery - Booking Group Order | The field defines the sequence of the bookings within a Booking group, so the order they are allowed to be booked by the system | STRING |
| False |
|
|
|
|
|
Delivery - Comment | Delivery comment, free text | STRING | Any comment text | False |
|
|
|
|
|
Delivery - Custom 1 | Using custom-defined, specific delivery data. | STRING |
| False |
|
|
|
|
|
Delivery - Custom 2 | Using custom-defined, specific delivery data. | STRING |
| False |
|
|
|
|
|
Delivery - Custom 3 | Using custom-defined, specific delivery data. | STRING |
| False |
|
|
|
|
|
Delivery - Custom 4 | Using custom-defined, specific delivery data. | STRING |
| False |
|
|
|
|
|
Delivery - Custom 5 | Using custom-defined, specific delivery data. | STRING |
| False |
|
|
|
|
|
Delivery - Custom 6 | Consignee Name | STRING |
| False |
|
|
|
|
|
Delivery - VH Loading Is Port | checking loading port in visibility hub | STRING | TRUE or FALSE | False | False |
|
|
|
|
Delivery - VH Unloading Is Port | checking unloading port in visibility hub | STRING | TRUE or FALSE | False |
|
|
|
|
|
Delivery - VH Loading UN/LOCODE | UNLO-code for port of loading in visibility hub | STRING | DE | False |
|
|
|
|
|
Delivery - VH Unloading UN/LOCODE | UNLO-code for port of unloading in visibility hub | STRING | DE | False |
|
|
|
|
|
Delivery - VH Loading IATA | Loading location IATA Code | STRING | 01-12345 | False |
|
|
|
|
|
Delivery - VH Unloading IATA | Unloading location IATA Code | STRING | 03-12345 | False |
|
|
|
|
|
Delivery - Goods Type | Type of goods | STRING | Gas | False |
|
|
|
|
|