File Format

File upload description

The data in the table below depicts the columns/fields in the bulk file upload format for creating safety and security declarations.

Column 1: Depicts the field name

Column 2: Describes whether the field is Mandatory (M)/ Conditional (C)/ Optional (O)

Column 3: Describes the data format and expected value for relevant field

Column 4: Describes any conditions applicable on the field name

Column 5: Briefly describes the field usage

Field Name

Format/Expected Value

Condition

Description

Declaration Seq

Integer (5)

Number of declarations trying to upload

IsDraft

Boolean (Yes or No)

To be selected as Yes or No

Whether a declaration is to be saved in draft mode

Declaration Country

Alphanumeric (2)

Country code Format provided in Country Code Table (e.g., GB, FR)

Country where filing a declaration

Declaration Place

Alphanumeric (35)

Place where filing a declaration

Declarant EORI

Alphanumeric (18)

EORI of Declarant

Declarant Branch

Alphanumeric (10)

Declarant Branch Name/Code

Commercial Reference Number

Alphanumeric (7

Office of First Entry

Alphanumer

Office code Format provided in Office of First Entry Table If not a part of the file, then free text to be entered with max of 8 characters

1st Entry Office Code

Office of Lodgement

Place of the declaration lodging office

Arrival Date

DD/MM/YYYY

Date when Arriving

Arrival Time

HH:MM:SS

Time of Arrival

Transport Mode at Border

1 - Sea Transport 2 - Rail Transport 3 - Road Transport 4 - Air Transport 5 - Postal Consignment 7 - Fixed Transport Installations 8 - Inland Waterway Transport 9 - Own Propulsion 10 - RoRo Accompanied 11 - RoRo Unaccompanied

User to enter one of these values

Mode of transporting Goods

Nationality of Transport

Alphanumeric (2)

Country code Format provided in Country Code Table (e.g., GB, FR)

Nationality Country

Transport Id

Alphanumeric (27)

ID/Number of the Transport Document used by user

Transport Ref No

Alphanumeric (27)

This field is the identification of the journey of the means of transport

Specific Circumstance Indicator

A - Postal and express consignment B - Ship and Aircraft Supplies C - Road mode of transport D - Rail mode of transport E - Authorised Economic Operators

User to enter one of these values

This is Consignment mode of Transport

Transport MOP

A - Payment in Cash B - Payment by Credit Card C - Payment by Cheque D - Other (e. g. direct debit to cash account) H - Electronic Credit Transfer Y - Account Holder with Carrier Z - Not Pre-Paid

User to enter one of these values

Payment mode used by declarant

Place of Loading

Alphanumeric (35)

Place of the loading port

Place of Unloading

Alphanumeric (35)

Place of the unloading port

Carrier EORI

Alphanumeric (18)

Carrier Name, Street, Country, City and Postcode Details

EORI number of the Carrier

Carrier Name

Alphanumeric (35)

Name of Carrier

Name of Carrier

Carrier Street

Alphanumeric (35)

Street name of the address of Carrier

Carrier Country

Alphanumeric (2)

Country code Format provided in Country Code Table (e.g., GB, FR)

Country of the Carrier, to be entered in Country Code Format (e.g., GB)

Carrier City

Alphanumeric (35)

City where Carrier resides

Carrier Postcode

Alphanumeric (9)

Postcode of address of Carrier, to be entered in Post code format (e.g., W1A 0AX, B33 8TH)

Consignor EORI

Alphanumeric (18)

EORI number of the Consignor

Consignor Name

Alphanumeric (35)

Name of Consignor

Consignor Street

Alphanumeric (35)

Street name of the address of Consignor

Consignor Country

Alphanumeric (4)

Country code Format provided in Country Code Table (e.g., GB, FR)

Country of the Consignor,

Consignor City

Alphanumeric (35)

City where Consignor resides

Consignor Postcode

Alphanumeric (9)

Post code format (e.g., W1A 0AX, B33 8TH)

Postcode of address of Consignor,

Consignee EORI

Alphanumeric (18)

EORI number of the Consignee

Consignee Name

Alphanumeric (35)

Name of Consignee

Consignee Street

Alphanumeric (35)

Street name of the address of Consignee

Consignee Country

Alphanumeric (2)

Country code Format provided in Country Code Table (e.g., GB, FR)

Country of the Consignee,

Consignee City

Alphanumeric (35)

City where Consignee resides

Carrier Country

Alphanumeric (2)

Country of the Carrier, to be entered in Country Code Format (e.g., GB)

Carrier City

Alphanumeric (35)

City where Carrier resides

Carrier Postcode

Alphanumeric (9)

Postcode of address of Carrier, to be entered in Post code format (e.g., W1A 0AX, B33 8TH)

Consignor EORI

Alphanumeric (18)

EORI number of the Consignor

Consignor Name

Alphanumeric (35)

Name of Consignor

Consignor Street

Alphanumeric (35)

Street name of the address of Consignor

Consignor Country

Alphanumeric (4)

Country code Format provided in Country Code Table (e.g., GB, FR)

Country of the Consignor,

Consignor City

Alphanumeric (35)

City where Consignor resides

Consignor Postcode

Alphanumeric (9)

Post code format (e.g., W1A 0AX, B33 8TH)

Postcode of address of Consignor,

Consignee EORI

Alphanumeric (18)

EORI number of the Consignee

Consignee Name

Alphanumeric (35)

Name of Consignee

Consignee Street

Alphanumeric (35)

Street name of the address of Consignee

Consignee Country

Alphanumeric (2)

Country code Format provided in Country Code Table (e.g., GB, FR)

Country of the Consignee,

Consignee City

Alphanumeric (35)

City where Consignee resides

Person Lodging Summary Declaration Country

Alphanumeric (2)

Country code Format provided in Country Code Table (e.g., GB, FR)

Country of the Person Lodging Summary Declaration

Person Lodging Summary Declaration City

Alphanumeric (35)

City where Person Lodging Summary Declaration resides

Person Lodging Summary Declaration Postcode

Alphanumeric (9)

Post code format (e.g., W1A 0AX, B33 8TH)

Postcode of address of Person Lodging Summary Declaration

Total Items

Integer (5)

Total Number of Items in Declaration

Total No of Packages

Integer (5)

Total Number of Packages in Declaration

Total Gross Weight (Kg)

Decimal (11)

Max of 11 Numerical; 8 before decimal and 3 after decimal e.g., 12345678.123

Total Weight of all items and Packages

Seal Id

Alphanumeric (20)

This is a container seal number

Itinerary

Alphanumeric (2)

Country code Format provided in Country Code Table. Min of 2 countries entered to be separated by a semi colon (;) (e.g., GB;FR)

Itinerary Country

Office of Subsequent Entry

Alphanumeric (8)

Office code Format provided in Office of Subsequent Entry Table If not a part of the file, then free text to be entered with max of 8 characters

Name/Code of the office of subsequent Entry

Item Seq

Integer (5)

No of Items

Commodity Code

Alphanumeric (8)

Code of the commodity transporting

UNDG Code

Alphanumeric (4)

Code of the Dangerous goods

Item Reference

Alphanumeric (35)

This field is a user defined reference number for a particular item

Item Gross Weight

Decimal (11)

Max of 11 Numerical; 8 before decimal and 3 after decimal e.g., 12345678.123

Total Weight of the Item

Item Goods Description

Alphanumeric (280)

Brief Description for the goods being transported

Item Transport MOP

A - Payment in Cash B - Payment by Credit Card C - Payment by Cheque D - Other (e. g. direct debit to cash account) H - Electronic Credit Transfer Y - Account Holder with Carrier Z - Not Pre-Paid

User to enter one of these values

Payment mode

Item Place of Loading

Alphanumeric (35)

Place of the loading port

Item Place of Unloading

Alphanumeric (35)

Place of the unloading port

Item Commercial Reference No

Alphanumeric (70)

Item Special Mention

Alphanumeric (5)

Special Mention code format (e.g., IB12, 12WA)

Special Mentioned Code for the Item

Item Document Type

Alphanumeric (4)

As displayed in Column "Document Code" in the Document Type Table

Type of Document required

Item Document Ref

Alphanumeric (35)

Reference number/text for the added item's document

Item Nat of Means of Trans

Alphanumeric (2)

Country code Format provided in Country Code Table (e.g., GB, FR)

Nationality Country

Item Id of Means of Trans

Alphanumeric (27)

ID/Number of the Transport Document used by user

Item Package Type

Alphanumeric (280)

As displayed in Column "Package Type Value" in the Package Code Table

Package code of the Item

Item No of Packages

Integer (5)

Number of Packages for that Item

Item No of Pieces

Integer (5)

Number of Pieces for that Item

Item Marks and Numbers

Alphanumeric (140)

Marks and Numbers description for that Item

Item Container Number

Alphanumeric (17)

Container number for the item

Item Consignor EORI

Alphanumeric (18)

EORI number of the Consignor

Item Consignor Name

Alphanumeric (35)

Name of Consignor

Item Consignor Street

Alphanumeric (35)

Street name of the address of Consignor

Item Consignor Country

Alphanumeric (4)

Country code Format provided in Country Code Table (e.g., GB, FR)

Country of the Consignor,

Item Consignor City

Alphanumeric (35)

City where Consignor resides

Item Consignor Postcode

Alphanumeric (9)

Post code format (e.g., W1A 0AX, B33 8TH)

Postcode of address of Consignor,

Item Consignee EORI

Alphanumeric (18)

EORI number of the Consignee

Item Consignee Name

Alphanumeric (35)

Name of Consignee

Item Consignee Street

Alphanumeric (35)

Street name of the address of Consignee

Item Consignee Country

Alphanumeric (2)

Country code Format provided in Country Code Table (e.g., GB, FR)

Country of the Consignee,

Item Consignee City

Alphanumeric (35)

City where Consignee resides

Item Consignee Postcode

Alphanumeric (9)

Post code format (e.g., W1A 0AX, B33 8TH)

Postcode of address of Consignee

Item Notify EORI

Alphanumeric (18)

EORI number of the Notify Party

Item Notify Name

Alphanumeric (35)

Name of Notify Party

Item Notify Street

Alphanumeric (35)

Street name of the address of Notify Party

Item Notify Country

Alphanumeric (2)

Country code Format provided in Country Code Table (e.g., GB, FR)

Country of the Notify Party

Item Notify City

Alphanumeric (35)

City where Notify Party resides

Item Notify Postcode

Alphanumeric (9)

Post code format (e.g., W1A 0AX, B33 8TH)

Postcode of address of Notify Party

Last updated