U.S. flag

An official website of the United States government


end of header

SPI DATA BANK RECORD LAYOUT

FIX FORMATTED ASCII FILE

RECORD LENGTH: 178

POSITION FIELD NAME DESCRIPTION
1-10 HS 10-digit harmonized commodity classification code (HTSUSA number).
11-14 COUNTRY 4-digit country of origin code (Schedule C).
15-16 COUNTRY SUBCODE 2-digit country subcode.
- '00' = Country of origin
- '01' = Country of shipment, country of origin unknown
- 'A ' = All Developing Beneficiary Countries; Eligible for All Articles (GSP)
- 'A*' = Certain Develping Beneficiary
Countries; Not Eligible for Specific Articles (GSP)
- 'A+' = All Least Develped Beneficiary
Countries; Eligible for All Articles (GSP)
- 'B ' = Automotive Products Trade Act (APTA)
- 'C ' = Agreement on Trade in Civil Aircraft
- 'CA' = NAFTA goods marked as Canada
- 'CL' = Products of Chile under designated
provision of the HTSUSA (New 01/2004)
- 'D ' = African Growth and Opportunity Act (New 01/2001)
- 'E ' = All articles elibible under designated provision of the HTSUSA (CBI)
- 'E*' = Articles or specific countries not eligible under the designated provision of the
HTSUSA (CBERA)
- 'IL' = Israel Free Trade Area Implementation Act
- 'J ' = Articles eligible from beneficiary countries under provision of the HTUSA (ATPA)
- 'J*' = Articles eligible from beneficiary countries under provision of the HTUSA with
execptions(ATPA)
- 'J+' = Articles elsibible from beneficiary countries under provision of the HTSUSA (ATPA)
- 'JO' = Jordon free Trade Act of 2002
- 'K ' = Agreement on Trade in Pharmaceutical Products
- 'L ' = Concessions on Intermediate Chemicals for Dyes
- 'MX' = NAFTA goods marked as Mexico
- 'N ' = Duty-free code for West Bank and Gaza Strip
- 'R ' = Caribbean Basin Trade Partnership Act (New 01/2001)
- 'SG' = Products of Singapore under designated provision of the HTSUSA (New 01/2004)
- 'W ' = Puerto Rican product under
Customs and Trade Act of 1990
- 'Z ' = Marshall Islands and the Federated States of Micronesia Compact of Free Association Act
17 PROGRAM INDICATOR 1-digit secondary special program indicator.
- 'F' = Certified hand-loomed or folklore product
- 'G' = Made to measure Hong Kong suits
- 'H' = Special regime commodity
- 'M' = Fashion Samples and Chinese Floor Coverings
- 'S' = Outward Processing Program for textiles and apparel. (eff 1/2000)
- 'V' = Set components
- 'X' = ***Discontinued 07/93
18-19 US_GOODS 2-digit Census special program indicator.
- '01' = HTSUSA 9802.00.5010 articles repaired or assembled abroad.
- '02' = HTSUSA 9802.00.8040 articles repaired or assembled abroad.
- '03' = HTSUSA 9802.00.6000 articles of metal manufactured in the .which were exported for
further processing abroad and returned to the U.S. for more processing
- '04' = HTSUSA 9802.00.8015 textile articles assembled abroad and entered under a special access program. (9802.00.8010 before January 1, 1994)
- '05' = HTSUSA 9802.00.8016 textile articles assembled abroad and entered under a special access program. (Effective January 1, 2000)
- '06' = HTUSA 9802.00.8042 Apparel articles
- '07' = HTUSA 9802.00.8044 Apparel articles
- '08' = HTUSA 9802.00.8046(CBTPA)
- '09' = HTUSA 9802.00.8048(ATPDEA)
- '10' = HTSUSA 9802.00.8055 textile or apparel goods assembled in Mexico.
- '11' = HTSUSA 9802.00.8068 articles
assembled abroad and enteredunder a Special Access Program. (9802.00.8066 before November 2002 and 9802.00.8065 before January 2002
- '12' = HTSUSA 9802.00.9000 textile and apparel goods assembled in Mexico from U.S. formed and cut fabric.
20-21 DISTRICT ENTRY 2-digit Customs district of entry.
22-23 DISTRICT UNLADING 2-digit Customs district of unlading code (Schedule D).
24-25 RATE PROVISION 2-digit rate provision code.
- '00' = Item entered into warehouse or foreign trade zone, duty not applicable
- '10','11','13','14','16','17','18' or '19' = Free Rate Provisions
- '61' = "General" rates apply
- '62' = "Column 2" rates apply
- '64' = "Special" NAFTA, Israel or ATPA trade agreement rates
- '69' = Chapter 99 rates apply - duty reported
- '70' = Various or special rates prescribed in rates of duty columns of HTSUSA chapters 01-97
- '79' = Chapter 99 rates apply - no duty reported
26-27 STAT_MO 2-digit statistical month.
28 FILLER 3-digit filler
29-40 CONSUMPTION QTY1 12-digit numeric consumption primary quantity.
41-52 CONSUMPTION QTY2 12-digit numeric consumption secondary quantity.
53-64 CONSUMPTION VALUE 12-digit numeric consumption Customs value (in dollars).
65-76 CONSUMPTION US VALUE 12-digit numeric consumption value of the merchandise portion originating in the U.S. (in dollars).
77-88 CONSUMPTION CHARGES 12-digit numeric consumption aggregate charges (in dollars).
89-100 CONSUMPTION CIF 12-digit numeric consumption cost, insurance and freight.
101-112 GENERAL QTY1 12-digit numeric general primary quantity.
113-124 GENERAL QTY2 12-digit numeric general secondary quantity.
125-136 GENERAL VALUE 12-digit numeric general Customs value (in dollars).
137-148 GENERAL US VALUE 12-digit numeric general value of the merchandise portion originating in the U.S. (in dollars).
149-160 GENERAL CHARGES 12-digit numeric general aggregate charges (in dollars).
161-172 GENERAL CIF 12-digit numeric general cost, insurance and freight.
173-176 STAT_YEAR 4-digit statistical year.
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?