Rules of Origin Data Mapping
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
|
Supported fta_type values are PREFERENTIAL and NON-PREFERENTIAL.
File Name | Cntent Provider Element | GTM Element | Description |
---|---|---|---|
_ROO_TRADEAGREEMENTS_PARTNERS | fta_id | GTM_TRADE_AGREEMENT_GID | Trade Agreement ID |
_ROO_TRADEAGREEMENTS_PARTNERS | Partner_Name | REGION_GID |
Region ID Cocatenation of partner_name+”_”+fta_id |
_ROO_TRADEAGREEMENTS_PARTNERS | Iso_Country_Cd | COUNTRY_CODE3_GID | Country Code ID |
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_ROO_HEADER | roo_id |
GTM_RULES_OF_ORIGIN_GID GTM_RULES_OF_ORIGIN_XID |
Unique identifier used by GTM to create rules of origin ID for a particular version. Rules of Origin ID is a concatenation of Data_Version_ID+’_’+ id. For Example: If the data version is 26877and rool_id is EU_GB, ID is created as 26877_EU_GB To identify the rules of origin based on the data version. |
_ROO_HEADER | name | GTM_RULES_OF_ORIGIN_NAME | Rules of Origin Name |
_ROO_HEADER | roo_id | SHORT_NAME | Short Name |
_ROO_HEADER | roo_id | EXTERNAL_REFERENCE_CODE | External Reference Code |
_ROO_HEADER | Rule_type | GTM_RULES_OF_ORIGIN_TYPE | Rules of Origin Type |
_ROO_HEADER | Fta_id | TRADE_AGREEMENT_SHORT_NAME | Trade Agreement Name |
_ROO_HEADER | End_dt | EXPIRATION_DATE | Expiration Date |
_ROO_HEADER | Partner_name | REGION_GID |
Identifies the region for which the Rules of origin is applicable. If it is a region in trade_agreement_partners, region_gid is created |
_ROO_HEADER | Partner_name | COUNTRY_CODE3_GID |
Identifies the country of import for which the Rules of origin is applicable. If it is a country code in trade_agreement_partners, country_code3_gid is created |
_ROO_HEADER | Version_number | -- | Not mapped to any GTM element. It is used to uniquely identify the roo_header file as a mapping for rule of origin data |
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_ROO_PSRULES | roo_id |
GTM_RULES_OF_ORIGIN_GID |
Rules of Origin ID is a concatenation of Data_Version_ID+’_’+ id. For Example: If the data version is 26877and rool_id is EU_GB, ID is created as 26877_EU_GB To identify the rules of origin based on the data version. |
_ROO_PSRULES | Hs_Start | START_CLASSIFICATION_CODE | Defines the code level starting range |
_ROO_PSRULES | Hs_end | END_CLASSIFICATION_CODE | Defines the code level ending range. |
_ROO_PSRULES | Suffix | SUFFIX | Holds the suffix value. |
_ROO_PSRULES | Ex | IS_EX | Determines if rollup to parent Harmonized System code is needed. |
_ROO_PSRULES | Attribute | ATTRIBUTE | Holds the description. |
_ROO_PSRULES | Rule_Expression | EXPRESSION |
Note : The expression should be in the below format · {ruleCode1} · {ruleCode1} OR {ruleCode2} · {ruleCode1} AND {ruleCode2} · ({ruleCode1}) AND ({ruleCode2} AND {ruleCode3})For example, · ({TS4_100EQ}) OR ({RVCT_50GE} AND {TS6_100EQ})· {EXCL:17} AND {TS2_100EQ} |
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_ROO_PSRULE_CODES | roo_id | GTM_RULES_OF_ORIGIN_GID |
Rules of Origin ID is a concatenation of Data_Version_ID+’_’+ id. For Example: If the data version is 26877and rool_id is EU_GB, ID is created as 26877_EU_GB To identify the rules of origin based on the data version. |
_ROO_PSRULE_CODES | rule | GTM_ROO_RULE_CODE_GID |
Rules of Origin Code ID is a concatenation of Data_Version_ID+’_’+ roo_id+”_”+rule. For Example: If the data version is 26877, rool_id is EU_GB and rule is ‘DMN_10LE’, ID is created as 26877_EU_GB_DMN_10LE
To identify the rules of origin codes based on the data version and rules of origin. |
_ROO_PSRULE_CODES | Rule | GTM_ROO_RULE_CODE_NAME | Rule Code Name |
_ROO_PSRULE_CODES | Rule | EXTERNAL_REFERENCE_CODE | External Reference Code |
_ROO_PSRULE_CODES | Rule_Type | GTM_ROO_RULE_TYPE_GID | Rules of Origin Type |
_ROO_PSRULE_CODES | HS_Start | START_CLASSIFICATION_CODE | Defines the code level starting range. |
_ROO_PSRULE_CODES | HS_End | END_CLASSIFICATION_CODE | Defines the code level ending range. |
_ROO_PSRULE_CODES | Percentage | PERCENTAGE_VALUE | Stores the percentage value. |
_ROO_PSRULE_CODES | Operator | PERCENTAGE_OPERATOR | Stores the percentage operator. The values can be any of <,>,<=,>=,= |
- THIRD COUNTRY CHECK
- FIFTY, CONDITION
- HS EXCLUSION
- HS INCLUSION
- RVC – NC
- RVC – TV
- RVC – UP
- RVC – DOWN
- TS – CHAPTER
- TS – HEADING
- TS – SUBHEADING
- TS - ITEM
- NTS – CHAPTER
- NTS – HEADING
- NTS – SUBHEADING
- NTS – ITEM
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_ROO_PSRULE_CODE_DESCS | Rule | GTM_ROO_RULE_CODE_GID |
Rules of Origin Code ID is a concatenation of Data_Version_ID+’_’+ roo_id+”_”+rule. For Example: If the data version is 26877, rool_id is EU_GB and rule is ‘DMN_10LE’, ID is created as 26877_EU_GB_DMN_10LE To identify the rules of origin codes based on the data version and rules of origin. |
_ROO_PSRULE_CODE_DESCS | language | GTM_LANGUAGE_GID | Language |
_ROO_PSRULE_CODE_DESCS | Text | TEXT | Description |
File Name | Content Provider Element | GTM Element | Description |
---|---|---|---|
_ROO_BASE_RULES | roo_id | GTM_RULES_OF_ORIGIN_GID |
Rules of Origin ID is a concatenation of Data_Version_ID+’_’+ id. For Example: If the data version is 26877and rool_id is EU_GB, ID is created as 26877_EU_GB To identify the rules of origin based on the data version. |
_ROO_BASE_RULES | base_rule_type_name | GTM_ROO_BASE_RULE_TYPE | The rules of origin base rule type can be any of the values: DEMIN, SETOFGOODS or MINOPS |
_ROO_BASE_RULES | base_rule_code | EXPRESSION | The expression for rules of origin base rule. |
ROO_BASE_RULE_TYPE | Expression Format |
---|---|
DEMIN | {DMN_10LE} |
SETOFGOODS | {SOG_10LE} |
MINOPS | {MOP_00EQ} |