Tracking Made Possible via Flatfile Integration

  1. Introduction

    We offer a flatfile format named “SCANINFO”, which is a simple text-based file format designed for easy data exchange and processing. This format is used for both regular shipments and collection request parcels. (UTF-8 encoded, semicolon-delimited) that includes all scans performed on your parcels. These scan files are exported every 30 minutes and made available for download and integration in a private SFTP folder.

     

  2. Naming Convention

    For regular shipments, the filename follows this format:
    SCANINFO_****_D<Date YYYYMMDD>T<Timestamp HHmmss>_<6 digit random number>
    Example: SCANINFO_BE0000_D20250117T133125_123456
    Each part of the filename has a specific meaning:
    • SCANINFO: Indicates the file type.
    • BE0000: Represents the customer ID.
    • D20250117: The date in YYYYMMDD format.
    • T133125: The time in HHmmss format.
    • 123456: A 6-digit random number for uniqueness.
    For collection requests, filenames will start with SCANINFOCR_.


  3. How to Request

    If you have not already received an SFTP account during onboarding, you can request one by contacting it.cs@dpd.be. If Sales assistance is required, please reach out to them first. Alternatively, reach out to Sales if this option is unavailable.

  4. File Description

    The SCANINFO file includes the following data fields (English translations provided, with any unrelated references removed):

    PARCELNO;SCAN_CODE;DEPOT_CODE;SCAN_DATE_TIME;ROUTE;TOUR;SERVICE;RCOUNTRYN;RCOUNTRY;CONSIGNEE_ZIP;ADD_SERVICE_1;ADD_SERVICE_2;ADD_SERVICE_3;ADD_SERVICE_4;ADD_SERVICE_5;WEIGHT;VOLUME;POD_IMAGE_REF;RECEIVER_NAME;INFO_TEXT;LOCATION;MPSCREF1;MPSCREF2;MPSCREF3;MPSCREF4;CREF1;CREF2;CREF3;CREF4;CUSTOMER_REFERENCE;DELISUSR;
    05300000000000;02;0300;20240815190000;0300;;327;752;SE;90592;;;;;;30;062041017;;;;;mps_crf1;;;;cref1;;;;customer_ref1;delisuser1;
    05300000000000;13;0521;20240815192906;0521;;328;528;;2353MR;;;;;;0;;6620080;somebody;;somewhere;mps_crf1;;;;cref1;;;;customer_ref1;delisuser1;
    05300000000000;04;1560;20240815190341;;;328;826;;TN118EE;;;;;;0;;;;;;mps_crf1;;;;cref1;;;;customer_ref1;delisuser1;
    05300000000000;04;1557;20240815185545;;;327;826;;HR27PA;;;;;;0;;;;;;mps_crf1;;;;cref1;;;;customer_ref1;delisuser1;
    05300000000000;04;1583;20240815185423;;;328;826;;WA66TL;;;;;;0;;;;;;mps_crf1;;;;cref1;;;;customer_ref1;delisuser1;

    Field Name

    Description

    Format

    Example

    PARCELNO

    Parcel Label Number

    VARCHAR(14)

    12345678901234

    SCAN_CODE

    Event Type*

    VARCHAR(2)

    02

    DEPOT_CODE

    Event Depot Code*

    VARCHAR(4)

    0534

    SCAN_DATE_TIME

    Event Timestamp (YYYYMMDDHHmmss)

    VARCHAR(14)

    20250128123045

    ROUTE

    Parcel Destination Depot Code

    VARCHAR(4)

    0548

    TOUR

    Tour Handling the Parcel

    VARCHAR(3)

    123

    SERVICE

    Service Code*

    VARCHAR(3)

    101

    RCOUNTRYN

    Receiver Country Number (ISO 3166 Numeric)

    VARCHAR(3)

    056

    RCOUNTRY

    Receiver Country Code (ISO 3166 Alpha-2)

    VARCHAR(2)

    BE

    CONSIGNEE_ZIP

    Receiver Postal Code

    VARCHAR(7)

    1000

    ADD_SERVICE_1

    Additional Code / Exception Code*

    VARCHAR(3)

    011

    ADD_SERVICE_2

    Additional Code / Exception Code*

    VARCHAR(3)

    095

    ADD_SERVICE_3

    Additional Code / Exception Code*

    VARCHAR(3)

    096

    ADD_SERVICE_4

    Additional Code / Exception Code*

    VARCHAR(3)

    000

    ADD_SERVICE_5

    Additional Code / Exception Code*

    VARCHAR(3)

    000

    WEIGHT

    Weight in Kilograms

    VARCHAR(8)

    5.50

    VOLUME

    Volume (Length/Width/Height in cm without separator)

    VARCHAR(9)

    050030020

    POD_IMAGE_REF

    Delivery Run Sheet Number

    VARCHAR(15)

    565485

    RECEIVER_NAME

    Signatory Name

    VARCHAR(35)

    John Doe

    INFO_TEXT

    Additional Encoded Information for Scan Type 18*

    VARCHAR(200)

    144:1:infotext@nowhere.com::2:2:DLO:20240701:1216:1:1430:1530::

    LOCATION

    Receiver City

    VARCHAR(35)

    Brussels

    MPSCREF1

    Consignment Customer Reference 1

    VARCHAR(35)

    Ref1

    MPSCREF2

    Consignment Customer Reference 2

    VARCHAR(35)

    Ref2

    MPSCREF3

    Consignment Customer Reference 3

    VARCHAR(35)

    Ref3

    MPSCREF4

    Consignment Customer Reference 4

    VARCHAR(35)

    Ref4

    CREF1

    Customer Reference 1

    VARCHAR(35)

    CustRef1

    CREF2

    Customer Reference 2

    VARCHAR(35)

    CustRef2

    CREF3

    Customer Reference 3

    VARCHAR(35)

    CustRef3

    CREF4

    Customer Reference 4

    VARCHAR(35)

    CustRef4

    CUSTOMER_REFERENCE

    DPD Customer Number

    VARCHAR(12)

    BE1234

    DELISUSR

    DPD Customer Delis User ID

    VARCHAR(12)

    User1234

    *See File Interpretation for more information

  5. File Interpretation

    This section outlines the possible values for the major fields, ensuring proper interpretation of the SCANINFO data:

    Key Categories:

    • Scancodes :

    ScanCode  

    Description

    Detailed Description

    01

    Consolidation

    Processed in sorting depot for further handling.

    02

    Inbound

    Arrived at distribution depot and ready for processing.

    03

    Out for delivery

    Left distribution depot and is being delivered by driver.

    04

    Driver’s return

    Returned to distribution depot after delivery attempt.

    05

    Pick-up

    Arrived at shipping depot for processing

    06

    System return

    Returned to sender or return address

    08

    Warehouse

    Stored in warehouse awaiting further processing or dispatch

    09

    Inbound Exception

    Initiating a new process in distribution depot

    10

    Hub scan

    Processed in sorting depot for further handling

    12

    Customs clearance process

    Processed by customs for international shipping (non-EU)

    13

    Delivered

    Delivered successfully to the consignee by the driver

    14

    Delivery attempt not successful.

    Delivery attempt failed due to an issue (e.g., recipient unavailable)

    15

    Driver’s pick-up

    Picked up by driver at the sender or parcel shop location

    17

    Export/Import cleared

    Cleared for import/export, enabling cross-border movement

    18

    Info scan ( with additional encoded information in the info_text)

    A scan event where additional encoded information is included in the info_text

    20

    Loading

    Loaded onto a truck for transit between depots

    23

    Delivered by driver to DPD ParcelShop

    Delivered by driver to a local DPD ParcelShop for customer pickup

    • Exception Codes :

    Exception code

    Description

    002

    Loading error

    003

    Routing error

    004

    Packaging damaged

    005

    Limited quantities

    006

    Collection-upon-delivery

    007

    Postcode error

    008

    NI processing

    009

    Non-conveyable

    010

    Hazardous goods

    011

    Wrong address

    012

    Refused by consignee – packaging damaged

    013

    Refused by Parcel Shop

    014

    Refused by consignee – not ordered

    015

    Refused by consignee

    016

    Refused by consignee – contents checked, found to be damaged

    017

    Return (pick-up) after wrong delivery

    018

    Exchange / order

    019

    Consignee not present – notified first time

    020

    Self-collecting consignee

    021

    Destruction / confiscated by customs

    022

    Broken in sub-contractor`s custody

    023

    Appointed day of delivery

    024

    Contents checked

    025

    Closed (e.g. department store)

    026

    Exchange / pick-up

    027

    Lack of space

    028

    Competitor

    029

    Consignment incomplete

    030

    Consignee on holiday

    031

    Not system conform

    032

    Lack of time

    033

    Missing, incorrect, incomplete, illegible export documentation

    034

    ORSYmat filling

    035

    Consignee not present, informed, on holiday

    036

    Department delivery

    037

    Consignee not present – notified third time

    038

    Sorting error at recipient depot

    039

    Customs / gateway return

    040

    Delivery to a third party with notification

    041

    Force majeure

    042

    Consignee not present, notified 2nd time

    044

    Small and lightweight parcel

    045

    Tyre

    046

    Amount not paid

    047

    Return third party

    048

    Unpacked tyre

    049

    Customer’s return

    050

    Digicode, access code required

    051

    Reusable box 101

    052

    Reusable box 102

    053

    Reusable box 103

    054

    Reusable box 104

    055

    Reusable box 105

    056

    Reusable box 106

    057

    Documents return

    059

    Private address

    060

    Post Office

    061

    Delay due to unknown reason

    062

    DPD Backbox

    063

    Same-day delivery

    064

    Groupage, envelope

    065

    Delivery on Saturday

    066

    ID check failed

    067

    Signature refused

    068

    Delivery / deposit with non-recurring authority

    069

    Delivery / deposit with general authorisation

    070

    Temperature sensitive

    071

    Customer not informed about collection request

    072

    Parcel not ready for shipment

    073

    Parcel shipped / used by other means

    074

    Customer has less than collection requests ordered

    075

    Identity check

    076

    DPD 8:30

    078

    DPD 10:00

    079

    DPD 12:00

    080

    Appointment scheduled

    081

    Regional public holiday

    082

    Customer has more than the collection request parcels ordered

    083

    Address changed

    084

    Delivery note / order reference missing

    085

    Missing or incorrect data

    086

    No forwarding on the inbound day

    087

    DPD 18:00 / DPD GUARANTEE

    088

    DPD GUARANTEE, DPD 8:30, DPD 10:00, DPD 12:00, DPD 18:00 too late

    089

    Delivery to Mail-/Parcel box (without signature)

    091

    Parcelshop delivery after 1st delivery attempt

    092

    Injected into delivery network

    093

    Preload

    094

    Manual entry

    095

    File import

    096

    Manual follow up

    098

    Print of DPD label

    099

    Canceled

    106

    Incorrect Address

    123

    Others

    160

    Others

    191

    Contactless delivery

    206

    Packaging damaged

    209

    Parcel damaged

    210

    Locker not working/out of order

    211

    Locker full/no free shelfs available

    212

    Parcel too big for locker

    213

    Missing data (at the locker)

    231

    Non-standard parcel (overweight, oversized)

    232

    Temperature

    248

    EORI missing or wrong

    249

    Power of attorney (POA) not provided by consignee

    250

    Return: Holding / storage limit expired

    251

    Parcel lost

    252

    Received, not manifested (overage)

    253

    Manifested, not received (underage)

    254

    Off-loaded

    255

    Flight canceled

    256

    Late arrival – in transit

    257

    Held in Customs: Other reasons

    258

    Value / description of goods required

    259

    Phone number or contact name missing or wrong

    260

    VAT / personal ID no. required

    261

    Prohibited goods

    262

    Customs examination

    263

    Unable to contact consignee

    264

    Pending consignee information or duty payment

    265

    Pending information from origin depot

    266

    Invoice address not destination country

    267

    Invoice not in English

    268

    Declaration of origin is missing on the invoice / without country of origin

    269

    Consignee refuses to pay taxies and duties

    270

    Declaration of origin without signature / without repeating the name legibly

    271

    Return requested by origin country

    272

    Export declaration is missing

    273

    Shipment removed from bag

    274

    Held in Customs: special forwarding required

    275

    Waiting for release by other authority e.g. FDA

    276

    Bag missing

    277

    EUR 1 is missing

    278

    EUR 1 not pre-stamped

    279

    A.TR is missing

    280

    Accompanying documents handed over to consignee’s broker

    281

    Contingency plan applicable – extreme situation

    282

    Missing prealert (SHPNOT)

    283

    Data information corrected manually

    284

    GPS data cannot be calculated

    285

    Payment of duties and taxes or information received

    304

    Door code required

    307

    Not present on first attempt – carded

    311

    Premises closed

    313

    Parcel not ready for shipping

    319

    Parcel refused by consignee

    321

    Parcel refused

    329

    Local holiday

    333

    Incomplete Shipment

    335

    Not present on second attempt – carded

    338

    Parcel already shipped / used by other means

    340

    Sender not informed about collection request

    341

    Sender has less collection requests than ordered

    342

    Sender has more collection request than ordered

    343

    Sender not present

    344

    Failed attempt – carded / notified

    351

    Shipment under customs clearance

    352

    Shipment customs cleared

    353

    Handover gateway

    386

    Order cancelled

    400

    Temperature too high

    401

    Temperature too low

    402

    Parcel destructed/destroyed

    403

    Return parcel at origin depot

    404

    Parcel delivered in transport unit

    405

    storage time exceeded/outdated food

    406

    Handover to third party

    407

    Address error – street name unknown

    408

    Address error – house number wrong/missing

    409

    Address error – consignee moved/unknown

    410

    Adress error – no name at the bell/mail box

    411

    Adress error – incomplete/details missing

    412

    Adress error – building/floor missing

    413

    Return because parcel was not picked up at PUDO

    414

    Cold room storage

    415

    Consignee can’t be informed/notified due to missing/incorrect contact details

    416

    Due date (from FastTrack)

    417

    Lost track (from FastTrack)

    418

    No temperature information available

    507

    Return Requested to Sender

    603

    Force majeure

    609

    Lack of time

    637

    Delayed for unknown reason

    652

    In storage

    655

    Open / Start a bag or a container

    659

    End of the container usage.

    661

    Cleaning /  cleaned

    801

    Destruction

    802

    Quarantine general

    803

    Quarantine DLC passed

    804

    temperature too Low

    810

    Delay In Route

    817

    Is predict stop

    847

    Signature available

    899

    Inflight refusal during the tour

    • Infocontainers (GSMT): Information on additional container-level data.
    • Depot Codes (GRMT): Depot identification codes.
    • Service Codes (GRMT): List of service-specific codes.
    • Country Codes (GRMT): Country identifiers used in parcel routing.

  6. Service code

    These are the most frequently used service codes in DPD Belux:

    101 DPD BUSINESS
    105 DPD BUSINESS (ex works)
    136 DPD BUSINESS (small parcel)
    137 DPD BUSINESS (saturday)
    138 DPD BUSINESS (ex works – small parcel)
    155 DPD EXPRESS 18 GUARANTEE
    158 DPD EXPRESS 18 GUARANTEE (ex works)
    179 DPD EXPRESS 10
    182 DPD EXPRESS 10  (saturday)
    185 DPD EXPRESS 10  (ex works)
    225 DPD EXPRESS 12
    228 DPD EXPRESS 12 (saturday)
    231 DPD EXPRESS 12 (ex works)
    300 DPD RETURN
    327 DPD HOME
    328 DPD HOME (small parcel)
    332 DPD SHOP RETURN
    337 DPD SHOP
    338 DPD SHOP (small parcel)
    365 DPD CLASSIC TYRE
    366 DPD HOME TYRE
    829 DPD HOME (saturday)
    830 DPD HOME (small parcel – saturday)
  7. Additional Exception Codes

    Download: Additional Exception Codes with Scan types

Was this post helpful?(Required)