declaration invoice file upload format

29
Declaration Invoice File Upload format File Declaration Invoice Details & Vehicles File Format Text Attribute Delimiter Comma (,) Quoted Text Identifier Double Quotes (“ “) Remarks One invoice file can be used for One or Many invoices Each Invoice can have many invoice Item Each Invoice Item can have zero or many Permit Each Invoice Item can have zero or many vehicle. Record Type: Invoice Header (IH) Sr. No Attribute Attribute Type Attribute Length MOC Description Value / Example 1. Record Identifier String 2 Invoice Header record Identification “IH” 2. Invoice number String 20 Commercial Invoice Number 3. Invoice date Date Date of issue of Invoice “YYYY-MM-DD” Year Month Date E.g. “2007-12-24” 4. Total number of invoice pages Numeric 3 E.g. 2 etc. 5. Invoice type Numeric 3 Type of invoice For valid codes Refer REF_INVOICE_TYPE 6. Seller’s name String 60 Name of the Seller of the goods 7. Payment instrument Type Numeric 3 To identify how the buyer has agreed to settle the payment to the seller such as TT, Bank LC, cash Transfer. Indication of the method of payment used for settlement of the commercial transaction between the supplier and For valid codes Refer REF_PAYMENT_INST_TYPE

Upload: others

Post on 01-Nov-2021

4 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Declaration Invoice File Upload format

Declaration Invoice File Upload format

File Declaration Invoice Details & Vehicles

File Format Text

Attribute Delimiter Comma (,)

Quoted Text Identifier Double Quotes (“ “)

Remarks One invoice file can be used for One or Many invoices Each Invoice can have many invoice Item Each Invoice Item can have zero or many Permit Each Invoice Item can have zero or many vehicle.

Record Type: Invoice Header (“IH”) Sr. No

Attribute Attribute Type

Attribute Length

MOC Description Value / Example

1. Record Identifier String 2 Invoice Header record Identification

“IH”

2. Invoice number String 20 Commercial Invoice Number

3. Invoice date Date Date of issue of Invoice “YYYY-MM-DD” Year – Month – Date E.g. “2007-12-24”

4. Total number of invoice pages

Numeric 3 E.g. 2 etc.

5. Invoice type Numeric 3 Type of invoice For valid codes Refer REF_INVOICE_TYPE

6. Seller’s name String 60 Name of the Seller of the goods

7. Payment instrument Type Numeric 3 To identify how the buyer has agreed to settle the payment to the seller such as TT, Bank LC, cash Transfer. Indication of the method of payment used for settlement of the commercial transaction between the supplier and

For valid codes Refer REF_PAYMENT_INST_TYPE

Page 2: Declaration Invoice File Upload format

buyer

8. Valuation method

Numeric 3 Method of valuation of goods For valid codes Refer REF_VALUATION_METHOD

9. Invoice currency

String 3 Currency code of the monetary unit associated with an amount involved in the transaction

For valid codes Refer REF_CURRENCY

10. Invoice Value Numeric 16,3 Total value of goods at the invoice level

11. INCO Terms code

String 3 To identify the INCO term under which the seller undertakes to deliver the cargo to buyer such as CIP, CIF, CPT, CFR, DDP, DDU, DEQ, DES, DAF, EXW, FCA, FAS and FOB. Code to indicate applicable delivery terms under which seller undertakes to deliver merchandise to buyer

E.g. “EXW” – Ex Works “FOB” – Free on Board “CPT” – Carriage Paid To etc For valid codes Refer REF_INCOTERM

12. Freight Currency Code

String 3 Freight Currency Code For valid codes Refer REF_CURRENCY

13. Freight charges/ costs

Numeric 16,3 Costs incurred by the shipper in moving the goods, by whatever means, to the port or place of importation/exportation as specified by national legislation.

14. Insurance Currency Code

String 3 Insurance Currency Code For valid codes Refer REF_CURRENCY

15. Insurance charges/ costs

Numeric 16,3 costs incurred by the shipper or consignee to provide insurance for the movement

16. Buyer Name String 60

Buyer Name in English or Arabic

Page 3: Declaration Invoice File Upload format

Record Type: Invoice Details (“ID:) One IH can have one or many ID

Sr. No

Attribute Attribute Type

Attribute Length

MOC Description Value / Example

1. Record Identifier String 2 Record Identifier for Invoice Details

“ID”

2. Invoice Item Line Number

Number 4 Number of the line in the document/ referenced in invoice number

Running sequence no., starting from one. Restart from 1 for each invoice header.

3. Commodity code (hs code) String 812 Harmonized system code. HSCODE

E.g. 90178020 , 96099030 etc

4. Goods description String 255 Description of item

5. Goods Condition

String 1 Used or New “N” for New “U” for Used

6. Statistical Quantity Measurement Unit

String 5 Unit of Quantity For valid codes refer UNIT_MEASUREMENT_QUANTITY

7. Statistical Quantity Number 15,4 Quantity of goods

8. Net Weight Unit

String 5 Unit of Measurement of Weight

For valid code refer UNIT_MEASUREMENT_WEIGHT

9. Net weight

Number 15,4 Net weight of goods at the item level including packing but excluding the carrier’s equipment

10. Supplementary Quantity Measurement Unit

String 5 Unit of Measurement of supplementary quantity

This is field is populated by system based on HS code. Pass Empty string always “”

11. Supplementary Quantity

Number 15,4 Measurement of the goods as

Page 4: Declaration Invoice File Upload format

required by Customs to be expressed for tariff, statistical or fiscal purposes

12. Value of Goods

Number 16,3 Value of the each item in the invoice

13. Country of origin

String 2 Country in which the goods have been produced or manufactured (UN Country code)

For valid code refer REF_COUNTRY

14. Previous Customs declaration reference number

String 15 Reference number of the previous/original declaration

Use only Numbers (ignore formatting char like – etc)

15. Previous Customs declaration Invoice Number

String 20 Previous Invoice Number

16. Previous Customs declaration Invoice line Number

Number 4 Previous Invoice line Number

17. Exemption Type

Numeric 5 To identify any exemption is available other than HS based such as FOC; ADV; Industrial; End user; Free Trade Agreement or other special category. Type of exemption given

For valid code refer EXEMPTION_CODE

18. Exemption Reference Number / Trade Agreement Code

String 30 The reference number provided by the exemption approving authority or custom code of free trade

Page 5: Declaration Invoice File Upload format

agreement

Record Type: Permit Details “PD” One ID can have zero or many PD Optional

Sr. No

Attribute Attribute Type

Attribute Length

MOC Description Value / Example

1. Record Identifier String 2 Record Identifier for Permit Details

“PD”

2. Permit reference Number

String 30 Permit No. provided by the department like Municipality, Ministry of Agriculture etc

3. Permit issuing authority

Number 5 Identification Number of department /ministry/ authority issuing the permit

For valid code refer REF_PERMIT_TYPE

4. Permit Indicator

String 1 Permit Not Required Flag

“Y” or “N”

Record Type: Vehicle Details (“VD”) One ID can have zero or many VD Optional Sr. No

Attribute Attribute Type

Attribute Length

MOC Description Value / Example

1. Record Identifier String 2 Record Identifier for Vehicle Details

“VD”

2. Vehicle Chassis Number

String 24 Vehicle Chassis Number

Page 6: Declaration Invoice File Upload format

3. Vehicle Brand

Numeric 5 Vehicle Brand For valid codes refer REF_VEHICLE_BRAND

4. Vehicle Model

String 60 Vehicle Model “TOYOTO CAMRY”, “LEXUS 400”

5. Vehicle Engine Number

String 30 Vehicle Engine Number

6. Vehicle Engine Capacity (in liters)

Number 6,2 Engine capacity of vehicle in liters

7. Vehicle Passenger Capacity

Number 3 Number of passengers a vehicle can carry.

8. Carriage Capacity

Number 6,2 Load carrying capacity of vehicles in tons

9. Vehicle Year of Built

String 4 Year of manufacture of vehicle

YYYY E.g. “2000”

10. Vehicle Color

String 30 Color of the Vehicle

11. Vehicle Condition

String 4 New/Used Vehicle indicator

“New” for New vehicle “Used” for Used Vehicle

12. Vehicle Type

String 3 Type of vehicle: commercial or personal use.

For valid codes refer REF_VEHICLE_TYPE

13. Vehicle Drive

String 1 Right hand or left hand drive.

“L” for Left “R” for Right

14. Vehicle Specification [STANDARD_CODE

String 100 Specification Standard

“1” for GCC Standard “2” for Non-GCC Standard

Page 7: Declaration Invoice File Upload format

Declaration Vehicle File Upload format

File Declaration Vehicles

File Format Text

Attribute Delimiter Comma (,)

Quoted Text Identifier Double Quotes (“ “)

Record Type: Vehicle Details (“VD”) Sr. No

Attribute Attribute Type

Attribute Length

MOC Description Value / Example

1. Record Identifier String 2 Record Identifier for Vehicle Details

“VD”

2. Vehicle Chassis Number String 24 Vehicle Chassis Number

3. Vehicle Brand

Numeric 5 Vehicle Brand For valid codes refer REF_VEHICLE_BRAND

4. Vehicle Model

String 60 Vehicle Model “TOYOTO CAMRY”, “LEXUS 400”

5. Vehicle Engine Number String 30 Vehicle Engine Number

6. Vehicle Engine Capacity (in liters)

Number 6,2 Engine capacity of vehicle in liters

7. Vehicle Passenger Capacity

Number 3 Number of passengers a vehicle can carry.

8. Carriage Capacity

Number 6,2 Load carrying capacity of vehicles in tons

9. Vehicle Year of Built

String 4 Year of manufacture of vehicle

YYYY E.g. “2000”

10. Vehicle Color String 30 Color of the Vehicle

11. Vehicle Condition

String 4 New/Used Vehicle indicator “New” for New vehicle “Used” for Used Vehicle

12. Vehicle Type

String 3 Type of vehicle: commercial or personal use.

For valid codes refer REF_VEHICLE_TYPE

13. Vehicle Drive

String 1 Right hand or left hand drive. “L” for Left “R” for Right

14. Vehicle Specification [STANDARD_CODE

String 100 Specification Standard “1” for GCC Standard “2” for Non-GCC Standard

Page 8: Declaration Invoice File Upload format

Declaration Container File Upload format

File Declaration Container

File Format Text

Attribute Delimiter Comma (,)

Quoted Text Identifier Double Quotes (“ “)

Record Type: Container Details (“CD”) Sr. No

Attribute Attribute Type

Attribute Length

MOC Description Value / Example

1. Record Identifier String 2 Record Identifier for Vehicle Details

“CD”

2. Container Number

String 15 Container identification number in case of full load cargo Container No. should include Check Digit also.

3. Container Size

Number 2 To collect Container size like ’20 or ’40 in case of full load cargo

Values : “20” or “40”

4. Container Type

Numeric 3 e.g. General Purpose (GP) Reefer (RE) Etc.

For valid codes refer REF_CONTAINER_TYPE

5. Container Seal Number

String 15 Container seal number in case of full load cargo

Page 9: Declaration Invoice File Upload format

Reference Data codes

REF_INVOICE_TYPE

INVOICE_TYPE_ID NAME

1 Commercial Invoice

2 Invoice

3 Pro Forma Invoice

4 Sales Invoice

5 Trade Invoice

6 Other

7 Delivery Invoice

REF_PAYMENT_INST_TYPE

INST_TYPE_ID NAME

1 Cash - Cash Payment

2 T/T - Telex Transfer

3 L/C - Letter of credit

4 EP - Electronic Payment

5 Other

6 Draft

7 Bank transfer

8 DAC(Doc against Accept)

9 DAP(Doc against Payment)

10 Courier

REF_INCOTERM

INCOTERM_ID INCORTERM_CODE

1 CIF

2 CFR

3 FOB

4 FCA

5 CIP

6 CPT

7 DAF

8 DDP

9 DDU

10 DEQ

11 DES

12 EXW

13 FAS

EXEMPTION_CODE

CODE NAME

1001 Police & Military

1002 Diplomatic & Consular

1003 Industrial Exemption

1004 Products of AGCC countries

1005 Not For Local Release

Page 10: Declaration Invoice File Upload format

1006 Used personal effects and new less than 3000 AEDs

1007 Return goods

1008 Short landed goods

1009 Auction goods

1010 Ship shore ship consignments / Transshipment

1012 Goods to be destructed

1013 Charitable societies

1014 Duty to be claimed from other GCC country

1015 Free Trade Agreement

1022 Courier service

1023 Freezone Transit Out

1024 Civil Aircraft Spare Parts to be used in GCC States Airport Zones

1025 Movement controlled by Customs

1026 Accrediated Client

REF_PERMIT_TYPE

PERMIT_TYPE_CODE NAME

1 Ministry of Environment & Water

10 CUSTOMS AUTHORITY

11 DUBAI COMM AND METAL CENTER

12 DUBAI CUSTOMS

13 DUBAI MUNICIPALITY

14 EMIRATES STANDARDIZATION AND SPECIFICATION

15 FEDERAL ENVIRONMENT AGENCY

16 FROM HIS HIGHNESS PRESIDENT

17 GENERAL SECRETARIAT OF MUNCIPALITIES

18 MINISTRY OF ECONOMIC

19 MINISTRY OF FINANCE AND INDUSTRY

2 Dubai Municipality -Food Control Section

20 MINISTRY OF INFORMATION

21 MINISTRY OF POWER

22 NATIONAL INFORMATION OFFICE

23 TELECOMMUNICATIONS REGULATORY AUTHORITY

3 Dubai Police

4 Dubai Municipality-Environment Department

5 Ministry of Interior

6 Ministry of Health

7 National Media Council

8 Central Bank

9 CABINET AFFAIRS

REF_VEHICLE_BRAND

VEHICLE_BRAND_ID VEHICLE_BRAND_NAME

1 ACURA

2 AM GENERAL

3 ASTON MARTIN

4 AUDI

Page 11: Declaration Invoice File Upload format

5 BENTLEY

6 BMW

7 BUICK

8 CADILLAC

9 CHEVROLET

10 CHRYSLER

11 DAEWOO

12 DODGE

13 FERRARI

14 FIAT

15 FORD

16 GENERAL MOTORS

17 GMC

18 HONDA

19 HYUNDAI

20 INFINITI

21 ISUZU

22 JAGUAR

23 JEEP

24 KIA

25 LAND ROVER

26 LEXUS

27 LINCOLN

28 LOTUS

29 MAZDA

30 MERCEDES-BENZ

31 MERCURY

32 MITSUBISHI

33 NISSAN

34 OLDSMOBILE

35 PLYMOUTH

36 PONTIAC

37 PORSCHE

38 ROLLS-ROYCE

39 SAAB

40 SATURN

41 SEAT

42 SUBARU

43 SUZUKI

44 TOYOTA

45 VOLKSWAGEN

46 VOLVO

47 HINO

48 OPEL

49 HILUX

50 CHEROKEE

51 DATSUN

52 RENAULT

Page 12: Declaration Invoice File Upload format

53 DAIHATSU

54 LANCIA

55 SPRINTER

56 GOLF

57 ROVER

58 CATERPILLAR

59 MORRIS

60 CAT

61 CITROEN

62 YAMAHA BIKE

63 DAIMLER

64 PEAUGEOT

65 KOMATSU

66 ALFA ROMEO

67 TCM

68 KAWASAKI

69 MESEFARGSON

70 MEKONG STAR

71 WRANGLER

72 PRIMEMOVER

73 TADANO

74 BOMBERDIER

75 SEEATURN

77 MINI COOPER

78 SMART

79 SSANGYONG

80 RAYMOND

81 KOBELCO

82 KUBOTA

83 RANGE ROVER

84 ELIMINATOR

85 TIANYE

86 PROTON

87 ISEKI

88 SCANIA

89 MG

90 BERTONE

91 MASERATI

92 SAMSUNG

93 HITACHI

94 LAMBORGHINI

95 JCB

96 FREIGHTLINER

97 KATO

99 PERDUA

100 ADMIRAL

101 AERONAUTC HAICE

102 AICHI MANLIFT

Page 13: Declaration Invoice File Upload format

103 ALLIS CHALMERS

104 AMERICAN

105 AMG

106 AMMAN

107 ANKAI

108 APBILIA

109 AQUILA

110 ARIA

111 ASHOK LEYLAND

112 ASIA

113 ATLAS

114 ATOMIX

115 AUSA

116 AUSTIN

117 AWM

118 BAJAJ

119 BAOLI

120 BAOTOU BEISANG

121 BARBER GREEN

122 BAUER

123 BEDFORD

124 BEIFANJ

125 BENFORD

126 BIANCO

127 BITELLI

128 BLAWKNOX

129 BLOW KNIX

130 BMC

131 BOBCAT

132 BOMAG

133 BOSS

134 BOWER

135 BROCE

136 BT

137 BUCHER

138 BUELL

139 BUFORI

140 BUGGY

141 BUSSCAR

142 BUSUN

143 BYD

144 CARBODIES

145 CARMIX1

146 CASAGRANDE

147 CASE

148 CEDARAPIDS

149 CHANA

150 CHANG JIANG

Page 14: Declaration Invoice File Upload format

151 CLARK

152 CLEVELAND

153 CMI

154 COBRA

155 COLES

156 CONDOR

157 CONMEX

158 CPCD

159 CRANE

160 DADIAUTO

161 DAF

162 DALIAN

163 DEMAG

164 DENNIS

165 DESPARADO

166 DITCHWITCH

167 DIV/MAG/EMB

168 DONG FENG

169 DOOSAN

170 DUCATI

171 DYNAPAC

172 EDSEL

173 ESCORTS

174 ESSEX

175 ESSLINGEN

176 EXCALIBUR

177 FAW

178 FERRARA

179 FIATALLIS

180 FORLAND

181 FUDI

182 FUMEC

183 FUQI

184 FURUKAWA

185 FUSHUN

186 FUWACRANE

187 GEHL

188 GENIE

189 GERMAN BOUCHER

190 GINAF

191 GODREJ

192 GOLDEN DRAGON

193 GONOW

194 GREATWALL

195 GRIGIO EXCALIBU

196 GROVE

197 HAIMA

198 HALLA

Page 15: Declaration Invoice File Upload format

199 HAMM

200 HANATOO

201 HANG CHA

202 HANGZHOU

203 HANTA

204 HARLAN

205 HARLEY DAVIDSON

206 HASAROST

207 HAULOTTE

208 HELI

209 HIGER

210 HOFMANN

211 HONGYAN

212 HORMANN

213 HOWO

214 HU-LIFT

215 HUMMER

216 HUSQVARNG

217 HYCO

218 HYOSUNG

219 HYSTER

220 IHI

221 INGERSOLL

222 INTERNATIONAL

223 ISTANA

224 IVECO

225 IVNOVEC

226 JAC

227 JCL

228 JIEFANG

229 JINBEI

230 JINMA

231 JLG

232 JMSTAR

233 JOHN DEERE

234 JR

235 KAI

236 KAITO

237 KALBNAES

238 KALMAR

239 KAMAG

240 KAMAZ

241 KENWORTH

242 KOEHRING

243 KRUPP

244 KTM

245 LADA

246 LAMBRETTA

Page 16: Declaration Invoice File Upload format

247 LANCER BOSS

248 LANSING

249 LEYLAND

250 LIEBHERR

251 LIFAN

252 LIGIER

253 LIMA

254 LINDE

255 LINHAI

256 LINK BELT

257 LIUGONG

258 LOCATELLI

259 LULL

260 LUOYANG

261 MACK

262 MAGRIUS

263 MAHINDRA

264 MAN

265 MANITOU

266 MANITWOC

267 MANJUSTA

268 MARINI

269 MASSEY

270 MAYBACH

271 MAZ TRACTOR

272 MECBO

273 MEIWA

274 MERTZ VIBRATOR

275 MITSU

276 MOL

277 MORGAN

278 MORO TRUCK

279 MOROOKA

280 MOTO GUZZI

281 MTR

282 MUDAN

283 MULTITOR

284 MVAGUSTA

285 NASHAMBASSADOR

286 NASTY BOY

287 NEO PLAN

288 NEWHOLLAND

289 NICHIYU

290 NICHOLAS

291 NIIGATA

292 NIPON - SHARYO

293 NISSEKI

294 NL

Page 17: Declaration Invoice File Upload format

295 NOBLE

296 NORTON COMMANDO

297 NYK

298 O&K

299 ORIENTSTAR

300 OSHKOSH

301 P&H

302 PAGANI

303 PATRICK

304 PEGASUS

305 PENG PU

306 PERLINI

307 PETERBILT MODEL

308 PETTIBONE

309 PHEATON

310 PIAGGIO

311 PICCINI

312 PIPELINE

313 PLATFORM

314 POLARIS

315 POLARSUN

316 POWERPLUS

317 PROFFI

318 PROTEC

319 PUMA

320 PUYUAN

321 QINGQI

322 RANDON

323 RAPTOR

324 RECORD

325 REWACO

326 RHINO

327 RINSPEED

328 ROCKY-D

329 ROSCO

330 SAKAI

331 SANDVIK

332 SANY

333 SARD

334 SAURER

335 SCAMMEL

336 SCHWING

337 SDLG

338 Seadoo

339 SENNEBOGEN

340 SERCEL MERTZ

341 SEWER SANITARY

342 SHAANXI

Page 18: Declaration Invoice File Upload format

343 SHAC

344 SHACMAN

345 SHANTUI

346 SHENYANG LEILON

347 SHIBAURA

348 SHIFENG

349 SHINKO

350 SILLA

351 SILVERWING

352 SINO TRUCK

353 SISU

354 SKID STEER

355 SKODA

356 SMV

357 SOILMEC

358 SOOSUNG

359 SOYAT JUNDA

360 STA

361 STADE

362 STERLING

363 STEYRA

364 STILL

365 STUDEBAKER

366 STYER

367 SUMITOMO

368 SUNVOYAGER

369 SUNWARD

370 SVE

371 TAMROCK

372 TATA

373 TATA DAEWOO

374 TENNANT

375 TEREX

376 TGT

377 THWAITES

378 TIGER

379 TOKYU

380 TOYO

381 TOYOTA SIENNA

382 TRACKJET

383 TRENCHER

384 TRIUMP

385 TRIVELSONDA

386 TRUIMPH

387 TUK TUK

388 UNIVERSAL

389 URAIM

390 URAL

Page 19: Declaration Invoice File Upload format

391 URBANUSS

392 VANTAGE

393 VERMEER

394 VERYCA

395 VESPA

396 VIBRATOR

397 VIBROMAX

398 VMOTO

399 VOGELE

400 VOLAT

401 VOLTAS

402 WATANABE

403 WEICHAI

404 WIGGINS

405 WINDHAM

406 WOMBAT

407 WONJAN

408 WUZHOULONG

409 XCMG

410 XGMA

411 XILIN

412 XINKAI

413 YALE

414 YANMAR

415 YINXIANG

416 YTO

417 YUCHAI

418 BUGATTI

419 AWM MOTOR

420 BELL

421 DONGFENG TRUCK

422 FLATBED TRAILER

423 FOTON

424 FW- MEC50C

425 HOWO TRACTOR

426 HY MAST VL 50H

427 JMC

428 JOHNSTON

429 KYLIN

430 ROYALENFIELD

431 SHENLONG

432 skid fteer

433 TRANS MARK1

434 VIJAY SUPER

435 WACKER

436 ZOOMLION

437 ASTRA

438 WESTERN STAR

Page 20: Declaration Invoice File Upload format

439 KETO

440 AEON

441 VICTORY

442 LEO

443 ORBIT

444 MATADOR

445 CAN-AM

446 SAMAND

447 RENLI

448 KUDO

449 CATERHAM

450 RADICAL

451 VDL

452 CAMC

453 GAOBIDA

REF_VEHICLE_TYPE

VEHICLE_TYPE_CODE VEHICLE_TYPE_DESCRIPTION

2WD 2WD

4WD 4WD

ALT ALL TERRAIN

AUT AUTORIKSHA

BDZ BULLDOZER

BKT BUCKET

BMG BOMAG

BOM BOOM

BUG BUGGY

BUS BUS

CAR CAR

CMP CON. PUMP

CMX CON. MIXER

COM COMPACTOR

CRN CRANE

CRT CART

DGR DRILLING RIG

DMP DUMPER

EXC EXCAVATOR

FIN FINISHER

FRK FORKLIFT

GRD GRADER

HCH HATCHBACK

JEP JEEP

JTS JETSKI

LOD LOADER

MBU MINI BUS

MCY MOTORCYCLE

MTK MINI TRUCK

OTH OTHER

Page 21: Declaration Invoice File Upload format

PAV PAVER

PIK PICK UP

ROL ROLLER

SCT SCOOTER

SHO SHOVEL

STW STATION WAGON

SWP SWEEPE

TRC TRACTOR

TRK TRUCK

TRL TRAILER

VAN VAN

VIB VIBRATOR

WAG WAGON

REF_CONTAINER_TYPE

CONTAINER_TYPE_CODE CONTAINER_TYPE_NAME

DRY Dry

REF Reefer

RTK Road Tanker

SPC Special container

STD Standard

TLR Trailer

TNK Tank

VNT Ventilator

HRF Cub Reefer

HT Half Height

INS Insulator

MAF Mafi Trailer

OS Open Side

OST Open Side Open Top

OT Open Top

BRT Blowthrough Container

CHA Chassis

FLC Flat Rack Container

FLT Flat

HC High Cube

REF_COUNTRY

UN_COUNTRY_CODE NAME

AC AIRCRAFT STORES

AD ANDORRA

AE UNITED ARAB EMIRATES

AF AFGHANISTAN

AG ANTIGUA AND BARBUDA

AI ANGUILLA

AL ALBANIA

AM ARMENIA

AN NETHERLANDS ANTILLES

Page 22: Declaration Invoice File Upload format

AO ANGOLA

AQ ANTARCTICA

AR ARGENTINA

AS AMERICAN SAMOA

AT AUSTRIA

AU AUSTRALIA

AW ARUBA

AX ALAND ISLANDS

AZ AZERBAIJAN

BA BOSNIA AND HERZEGOVINA

BB BARBADOS

BD BANGLADESH

BE BELGIUM

BF BURKINA FASO

BG BULGARIA

BH BAHRAIN

BI BURUNDI

BJ BENIN

BM BERMUDA

BN BRUNEI DARUSSALAM

BO BOLIVIA

BR BRAZIL

BS BAHAMAS

BT BHUTAN

BV BOUVET ISLAND

BW BOTSWANA

BY BELARUS

BZ BELIZE

CA CANADA

CC COCOS (KEELING) ISLANDS

CD CONGO, THE DEMOCRATIC REPUBLIC OF THE (formerly Zaire)

CF CENTRAL AFRICAN REPUBLIC

CG CONGO(REPUBLIC OF CONGO)

CH SWITZERLAND (Confederation of Helvetia)

CI COTE D'IVOIRE (Ivory Coast)

CK COOK ISLANDS

CL CHILE

CM CAMEROON

CN CHINA

CO COLOMBIA

CR COSTA RICA

CU CUBA

CV CAPE VERDE

CX CHRISTMAS ISLAND

CY CYPRUS

CZ CZECH REPUBLIC

DD DUTY FREE

DE GERMANY (Deutschland)

Page 23: Declaration Invoice File Upload format

DJ DJIBOUTI

DK DENMARK

DM DOMINICA

DO DOMINICAN REPUBLIC

DZ ALGERIA

EC ECUADOR

EE ESTONIA

EG EGYPT

EH WESTERN SAHARA (formerly Spanish Sahara)

ER ERITREA

ES SPAIN

ET ETHIOPIA

FI FINLAND

FJ FIJI

FK FALKLAND ISLANDS (MALVINAS)

FM MICRONESIA (Federated States of Micronesia)

FO FAEROE ISLANDS

FR FRANCE

GA GABON

GB UNITED KINGDOM (Great Britain)

GD GRENADA

GE GEORGIA

GF FRENCH GUIANA

GG GUERNSEY

GH GHANA

GI GIBRALTAR

GL GREENLAND

GM GAMBIA, THE

GN GUINEA

GP GUADELOUPE

GQ EQUATORIAL GUINEA

GR GREECE

GS SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS

GT GUATEMALA

GU GUAM

GW GUINEA-BISSAU

GY GUYANA

HK HONG KONG (Special Administrative Region of China)

HM HEARD ISLAND AND MCDONALD ISLANDS

HN HONDURAS

HR CROATIA (Hrvatska)

HT HAITI

HU HUNGARY

ID INDONESIA

IE IRELAND

IL ISRAEL

IM ISLE OF MAN

IN INDIA

Page 24: Declaration Invoice File Upload format

IO BRITISH INDIAN OCEAN TERRITORY

IQ IRAQ

IR IRAN (Islamic Republic of Iran)

IS ICELAND

IT ITALY

JE JERSEY

JM JAMAICA

JO JORDAN (Hashemite Kingdom of Jordan)

JP JAPAN

KE KENYA

KG KYRGYZSTAN

KH CAMBODIA

KI KIRIBATI

KM COMOROS

KN SAINT KITTS AND NEVIS

KP KOREA (Democratic Peoples Republic of North Korea)

KR KOREA (Republic of South Korea)

KW KUWAIT

KY CAYMAN ISLANDS

KZ KAZAKHSTAN

LA LAO PEOPLE'S DEMOCRATIC REPUBLIC

LB LEBANON

LC SAINT LUCIA

LI LIECHTENSTEIN (Furstentum Liechtenstein)

LK SRI LANKA (formerly Ceylon)

LR LIBERIA

LS LESOTHO

LT LITHUANIA

LU LUXEMBOURG

LV LATVIA

LY LIBYA (Libyan Arab Jamahirya)

MA MOROCCO

MC MONACO

MD MOLDOVA

ME MONTENEGRO

MG MADAGASCAR

MH MARSHALL ISLANDS

MK MACEDONIA (Former Yugoslav Republic of Macedonia)

ML MALI

MM MYANMAR (formerly Burma)

MN MONGOLIA

MO MACAO (Special Administrative Region of China)

MP NORTHERN MARIANA ISLANDS

MQ MARTINIQUE

MR MAURITANIA

MS MONTSERRAT

MT MALTA

MU MAURITIUS

Page 25: Declaration Invoice File Upload format

MV MALDIVES

MW MALAWI

MX MEXICO

MY MALAYSIA

MZ MOZAMBIQUE (Mocambique)

NA NAMIBIA

NC NEW CALEDONIA

NE NIGER

NF NORFOLK ISLAND

NG NIGERIA

NI NICARAGUA

NL NETHERLANDS

NO NORWAY

NP NEPAL

NR NAURU

NU NIUE

NZ NEW ZEALAND

OM OMAN

PA PANAMA

PE PERU

PF FRENCH POLYNESIA

PG PAPUA NEW GUINEA

PH PHILIPPINES

PK PAKISTAN

PL POLAND

PM SAINT PIERRE AND MIQUELON

PN PITCAIRN

PR PUERTO RICO

PS PALESTINIAN TERRITORIES

PT PORTUGAL

PW PALAU

PY PARAGUAY

QA QATAR

RE REUNION

RO ROMANIA

RS SERBIA (Republic of Serbia)

RU RUSSIAN FEDERATION

RW RWANDA

SA SAUDI ARABIA (Kingdom of Saudi Arabia)

SB SOLOMON ISLANDS

SC SEYCHELLES

SD SUDAN

SE SWEDEN

SG SINGAPORE

SH SAINT HELENA

SI SLOVENIA

SJ SVALBARD AND JAN MAYEN

SK SLOVAKIA (Slovak Republic)

Page 26: Declaration Invoice File Upload format

SL SIERRA LEONE

SM SAN MARINO (Republic of)

SN SENEGAL

SO SOMALIA

SR SURINAME

SS SHIP STORES

ST SAO TOME AND PRINCIPE

SV EL SALVADOR

SY SYRIAN ARAB REPUBLIC

SZ SWAZILAND

TC TURKS AND CAICOS ISLANDS

TD CHAD (Tchad)

TF FRENCH SOUTHERN TERRITORIES

TG TOGO

TH THAILAND

TJ TAJIKISTAN

TK TOKELAU

TL TIMOR-LESTE (formerly East Timor)

TM TURKMENISTAN

TN TUNISIA

TO TONGA

TR TURKEY

TT TRINIDAD AND TOBAGO

TV TUVALU

TW TAIWAN (Chinese Taipei for IOC)

TZ TANZANIA

UA UKRAINE

UG UGANDA

UM UNITED STATES MINOR OUTLYING ISLANDS

US UNITED STATES

UY URUGUAY

UZ UZBEKISTAN

VA VATICAN CITY (Holy See)

VC SAINT VINCENT AND THE GRENADINES

VE VENEZUELA

VG VIRGIN ISLANDS, BRITISH

VI VIRGIN ISLANDS, U.S.

VN VIET NAM

VU VANUATU

WF WALLIS AND FUTUNA

WS SAMOA (formerly Western Samoa)

YE YEMEN (Yemen Arab Republic)

YT MAYOTTE

ZA SOUTH AFRICA (Zuid Afrika)

ZM ZAMBIA (formerly Northern Rhodesia)

ZW ZIMBABWE

REF_CURRENCY

Page 27: Declaration Invoice File Upload format

CURRENCY_CODE NAME

AED UAE DIRHAM

AFA AFGHANI

AFR CAMEROON FRANC

ALL ALBANIAN

ANG NETH GUILDER

ARS ARGENTINE PESO

ATS AUST SCHILLING

AUD AUSTRALIAN DOLLAR

AWG ARUBAN GUILDER

AZM AZERBAIJAN MANAT

BBD BARBODAS DOLLAR

BDT BANGLA TAKA

BEF BELGIAN FRANC

BGL BULGARIA LEV

BHD BAHRAIN DINAR

BIF BURUNDI FRANK

BMD BERMUDA DOLLAR

BND BRUNEI DOLLAR

BRC BRAZIL CRUZADO

BRR BRAZILIAN REAL

BSD BAHAMAS DOLLAR

BTN NGULTRUM

BUK BURMA KYAT

CAD CANADIAN DOLLAR

CHF SWISS FRANC

CNR CHINA RENMINBI

COP COLOMBIAN PESO

COR NICARGUA CORDBA

CSK CZECH KORUNA

CUP CUBAN PESO

CYP CYPRUS POUND

CZK CZECHKORUNA

DDM GERMAN OUSTMARK

DEM DUESCHE MARK

DJF DJIBOUTI FRANC

DKK DANISH KRONER

DZD ALGERIAN DINAR

ECS ECUAODR SUCER

EGP EGYPTIAN POUND

ESP SPANISH PESTA

ETB ETHIOPIA BIRR

EUR EUROPE UNION

FIM FINLAND MARK

FJD FIJI DOLLAR

FRF FRENCH FRANC

GBP POUND STERLING

GHC GHANA CEDI

Page 28: Declaration Invoice File Upload format

GIP GIBRALTER POUND

GRD GREEK DRACKMA

GTQ GAUTMALA QETZAL

HKD H.K DOLLAR

HNL HONDRAS LEMPIRA

HUF HUNGARY FORINT

IDR INDONESA RUPIAH

IEP IRISH POUND

INR INDIAN RUPEE

IQD IRAQI DINAR

IRR IRANI RIAL

ISK ICELAND KRONA

ITL ITALIAN LIRA

JMD JAMAICAN DOLLAR

JOD JORDAN DINAR

JPY JAPANESE YEN

KES KENYA SHILLING

KIP LAOS KIP

KRW KOREAN WON

KWD KUWAITI DINAR

KZT Kazakhstan Tenge

LBP LEBANESE POUND

LKR SRILANKAN RUPEE

LRD LIBERIAN DOLLAR

LUF LUXEMBORG FRANC

LYD LIBYAN DINAR

MAD MOROCCO DIRHAM

MGF MALACACHE FRANC

MTL MALTA LIRA

MUR MAUR RUPEE

MVR MALDIVE RUFIYAA

MWK MALAWI-KWACHA

MXN MEXICANN PESO

MYR MALAYSIA RINGIT

MZM MOZABIQ METICAL

NA NA

NAD NAMIBIAN DOLLAR

NGN NIGERIAN NAIRA

NIU CORDOBA

NLG DUTCH GUILDER

NOK NORWAY KRONER

NPR NEPAL RUPEE

NZD NZLAND DOLLAR

OMR OMAN RIAL

PAB BALBOA

PHP PHP. PESO

PKR PAK RUPEE

PLZ POLAND ZLOTY

Page 29: Declaration Invoice File Upload format

PTE PORTUGAL ESCUDO

QAR QATAR RIYAL

ROL ROMANIA LEU

RUB RUSSIAN ROUBLE

SAR SAUDI RIYAL

SCR SEYCHELES RUPEE

SDD SUDANESE DINAR

SDP SUDAN POUND

SEK SWEDISH KRONER

SGD SINGPORE DOLLAR

SLL LEONE

SOS SOMALIA SHILING

SUR USSR ROUBLE

SVC EL SALVADOR

SYP SYRIAN POUND

SZL SWAZI LILANGENI

THB THAILAND BHAT

TND TUNISIAN DOLLAR

TRL TURKISH LIRA

TWD TAIWAN DOLLAR

TZS TANZA.SCHILLING

UGX UGAN.SCHILLINGS

USD US DOLLAR

UYP URUGUAY PESO

VEB VENEZULA BOLVER

YDD YEMEN DINAR

YER YEMEN RIYAL

YUD YUGOSLAV DINAR

ZAR SOUTH AFRICA RAND

ZMK ZAMBIA KWACHA

ZRZ ZAIRE

ZWD ZIMBABWE DOLLAR

UNIT_MEASUREMENT_WEIGHT

UNIT_ID NAME

1 kg

2 carat

3 m

4 m2

5 m3

6 l

7 kwh

8 u

9 2u

10 12u

11 1000u

12 pack