FL_IMP.ASC ---------- FILES ON CD-ROM U.S. Imports of Merchandise on CD-ROM These files are in dBase III format. There are 10 database files and 11 index files. The index files pertain to the database files as they are shown below. To access each index, use the key listed with the index. The detailed database structure appears on the page listed. IMP_DETL.DBF Import Detail Database P. 2-9 IMP_DETL.CDY Index File - Key: COMMODITY1 IMP_DETL.CTY Index File - Key: CTY_CODE IMP_DETL.DST Index File - Key: DIST_CODE IMP_COMM.DBF Commodity Summary Database P. 2-11 IMP_COMM.NDX Index File - Key: DOM_OR_FOR + COMMODITY IMP_CTY.DBF Country Summary Database P. 2-13 IMP_CTY.NDX Index File - Key: CTY_CODE IMP_DE.DBF District of Entry Summary Database P. 2-15 IMP_DE.NDX Index File - Key: DIST_ENTRY IMP_DU.DBF District of Unlading Summary Database P. 2-17 IMP_DU.NDX Index File - Key: DIST_UNLAD CONCORD.DBF Harmonized Commodity Masters  Imports Concordance Database P. 2-19 CONCORD.NDX Index File - Key: COMMODITY HSDESC.DBF Harmonized Commodity Masters  Commodity Description P. 2-21 HSDESC2.NDX Index File - Key: LEFT (COMMODITY, 2) HSDESC4.NDX Index File - Key: LEFT (COMMODITY, 4) HSDESC6.NDX Index File - Key: COMMODITY SITCDESC.DBF Harmonized Commodity Masters  SITC Descriptions P. 2-21 COUNTRY.DBF Country Name Database P. 2-23 DISTRICT.DBF Customs District Name Database P. 2-23 ----------- 1Unique index file. This points only to the first occurrence of each key value. --- Import Detail Database IMP_DETL.DBF Field Field Field Field Number Name Type Size Decimal Field Description 1 COMMODITY C 10 0 Import Harmonized Code 2 CTY_CODE C 4 0 Country Code 3 CTY_SUBCO C 1 0 Country Subcode 4 DIST_ENTRY C 2 0 District of Entry 5 DIST_UNLAD C 2 0 District of Unlading 6 RATE_PROV C 2 0 Rate Provision Code 7 STAT_MONTH C 2 0 Statistical Month 8 CARDS_MO N 8 0 Number of Detailed Records, Current Month 9 CARDS_YR N 8 0 Number of Detailed Records, Year to Date 10 CON_QY1_MO N 12 0 Imports for Consumption, 1st Unit of Quantity, Current Month 11 CON_QY1_YR N 12 0 Imports for Consumption, 1st Unit of Quantity, Year to Date 12 CON_QY2_MO N 12 0 Imports for Consumption, 2nd Unit of Quantity, Current Month 13 CON_QY2_YR N 12 0 Imports for Consumption, 2nd Unit of Quantity, Year to Date 14 CON_VAL_MO N 12 0 Imports for Consumption, Customs Value, Current Month 15 CON_VAL_YR N 12 0 Imports for Consumption, Customs Value, Year to Date 16 DUT_VAL_MO N 12 0 Dutiable Value, Current Month 17 DUT_VAL_YR N 12 0 Dutiable Value, Year to Date 18 CAL_DUT_MO N 12 0 Calculated Duty, Current Month 19 CAL_DUT_YR N 12 0 Calculated Duty, Year to Date 20 CON_CHA_MO N 12 0 Imports for Consumption, Import Charges, Current Month 21 CON_CHA_YR N 12 0 Imports for Consumption, Import Charges, Year to Date 22 GEN_QY1_MO N 12 0 General Imports, 1st Unit of Quantity, Current Month 23 GEN_QY1_YR N 12 0 General Imports, 1st Unit of Quantity, Year to Date 24 GEN_QY2_MO N 12 0 General Imports, 2nd Unit of Quantity, Current Month 25 GEN_QY2_YR N 12 0 General Imports, 2nd Unit of Quantity, Year to Date 26 GEN_VAL_MO N 12 0 General Imports, Customs Value, Current Month 27 GEN_VAL_YR N 12 0 General Imports, Customs Value, Year to Date 28 GEN_CHA_MO N 12 0 General Imports, Import Charges, Current Month 29 GEN_CHA_YR N 12 0 General Imports, Import Charges, Year to Date 30 VES_VAL_MO N 12 0 Shipments by Vessel, Customs Value, Current Month 31 VES_VAL_YR N 12 0 Shipments by Vessel, Customs Value, Year to Date 32 VES_WGT_MO N 12 0 Shipments by Vessel, Shipping Weight, Current Month 33 VES_WGT_YR N 12 0 Shipments by Vessel, Shipping Weight, Year to Date 34 VES_CHA_MO N 12 0 Shipments by Vessel, Import Charges, Current Month 35 VES_CHA_YR N 12 0 Shipments by Vessel, Import Charges, Year to Date 36 AIR_VAL_MO N 12 0 Shipments by Air, Customs Value, Current Month 37 AIR_VAL_YR N 12 0 Shipments by Air, Customs Value, Year to Date 38 AIR_WGT_MO N 12 0 Shipments by Air, Shipping Weight, Current Month 39 AIR_WGT_YR N 12 0 Shipments by Air, Shipping Weight, Year to Date 40 AIR_CHA_MO N 12 0 Shipments by Air, Import Charges, Current Month 41 AIR_CHA_YR N 12 0 Shipments by Air, Import Charges, Year to Date Total Size 549 Commodity Summary Database IMP_COMM.DBF Field Field Field Number Field Name Type Size Decimal Field Description 1 COMMODITY C 10 0 Import Harmonized Code 2 COMM_DESC C 50 0 Commodity Description 3 UNIT_QY1 C 3 0 1st Unit of Quantity 4 UNIT_QY2 C 3 0 2nd Unit of Quantity 5 STAT_MONTH C 2 0 Statistical Month 6 CARDS_MO N 8 0 Number of Detailed Records, Current Month 7 CARDS_YR N 8 0 Number of Detailed Records, Year to Date 8 CON_QY1_MO N 12 0 Imports for Consumption, 1st Unit of Quantity, Current Month 9 CON_QY1_YR N 12 0 Imports for Consumption, 1st Unit of Quantity, Year to Date 10 CON_QY2_MO N 12 0 Imports for Consumption, 2nd Unit of Quantity, Current Month 11 CON_QY2_YR N 12 0 Imports for Consumption, 2nd Unit of Quantity, Year to Date 12 CON_VAL_MO N 12 0 Imports for Consumption, Customs Value, Current Month 13 CON_VAL_YR N 12 0 Imports for Consumption, Customs Value, Year to Date 14 DUT_VAL_MO N 12 0 Dutiable Value, Current Month 15 DUT_VAL_YR N 12 0 Dutiable Value, Year to Date 16 CAL_DUT_MO N 12 0 Calculated Duty, Current Month 17 CAL_DUT_YR N 12 0 Calculated Duty, Year to Date 18 CON_CHA_MO N 12 0 Imports for Consumption, Import Charges, Current Month 19 CON_CHA_YR N 12 0 Imports for Consumption, Import Charges, Year to Date 20 CON_CIF_MO N 12 0 Imports for Consumption, CIF Import Value, Current Month 21 CON_CIF_YR N 12 0 Imports for Consumption, CIF Import Value, Year to Date 22 GEN_QY1_MO N 12 0 General Imports, 1st Unit of Quantity, Current Month 23 GEN_QY1_YR N 12 0 General Imports, 1st Unit of Quantity, Year to Date 24 GEN_QY2_MO N 12 0 General Imports, 2nd Unit of Quantity, Current Month 25 GEN_QY2_YR N 12 0 General Imports, 2nd Unit of Quantity, Year to Date 26 GEN_VAL_MO N 12 0 General Imports, Customs Value, Current Month 27 GEN_VAL_YR N 12 0 General Imports, Customs Value, Year to Date 28 GEN_CHA_MO N 12 0 General Imports, Import Charges, Current Month 29 GEN_CHA_YR N 12 0 General Imports, Import Charges, Year to Date 30 GEN_CIF_MO N 12 0 General Imports, CIF Import Value, Current Month 31 GEN_CIF_YR N 12 0 General Imports, CIF Import Value, Year to Date 32 VES_VAL_MO N 12 0 Shipments by Vessel, Customs Value, Current Month 33 VES_VAL_YR N 12 0 Shipments by Vessel, Customs Value, Year to Date 34 VES_WGT_MO N 12 0 Shipments by Vessel, Shipping Weight, Current Month 35 VES_WGT_YR N 12 0 Shipments by Vessel, Shipping Weight, Year to Date 36 VES_CHA_MO N 12 0 Shipments by Vessel, Import Charges, Current Month 37 VES_CHA_YR N 12 0 Shipments by Vessel, Import Charges, Year to Date 38 AIR_VAL_MO N 12 0 Shipments by Air, Customs Value, Current Month 39 AIR_VAL_YR N 12 0 Shipments by Air, Customs Value, Year to Date 40 AIR_WGT_MO N 12 0 Shipments by Air, Shipping Weight, Current Month 41 AIR_WGT_YR N 12 0 Shipments by Air, Shipping Weight, Year to Date 42 AIR_CHA_MO N 12 0 Shipments by Air, Import Charges, Current Month 43 AIR_CHA_YR N 12 0 Shipments by Air, Import Charges, Year to Date Total Size 517 Country Summary Database IMP_CTY.DBF Field Field Field Number Field Name Type Size Decimal Field Description 1 CTY_CODE C 4 0 Country Code 2 CTY_DESC C 7 0 Country Description 3 STAT_MONTH C 2 0 Statistical Month 4 FILLER C 3 0 Filler 5 CARDS_MO N 8 0 Number of Detailed Records, Current Month 6 CARDS_YR N 8 0 Number of Detailed Records, Year to Date 7 CON_VAL_MO N 12 0 Imports for Consumption, Customs Value, Current Month 8 CON_VAL_YR N 12 0 Imports for Consumption, Customs Value, Year to Date 9 DUT_VAL_MO N 12 0 Dutiable Value, Current Month 10 DUT_VAL_YR N 12 0 Dutiable Value, Year to Date 11 CAL_DUT_MO N 12 0 Calculated Duty, Current Month 12 CAL_DUT_YR N 12 0 Calculated Duty, Year to Date 13 CON_CHA_MO N 12 0 Imports for Consumption, Import Charges, Current Month 14 CON_CHA_YR N 12 0 Imports for Consumption, Import Charges, Year to Date 15 CON_CIF_MO N 12 0 Imports for Consumption, CIF Import Value, Current Month 16 CON_CIF_YR N 12 0 Imports for Consumption, CIF Import Value, Year to Date 17 GEN_VAL_MO N 12 0 General Imports, Customs Value, Current Month 18 GEN_VAL_YR N 12 0 General Imports, Customs Value, Year to Date 19 GEN_CHA_MO N 12 0 General Imports, Import Charges, Current Month 20 GEN_CHA_YR N 12 0 General Imports, Import Charges, Year to Date 21 GEN_CIF_MO N 12 0 General Imports, CIF Import Value, Current Month 22 GEN_CIF_YR N 12 0 General Imports, CIF Import Value, Year to Date 23 VES_VAL_MO N 12 0 Shipments by Vessel, Customs Value, Current Month 24 VES_VAL_YR N 12 0 Shipments by Vessel, Customs Value, Year to Date 25 VES_WGT_MO N 12 0 Shipments by Vessel, Shipping Weight, Current Month 26 VES_WGT_YR N 12 0 Shipments by Vessel, Shipping Weight, Year to Date 27 VES_CHA_MO N 12 0 Shipments by Vessel, Import Charges, Current Month 28 VES_CHA_YR N 12 0 Shipments by Vessel, Import Charges, Year to Date 29 AIR_VAL_MO N 12 0 Shipments by Air, Customs Value, Current Month 30 AIR_VAL_YR N 12 0 Shipments by Air, Customs Value, Year to Date 31 AIR_WGT_MO N 12 0 Shipments by Air, Shipping Weight, Current Month 32 AIR_WGT_YR N 12 0 Shipments by Air, Shipping Weight, Year to Date 33 AIR_CHA_MO N 12 0 Shipments by Air, Import Charges, Current Month 34 AIR_CHA_YR N 12 0 Shipments by Air, Import Charges, Year to Date Total Size 369 District of Entry Summary Database IMP_DE.DBF Field Field Field Number Field Name Type Size Decimal Field Description 1 DIST_ENTRY C 2 0 District of Entry 2 D_E_DESC C 7 0 District of Entry Description 3 STAT_MONTH C 2 0 Statistical Month 4 FILLER N 1 0 Filler 5 CARDS_MO N 8 0 Number of Detailed Records, Current Month 6 CARDS_YR N 8 0 Number of Detailed Records, Year to Date 7 CON_VAL_MO N 12 0 Imports for Consumption, Customs Value, Current Month 8 CON_VAL_YR N 12 0 Imports for Consumption, Customs Value, Year to Date 9 DUT_VAL_MO N 12 0 Dutiable Value, Current Month 10 DUT_VAL_YR N 12 0 Dutiable Value, Year to Date 11 CAL_DUT_MO N 12 0 Calculated Duty, Current Month 12 CAL_DUT_YR N 12 0 Calculated Duty, Year to Date 13 CON_CHA_MO N 12 0 Imports for Consumption, Import Charges, Current Month 14 CON_CHA_YR N 12 0 Imports for Consumption, Import Charges, Year to Date 15 CON_CIF_MO N 12 0 Imports for Consumption, CIF Import Value, Current Month 16 CON_CIF_YR N 12 0 Imports for Consumption, CIF Import Value, Year to Date 17 GEN_VAL_MO N 12 0 General Imports, Customs Value, Current Month 18 GEN_VAL_YR N 12 0 General Imports, Customs Value, Year to Date 19 GEN_CHA_MO N 12 0 General Imports, Import Charges, Current Month 20 GEN_CHA_YR N 12 0 General Imports, Import Charges, Year to Date 21 GEN_CIF_MO N 12 0 General Imports, CIF Import Value, Current Month 22 GEN_CIF_YR N 12 0 General Imports, CIF Import Value, Year to Date 23 VES_VAL_MO N 12 0 Shipments by Vessel, Customs Value, Current Month 24 VES_VAL_YR N 12 0 Shipments by Vessel, Customs Value, Year to Date 25 VES_WGT_MO N 12 0 Shipments by Vessel, Shipping Weight, Current Month 26 VES_WGT_YR N 12 0 Shipments by Vessel, Shipping Weight, Year to Date 27 VES_CHA_MO N 12 0 Shipments by Vessel, Import Charges, Current Month 28 VES_CHA_YR N 12 0 Shipments by Vessel, Import Charges, Year to Date 29 AIR_VAL_MO N 12 0 Shipments by Air, Customs Value, Current Month 30 AIR_VAL_YR N 12 0 Shipments by Air, Customs Value, Year to Date 31 AIR_WGT_MO N 12 0 Shipments by Air, Shipping Weight, Current Month 32 AIR_WGT_YR N 12 0 Shipments by Air, Shipping Weight, Year to Date 33 AIR_CHA_MO N 12 0 Shipments by Air, Import Charges, Current Month 34 AIR_CHA_YR N 12 0 Shipments by Air, Import Charges, Year to Date Total Size 365 District of Unlading Database IMP_DU.DBF Field Field Field Number Field Name Type Size Decimal Field Description 1 DIST_UNLAD C 2 0 District of Unlading 2 D_U_DESC C 7 0 District of Unlading Description 3 STAT_MONTH C 2 0 Statistical Month 4 FILLER C 1 0 Filler 5 CARDS_MO N 8 0 Number of Detailed Records, Current Month 6 CARDS_YR N 8 0 Number of Detailed Records, Year to Date 7 CON_VAL_MO N 12 0 Imports for Consumption, Customs Value, Current Month 8 CON_VAL_YR N 12 0 Imports for Consumption, Customs Value, Year to Date 9 DUT_VAL_MO N 12 0 Dutiable Value, Current Month 10 DUT_VAL_YR N 12 0 Dutiable Value, Year to Date 11 CAL_DUT_MO N 12 0 Calculated Duty, Current Month 12 CAL_DUT_YR N 12 0 Calculated Duty, Year to Date 13 CON_CHA_MO N 12 0 Imports for Consumption, Import Charges, Current Month 14 CON_CHA_YR N 12 0 Imports for Consumption, Import Charges, Year to Date 15 CON_CIF_MO N 12 0 Imports for Consumption, CIF Import Value, Current Month 16 CON_CIF_YR N 12 0 Imports for Consumption, CIF Import Value, Year to Date 17 GEN_VAL_MO N 12 0 General Imports, Customs Value, Current Month 18 GEN_VAL_YR N 12 0 General Imports, Customs Value, Year to Date 19 GEN_CHA_MO N 12 0 General Imports, Import Charges, Current Month 20 GEN_CHA_YR N 12 0 General Imports, Import Charges, Year to Date 21 GEN_CIF_MO N 12 0 General Imports, CIF Import Value, Current Month 22 GEN_CIF_YR N 12 0 General Imports, CIF Import Value, Year to Date 23 VES_VAL_MO N 12 0 Shipments by Vessel, Customs Value, Current Month 24 VES_VAL_YR N 12 0 Shipments by Vessel, Customs Value, Year to Date 25 VES_WGT_MO N 12 0 Shipments by Vessel, Shipping Weight, Current Month 26 VES_WGT_YR N 12 0 Shipments by Vessel, Shipping Weight, Year to Date 27 VES_CHA_MO N 12 0 Shipments by Vessel, Import Charges, Current Month 28 VES_CHA_YR N 12 0 Shipments by Vessel, Import Charges, Year to Date 29 AIR_VAL_MO N 12 0 Shipments by Air, Customs Value, Current Month 30 AIR_VAL_YR N 12 0 Shipments by Air, Customs Value, Year to Date 31 AIR_WGT_MO N 12 0 Shipments by Air, Shipping Weight, Current Month 32 AIR_WGT_YR N 12 0 Shipments by Air, Shipping Weight, Year to Date 33 AIR_CHA_MO N 12 0 Shipments by Air, Import Charges, Current Month 34 AIR_CHA_YR N 12 0 Shipments by Air, Import Charges, Year to Date Total Size 365 Harmonized Commodity Masters  Imports Concordance Database CONCORD.DBF Field Field Field Number Field Name Type Size Decimal Field Description 1 ID-CODE C 1 0 Identification Code = 2 2 COMMODITY C 10 0 Import Harmonized Code 3 FILL1 C 2 0 Filler 4 DESCRIP_1 C 150 0 Description of 10-digit commodity 5 FILL2 C 1 0 Filler 6 DESCRIP_2 C 50 0 Abbreviated version of description 7 FILL3 C 1 0 Filler 8 QUANTITY_1 C 3 0 Alphabetic abbreviation of the first reporting unit of quantity as required by HTSUSA 9 FILL4 C 1 0 Filler 10 QUANTITY_2 C 3 0 Second unit of quantity if required by HTSUSA 11 FILL5 C 1 0 Filler 12 SITC C 5 0 Standard International Trade Classification Revision 3 Code 13 FILL6 C 1 0 Filler 14 END_USE C 5 0 End use classification 15 FILL7 C 1 0 Filler 16 SIC C 4 0 Standard Industry Classification code 17 FILL8 C 7 0 Filler 18 USDA C 1 0 Agriculture or non- agriculture product code 19 FILL9 C 1 0 Filler Total Size 249 Harmonized Commodity Masters Commodity Descriptions HSDESC.DBF Field Field Field Number Field Name Type Size Decimal Field Description 1 ID_CODE C 1 0 Identification Code = 6 2 COMMODITY C 6 0 Import Harmonized Code 3 FILL1 C 6 0 Filler 4 DESCRIPTN C 150 0 Description of Harmonized Code 5 FILL2 C 1 0 Filler 6 ABBREVIATN C 50 0 Abbreviated version of description of Harmonized Code Total Size 215 Harmonized Comodity Masters Standard International Trade Classification Descriptions SITCDESC.DBF Field Field Field Number Field Name Type Size Decimal Field Description 1 ID_CODE C 1 0 Identification code = 5 2 SITC_CODE C 5 0 SITC REV3 Code 3 FILL1 C 7 0 Filler 4 DESCRIPTN C 150 0 Description of SITC REV3 product 5 FILL2 C 1 0 Filler 6 ABBREVIATN C 50 0 Abbreviated description of SITC REV3 product Total Size 215 Country Name Database COUNTRY.DBF Field Field Field Number Field Name Type Size Decimal Field Description 1 CTY_CODE C 4 0 Country Code 2 CTY_DESC C 7 0 Country Abbreviation 3 CTY_NAME C 30 0 Country Name Total 42 Customs District Name Database DISTRICT.DBF Field Field Field Number Field Name Type Size Decimal Field Description 1 DIST_CODE C 2 0 District Code 2 DIST_DESC C 7 0 District Abbreviation 3 DIST_NAME C 30 0 District Name Total Size 40 *