FIX FORMATTED ASCII FILE RECORD LENGTH: 245
POSITION | FIELD NAME | DESCRIPTION |
---|---|---|
1-10 | commodity | 10-Digit Schedule B Commodity Code |
11-160 | descriptn | 150-Digit Schedule B Commodity Code Description |
161-210 | abbreviatn | 50-Digit Schedule B Commodity Code 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 Schedule B 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: 224
POSITION | FIELD NAME | DESCRIPTION |
---|---|---|
1-1 | df | 1-Digit Domestic or Foreign Code |
2-11 | commodity | 10-Digit Schedule B Commodity Code |
12-61 | comm_desc | 50-Digit Schedule B Commodity Code Description |
62-64 | unit_qy1 | 3-Digit Unit of Quantity 1 |
65-74 | years_ap | 10-Digit All 2-Digit Years HS Code has Data During 5 Year History |
75-89 | qty_1_[Y1] | 15-Digit Quantity 1, First Year in Series, where [Y1] is the 2-digit year |
90-104 | all_val_[Y1] | 15-Digit Total Value, First Year in Series, where [Y1] is the 2-digit year |
105-119 | qty_1_[Y2] | 15-Digit Quantity 1, Second Year in Series, where [Y1] is the 2-digit year |
120-134 | all_val_[Y2] | 15-Digit Total Value, Second Year in Series, where [Y1] is the 2-digit year |
135-149 | qty_1_[Y3] | 15-Digit Quantity 1, Third Year in Series, where [Y1] is the 2-digit year |
150-164 | all_val_[Y3] | 15-Digit Total Value, Third Year in Series, where [Y1] is the 2-digit year |
165-179 | qty_1_[Y4] | 15-Digit Quantity 1, Fourth Year in Series, where [Y1] is the 2-digit year |
180-194 | all_val_[Y4] | 15-Digit Total Value, Fourth Year in Series, where [Y1] is the 2-digit year |
195-209 | qty_1_[Y5] | 15-Digit Quantity 1, Fifth Year in Series, where [Y1] is the 2-digit year |
210-224 | all_val_[Y5] | 15-Digit Total Value, Fifth Year in Series, where [Y1] is the 2-digit year |
FIX FORMATTED ASCII FILE RECORD LENGTH: 119
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 | all_val_[Y1] | 15-Digit Total Value, First Year in Series, where [Y1] is the 2-digit year |
60-74 | all_val_[Y2] | 15-Digit Total Value, Second Year in Series, where [Y1] is the 2-digit year |
75-89 | all_val_[Y3] | 15-Digit Total Value, Third Year in Series, where [Y1] is the 2-digit year |
90-104 | air_val_[Y4] | 15-Digit Total Value, Fourth Year in Series, where [Y1] is the 2-digit year |
105-119 | all_val_[Y5] | 15-Digit Total Value, Fifth Year in Series, where [Y1] is the 2-digit year |
FIX FORMATTED ASCII FILE RECORD LENGTH: 290
POSITION | FIELD NAME | DESCRIPTION |
---|---|---|
1-1 | df | 1-Digit Domestic or Foreign Code (domestic = 1; foreign = 2) |
2-11 | commodity | 10-Digit Schedule B Commodity Code |
12-61 | comm_desc | 50-Digit Schedule B Description |
62-64 | unit_qy1 | 3-Digit Unit of Quantity |
65-68 | cty_code | 4-Digit Country Code |
69-98 | cty_name | 30-Digit Country Name |
99-100 | district | 2-Digit District Code |
101-130 | dist_desc | 30-Digit District Description |
131-140 | years_ap | 10-Digit All 2-Digit Years HS Codes has data during 5 year history |
141-155 | qty_1_[Y1] | 15-Digit Quantity 1, First Year in Series, where [Y1] is the 2-digit year |
156-170 | all_val_[Y1] | 15-Digit Total Value, First Year in Series, where [Y1] is the 2-digit year |
171-185 | qty_1_[Y2] | 15-Digit Quantity 1, Second Year in Series, where [Y2] is the 2-digit year |
186-200 | all_val_[Y2] | 15-Digit Total Value, Second Year in Series, where [Y2] is the 2-digit year |
201-215 | qty_1_[Y3] | 15-Digit Quantity 1, Third Year in Series, where [Y3] is the 2-digit year |
216-230 | all_val_[Y3] | 15-Digit Total Value, Third Year in Series, where [Y3] is the 2-digit year |
231-245 | qty_1_[Y4] | 15-Digit Quantity 1, Fourth Year in Series, where [Y4] is the 2-digit year |
246-260 | all_val_[Y4] | 15-Digit Total Value, Fourth Year in Series, where [Y4] is the 2-digit year |
261-275 | qty_1_[Y5] | 15-Digit Quantity 1, Fifth Year in Series, where [Y5] is the 2-digit year |
276-290 | all_val_[Y5] | 15-Digit Total Value, Fifth Year in Series, where [Y5] is the 2-digit year |
FIX FORMATTED ASCII FILE RECORD LENGTH: 117
POSITION | FIELD NAME | DESCRIPTION |
---|---|---|
1-2 | district | 2-Digit District Code |
3-32 | dist_name | 30-Digit District Name |
33-42 | year | 10-Digit All 2-Digit Years HS Code has data During 5 Year History |
43-57 | all_val_[Y1] | 15-Digit Total Value, First Year in Series, where [Y1] is the 2-digit year |
58-72 | all_val_[Y2] | 15-Digit Total Value, Second Year in Series, where [Y1] is the 2-digit year |
73-87 | all_val_[Y3] | 15-Digit Total Value, Third Year in Series, where [Y1] is the 2-digit year |
88-102 | air_val_[Y4] | 15-Digit Total Value, Fourth Year in Series, where [Y1] is the 2-digit year |
103-117 | all_val_[Y5] | 15-Digit Total Value, Fifth Year in Series, where [Y1] is the 2-digit year |
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: 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.