FIX FORMATTED ASCII FILE RECORD LENGTH: 235
POSITION | FIELD NAME | DESCRIPTION |
---|---|---|
1-10 | commodity | 10-Digit Harmonized Tariff Schedule (HTS) Code |
11-160 | descriptn | 150-Digit HTS Description |
161-210 | abbreviatn | 50-Digit HTS Description |
211-213 | unit_qy1 | 3-Digit Unit of Quanitity 1 |
214-216 | unit_qy2 | 3-Digit Unit of Quanitity 2 |
217-221 | sitc | 5-Digit SITC Code |
222-226 | end_use | 5-Digit ENDUSE Code |
227-232 | naics | 6-Digit NAICS Code |
233-233 | usda | 1-Digit USDA Code |
234-235 | hitech | 2-Digit HITECH Code |
236-245 | years_ap | 10-Digit All 2-Digit Years HS Code Has Data During 5 Year History |
FIX FORMATTED ASCII FILE RECORD LENGTH: 51
POSITION | FIELD NAME | DESCRIPTION |
---|---|---|
1-4 | cty_code | 4-Digit Country Code |
5-11 | cty_desc | 7-Digit Country Description |
12-41 | cty_name | 30-Digit Country Name |
42-51 | years_ap | 10-Digit All 2-Digit Years Country Code Was Valid During 5 Year History |
FIX FORMATTED ASCII FILE RECORD LENGTH: 49
POSITION | FIELD NAME | DESCRIPTION |
---|---|---|
1-2 | dist_code | 2-Digit Distrcit Code |
3-9 | dist_desc | 7-Digit District Description |
10-39 | dist_name | 30-Digit District Name |
40-49 | years_ap | 10-Digit All 2-Digit Years District Code Was Valid During 5 Year History |
FIX FORMATTED ASCII FILE RECORD LENGTH: 105
POSITION | FIELD NAME | DESCRIPTION |
---|---|---|
1-5 | enduse | 5-Digit ENDUSE Code* |
6-105 | eudesc | 100-Digit ENDUSE Description |
* Includes 1-, 2-, 3-, and 5-Digit end-use codes.
FIX FORMATTED ASCII FILE RECORD LENGTH: 32
POSITION | FIELD NAME | DESCRIPTION |
---|---|---|
1-2 | hitech | 2-Digit HITECH Code |
3-32 | hidesc | 30-Digit HITECH Description |
FIX FORMATTED ASCII FILE RECORD LENGTH: 206
POSITION | FIELD NAME | DESCRIPTION |
---|---|---|
1-6 | commodity | 6-Digit Harmonized Code* |
7-156 | descriptn | 150-Digit Commodity Description |
157-206 | abbreviatn | 50-Digit Commodity Description |
* Includes 2-, 4- and 6-Digit HS codes.
FIX FORMATTED ASCII FILE RECORD LENGTH: 373
POSITION | FIELD NAME | DESCRIPTION |
---|---|---|
1-10 | commodity | 10-Digit Harmonized Tariff Schedule (HTS) Code |
11-60 | comm_desc | 50-Digit HTS Description |
61-63 | unit_qy1 | 3-Digit Unit of Quantity 1 |
64-73 | years_ap | 10-Digit All 2-Digit Years HS Code Has Data During 5 Year History |
74-88 | con_qy1_[Y1] | 15-Digit Imports for Consumption, Quantity 1, First Year in Series, where [Y1] is the 2-digit year |
89-103 | con_val_[Y1] | 15-Digit Imports for Consumption, Total Value, First Year in Series, where [Y1] is the 2-digit year |
104-118 | gen_qy1_[Y1] | 15-Digit General Imports, Quantity 1, First Year in Series, where [Y1] is the 2-digit year |
119-133 | gen_val_[Y1] | 15-Digit General Imports, Total Value, Second Year in Series, where [Y1] is the 2-digit year |
134-148 | con_qy1_[Y2] | 15-Digit Imports for Consumption, Quantity 1, Second Year in Series, where [Y1] is the 2-digit year |
149-163 | con_val_[Y2] | 15-Digit Imports for Consumption, Total Value, Second Year in Series, where [Y1] is the 2-digit year |
164-178 | gen_qy1_[Y2] | 15-Digit General Imports, Quantity 1, Second Year in Series, where [Y1] is the 2-digit year |
179-193 | gen_val_[Y2] | 15-Digit General Imports, Total Value, Second Year in Series, where [Y1] is the 2-digit year |
194-208 | con_qy1_[Y3] | 15-Digit Imports for Consumption, Quantity 1, Third Year in Series, where [Y1] is the 2-digit year |
209-223 | con_val_[Y3] | 15-Digit Imports for Consumption, Total Value, Third Year in Series, where [Y1] is the 2-digit year |
224-238 | gen_qy1_[Y3] | 15-Digit General Imports, Quantity 1, Third Year in Series, where [Y1] is the 2-digit year |
239-253 | gen_val_[Y3] | 15-Digit General Imports, Total Value, Third Year in Series, where [Y1] is the 2-digit year |
254-268 | con_qy1_[Y4] | 15-Digit Imports for Consumption, Quantity 1, Fourth Year in Series, where [Y1] is the 2-digit year |
269-283 | con_val_[Y4] | 15-Digit Imports for Consumption, Total Value, Fourth Year in Series, where [Y1] is the 2-digit year |
284-298 | gen_qy1_[Y4] | 15-Digit General Imports, Quantity 1, Fourth Year in Series, where [Y1] is the 2-digit year |
299-313 | gen_val_[Y4] | 15-Digit General Imports, Total Value, Fourth Year in Series, where [Y1] is the 2-digit year |
314-328 | con_qy1_[05] | 15-Digit Imports for Consumption, Quantity 1, Fifth Year in Series, where [Y1] is the 2-digit year |
329-343 | con_val_[05] | 15-Digit Imports for Consumption, Total Value, Fifth Year in Series, where [Y1] is the 2-digit year |
344-358 | gen_qy1_[05] | 15-Digit General Imports, Quantity 1, Fifth Year in Series, where [Y1] is the 2-digit year |
359-373 | gen_val_[05] | 15-Digit General Imports, Total Value, Fifth Year in Series, where [Y1] is the 2-digit year |
FIX FORMATTED ASCII FILE RECORD LENGTH: 194
POSITION | FIELD NAME | DESCRIPTION |
---|---|---|
1-4 | cty_code | 4-Digit Country Code |
5-34 | cty_name | 30-Digit Country Name |
35-44 | years_ap | 10-Digit All 2-Digit Years HS Code has Data During 5 Year History |
45-59 | con_val_[Y1] | 15-Digit Imports for Consumption, Total Value, First Year in Series, where [Y1] is the 2-digit year |
60-74 | gen_val_[Y1] | 15-Digit General Imports, Total Value, First Year in Series, where [Y1] is the 2-digit year |
75-89 | con_val_[Y2] | 15-Digit Imports for Consumption, Total Value, Second Year in Series, where [Y1] is the 2-digit year |
90-104 | gen_val_[Y2] | 15-Digit General Imports, Total Value, Second Year in Series, where [Y1] is the 2-digit year |
105-119 | con_val_[Y3] | 15-Digit Imports for Consumption, Total Value, ThirdYear in Series, where [Y1] is the 2-digit year |
120-134 | gen_val_[Y3] | 15-Digit General Imports, Total Value, Third Year in Series, where [Y1] is the 2-digit year |
135-149 | con_val_[Y4] | 15-Digit Imports for Consumption, Total Value, Fourth Year in Series, where [Y1] is the 2-digit year |
150-164 | gen_val_[Y4] | 15-Digit General Imports, Total Value, Fourth Year in Series, where [Y1] is the 2-digit year |
165-179 | con_val_[Y5] | 15-Digit Imports for Consumption, Total Value, Fifth Year in Series, where [Y1] is the 2-digit year |
180-194 | gen_val_[Y5] | 15-Digit General Imports, Total Value, Fifth Year in Series, where [Y1] is the 2-digit year |
FIX FORMATTED ASCII FILE RECORD LENGTH: 192
POSITION | FIELD NAME | DESCRIPTION |
---|---|---|
1-2 | cty_code | 4-Digit Country Code |
3-32 | cty_name | 30-Digit Country Name |
33-42 | years_ap | 10-Digit All 2-Digit Years HS Code has Data During 5 Year History |
43-57 | con_val_[Y1] | 15-Digit Imports for Consumption, Total Value, First Year in Series, where [Y1] is the 2-digit year |
58-72 | gen_val_[Y1] | 15-Digit General Imports, Total Value, First Year in Series, where [Y1] is the 2-digit year |
73-87 | con_val_[Y2] | 15-Digit Imports for Consumption, Total Value, Second Year in Series, where [Y1] is the 2-digit year |
88-102 | gen_val_[Y2] | 15-Digit General Imports, Total Value, Second Year in Series, where [Y1] is the 2-digit year |
103-117 | con_val_[Y3] | 15-Digit Imports for Consumption, Total Value, ThirdYear in Series, where [Y1] is the 2-digit year |
118-132 | gen_val_[Y3] | 15-Digit General Imports, Total Value, Third Year in Series, where [Y1] is the 2-digit year |
133-147 | con_val_[Y4] | 15-Digit Imports for Consumption, Total Value, Fourth Year in Series, where [Y1] is the 2-digit year |
148-162 | gen_val_[Y4] | 15-Digit General Imports, Total Value, Fourth Year in Series, where [Y1] is the 2-digit year |
163-177 | con_val_[Y5] | 15-Digit Imports for Consumption, Total Value, Fifth Year in Series, where [Y1] is the 2-digit year |
178-192 | gen_val_[Y5] | 15-Digit General Imports, Total Value, Fifth Year in Series, where [Y1] is the 2-digit year |
FIX FORMATTED ASCII FILE RECORD LENGTH: 441
POSITION | FIELD NAME | DESCRIPTION |
---|---|---|
1-10 | commodity | 10-Digit Harmonized Tariff Schedule (HTS) Code |
11-60 | abbreviatn | 50-Digit HTS Description |
61-63 | unit_qy1 | 3-Digit Unit of Quantity 1 |
64-67 | cty_code | 4-Digit Country Code |
68-97 | cty_name | 30-Digit Country Name |
98-99 |
cty_subco |
2-Digit Country Subcode |
100-101 | dist_entry | 2-Digit District of Entry Code |
102-131 | dist_name | 30-Digit District Name |
132-141 | years_ap | 10-Digit All 2-Digit Years HS Code Has Data During 5 Year History |
142-156 | con_qy1_[Y1] | 15-Digit Imports for Consumption, Quantity 1, First Year in Series, where [Y1] is the 2-digit year |
157-171 | con_val_[Y1] | 15-Digit Imports for Consumption, Total Value, First Year in Series, where [Y1] is the 2-digit year |
172-186 | gen_qy1_[Y1] | 15-Digit General Imports, Quantity 1, First Year in Series, where [Y1] is the 2-digit year |
187-201 | gen_val_[Y1] | 15-Digit General Imports, Total Value, Second Year in Series, where [Y1] is the 2-digit year |
202-216 | con_qy1_[Y2] | 15-Digit Imports for Consumption, Quantity 1, Second Year in Series, where [Y1] is the 2-digit year |
217-231 | con_val_[Y2] | 15-Digit Imports for Consumption, Total Value, Second Year in Series, where [Y1] is the 2-digit year |
232-246 | gen_qy1_[Y2] | 15-Digit General Imports, Quantity 1, Second Year in Series, where [Y1] is the 2-digit year |
247-261 | gen_val_[Y2] | 15-Digit General Imports, Total Value, Second Year in Series, where [Y1] is the 2-digit year |
262-276 | con_qy1_[Y3] | 15-Digit Imports for Consumption, Quantity 1, Third Year in Series, where [Y1] is the 2-digit year |
277-291 | con_val_[Y3] | 15-Digit Imports for Consumption, Total Value, Third Year in Series, where [Y1] is the 2-digit year |
292-306 | gen_qy1_[Y3] | 15-Digit General Imports, Quantity 1, Third Year in Series, where [Y1] is the 2-digit year |
307-321 | gen_val_[Y3] | 15-Digit General Imports, Total Value, Third Year in Series, where [Y1] is the 2-digit year |
322-336 | con_qy1_[Y4] | 15-Digit Imports for Consumption, Quantity 1, Fourth Year in Series, where [Y1] is the 2-digit year |
337-351 | con_val_[Y4] | 15-Digit Imports for Consumption, Total Value, Fourth Year in Series, where [Y1] is the 2-digit year |
352-366 | gen_qy1_[Y4] | 15-Digit General Imports, Quantity 1, Fourth Year in Series, where [Y1] is the 2-digit year |
367-381 | gen_val_[Y4] | 15-Digit General Imports, Total Value, Fourth Year in Series, where [Y1] is the 2-digit year |
382-396 | con_qy1_[Y5] | 15-Digit Imports for Consumption, Quantity 1, Fifth Year in Series, where [Y1] is the 2-digit year |
397-411 | con_val_[Y5] | 15-Digit Imports for Consumption, Total Value, Fifth Year in Series, where [Y1] is the 2-digit year |
412-426 | gen_qy1_[Y5] | 15-Digit General Imports, Quantity 1, Fifth Year in Series, where [Y1] is the 2-digit year |
427-441 | gen_val_[Y5] | 15-Digit General Imports, Total Value, Fifth Year in Series, where [Y1] is the 2-digit year |
FIX FORMATTED ASCII FILE RECORD LENGTH: 56
POSITION | FIELD NAME | DESCRIPTION |
---|---|---|
1-6 | naics | 6-Digit NAICS Code* |
7-56 | naicdesc | 50-Digit NAICS Description |
* Includes 2-, 3-, 4-, 5-, and 6-Digit NAICS codes.
FIX FORMATTED ASCII FILE RECORD LENGTH: 205
POSITION | FIELD NAME | DESCRIPTION |
---|---|---|
1-5 | sitc | 5-Digit SITC Code* |
6-155 | sitcdesc | 150-Digit SITC Description |
156-205 | sitcabrev | 50-Digit SITC Description |
* Includes 1-, 2-, 3-, 4-, and 5-Digit SITC codes.