U.S. Exports Merchandise Trade Files - Layouts
FILENAME: CONCORD.TXT
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 |
FILENAME: COUNTRY.TXT
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 |
FILENAME: DISTRICT.TXT
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 |
FILENAME: ENDUSE.TXT
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.
FILENAME: EXP_COMM.TXT
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 |
FILENAME: EXP_CTY.TXT
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 |
FILENAME: EXP_DETL.TXT
FIX FORMATTED ASCII FILE RECORD LENGTH: 323
POSITION |
FIELD NAME |
DESCRIPTION |
1-1 |
df |
1-digit Domestic or Foreign Code |
2-11 |
commodity |
10-digit Harmonized Tariff Schedule
(HTS) 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 |
FILENAME: EXP_DIST.TXT
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 |
FILENAME: HITECH.TXT
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 |
FILENAME: HSDESC.TXT
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.
FILENAME: NAICS.TXT
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.
FILENAME: SITC.TXT
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.
|