1. Localizations for European Reporting and SEPA Processing Implementation Guide
  2. Electronic Format

Electronic Format

Use the UK SEMDEC Interface program (R0018I4) to create a flat file in the SEMDEC message format, which can be submitted to HM Customs and Excise on a diskette.

Note: The SEMDEC message format combines the information from the Intrastat Revision table that is required for the declaration of Intra EU Trade Statistics and the EU Sales List.

Businesses in the United Kingdom do not need to submit the EU Sales List report.

When you submit the UK SEMDEC Interface program (R0018I4) to create the EU Sales List, the system submits the SEMDEC Interface - Intra EU Trade Statistics program (R0018I41) to create the Intra EU Trade Statistics report.

You must use the Text File Processor tool to create a flat file in the SEMDEC message format that contains the EU Sales List and Intra EU Trade Statistics information. Text File Processor information is stored in these files:

  • F007101 - Text Processor Header

  • F007111 - Text Processor Detail

You must use the Text File Processor program (P007101) to copy the text batch that is generated by the SEMDEC Interface programs (R0018I4 and R0018I41) to a flat file that you can submit to HM Customs and Excise.

HM Customs and Excise provides these file names for the flat file in the SEMDEC message format:

  • KEDCSD.TRX - use for live data.

  • KEDCSD.TST - use for test data.

You should use these names when you copy the SEMDEC text batch in the Text File Processor.

Important: HM Customs and Excise rejects any submission that contains lowercase letters. Verify that the company name has been entered in all uppercase letters in the Companies program (P0010), or enter the company name in the processing options of the SEMDEC Interface program (R0018I4).