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.
|