declaration invoice file upload format
TRANSCRIPT
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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)
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
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
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)
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
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
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
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