Post-Brexit: making MPSEXPDATA Brexit-compliant

Please be warned: due to the high uncertainties concerning the Brexit, this page is very susceptible to changes!

 

In order to make your MPSEXPDATA Brexit-compliant, a few changes need to be kept in mind.

General changes and points of attention

INTER and in some cases, INTERINVOICELINE line become mandatory. More details in separate points below. For the fields outside INTER and INTERINVOICE, these become mandatory if the shipment has UK as destination:

  • HEADER line, MPSWEIGHT: total weight of your shipment, in decagrams (ex. 3.5 kilo is value 300)
  • HEADER line, SPHONE : phone number of the Sender
  • HEADER line, SSTREET: this field must include both the Sender street and the Sender house number
  • HEADER line, SEMAIL : email address of the Sender
  • HEADER line, RSTREET: this field must include both the Receiver street and the Receiver house number
  • HEADER line, RPHONE: phone number of the Receiver is mandatory unless REMAIL is given
  • HEADER line, REMAIL: phone number of the Receiver is mandatory unless RPHONE is given
    So only one of both fields, RPHONE or REMAIL is mandatory.

 

INTER line

Please kindly refer to the INTER line chapter located here.

 

INTERINVOICELINE line

Please kindly refer to the INTERINVOICELINE line chapter located here for more details on it's content.

 

Concrete example

We'll use a very simple example to make it easier to understand. Let's say you ship toys. Assume the following scenarios:

You're shipping a box containing 100 little toy cars. All have the same HS Code (9503.00.95). This means you're only selling one type of item.
Only one HS code so no INTERINVOICELINE is needed.

However, let's say you're shipping a box that contains 100 little toy cars and 250 wooden toy blocks: the toy cars have HS code 9503.00.95 and the wooden blocks have HS code 9503.00.39.90. Both originate from Belgium and the box with toy cars has gross weight 3 kilo and net weight 2.7 kilo. The box with wooden blocks has gross weight 5 kilo and net weight 4 kg.
You're shipping hundreds of toys in total in this shipment, but that doesn't really matter. What matters is that you have two different HS codes, one for the blocks and one for the cars. 
Two different HS codes, so two INTERINVOICELINE lines are needed.

We'll put the example in MPSEXP data:

QITEMS CCONTENT CTARIF CAMOUNTLINE CORIGIN CNETWEIGHT CGROSSWEIGHT
100 Toy cars 95030095 3489 056 270 300
250 Wooden Toy Blocks 9503003990 5242 056 400 500

 

Full MPSEXPDATA for these examples

This example will assume that the box of 100 toy cars has a value of 75 Euros and the box with 250 wooden blocks has a value of 95 Euros.

Only the box of 100 toy cars

#FILE;KD160145SQ;0530;20190827;151601;1;
#DEF;MPSEXP:HEADER;MPSID;MPSCOMP;MPSCOMPLBL;MPSCREF1;MPSCREF2;MPSCREF3;MPSCREF4;MPSCOUNT;MPSVOLUME;MPSWEIGHT;SDEPOT;SCUSTID;SCUSTSUBID;DELISUSR;SNAME1;SNAME2;SSTREET;SHOUSENO;SCOUNTRYN;SPOSTAL;SCITY;SCONTACT;SPHONE;SFAX;SEMAIL;SCOMMENT;SILN;CDATE;CTIME;CUSER;HARDWARE;RDEPOT;ESORT;RCUSTID;RNAME1;RNAME2;RSTREET;RHOUSENO;RCOUNTRYN;RSTATE;RPOSTAL;RCITY;RCONTACT;RPHONE;RFAX;REMAIL;RCOMMENT;RILN;MPSSERVICE;MPSSDATE;MPSSTIME;LATEPICKUP;UMVER;UMVERREF;PODMAN;;
#DEF;MPSEXP:PARCEL;MPSID;PARCELNO;CREF1;CREF2;CREF3;CREF4;DELISUSR;SERVICE;VOLUME;WEIGHT;HINSURE;HINSAMOUNT;HINSCURRENCY;HINSCONTENT;;
#DEF;MPSEXP:INTER;MPSID;PARCELNO;PARCELTYPE;CAMOUNT;CURRENCY;CTERMS;CCONTENT;CTARIF;CPAPER;CCOMMENT1;CCOMMENT2;CSTATUS;CENCLOSURE;CAMOUNTP;CINVOICE;CINVOICEDATE;CORIGIN;CAMOUNTLINE;CNAME1;CNAME2;CSTREET;CHOUSENO;CCOUNTRYN;CPOSTAL;CCITY;CCONTACT;CPHONE;CFAX;CEMAIL;CILN;CVATNO;CNUMBER;LINEHAUL;KNOWNCONSIGNOR;SHIPMRN;CCC;QITEMS;CINVOICEPOSITION;CGATEWAYEXP;CEORI;SINAME1;SINAME2;SISTREET;SICOUNTRYN;SIPOSTAL;SICITY;SICONTACT;SIPHONE
HEADER;MPS0530800132970620190827;2;1;2348414745;;;;1;;300;0530;05300000000262500;;KD160145SQ;Testsender;;Teststreet 55;;056;2800;Mechelen;;+3215000001;;iamthesender@sendercompany.be;;;;;;K;;;;Mr. Testreceiver;;Test Avenue 2;;826;;HA71PH;Stanmore;Mr.Test;+447872027717;;mister.receiverintheuk@gmail.com;;;101;20190827;;;;;;
PARCEL;MPS0530800132970620190827;05308001329706;2348414745;;;;KD160145SQ;101;;;;;;;
INTER;MPS0530800132970620190827;05308001329706;P;7500;EUR;06;Toy Cars;61124190;;;;C11;;7500;;;56;;Mr. Testreceiver;;Test Avenue 2;;826;HA71PH;Stanmore;Mr.Receiver;+447872027717;;mister.receiverintheuk@gmail.com;;GB 1234567;;;;This is the MRN;;1;;;123456789 B01;Invoice Consignor Name;;;056;2800;;;

 

Both the box of toy cars and the box of wooden toy blocks

The total weight of this shipment will be a sum of the weight of both boxes, obviously. So in this case: 3 kg + 5 kg = 8 kg.
Likewise, the total value of this shipment will be a sum of the value of both boxes: €75 + €95 = €170 

 

#FILE;KD160145SQ;0530;20190827;151601;1;
#DEF;MPSEXP:HEADER;MPSID;MPSCOMP;MPSCOMPLBL;MPSCREF1;MPSCREF2;MPSCREF3;MPSCREF4;MPSCOUNT;MPSVOLUME;MPSWEIGHT;SDEPOT;SCUSTID;SCUSTSUBID;DELISUSR;SNAME1;SNAME2;SSTREET;SHOUSENO;SCOUNTRYN;SPOSTAL;SCITY;SCONTACT;SPHONE;SFAX;SEMAIL;SCOMMENT;SILN;CDATE;CTIME;CUSER;HARDWARE;RDEPOT;ESORT;RCUSTID;RNAME1;RNAME2;RSTREET;RHOUSENO;RCOUNTRYN;RSTATE;RPOSTAL;RCITY;RCONTACT;RPHONE;RFAX;REMAIL;RCOMMENT;RILN;MPSSERVICE;MPSSDATE;MPSSTIME;LATEPICKUP;UMVER;UMVERREF;PODMAN;;
#DEF;MPSEXP:PARCEL;MPSID;PARCELNO;CREF1;CREF2;CREF3;CREF4;DELISUSR;SERVICE;VOLUME;WEIGHT;HINSURE;HINSAMOUNT;HINSCURRENCY;HINSCONTENT;;
#DEF;MPSEXP:INTER;MPSID;PARCELNO;PARCELTYPE;CAMOUNT;CURRENCY;CTERMS;CCONTENT;CTARIF;CPAPER;CCOMMENT1;CCOMMENT2;CSTATUS;CENCLOSURE;CAMOUNTP;CINVOICE;CINVOICEDATE;CORIGIN;CAMOUNTLINE;CNAME1;CNAME2;CSTREET;CHOUSENO;CCOUNTRYN;CPOSTAL;CCITY;CCONTACT;CPHONE;CFAX;CEMAIL;CILN;CVATNO;CNUMBER;LINEHAUL;KNOWNCONSIGNOR;SHIPMRN;CCC;QITEMS;CINVOICEPOSITION;CGATEWAYEXP;CEORI;SINAME1;SINAME2;SISTREET;SICOUNTRYN;SIPOSTAL;SICITY;SICONTACT;SIPHONE
#DEF;MPSEXP:INTERINVOICELINE;MPSID;CINVOICEPOSITION;QITEMS;CCONTENT;CTARIF;CAMOUNTLINE;CORIGIN;CNETWEIGHT;CGROSSWEIGHT
HEADER;MPS0530800132970620190827;2;1;2348414745;;;;1;;800;0530;05300000000262500;;KD160145SQ;Testsender;;Teststreet 55;;056;2800;Mechelen;;+3215000001;;iamthesender@sendercompany.be;;;;;;K;;;;Mr. Testreceiver;;Test Avenue 2;;826;;HA71PH;Stanmore;Mr.Test;+447872027717;;mister.receiverintheuk@gmail.com;;;101;20190827;;;;;;
PARCEL;MPS0530800132970620190827;05308001329706;2348414745;;;;KD160145SQ;101;;;;;;;
INTER;MPS0530800132970620190827;05308001329706;P;17000;EUR;06;Toys;61124190;;;;C11;;17000;;;56;;Mr. Testreceiver;;Test Avenue 2;;826;HA71PH;Stanmore;Mr.Receiver;+447872027717;;mister.receiverintheuk@gmail.com;;GB 1234567;;;;This is the MRN;;1;;;123456789 B01;Invoice Consignor Name;;;056;2800;;;
INTERINVOICELINE;MPS0530800132970620190827;;100;Toy cars;95030095;3489;056;270;300
INTERINVOICELINE;MPS0530800132970620190827;;250;Wooden Toy Blocks;9503003990;5242;056;400;500

Submitted by CustomerIT on Mon, 08/05/2019 - 14:11