FIX FORMATTED ASCII FILE RECORD LENGTH: 235
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 |
FIX FORMATTED ASCII FILE RECORD LENGTH: 61
POSITION | FIELD NAME | DESCRIPTION |
---|---|---|
1-4 | cty_code | 4-Digit Country Code |
5-11 | cty_desc | 7-Digit Country Description |
12-61 | cty_name | 50-Digit Country Name |
FIX FORMATTED ASCII FILE RECORD LENGTH: 59
POSITION | FIELD NAME | DESCRIPTION |
---|---|---|
1-2 | dist_code | 2-Digit Distrcit Code |
3-9 | dist_desc | 7-Digit District Description |
10-59 | dist_name | 50-Digit District Name |
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: 373
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-67 | unit_qy2 | 3-digit Unit of Quantity 2 |
68-71 | year | 4-digit Statistical Year |
72-73 | month | 2-digit Statistical Month |
74-88 | cards_mo | 15-digit Card Count |
89-103 | qty_1_mo | 15-digit Quantity 1 |
104-118 | qty_2_mo | 15-digit Quantity 2 |
119-133 | all_val_mo | 15-digit Total Value |
134-148 | air_val_mo | 15-digit Air Value |
149-163 | air_wgt_mo | 15-digit Air Shipping Weight |
164-178 | ves_val_mo | 15-digit Vessel Value |
179-193 | ves_wgt_mo | 15-digit Vessel Shipping Weight |
194-208 | cnt_val_mo | 15-digit Containerized Vessel Value |
209-223 | cnt_wgt_mo | 15-digit Containerized Vessel Shipping Weight |
224-238 | cards_yr | 15-digit Year-to-Date Card Count |
239-253 | qty_1_yr | 15-digit Year-to-Date Quantity 1 |
254-268 | qty_2_yr | 15-digit Year-to-Date Quantity 2 |
269-283 | all_val_yr | 15-digit Year-to-Date Total Value |
284-298 | air_val_yr | 15-digit Year-to-Date Air Value |
299-313 | air_wgt_yr | 15-digit Year-to-Date Air Shipping Weight |
314-328 | ves_val_yr | 15-digit Year-to-Date Vessel Value |
329-343 | ves_wgt_yr | 15-digit Year-to-Date Vessel Shipping Weight |
344-358 | cnt_val_yr | 15-digit Year-to-Date Containerized Vessel Value |
359-373 | cnt_wgt_yr | 15-digit Year-to-Date Containerized Vessel Shipping Weight |
FIX FORMATTED ASCII FILE RECORD LENGTH: 280
POSITION | FIELD NAME | DESCRIPTION |
---|---|---|
1-4 | cty_code | 4-digit Country Code |
5-34 | cty_name | 30-digit Country Name |
35-38 | year | 4-digit Statistical Year |
39-40 | month | 2-digit Statistical Month |
41-55 | cards_mo | 15-digit Card Count |
56-70 | all_val_mo | 15-digit Total Value |
71-85 | air_val_mo | 15-digit Air Value |
86-100 | air_wgt_mo | 15-digit Air Shipping Weight |
101-115 | ves_val_mo | 15-digit Vessel Value |
116-130 | ves_wgt_mo | 15-digit Vessel Shipping Weight |
131-145 | cnt_val_mo | 15-digit Containerized Vessel Value |
146-160 | cnt_wgt_mo | 15-digit Containerized Vessel Shipping Weight |
161-175 | cards_yr | 15-digit Year-to-Date Card Count |
176-190 | all_val_yr | 15-digit Year-to-Date Total Value |
191-205 | air_val_yr | 15-digit Year-to-Date Air Value |
206-220 | air_wgt_yr | 15-digit Year-to-Date Air Shipping Weight |
221-235 | ves_val_yr | 15-digit Year-to-Date Vessel Value |
236-250 | ves_wgt_yr | 15-digit Year-to-Date Vessel Shipping Weight |
251-265 | cnt_val_yr | 15-digit Year-to-Date Containerized Vessel Value |
266-280 | cnt_wgt_yr | 15-digit Year-to-Date Containerized Vessel Shipping Weight |
FIX FORMATTED ASCII FILE RECORD LENGTH: 323
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-15 | cty_code | 4-digit Country Code |
16-17 | district | 2-digit District Code |
18-21 | year | 4-digit Statistical Year |
22-23 | month | 2-digit Statistical Month |
24-38 | cards_mo | 15-digit Card Count |
39-53 | qty_1_mo | 15-digit Quantity 1 |
54-68 | qty_2_mo | 15-digit Quantity 2 |
69-83 | all_val_mo | 15-digit Total Value |
84-98 | air_val_mo | 15-digit Air Value |
99-113 | air_wgt_mo | 15-digit Air Shipping Weight |
114-128 | ves_val_mo | 15-digit Vessel Value |
129-143 | ves_wgt_mo | 15-digit Vessel Shipping Weight |
144-158 | cnt_val_mo | 15-digit Containerized Vessel Value |
159-173 | cnt_wgt_mo | 15-digit Containerized Vessel Shipping Weight |
174-188 | cards_yr | 15-digit Year-to-Date Card Count |
189-203 | qty_1_yr | 15-digit Year-to-Date Quantity 1 |
204-218 | qty_2_yr | 15-digit Year-to-Date Quantity 2 |
219-233 | all_val_yr | 15-digit Year-to-Date Total Value |
234-248 | air_val_yr | 15-digit Year-to-Date Air Value |
249-263 | air_wgt_yr | 15-digit Year-to-Date Air Shipping Weight |
264-278 | ves_val_yr | 15-digit Year-to-Date Vessel Value |
279-293 | ves_wgt_yr | 15-digit Year-to-Date Vessel Shipping Weight |
294-308 | cnt_val_yr | 15-digit Year-to-Date Containerized Vessel Value |
309-323 | cnt_wgt_yr | 15-digit Year-to-Date Containerized Vessel Shipping Weight |
FIX FORMATTED ASCII FILE RECORD LENGTH: 278
POSITION | FIELD NAME | DESCRIPTION |
---|---|---|
1-2 | district | 2-digit District Code |
3-32 | dist_name | 30-digit District Name |
33-36 | year | 4-digit Statistical Year |
37-38 | month | 2-digit Statistical Month |
39-53 | cards_mo | 15-digit Card Count |
54-68 | all_val_mo | 15-digit Total Value |
69-83 | air_val_mo | 15-digit Air Value |
84-98 | air_wgt_mo | 15-digit Air Shipping Weight |
99-113 | ves_val_mo | 15-digit Vessel Value |
114-128 | ves_wgt_mo | 15-digit Vessel Shipping Weight |
129-143 | cnt_val_mo | 15-digit Containerized Vessel Value |
144-158 | cnt_wgt_mo | 15-digit Containerized Vessel Shipping Weight |
159-173 | cards_yr | 15-digit Year-to-Date Card Count |
174-188 | all_val_yr | 15-digit Year-to-Date Total Value |
189-203 | air_val_yr | 15-digit Year-to-Date Air Value |
204-218 | air_wgt_yr | 15-digit Year-to-Date Air Shipping Weight |
219-233 | ves_val_yr | 15-digit Year-to-Date Vessel Value |
234-248 | ves_wgt_yr | 15-digit Year-to-Date Vessel Shipping Weight |
249-263 | cnt_val_yr | 15-digit Year-to-Date Containerized Vessel Value |
264-278 | cnt_wgt_yr | 15-digit Year-to-Date Containerized Vessel Shipping Weight |
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.