U.S. flag

An official website of the United States government

census.gov Notification
Due to the lapse of federal funding, portions of this website are not being updated. Any inquiries submitted via www.census.gov will not be answered until appropriations are enacted.

end of header

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.
X
  Is this page helpful?
Thumbs Up Image Yes    Thumbs Down Image No
X
No, thanks
255 characters remaining
X
Thank you for your feedback.
Comments or suggestions?