Skip Main Navigation Skip To Navigation Content
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: About Foreign Trade | Data | A.E.S. | Regulations | Reference | Definitions | Schedule B | FAQs | 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 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.

FTD Web News


What is required for me to ship charity goods to Haiti?
From GLOBAL REACH: "In order to facilitate the movements of these goods, we offer the following guidance that applies to any goods not requiring a license, such as food, clothing, and medicines." (January 22, 2010)

Foreign Trade has GLOBAL REACH
Foreign Trade has just created and published its official blog, "Global Reach." Visit it to discuss the Foreign Trade Regulations, Export Filing (AES), Trade Data, and other trade related topics. Posts are current and relevant to you as the filer, exporter, data user, or curious blog reader. (January 5, 2010)

FTZ: Guidelines for Submtting Statistical Data (PDF) (1.8 MB)
Guidelines and best practices for fulfilling FTZ's statistical reporting requirements are now available.

NEW EXPORT TRAINING VIDEOS!!!
- Training videos on topics such as the Foreign Trade Regulations, AESDirect, NAFTA, Taxes/Tariffs, Commodities, etc. now available!

2009 Constant Dollar Data
- The Census Bureau identified a processing error that caused incorrect deflators to be applied to the revised data for 2009. The data have been corrected.

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.

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: Codes
Created: March 9, 2009
Last modified: 13 July 2011 at 08:23:51 AM