Skip Main Navigation Skip To Navigation Content
FOREIGN TRADE STATISTICS: Your Key to Trade [Skip all navigation and go directly to page content]
[Go to the FTD MAIN page.]
[FTD Main Navigation] MAIN: About Foreign Trade | Data | A.E.S. | Regulations | Reference | Definitions | Schedule B | FAQs | Feedback | Search
[FTD Subject Navigation] STATISTICS: Press Releases | Trade Highlights | Country/Product Data | State Export Data | Historical Series | Special Request
[ADVERT: USATrade Online - Trade data online]

Import Detail File Structure (imp_detl.dbf)

The following will be the new file structure for the imp_detl.dbf file contained on the U.S. Imports of Merchandise DVD-ROM.

Field Number
Field Name
Type
Field Size
Field Description
1 COMMODITY Char 10 Import Harmonized Code
2 CTY_CODE Char 4 Country Code

3*

CTY_SUBCO Char 2 Country Subcode
4 DIST_ENTRY Char 2 District of Entry
5 DIST_UNLAD Char 2 District of Unlading
6 RATE_PROV Char 2 Rate Provision Code
7 STAT_MONTH Char 2 Statistical Month
8 CARDS_MO Num 8 Number of Detailed Records, Current Month
9 CARDS_YR Num 8 Number of Detailed Records, Year to Date
10 CON_QY1_MO Num 12 Imports for Consumption, 1st Unit of Quantity, Current Month
11 CON_QY1_YR Num 12 Imports for Consumption, 1st Unit of Quantity, Year to Date
12 CON_QY2_MO Num 12 Imports for Consumption, 2nd Unit of Quantity, Current Month
13 CON_QY2_YR Num 12 Imports for Consumption, 2nd Unit of Quantity, Year to Date
14 CON_VAL_MO Num 12 Imports for Consumption, Customs Value, Current Month
15 CON_VAL_YR Num 12 Imports for Consumption, Customs Value, Year to Date
16 DUT_VAL_MO Num 12 Dutiable Value, Current Month
17 DUT_VAL_YR Num 12 Dutiable Value, Year to Date
18 CAL_DUT_MO Num 12 Calculated Duty, Current Month
19 CAL_DUT_YR Num 12 Calculated Duty, Year to Date
20 CON_CHA_MO Num 12 Imports for Consumption, Import Charges, Current Month
21 CON_CHA_YR Num 12 Imports for Consumption, Import Charges, Year to Date
22 GEN_QY1_MO Num 12 General Imports, 1st Unit of Quantity, Current Month
23 GEN_QY1_YR Num 12 General Imports, 1st Unit of Quantity, Year to Date
24 GEN_QY2_MO Num 12 General Imports, 2nd Unit of Quantity, Current Month
25 GEN_QY2_YR Num 12 General Imports, 2nd Unit of Quantity, Year to Date
26 GEN_VAL_MO Num 12 General Imports, Customs Value, Current Month
27 GEN_VAL_YR Num 12 General Imports, Customs Value, Year to Date
28 GEN_CHA_MO Num 12 General Imports, Import Charges, Current Month
29 GEN_CHA_YR Num 12 General Imports, Import Charges, Year to Date
30 VES_VAL_MO Num 12 Shipments by Vessel, Customs Value, Current Month
31 VES_VAL_YR Num 12 Shipments by Vessel, Customs Value, Year to Date
32 VES_WGT_MO Num 12 Shipments by Vessel, Shipping Weight, Current Month
33 VES_WGT_YR Num 12 Shipments by Vessel, Shipping Weight, Year to Date
34 VES_CHA_MO Num 12 Shipments by Vessel, Import Charges, Current Month
35 VES_CHA_YR Num 12 Shipments by Vessel, Import Charges, Year to Date
36 AIR_VAL_MO Num 12 Shipments by Air, Customs Value, Current Month
37 AIR_VAL_YR Num 12 Shipments by Air, Customs Value, Year to Date
38 AIR_WGT_MO Num 12 Shipments by Air, Shipping Weight, Current Month
39 AIR_WGT_YR Num 12 Shipments by Air, Shipping Weight, Year to Date
40 AIR_CHA_MO Num 12 Shipments by Air, Import Charges, Current Month
41 AIR_CHA_YR Num 12 Shipments by Air, Import Charges, Year to Date

 

* - The only change to the file is in Field Number 3, CTY_SUBCO, which has a new Field Size of 2. It previously had a Field Size of 1.

 

 

 

Source: FTDWebMaster, Foreign Trade Division, U.S. Census Bureau, Washington, D.C. 20233
Location: MAIN: STATISTICS: NOTICES
Created: 12 November 2003
Last modified: 12 July 2011 at 04:08:45 PM