Product Classification Data Mapping
HTS (Harmonized Tariff Schedule) Mapping
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_MASTER | mstr_id | GTM_PROD_CLASS_CODE_GID |
Unique identifier used by GTM to create a classification code for a particular version. Product Classification Code ID is a concatenation of Data_Version_ID+’_’+mstr_id. To identify the classification code based on the data version. |
_MASTER | data_type+ iso_country |
GTM_PROD_CLASS_TYPE_GID |
Product Classification Type is a concatenation of data_type + <space> + (2-digit)country_code Eg: data_type is HTS and country is US. Product Classification Type would be ‘HTS US’. |
_MASTER | hscode | CLASSIFICATION_CODE | Actual Product Classification Code from the harmonized tariff |
_MASTER | eff_beg_dt | EFFECTIVE_DATE | The date from which the classification code is active |
_MASTER | eff_end_dt | EXPIRATION_DATE | Expiration date of the classification code |
_MASTER | section_number | SECTION | Section number provided by HS |
_MASTER | chapter | CHAPTER | Chapter number provided by HS |
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_MASTER | iso_language | GTM_LANGUAGE_GID | Language |
_MASTER | full_desc | DESCRIPTION | Description up to 3997 characters followed by ‘…’ is taken |
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
NOTE_TYPE | Value : ‘Notes’ | ||
_MASTER | notes | NOTE_VALUE | Notes up to 3997 characters followed by ‘…’ is taken |
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_ATTRIBUTE | attribute | ATTRIBUTE_NAME | Attribute name for the Classification code |
_ATTRIBUTE | value | ATTRIBUTE_VALUE | Attribute Value for the Attribute Name. There can be multiple values applicable for same attribute name. For example, OGA, PGA can have multiple values. |
_ATTRIBUTE | description | ATTRIBUTE_DESCRIPTION | Description for the attribute value applicable. |
GTM Attribute Name | Description |
---|---|
OGA | Other Government Agency Indicator |
PGA | Participating Government Agency Indicator |
ADD_FLAG | Anti-Dumping Duties Flag |
CVD_FLAG | Countervailing Duties Flag |
SITC | Standard International Trade Classification |
ENDUSE_CD | End Use Classification |
ASUSDA_FLAG | ASUSDA Flag |
NAICS | North American Industry Classification System (NAICS) Classification |
HITECH | Hi-Tech Flag |
QUOTA_INDICATOR | Quota Program Indicator |
SHORT_DESCRIPTION | A shortened version of the tariff description often used for printing on documentation |
IS_AES_REPORTABLE | Indicator that the HS code can be used for US Export Declarations (AES Filing). If not populated, a Schedule-B Code must be submitted instead. |
LACEY | Lacey Act Flag |
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_UOM | name | UOM_NAME | Identifies the parameter name for which the unit of measure needs to be reported. The value can be either REPORTING UOM 1, REPORTING UOM 2. |
_UOM | oracle_unit_code | UOM_CODE | Standard UOM in which the quantity should be send. |
_UOM | country_specific_UOM | REPORTING_UOM | UOM in which the quantity should be reported. |
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_PART | part_id | GTM_PROD_CLASS_CODE_PART_GID | Product Classification Code Part ID is created by concatenating the Data Version ID and part_id with an underscore ‘_’. |
_PART | part_hscode | CLASSIFICATION_CODE_PART | Classification Code |
_PART | parent_id | PARENT_GID |
parent_id is the parent part ID and its detail must be present in the same file. Concatenation of Dataversion_parent_id is saved as Parent GID. This is used to display the classification code details in tree format. |
ROOT_GID | Chapter for the product classification code |
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_PART | iso_language | GTM_LANGUAGE_GID | Language |
_PART | part_desc | DESCRIPTION | Description up to 3997 characters followed by ‘…’ is taken |
Tariff Details Mapping
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_TRADE_PROGRAM_TYPES | TRADE_PROGRAM_TYPE | GTM_TARIFF_TYPE_GID | Trade Program Type ID |
_TRADE_PROGRAM_TYPES | TRADE_PROGRAM_TYPE_DESCRIPTION | TARIFF_TYPE_NAME | Trade Program Name |
_TRADE_PROGRAM_TYPES | TRADE_PROGRAM_TYPE | EXTERNAL_REFERENCE_CODE | External Code for Trade Program Type |
HTS (Harmonized Tariff Schedule) Tariff Schedule Mapping
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_TRADE_PROGRAM | TRADE_PROGRAM_ID | GTM_TARIFF_CODE_GID |
Unique identifier used by GTM to create trade program for a particular version. Trade Program ID is a concatenation of Data_Version_ID+’_’+Product ClassificationType+’_’+ TRADE_PROGRAM_ID. To identify the trade program based on the data version and product classification type. |
_TRADE_PROGRAM | SHORT_NAME | TARIFF_CODE_SHORT_NAME | Trade Program Short Name |
_TRADE_PROGRAM | NAME | TARIFF_CODE_NAME | Trade Program Name |
_TRADE_PROGRAM | FTA_ID | GTM_TRADE_AGREEMENT | Trade Agreement Short Name |
_TRADE_PROGRAM | IS_INCLUDED | IS_INCLUDE_COUNTRY | Specifies if the countries mentioned in the table TARIFF_COUNTRY are included or excluded in the rate calculation for trade program. |
_TRADE_PROGRAM | TRADE_PROGRAM_TYPE_ID | GTM_TARIFF_TYPE_GID | Trade Program Type ID |
_TRADE_PROGRAM | IS_DEFAULT_TRADE_PROGRAM | IS_DEFAULT | Specifies if the trade program is the default. |
_TRADE_PROGRAM | TRADE_PREFERENCE+COUNTRY_CODE2 | GTM_TRADE_PREFERENCE_GID | Trade Preference ID is the concatenation of TRADE_PREFERENCE+’-’+COUNTRY_CODE2 |
_TRADE_PROGRAM | TRADE_PROGRAM_ID | EXTERNAL_REFERENCE_CODE | External Code for Trade Program |
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_TRADE_PROGRAM | TRADE_PREFERENCE+COUNTRY_CODE2 | GTM_TRADE_PREFERENCE_GID |
Unique identifier used by GTM to create trade preference. Trade Preference ID is a concatenation of TRADE_PREFERENCE+’-’+COUNTRY_CODE2 |
_TRADE_PROGRAM | TRADE_PREFERENCE | CODE | Trade Preference Name |
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_TARIFF_COUNTRIES | TRADE_PROGRAM_ID | GTM_TARIFF_CODE_GID |
Unique identifier used by GTM to create trade program for a particular version. Trade Program ID is a concatenation of Data_Version_ID+’_’+Product ClassificationType+’_’+ TRADE_PROGRAM_ID. To identify the trade program based on the data version and product classification type. |
_TARIFF_COUNTRIES | ORIGIN_COUNTRY_CD | COUNTRY_CODE3_GID | Country Code ID. It is a 2-digit country code. |
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_TARIFF_RATE | TRADE_PROGRAM_ID | GTM_TARIFF_CODE_GID |
Unique identifier used by GTM to create trade program for a particular version. Trade Program ID is a concatenation of Data_Version_ID+’_’+Product ClassificationType+’_’+ TRADE_PROGRAM_ID. To identify the trade program based on the data version and product classification type. |
_TARIFF_RATE | CLASSIFICATION_CODE | CLASSIFICATION_CODE | Product Classification Code |
_TARIFF_RATE | ADDVALOREM_RATE | ADDVALOREM_RATE | The percentage rate used for calculating the tariffs based on the value of goods imported. |
_TARIFF_RATE | PER_UNIT_CHARGE | PER_UNIT_CHARGE | The amount to be paid as tariff for each unit of goods imported. |
_TARIFF_RATE | UNIT_CODE | UOM_CODE | The UOM code to use with per unit charge. |
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_ROO_TRADE_AGREEMENTS | fta_id | GTM_TRADE_AGREEMENT_GID | Trade Agreement ID |
_ROO_TRADE_AGREEMENTS | fta_id | EXTERNAL_REFERENCE_CODE | Trade Agreement ID |
_ROO_TRADE_AGREEMENTS | shortname | GTM_TA_SHORT_NAME | Short Name |
_ROO_TRADE_AGREEMENTS | fta_name | GTM_TA_NAME | Name |
_ROO_TRADE_AGREEMENTS | Fta_type | GTM_TA_TYPE_GID | Trade Agreement Type |
_ROO_TRADE_AGREEMENTS | effective_Date | EFFECTIVE_DATE | Effective Date |
_ROO_TRADE_AGREEMENTS | expiration_Date | EXPIRATION_DATE | Expiration Date |
ECCN (Dual-Use Export Control Classification Numbers) Mapping
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_MASTER | mstr_id | GTM_PROD_CLASS_CODE_GID |
Unique identifier used by GTM to create classification code for a particular version. Product Classification Code ID is a concatenation of Data_Version_ID+’_’+mstr_id. To identify the classification code based on the data version. |
_MASTER | ‘ECCN ‘ + iso_country | GTM_PROD_CLASS_TYPE_GID |
Product Classification Type is a concatenation of data_type + <space> + (2-digit)country_code Eg: For country = US, Product Classification Type would be ‘ECCN US’. |
_MASTER | eccn_no | CLASSIFICATION_CODE | Actual Product Classification Code |
_MASTER | eff_beg_dt | EFFECTIVE_DATE | The date from which the classification code is active |
_MASTER | eff_end_dt | EXPIRATION_DATE | Expiration date of the classification code |
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_MASTER | iso_language | GTM_LANGUAGE_GID | Language |
_MASTER | eccn_desc | DESCRIPTION | Description up to 3997 characters followed by ‘…’ is taken |
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_MASTER | NOTE_TYPE | Value : ‘Notes’ | |
_MASTER | notes | NOTE_VALUE | Notes up to 3997 characters followed by ‘…’ is taken |
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_MASTER | unit | UNIT | Units of Measure |
_MASTER | at | CONTROL-AT | Reason for Control: Anti-Terrorism |
_MASTER | at1 | CONTROL-AT1 | Reason for Control: Anti-Terrorism Column 1 |
_MASTER | at2 | CONTROL-AT2 | Reason for Control: Anti-Terrorism Column 2 |
_MASTER | cb | CONTROL-CB | Reason for Control: Chemical & Biological Weapons |
_MASTER | cb1 | CONTROL-CB1 | Reason for Control: Chemical & Biological Weapons Column 1 |
_MASTER | cb2 | CONTROL-CB2 | Reason for Control: Chemical & Biological Weapons Column 2 |
_MASTER | cb3 | CONTROL-CB3 | Reason for Control: Chemical & Biological Weapons Column 3 |
_MASTER | cc | CONTROL-CC | Reason for Control: Crime Control |
_MASTER | cc1 | CONTROL-CC1 | Reason for Control: Crime Control Column 1 |
_MASTER | cc2 | CONTROL-CC2 | Reason for Control: Crime Control Column 2 |
_MASTER | cc3 | CONTROL-CC3 | Reason for Control: Crime Control Column 3 |
_MASTER | cw | CONTROL-CW | Reason for Control: Chemical Weapons |
_MASTER | ei | CONTROL-EI | Reason for Control: Encryption Items |
_MASTER | fc1 | CONTROL-FC1 | Reason for Control: Firearms Convention Column 1 |
_MASTER | mt1 | CONTROL-MT1 | Reason for Control: Missile Tech Column 1 |
_MASTER | mt2 | CONTROL-MT2 | Reason for Control: Missile Tech Column 2 |
_MASTER | np | CONTROL-NP | Reason for Control: Nuclear Nonproliferation |
_MASTER | np1 | CONTROL-NP1 | Reason for Control: Nuclear Nonproliferation Column 1 |
_MASTER | np2 | CONTROL-NP2 | Reason for Control: Nuclear Nonproliferation Column 2 |
_MASTER | ns1 | CONTROL-NS1 | Reason for Control: National Security Column 1 |
_MASTER | ns2 | CONTROL-NS2 | Reason for Control: National Security Column 2 |
_MASTER | rs | CONTROL-RS | Reason for Control: Regional Stability |
_MASTER | rs1 | CONTROL-RS1 | Reason for Control: Regional Stability Column 1 |
_MASTER | rs2 | CONTROL-RS2 | Reason for Control: Regional Stability Column 2 |
_MASTER | si | CONTROL-SI | Reason for Control: Significant Items |
_MASTER | sl | CONTROL-SL | Reason for Control: Surreptitious Listening |
_MASTER | ss | CONTROL-SS | Reason for Control: Short Supply |
_MASTER | un | CONTROL-UN | Reason for Control: United Nations Embargo |
_MASTER | z | CONTROL-Z | Generic attribute for items regulated by other agencies |
_MASTER | agr | EXCEPTION-AGR | License Exception: Agricultural Commodities |
_MASTER | app | EXCEPTION-APP | License Exception: Computers |
_MASTER | apr | EXCEPTION-APR | License Exception: Additional Permissive Re-exports |
_MASTER | avs | EXCEPTION-AVS | License Exception: Aircraft, Vessels and Spacecraft |
_MASTER | bag | EXCEPTION-BAG | License Exception: Baggage |
_MASTER | civ | EXCEPTION-CIV | License Exception: Civil End-Users |
_MASTER | enc | EXCEPTION-ENC | License Exception: Encryption Commodities, Software and Technology |
_MASTER | gbs | EXCEPTION-GBS | License Exception: Shipments to Country Group B Countries |
_MASTER | gft | EXCEPTION-GFT | License Exception: Gift Parcels and Humanitarian Donations |
_MASTER | gov | EXCEPTION-GOV | License Exception: Governments, International Organizations, International Inspections Under the Chemical Weapons Convention, and the International Space Station |
_MASTER | kmi | EXCEPTION-KMI | License Exception: Key Management Infrastructure – Amendments Only |
_MASTER | lvs | EXCEPTION-LVS | License Exception: Shipments of Limited Value |
_MASTER | rpl | EXCEPTION-RPL | License Exception: Servicing and Replacement of Parts and Equipment |
_MASTER | sta | EXCEPTION-STA | License Exception: Strategic Trade Authorization |
_MASTER | tmp | EXCEPTION-TMP | License Exception: Temporary Imports, Exports, Reexports, and Transfers (In-Country) |
_MASTER | tsr | EXCEPTION-TSR | License Exception: Technology and Software Under Restriction |
_MASTER | tsu | EXCEPTION-TSU | License Exception: Technology and Software Unrestricted |
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_PART | part_id | GTM_PROD_CLASS_CODE_PART_GID | Product Classification Code Part ID is created by concatenating the Data Version ID and part_id with an underscore ‘_’. |
_PART | eccn_no | CLASSIFICATION_CODE_PART | Classification Code |
_PART | parent_id | PARENT_GID | Concatenation of Dataversion_parent_id is saved as Parent GID. This is used to display the classification code details in tree format. |
ROOT_GID | Chapter for the product classification code |
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_PART | iso_language | GTM_LANGUAGE_GID | Language |
_PART | eccn_desc | DESCRIPTION | Description up to 3997 characters followed by ‘…’ is taken |
ML (Munitions List) Mapping
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_MASTER | id | GTM_PROD_CLASS_CODE_GID |
Unique identifier used by GTM to create classification code for a particular version. Product Classification Code ID is a concatenation of Data_Version_ID+’_’+ id. To identify the classification code based on the data version. |
_MASTER | country_cd | GTM_PROD_CLASS_TYPE_GID |
Product Classification Type is a concatenation of ML + <space> + (2-digit) country_code Eg: For country US, Product Classification Type would be ‘ML US’. |
_MASTER | ml_code | CLASSIFICATION_CODE | Actual Product Classification Code |
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_MASTER | iso_language | GTM_LANGUAGE_GID | Language |
_MASTER | ml_desc | DESCRIPTION | Description up to 3997 characters followed by ‘…’ is taken |
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_MASTER | note | NOTE | Description up to 3997 characters followed by ‘…’ is taken |
_MASTER | note1 | NOTE1 | Description up to 3997 characters followed by ‘…’ is taken |
_MASTER | note2 | NOTE2 | Description up to 3997 characters followed by ‘…’ is taken |
_MASTER | note3 | NOTE3 | Description up to 3997 characters followed by ‘…’ is taken |
_MASTER | note4 | NOTE4 | Description up to 3997 characters followed by ‘…’ is taken |
_MASTER | note5 | NOTE5 | Description up to 3997 characters followed by ‘…’ is taken |
_MASTER | note6 | NOTE6 | Description up to 3997 characters followed by ‘…’ is taken |
_MASTER | sme_ind | SME INDICATOR | Significant Military Equipment Indicator |
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_PART | ID | GTM_PROD_CLASS_CODE_PART_GID | Product Classification Code Part ID is created by concatenating the Data Version ID and part_id with an underscore ‘_’. |
_PART | ml_code | CLASSIFICATION_CODE_PART | Classification Code |
_PART | parent_id | PARENT_GID | Concatenation of Dataversion_parent_id is saved as Parent GID. This is used to display the classification code details in tree format. |
ROOT_GID | Chapter for the product classification code |
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_PART | iso_language | GTM_LANGUAGE_GID | Language |
_PART | ml_desc | DESCRIPTION | Description up to 3997 characters followed by ‘…’ is taken |