[U.S. Census Bureau - Click for Census Home Page]
FOREIGN TRADE STATISTICS: Your Key to Trade [Skip all navigation and go directly to page content]
[Go to the FTD MAIN page.]
[FTD Main Navigation] MAIN: A.E.S. | Reference | Regulations | Statistics | Feedback | Search
[FTD Subject Navigation] REFERENCE: Announcements and Information Papers | Codes | FAQs | Forms | Guides
[ADVERT: USATrade Online - Trade data online]

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 SITC Rev. 3 code.
229 1-digit filler.
230-234 5-digit END USE classification as determined by the Bureau of Economic Analysis.
235 1-digit filler.
236-239 4-digit Standard Industry Classification (SIC) code.
240-245 6-digit filler.
246 1-digit Department of Agriculture code:
- '0' = agriculture item
- '1' = Non-agriculture item
247-248 2-digit filler.


Section 2 - Imports - 10-digit HTSUSA Codes


POSITION DESCRIPTION
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 SITC Rev. 3 code.
229 1-digit filler.
230-234 5-digit END USE classification as determined by the Bureau of Economic Analysis.
235 1-digit filler.
236-239 4-digit Standard Industry Classification (SIC) code.
240-245 4-digit filler.
246 1-digit Department of Agriculture code:
- '0' = agriculture item
- '1' = Non-agriculture item
247-248 2-digit high technology indicator.
- '00' = Not Advanced Technology
- '01' = Biotechnology
- '02' = Life Science
- '03' = Opto-electronics
- '04' = Computers and telecommunications (Information and Communications)
- '05' = Electronics
- '06' = Computer integrated manufacturing (Flexible Manuf.)
- '07' = Material design (Advanced Material)
- '08' = Aerospace
- '09' = Weapons
- '10' = Nuclear


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.

FTD Web News

2009 DATA PRODUCT CHANGES
- U.S. Census Bureau will modify the structure of several data products to accommodate changing technology and user demand.

EXPORT COMPLIANCE SEMINARS AND WORKSHOPS
- The export environment has dramatically changed. Come and understand what it takes to remain compliant, aware and out of trouble.
- See Seminar and Workshop Schedule

2003 AES Option 4 Moratorium
Option 4 Filing Review Process Suspended

AES Compliance Best Practices:
Best Practices for maintaining AES Compliance are now available.

Related Party Database Application:
Time series RELATED PARTY data for specific commodities and countries.

ORDER AND DOWNLOAD FOREIGN TRADE DATA PRODUCTS:
- Online Order Form - FTD DropBox
- Merchandise Trade Downloads

NEW Schedule B Search Engine:
It's new. It's flexible. It has more options.

NEWEST TRADE DATA! Get the basics! Learn more!

Source: FTDWebMaster, Foreign Trade Division, U.S. Census Bureau, Washington, D.C. 20233
Location: MAIN: REFERENCE: [Sub-category]
Created: [day] [month] [year]
Last modified: 09 March 2004 at 11:49:55 AM