Data dictionary

This section is Guidance

This data dictionary details each field contained in the bulk datasets that are published on UK Trade Info.

Users of this data dictionary should be aware that it needs to be used in conjunction with the accompanying technical specification documents.

Description of flows

File

January 2009 to December 2020

Jan 2021 onwards

Imports (I)

Imports into UK from countries outside the EU

Imports into UK from countries outside the EU

Exports (E)

Exports from UK to countries outside the EU

Exports from UK to countries outside the EU

plus

Exports from GB to countries inside the EU

Arrivals (A)

Imports in the UK from countries inside the EU

Imports in the UK from inside the EU

Dispatches (D)

Exports from UK to countries inside the EU

Not published in Data Downloads datasets

Explanatory Keys

Key to Flows

Reference

Meaning

I

UK Customs imports

E

UK Customs exports

A

UK arrivals

D

UK dispatches
From January 2021 onwards, no data files will be published for (D) dispatches to the EU

 

* Inclusion of any of the four references above indicates that the field is present and contains data

#

Field present – but contains zeros /spaces

Key to ‘Size & Type’ field

Reference

Meaning

Number (e.g. 4)

Number of characters

A

Alpha

N

Numeric

C

Combined alpha & numeric

e.g. 4N means it is a 4 character numeric field.

Field names A-C

Field name: ACCOUNT-CCYY

Full name: Century and Year of Account

Flow(s): Imports (I), Exports (E)

Size and type: 4N

Description: Identifies the century and year of an item in format CCYY. For non-amendment records this will be the same as the file month; for amendment records it will be the year to which the amendment relates.


Field name: ACCOUNT-MM

Full name: Month of Account

Flow(s): Imports (I), Exports (E)

Size and type: 2N

Description: Identifies the month of account of an item in format MM. For non-amendment records this will be the same as the file month; for amendment records it will be the month to which the amendment relates.


Field name: ADDR-1

Full name: Address-Line 1

Flow(s): Imports (I)

Size and type: 30C

Description: First line of postal address


Field name: ADDR-2

Full name: Address-Line 2

Flow(s): Imports (I)

Size and type: 30C

Description: Second line of postal address


Field name: ADDR-3

Full name: Address-Line 3

Flow(s): Imports (I)

Size and type: 30C

Description: Third line of postal address


Field name: ADDR-4

Full name: Address-Line 4

Flow(s): Imports (I)

Size and type: 30C

Description: Fourth line of postal address


Field name: ADDR-5

Full name: Address-Line 5

Flow(s): Imports (I)

Size and type: 30C

Description: Fifth line of postal address


Field name: CB CODE

Full name: CB Code

Flow(s): Imports (I)

Size and type: 3N

Description: This code denotes items subject to certain customs procedures or belonging to certain duty groups:

01 - EFTA/EEA countries

02 - agreements between EU and Andorra, Albania, Bosnia & Herzegovina, Ceuta, Mellila, Faroes, Occupied Palestinian Territory, Croatia, Israel, FYR Macedonia, Mexico, San Marino, South Africa (Vol 1 pt 7 of Tariff).

03 - Mashraq countries (Vol 1 pt 7 of Tariff)

04 - Maghreb countries (Vol 1 pt 7 of Tariff)

05 - ACP countries

06 - OCT countries

07 - GSP

08 - EU free circulation

09 - re-imported goods

10 - inward processing 11 - not currently in use

11 - outward processing relief

12 - outward processing relief textiles

It is important to note that procedure information relates only to the regime initially declared in the UK. Where a consignment undergoes a subsequent change of procedure, this change will not be reflected.


Field name: CN-Q2

Full name: Combined Nomenclature-2nd Quantity

Flow(s): Imports (I), Exports (E), Arrivals (A), Dispatches (D)

Size and type: 3N

Description: Indicates whether the 2nd quantity is a national (UK) or a Combined Nomenclature (EU) requirement and is relevant when compiling figures similar to those produced by the UK for Eurostat.

000 – No CN 2nd quantity required

200 – CN 2nd quantity required


Field name: COD-ALPHA

Full name: COD alpha

Flow(s): Imports (I), Exports (E), Arrivals (A), Dispatches (D)

Size and type: 2A

Description: Alpha code for Country of Destination (Exports/Dispatches) or Country of Dispatch (Imports/Arrivals). For codes see GOV.UK.

Country of Destination (Exports/Dispatches) - country of ultimate destination. This is the final country to which the goods are being exported from the UK irrespective of any changes to the means of transport en route (provided they are not subject to a commercial transaction in an intermediate country).

Country of Dispatch (Imports/Arrivals) - country from which the goods were originally dispatched to the UK (regardless of transhipment through intermediate countries en route). This is not necessarily the country of origin/manufacture or the last country from which the goods were shipped to the UK. Where a change of ownership occurs en route or where the sale occurs via an intermediary country, the Country of Dispatch is the country where the last commercial transaction took place (i.e. the intermediary country, even though the goods never physically resided in that country).


Field name: COD-SEQUENCE

Full name: COD sequence

Flow(s): Imports (I), Exports (E), Arrivals (A), Dispatches (D)

Size and type: 3N

Description: Numeric sequence for Country of Destination or Country of Dispatch. See above for definition.


Field name: COMCODE

Full name: Commodity code

Flow(s): Imports (I), Exports (E), Arrivals (A), Dispatches (D)

Size and type: 9N

Description: 9 digit commodity code comprising: 1-8 Combined Nomenclature; 9 zero (formerly national sub-division) The following pseudo commodity codes exist for specific categories of trade:

9920 9900 - Parcel Post

9930 2400, 9930 2700 and 9930 9900 - Ships & Aircraft stores with effect from 1.1.02, valid for Customs and Intrastat trade.

9950 0000 Low Value*

9990 9908 Continental Shelf

* aggregated under pseudo code 9950 0000 and cannot be allocated to a specific comcode or to country. For values see OTS Methodology Paper. Consult the UK Trade Tariff or the Combined Nomenclature for a full list of commodity codes and descriptions.

Industrial Plant

With effect from January 2011, HMRC implemented simplified procedures in line with the legislation for the declarations of Industrial Plant (IP). Users are no longer required to gain authorisation for this procedure in writing prior to moving goods.

Traders now submit the declarations for Industrial Plant movements directly using the appropriate 8 digit IP commodity code . The first four digits for this commodity code are always ‘9880’, followed by the fif th and sixth digits which correspond to the HS2 (chapter) heading to which the goods of the component parts belong. The seventh and eighth digits are always 00. The concession is available for Exports, Dispatches and Arrivals.

The following IP codes are as follows: 98806300, 98806800, 98806900, 98807000, 98807200, 98807300, 98807600, 98808200, 98808400, 98808500, 98808600, 98808700, 98809000, 98809400

Quantity requirements are net mass (Q1) only.


Field name: COMMODITY-ALPHA-1

Full name: Commodity code alpha description

Flow(s): Imports (I), Exports (E), Arrivals (A), Dispatches (D)

Size and type: 61A

Description: Description of the commodity code – line 1


Field name: COMMODITY-ALPHA-2

Full name: Commodity code alpha description

Flow(s): Imports (I), Exports (E), Arrivals (A), Dispatches (D)

Size and type: 48A

Description: Description of the commodity code – line 2


Field name: CONTAINER

Full name: Container

Flow(s): Imports (I), Exports (E)

Size and type: 3C

Description: Code identifying goods transported by container:

0 - not in container

1 - in container

‘0’ for Trade Indicator 5 items


Field name: COO-ALPHA

Full name: COO - ALPHA

Flow(s): Imports (I)

Size and type: 2A

Description: Alpha code for Country of Origin. The Country of Origin is the country where the goods were originally produced, which may be different from the Country of Dispatch (Country of Origin will be different from Country of Dispatch if goods have been sold to another country before being consigned to the UK).

This field is mandatory for imports, not required for the rest.


Field name: COO-SEQ

Full name: COO sequence

Flow(s): Imports (I)

Size and type: 3N

Description: Numeric sequence for Country of Origin. See above for definition and usage.


Field name: COUNTRY-ALPHA-COO IMP

Full name: Country of Origin Impure alpha

Flow(s): Imports (I)

Size and type: 2A

Description: Alpha code for Country of Origin (Impure). COO (Impure) is a country of origin definition specified by the EU for transmission of non-EU data to Eurostat. Under this system the declared COO is replaced by the COD when:

  • the goods fall in Chapter 97
  • the COD is an EU country
  • the COO is an EU country

For example:an item with COD ’IE’/ COO ‘US’ would be converted to IE/IE, and COD ‘BR’/ COO ‘FR’ would be converted to BR/BR. This is to prevent double counting by Eurostat when Member State’s statistics are aggregated.


Field name: COUNTRY-SEQ. COO IMP

Full name: Country of Origin Impure sequence

Flow(s): Imports (I)

Size and type: 3C

Description: Numeric sequence corresponding to the COO Impure alpha (COOIMP). See country seq. COO IMP above for definition and usage.

Field names E-I

Field name: ESTIMATED VALUE

Full name: Estimated Value

Flow(s): Arrivals (A), Dispatches (D)

Size and type: 15N

Description: Value of estimated trade at SITC 2 digit level.


Field name: EU/NON-EU–IND

Full name: EU/Non-EU indicator

Flow(s): Imports (I), Exports (E), Arrivals (A), Dispatches (D)

Size and type: 1N

Description: Identifies whether a commodity code is Intrastat, Customs trade or both:

1 = Intrastat only;

2 = Customs only;

0 = both


Field name: EU-MM-OFF

Full name: EU month off

Flow(s): Arrivals (A), Dispatches (D)

Size and type: 2N

Description: Indicates the final month that a commodity code was valid for Intrastat trade.


Field name: EU-MM-ON

Full name: EU month on

Flow(s): Arrivals (A), Dispatches (D)

Size and type: 2N

Description: Indicates the first month that a commodity code was introduced for Intrastat trade. This date remains on the file until the end of the calendar year, when it reverts to zeros


Field name: EU-YY-OFF

Full name: Intrastat year off

Flow(s): Arrivals (A), Dispatches (D)

Size and type: 2N

Description: Indicates the year that a commodity code was discontinued for EU trade. Discontinued commodity codes will remain on the file until the end of the calendar year following the year in which they expired.


Field name: EU-YY-ON

Full name: Intrastat year on

Flow(s): Arrivals (A), Dispatches (D)

Size and type: 2N

Description: Indicates the year that a commodity code was introduced for EU trade. This date remains on the file until the end of the calendar year following the year in which it was introduced. The date reverts to zeros.


Field name: FLAG-ALPHA

Full name: Flag alpha

Flow(s): Imports (I), Exports (E)

Size and type: 2A

Description: Alpha code for the flag of the ship transporting the goods to/from the UK. Same country codes as used for COD/COO (goods not transported by ship are allocated a pseudo country code). Zero for Trade Indicator ‘5’ items.


Field name: FLAG-SEQUENCE

Full name: Flag sequence

Flow(s): Imports (I), Exports (E)

Size and type: 3N

Description: Numeric sequence for the flag (nationality) of the ship. Zero for Trade Indicator ‘5’ items.


Field name: GOLO-ALPHA

Full name: Location alpha

Flow(s): Imports (I), Exports (E) #

Size and type: 3A

Description: Alpha code indicating location of inland clearance (inland clearance depot or inland rail depot) if goods were not cleared at the border. Also used to indicate relevant free zone location for goods entering or leaving freezone. Zero for Trade Indicator ‘5’ items. 


Field name: GOLO-SEQUENCE

Full name: Location sequence

Flow(s): Imports (I), Exports (E) #

Size and type: 3N

Description: Numeric sequence for Location alpha above.


Field name: INDUSTRIAL PLANT-COMCODE

Full name: IP commodity code

Flow(s): Exports (E), Dispatches (D)

Size and type: Exports 15N, Dispatches 9N

Description: With effect from January 2011, a pseudo concessionary comcode beginning 98 used for declaration of high value Industrial Plant. IP comcode appears in this field (Tariff comcode appears in ‘COMCODE’ field –refer to notes on that field for more detailed information).


Field name: INLAND-MOT

Full name: Inland Mode of Transport

Flow(s): Imports (I), Exports (E)

Size and type: 2N

Description: Optional code identifying the mode of transport where there has been an ‘internal’ movement within the Community before goods have been subject to Customs formalities (Imports) or after they have been subject to Customs formalities (Exports). No code will be present where Customs formalities are carried out at point of exit from or entry into the Community, which is the normal situation.(00 for TRADEIND ‘5’ items).

10 -sea transport (not vehicle on ferry)

20 -rail transport

30 -road transport

40 -air transport

50 -mail

70 -fixed installations, e.g. pipeline and Channel Tunnel

80 –inland waterway transport

90 -own propulsion, e.g. imported vehicle driven across land boundary

Field names M-Q

Field name: MODE-OF-TRANSPORT

Full name: Mode of Transport

Flow(s): Imports (I), Exports (E), Arrivals (A) #, Dispatches (D) #

Size and type: 3N

Description: Mode of transport by which goods leave or arrive in the UK.(00 for TRADEIND ‘5’ items).

10 - sea transport (not vehicle on ferry)

20 - rail transport

30 - road transport

40 - air transport

50 - mail

60 - RORO

70 - fixed installations, e.g. pipeline and Channel Tunnel

80 - inland waterway transport

90 - own propulsion, e.g. imported vehicle driven across land boundary


Field name: MONTH-IND

Full name: Month Indicator

Flow(s): Arrivals (A), Dispatches (D)

Size and type: 6N

Description: Indicates the Year and the Month of the estimated item of trade.


Field name: NAME

Full name: Importers’ Name

Flow(s): Imports (I)

Size and type: 105C

Description: The name of the declared importer.


Field name: NATURE-OF-TRANSACTION

Full name: Nature of Transaction

Flow(s): Arrivals (A), Dispatches (D)

Size and type: 3N

Description: Codes used for EU (Intrastat) trade only, describing the type of transaction. Codes have the following meaning:

01 - all transactions involving actual or intended change of ownership.

02 - returned goods and replacement goods

03 - free of charge transactions involving permanent change of ownership.

04 - goods for processing or repair

05- goods returned following process/repair(other than 007)

(no code 006)

07 - joint defence projects or other joint inter-governmental programmes

08 - supply of building materials and equipment as part of a general construction or engineering contract

09 - other transactions

000 - below threshold trade allocations

See Intrastat Public Notice 60 for more. See Section 5 for Below Threshold Trade Allocations


Field name: NET-MASS

Full name: Net Mass

Flow(s): Imports (I), Exports (E), Arrivals (A), Dispatches (D)

Size and type: 14C

Description: Weight of the item in kilograms excluding packaging. Format: Leading sign + 13 digits.


Field name: NO OF CONSIGNMENTS

Full name: Number of consignments

Flow(s): Arrivals (A), Dispatches (D)

Size and type: 12C

Description: Optional field used to indicate the number of consignments. Please note that several consignments may be aggregated.From January 2021, this field will be populated with zeros. Format: Leading sign + 11 digits


Field name: NON-EU-MM-ON

Full name: Non-EU month on

Flow(s): Imports (I), Exports (E)

Size and type: 2N

Description: Indicates the month that a commodity code was introduced for Non-EU trade. This date remains on the file until the end of the calendar year, then reverts to zeros.


Field name: NON-EU-MM-OFF

Full name: Non-EU month off

Flow(s): Imports (I), Exports (E)

Size and type: 2N

Description: Indicates the final month that a commodity code was valid for Non-EU trade.


Field name: NON-EU-YY-ON

Full name: Non-EU year on

Flow(s): Imports (I), Exports (E)

Size and type: 2N

Description: Indicates the year that a commodity code was introduced for Non-EU trade. This date remains on the file until the end of the calendar year following the year of introduction, then reverts to zeros.


Field name: NON-EU-YY-OFF

Full name: Non-EU year off

Flow(s): Imports (I), Exports (E)

Size and type: 2N

Description: Indicates the year that a commodity code was discontinued for Non-EU trade. Discontinued commodity codes will remain on the file until the end of the calendar year following the year in which they expired.


Field name: PCODE

Full name: Postcode

Flow(s): Imports (I)

Size and type: 8C

Description: Postal code within the UK.


Field name: PERIOD-REFERENCE

Full name: Period reference

Flow(s): Arrivals (A), Dispatches (D)

Size and type: 7N

Description: Identifies the month of account of an item in format 0YYYYMM. For non-amendment records this will be the same as the file month; for amendment records and late supplementary declarations it will be the month to which the amendment or supplementary declaration relates.


Field name: PORT-ALPHA

Full name: Port alpha

Flow(s): Imports (I), Exports (E)

Size and type: 3A

Description: Alpha code for the port of import/export.


Field name: PORT-SEQUENCE

Full name: Port sequence

Flow(s): Imports (I), Exports (E)

Size and type: 3N

Description: Numeric code for port of import/export.


Field name: PROCEDURE-CODE

Full name: Procedure code

Flow(s): Imports (I) #, Exports (E)

Size and type: 3N

Description: This identifies specific types of Customs Procedure (codes from 1/1/2015 shown):

1- Normal trade

2 - InwardProcessing

3 - Outward Processing Procedure

4 - Re-export from a warehouse or freezone

5 - Re-export from/after Processing under CustomsControl

6 - Re-export, other. For definitions and previous years, see Table 5.

The import equivalent of these codes is in the CB code field on the import data file.

It is important to note that procedure information relates only to the regime initially declared in the UK. Subsequent changes of procedure will not be reflected.


Field name: QTY 1 ALPHA

Full name: Quantity 1 Alpha

Flow(s): Imports (I), Exports (E), Arrivals (A), Dispatches (D)

Size and type: 3A

Description: Lists the 3 digit abbreviation of the quantity 1 description for the commodity code. See Table 6 for Standard Abbreviations and their meanings.


Field name: QTY 2 ALPHA

Full name: Quantity 2 Alpha

Flow(s): Imports (I), Exports (E), Arrivals (A), Dispatches (D)

Size and type: 3A

Description: Lists the 3 digit abbreviation of the quantity 2 description for the commodity code. See Table 6 for Standard Abbreviations and their meaning.

Field names R-T

Field name: RECORD-TYPE

Full name: Record type

Flow(s): Imports (I), Exports (E), Arrivals (A), Dispatches (D)

Size and type: Imports (I) 3N, Exports (E) 3N, Arrivals (A) 1N, Dispatches (D) 1N

Description: Range 0-3 identifies the kind of suppression record. For a list of the type of record and the suppression code, see Section 7 Suppression and Confidentiality and Tables 1 and 2.


Field name: SITC

Full name: SITC-5

Flow(s): Imports (I), Exports (E), Arrivals (A), Dispatches (D)

Size and type: 5N

Description: Standard International Trade Classification - a United Nations commodity classification system based on a five digit numeric code. Current version is ‘Revision 4’. Each 8 digit Combined Nomenclature code correlates to an SITC 5 digit code. SITC data is commonly published at different levels. Each level is designated as follows:

1 digit - Section

2 digit - Division

3 digit - Group

4 digit - Sub-group

5 digit - Item


Field name: SITC-0

Full name: SITC zero field

Flow(s): Arrivals (A) #, Dispatches (D) #

Size and type: 1N

Description: 1 digit field –value set to 0


Field name: SITC-2

Full name: SITC 2 Digit Divisional Level

Flow(s): Arrivals (A), Dispatches (D)

Size and type: 2N

Description: See description under SITC-5.


Field name: SITC-CONV-A

Full name: SITC conversion A

Flow(s): Imports (I), Exports (E), Arrivals (A), Dispatches (D)

Size and type: 3N

Description: Indicates the necessary conversion to obtain the relevant SITC quantity 1 unit. See Table 4, SITC Quantity Conversions.


Field name: SITC-CONV-B

Full name: SITC conversion B

Flow(s): Imports (I), Exports (E), Arrivals (A), Dispatches (D)

Size and type: 3N

Description: Indicates the necessary conversion to obtain the relevant SITC quantity 2 unit. See Table 4, SITC Quantity Conversions.


Field name: SITC-IND

Full name: SITC Indicator

Flow(s): Imports (I), Exports (E), Arrivals (A), Dispatches (D)

Size and type: 1N

Description: Indicates which quantities should be selected for SITC based outputs:

0 = No quantities

1 = Quantity 1 only

2 = Quantities 1 and 2

4 = Quantity 2 only.


Field name: STAT-VALUE

Full name: Stat Value

Flow(s): Imports (I), Exports (E), Arrivals (A), Dispatches (D)

Size and type: 16C

Description: Invoice or contract price of the goods (£ sterling) as used for statistical purposes. The export value is the cost of the goods to the purchaser abroad. The import value is the value of the goods including the cost, insurance and freight.

Format: Leading sign + 15 digits.


Field name: SUB-GROUP-ARR / DISP IMP / EXP

Full name: SITC Aggregation Indicators

Flow(s): Imports (I), Exports (E), Arrivals (A), Dispatches (D)

Size and type: 1N

Description: Indicators for use in aggregating to SITC 4 (sub group) where these levels contain suppressed commodity codes. Codes indicate what data should be published to be compatible with UK based publications. For a list of standard definitions, see Table 3, SITC Aggregation Indicators.


Field name: SUB-ITEM-ARR DISP IMP EXP

Full name: SITC Aggregation Indicators

Flow(s): Imports (I), Exports (E), Arrivals (A), Dispatches (D)

Size and type: 1N

Description: Indicators for use in aggregating to SITC 5 (item) where these levels contain suppressed commodity codes. Codes indicate what data should be published to be compatible with UK based publications.


Field name: SUITE INDICATOR

Full name: Suite Indicator

Flow(s): Imports (I), Exports (E), Arrivals (A), Dispatches (D)

Size and type: 3N

Description: Identifies commodity codes to be excluded from General and Special trade compilations:

00 - trade commodity codes
03 - no longer used
04 - no longer used
08 - non-monetary gold excluded from General Trade for before 2005:

7108 1100

7108 1200

7108 1310

7108 1380*

7109 0000

7112 3000**

7112 9100**

(up to and including 2004 only –from 2005 these codes fall under suite 00 so 08 is empty).

09 monetary gold and gold coin excluded from General and Special Trade.

SUITE is used in conjunction with TRADEIND to compile General and Special trade. See Section 3 General and Special Trade.


Field name: SUPP-ARRIVALS DISPATCHES IMPORTS EXPORTS

Full name: Suppression code

Flow(s): Imports (I), Exports (E), Arrivals (A), Dispatches (D)

Size and type: 2C

Description: Indicates whether the commodity code is subject to suppression and the level of suppression which applies (2 character field, leading sign + 1 digit):

0 - no suppression

1 - complete suppression

2 - suppression of countries and ports

3 - suppression of countries, ports & total trade 


Field name: SUPPUNIT

Full name: Supp Unit

Flow(s): Imports (I), Exports (E), Arrivals (A), Dispatches (D)

Size and type: 14C

Description: Second quantity (e.g. number) required for certain commodities, as specified in the Tariff / Combined Nomenclature.

Format: Leading sign + 13 digits.


Field name: TRADE-IND

Full name: Trade Indicator

Flow(s): Imports (I), Exports (E), Arrivals (A), Dispatches (D)

Size and type: 1N

Description: A code used to identify the type of trade. Code is used in conjunction with Suite Indicator to select appropriate items for General and Special trade compilations. Indicators are:

Imports & Arrivals

5 removal from warehouse into free circulation

4 import into warehouse (goods not in free circulation)

0 all other items

Exports & Dispatches

1 exports from warehouse (goods not in free circulation)

0 all other items

See Section 3 General and Special Trade.