> ## Documentation Index
> Fetch the complete documentation index at: https://docs.trackstarhq.com/llms.txt
> Use this file to discover all available pages before exploring further.
# DPD
> Sample invoice CSV for DPD, semicolon-delimited, with English column names.
## Overview
DPD delivers invoice data via the DPD Insights portal. Each file is one invoice's worth of shipments, with one row per shipment (parcel). Columns use English names; DPD also accepts a set of Dutch-language column aliases for the key identifier and charge fields (see [Dutch column aliases](#dutch-column-aliases) below).
## Shape notes
* **Semicolon-delimited, not comma.** DPD uses `;` as the column separator. Standard comma-CSV readers will misread DPD files.
* **One row per shipment.** Each row is one parcel. A row may populate several charge columns (base price, fuel, toll, etc.); each non-zero charge becomes one line item in the Trackstar API.
* **Tracking number is the parcel number.** DPD's `Parcel number` column maps to `tracking_number`. `Shipment number` is a separate DPD reference, not the tracking number.
* **Quoted reference values.** DPD occasionally wraps a reference value in quotes to protect an embedded semicolon (e.g., `"RF_103326;"`).
* **Dates are `YYYYMMDD` or `DD.MM.YYYY`.** Both are accepted — no separators in the former (e.g., `20260331`), dots in the latter (e.g., `31.03.2026`).
## Sample rows
Curated subset of columns for readability. The downloadable CSV has all 43 columns.
```csv theme={null}
Invoice number;Invoice date;Customer number;Parcel number;Service;Base price;Energy surcharge;Total amount
26840305;20260331;63196946;79184603396001;Express;8.62;0.35;9.80
05566517;20260331;66888433;77960076935433;Shop Delivery;7.75;0.63;10.02
60987472;20260331;76964474;74069815441672;Shop Return;5.37;0.84;11.07
23132839;20260331;33439835;41425546063107;Classic;13.24;0.52;25.57
29556504;20260331;52571506;59507496384122;Classic;4.90;0.63;13.88
```
## Download
Download full sample CSV (1 header row + 25 data rows, 43 columns, semicolon-delimited)
All sample data is synthetic. Tracking numbers, account numbers, addresses, and reference fields are fabricated and do not correspond to any real shipments or customers.
## Fields
### Sender and receiver
| Column | Description |
| :----------------------------------------------------------------- | :------------------------------------------ |
| `Sender name` / `Sender name 2` | Sender identity (DPD relay + merchant name) |
| `Receiver name` / `Receiver name 2` | Recipient name lines |
| `Sender address` / `Sender ZIP` / `Sender city` / `Sender country` | Sender address |
### Identifiers
| Column | Description | Example |
| :---------------- | :----------------------------------------------------- | :----------------------- |
| `Type` | Shipment type (`P` = parcel) | `P` |
| `Quantity order` | Items in the order | `1` |
| `Customer number` | Customer account — maps to `account_id` | `63196946` |
| `Customer name` | Customer display name | `Acme Logistics NL B.V.` |
| `Invoice number` | Invoice ID — maps to `invoice_id` | `26840305` |
| `Invoice date` | `YYYYMMDD` — maps to `transaction_date` | `20260331` |
| `Parcel number` | DPD parcel tracking number — maps to `tracking_number` | `79184603396001` |
| `Shipment number` | Separate DPD shipment reference | `368264` |
### Destination and service
| Column | Description |
| :------------------------------- | :------------------------------------------------------------------ |
| `Destination zone` | `NL`, `EU`, `INT` |
| `Commercial destination country` | ISO country code |
| `Service` | Service name (`Classic`, `Shop Delivery`, `Shop Return`, `Express`) |
| `Shipment date` | YYYYMMDD |
### Charges
Each populated charge column becomes one Trackstar line item. The `charge_description` is set to the column name.
| Column | Description |
| :------------------------------- | :-------------------------------------------------------------------------------- |
| `Base price` | Base freight charge |
| `Energy surcharge` | Energy / fuel surcharge |
| `Toll surcharge` | Road toll surcharge |
| `Peak surcharge` | Peak-period surcharge |
| `System return surcharge` | System return fee |
| `Oversized/Overweight surcharge` | Oversize / overweight fee |
| `Customs surcharge` | Customs handling fee |
| `Total other surcharges` | Miscellaneous surcharges |
| `Total amount` | Row total (sum of all populated charges; informational, not a separate line item) |
| `VAT percentage` | VAT rate applied |
### Descriptions, measurement, references
| Column | Description |
| :------------------------------------------------- | :------------------------------------------------------ |
| `System return date` / `System return description` | Context for a system return surcharge |
| `Oversized/Overweight description` | Context for an oversize / overweight surcharge |
| `Date of measurement` / `Depot of measurement` | When / where the parcel was measured |
| `Weight` | Parcel weight (grams) |
| `Length` / `Width` / `Height` / `Girth` | Dimensions (cm) |
| `Customer parcel reference 1` | Customer's parcel reference (typically order number) |
| `Customer shipment reference 1` | Customer's shipment reference |
| `Other surcharges codes` | Comma-separated codes for any itemized other surcharges |
## Dutch column aliases
For Dutch-language files, DPD recognizes the following column aliases for the key fields. Where a row uses the Dutch name, it maps to the same Trackstar field as its English counterpart.
| Trackstar field | English column | Dutch alias |
| :----------------- | :---------------- | :-------------- |
| `invoice_id` | `Invoice number` | `Factuur` |
| `transaction_date` | `Invoice date` | `Factuurdatum` |
| `account_id` | `Customer number` | `Relatienummer` |
| `tracking_number` | `Parcel number` | `Pakketnummer` |
Charge columns may also appear under alternate names — `Tarief` (base freight), `Toeslag` (surcharge), `Totaal` (total), and `COD Toeslag` (cash-on-delivery). As with the English charge columns, each populated charge becomes one line item with the column name as its `charge_description`.