Specification

CD-R(Trade Statistics)

Magnetic media contains, - statistical number (HS Code), export / import, year & month, abbreviation (country),country code, unit, quantity (current month), value (current month), quantity (cumulative year to date), value (cumulative year to date).

Specification

  1. CD-R(650MB)
  2. File Form : CSV(Comma Separated Values) File
  3. Data : Export : Section No.01 - 22 , Import : Section No.01 - 22
  4. File Name : Export=EX Import=IM
    ex) 2014. MAY/ Export/ Section No.19 = Z201405EX19.CSV
    ex) 2014. MAY/ Export/ Section No.22 = M201405EP22.CSV (in case of Port)

Record Layout(Nation wide trade statistics)

Statistical Number,Export/Import,Month Year,Abbreviation(Country),Country Code,Value (Current Month),Value (Cumulative Year to Date),First Unit (Quantity),First Unit Quantity (Current Month),First Unit Quantity (Cumulative Year to Date),Second Unit (Quantity),Second Unit Quantity (Current Month),Second Unit Quantity(Cumulative Year to Date)

 

7003.19-000,I,201311,"R KOREA",103,4341,12238,,,,"SM",5,23
7003.19-000,I,201311,"CHINA",105,61784,1006007,,,,"SM",4279,72813
7003.19-000,I,201311,"TAIWAN",106,19382,20545,,,,"SM",100,1790
7003.19-000,I,201311,"BELGIUM",208,-,322,,,,"SM",-,154
7003.19-000,I,201311,"FRANCE",210,2020,64927,,,,"SM",27,388
7003.19-000,I,201311,"GERMANY",213,6685,124526,,,,"SM",3491,45989
7003.19-000,I,201311,"SPAIN",218,-,219,,,,"SM",-,147
7003.19-000,I,201311,"ITALY",220,-,254,,,,"SM",-,48
7003.19-000,I,201311,"USA",304,-,7245,,,,"SM",-,1991
7003.19-000,I,201311," TOTAL",990,94212,1236283,,,,"SM",7902,123343
7003.19-000,I,201311,"(E . U)",991,8705,190248,,,,"SM",3518,46726
7003.20-000,I,201311,"USA",304,5060,25335,,,,"SM",577,5204
7003.20-000,I,201311," TOTAL",990,5060,25335,,,,"SM",577,5204
7003.30-000,I,201311,"CHINA",105,-,4943,"SM",-,4750,"KG",-,42196
7003.30-000,I,201311,"GERMANY",213,-,5505,"SM",-,2179,"KG",-,51736
7003.30-000,I,201311," TOTAL",990,-,10448,"SM",-,6929,"KG",-,93932
7003.30-000,I,201311,"(E . U)",991,-,5505,"SM",-,2179,"KG",-,51736

 

Record Layout (by Port)

Port Code,Statistical Number,Export/Import,Month Year,Abbreviation (Country),Country Code,Value (Current Month),Value (Cumulative Year to Date),First Unit (Quantity),First Unit Quantity (Current Month) ,First Unit Quantity (Cumulative Year to Date),Second Unit (Quantity),Secondt Unit Quantity (Current Month) ,Second Unit Quantity (Cumulative Year to Date)

 

100,9304.00-000,I,201311,"R KOREA",103,207,3934,"NO",5,1020,"KG",22,548
100,9304.00-000,I,201311,"CHINA",105,-,236,"NO",-,200,"KG",-,15
100,9304.00-000,I,201311,"TAIWAN",106,1799,8549,"NO",524,6906,"KG",153,2065
100,9304.00-000,I,201311,"DENMARK",204,-,369,"NO",-,2,"KG",-,8
100,9304.00-000,I,201311,"U KING",205,-,284,"NO",-,5,"KG",-,12
100,9304.00-000,I,201311,"GERMANY",213,401,736,"NO",4,6,"KG",6,14
100,9304.00-000,I,201311,"USA",304,1407,5302,"NO",95,475,"KG",35,185
100,9304.00-000,I,201311," TOTAL",990,3814,19410,"NO",628,8614,"KG",216,2847
100,9304.00-000,I,201311,"(E . U)",991,401,1389,"NO",4,13,"KG",6,34
100,9305.10-020,I,201311,"GERMANY",213,-,788,,,,"KG",-,4
100,9305.10-020,I,201311,"SWITZLD",215,-,1645,,,,"KG",-,1
100,9305.10-020,I,201311,"ITALY",220,-,292,,,,"KG",-,13
100,9305.10-020,I,201311,"USA",304,746,9987,,,,"KG",27,338
100,9305.10-020,I,201311,"MEXICO",305,217,217,,,,"KG",3,3
100,9305.10-020,I,201311," TOTAL",990,963,12929,,,,"KG",30,359
100,9305.10-020,I,201311,"(E . U)",991,-,1080,,,,"KG",-,17

 

 

 

A. HS code(statistical number) records XXXX.XX-XXX, as we add period, hyphen and total bytes are 11 bytes.

B. Abbreviation (Country) and unit are quote by double quotation. For example " TOTAL","(E . U)","R KOREA"
C. Unit of first value to the first unit field, second value unit to the second unit filed. Case of only one value, it entered into second unit filed, first unit filed will be blank.

D. MS-DOS is a registered trademark of The Microsoft Corporation in U.S.A..