Skip Main Navigation Skip To Navigation Content

Foreign Trade

Skip top of page navigation
You are here: Census.govBusiness & IndustryForeign Trade › U.S. International Trade Data

COMMODITY MASTER RECORD LAYOUT

FIX FORMATED ASCII FILE

A. Section 1 - Exports - 10-digit Schedule B Codes

POSITION DESCRIPTION
1 1-digit identification code = 1
2-11 10-digit numeric Harmonized Commodity Classification Code (Schedule B)
12-13 2-digit filler
14-163 150-digit alphabetic commodity description
164 1-digit filler
165-214 50-digit alphabetic abbreviated commodity description
215 1-digit filler
216-218 3-digit alphabetic abbreviation of 1st unit of quantity. Field is marked with "X" if quantity is not required
219 1-digit filler
220-222 3-digit alphabetic abbreviation of 2nd unit of quantity. Field is blank if not required.
223 1-digit filler
224-228 5-digit Standard International Trade Classification (SITC) code
229 1-digit filler
230-234 5-digit End-use classification as determined by the Bureau of Economic Analysis
235-239 5-digit filler
240-245 6-digit North American Industry Classification System (NAICS) code
246 1-digit Department of Agriculture code:
- '0' = agriculture item
- '1' = Non-agriculture item
247-248 2-digit Advanced Technology Product code

Section 2 - Imports - 10-digit HTSUSA Codes


POSITION DESCRIPTION
1 1-digit identification code = 2
2-11 10-digit numeric Harmonized Commodity Classification Code (HTSUSA).
12-13 2-digit filler
14-163 150-digit alphabetic commodity description
164 1-digit filler
165-214 50-digit alphabetic abbreviated commodity description
215 1-digit filler
216-218 3-digit alphabetic abbreviation of 1st unit of quantity. Field is marked with "X" if quantity is not required
219 1-digit filler
220-222 3-digit alphabetic abbreviation of 2nd unit of quantity. Field is blank if not required
223 1-digit filler
224-228 5-digit Standard International Trade Classification (SITC) code
229 1-digit filler.
230-234 5-digit End-use classification as determined by the Bureau of Economic Analysis
235-239 5-digit filler.
240-245 6-digit North American Industry Classification System (NAICS) code
246 1-digit Department of Agriculture code:
- '0' = agriculture item
- '1' = Non-agriculture item
247-248 2-digit Advanced Technology Product code


C. Section 3 - Exports ENDUSE Descriptions


POSITION DESCRIPTION
1 1-digit identification code = 3.
2-6 1, 2, 3 or 5-digit END USE classification as determined by the Bureau of Economic Analysis. (Depending on the digit, remaining positions will be blank)
7-13 7-digit filler.
14-163 150-digit alphabetic description that corresponds to 1, 2, 3 or 5-digit END USE classification.
164 1-digit filler.
165-214 50-digit alphabetic abbreviation of the 150-digit alphabetic description.
215-248 34-digit filler.

D. Section 4 - Imports ENDUSE Descriptions


POSITION DESCRIPTION
1 1-digit identification code = 4.
2-6 1, 2, 3 or 5-digit END USE classification as determined by the Bureau of Economic Analysis. (Depending on the digit, the remaining positions will be blank).
7-13 7-digit filler.
14-163 150-digit alphabetic description that corresponds to 1, 2, 3 or 5-digit END USE classification.
164 1-digit filler.
165-214 50-digit alphabetic abbreviation of the 150-digit alphabetic description.
215-248 34-digit filler.

E. Section 5 - SITC Descriptions (Related to both Import and Exports)


POSITION DESCRIPTION
1 1-digit identification code = 5.
2-6 1, 2, 3, 4 or 5-digit SITC REV3 code. (Depending on the digit, the remaining positions will be blank).
7-13 7-digit filler.
14-163 150-digit description related to the 1, 2, 3, 4 or 5-digit SITC REV3 code.
164 1-digit filler.
165-214 50-digit alphabetic abbreviation of the 150-digit alphabetic description.
215-248 34-digit filler.

F. Section 6 - HS Commodity Descriptions (Related to both Imports and Exports)


POSITION DESCRIPTION
1 1-digit identification code = 6.
2-7 2, 4 or 6-digit HS code. (Depending on the digit, the remaining positions will be blank).
7-13 6-digit filler.
14-163 150-digit alphabetic description related to 2, 4 or 6-digit HS code.
164 1-digit filler.
165-214 50-digit alphabetic abbreviation of the 150-digit alphabetic description.
215-248 34-digit filler.


G. Section 9 - North American Industry Classification System (NAICS) Descriptions


POSITION DESCRIPTION
1 1-digit identification code = 9.
2-7 2, 3, 4, 5 or 6-digit NAICS Import code. (Depending on the digit, the remaining positions will be blank).
8-13 8-digit filler.
14-163 150-digit alphabetic description related to 2, 3, 4, 5 or 6-digit NAICS code.
164 1-digit filler.
165-214 50-digit alphabetic abbreviation of the 150-digit alphabetic description.
215-248 34-digit filler.

August 2014
Trade Numbers

Deficit: $40.1 Billion
Exports: $198.5 Billion
Imports: $238.6 Billion

Next release: November 4, 2014
Complete Release Schedule

Export Training Videos


Collection of videos to enhance export training.

Upcoming Training

AES Compliance Seminars

Oct 22-23, 2014
New Orleans, LA

Contact Us

Contact the Foreign Trade Data Dissemination staff: Email us! or use our feedback form!

Call us: (301)763-2311 or 1-800-549-0595 option 4

[PDF] or PDF denotes a file in Adobe’s Portable Document Format. To view the file, you will need the Adobe® Reader® Off Site available free from Adobe. [Excel] or the letters [xls] indicate a document is in the Microsoft® Excel® Spreadsheet Format (XLS). To view the file, you will need the Microsoft® Excel® Viewer Off Site available for free from Microsoft®. [MSWord] or the letters [doc] indicate a document is in the Microsoft® Word Format (DOC). To view the file, you will need the Microsoft® Word Viewer Off Site available for free from Microsoft®. This symbol Off Site indicates a link to a non-government web site. Our linking to these sites does not constitute an endorsement of any products, services or the information found on them. Once you link to another site you are subject to the policies of the new site.
Source: U.S. Census Bureau | Foreign Trade | ftdwebmaster@census.gov |  Last Revised: July 12, 2011