Trade Agreements
Certificate of Origin: Data Mapping Details
The following tables provide data mapping details when a Certificate of Origin is generated for an item qualification, campaign, and transaction line.
Item Qualification
Section |
Field |
Table Name |
Column Name | Description |
---|---|---|---|---|
Document Header |
Trade Agreement Header |
GTM_TRADE_AGREEMENT |
GTM_TA_SHORT_NAME |
Concatenated value of short name and name of the Trade Agreement. |
GTM_TRADE_AGREEMENT |
GTM_TA_NAME |
|||
Exporter Details |
EXPORTER_COMPANY |
CONTACT |
COMPANY_NAME |
The company name of the party. |
EXPORTER_EMAIL |
CONTACT |
EMAIL_ADDRESS |
The email address of the contact person of the party. |
|
EXPORTER_CITY |
LOCATION |
CITY |
The name of the city for the location associated with the party. |
|
EXPORTER_POSTAL_CODE |
LOCATION |
POSTAL_CODE |
The postal code for the location associated with the party. |
|
EXPORTER_PROVINCE_CODE |
LOCATION |
PROVINCE_CODE |
The abbreviation for the province (or a state in the United States of America) for the location associated with the party. |
|
EXPORTER_ADDRESS |
LOCATION_ADDRESS |
ADDRESS_LINE |
The address line information of the party. |
|
EXP_TAX_ID |
GTM_PARTY_REFNUM |
REFNUM_VALUE |
If there exists a Reference Number Qualifier 'EIN' or 'TAX ID NUMBER' on the party, its corresponding reference number value is used. |
|
Blanket Period |
FROM |
|
|
Effective Date selected in the Generate Certificate of Origin action input screen. |
TO |
Expiration Date selected in the Generate Certificate of Origin action input screen. |
|||
Producer Details |
PRODUCER_COMPANY |
CONTACT |
COMPANY_NAME |
The company name of the party. |
PRODUCER_EMAIL |
CONTACT |
EMAIL_ADDRESS |
The email address of the contact person of the party. |
|
PRODUCER_CITY |
LOCATION |
CITY |
The name of the city for the location associated with the party. |
|
PRODUCER_POSTAL_CODE |
LOCATION |
POSTAL_CODE |
The postal code for the location associated with the party. |
|
PRODUCER_PROVINCE_CODE |
LOCATION |
PROVINCE_CODE |
The abbreviation for the province (or a state in the United States of America) for the location associated with the party. |
|
PRODUCER_ADDRESS |
LOCATION_ADDRESS |
ADDRESS_LINE |
The address line information of the party. |
|
PROD_TAX_ID |
GTM_PARTY_REFNUM |
REFNUM_VALUE |
If there exists a Reference Number Qualifier 'EIN' or 'TAX ID NUMBER' on the party, its corresponding reference number value is used. |
|
Importer Details |
IMPORTER_COMPANY |
CONTACT |
COMPANY_NAME |
The company name of the party. |
IMPORTER_EMAIL |
CONTACT |
EMAIL_ADDRESS |
The email address of the contact person of the party. |
|
IMPORTER_CITY |
LOCATION |
CITY |
The name of the city for the location associated on the Party |
|
IMPORTER_POSTAL_CODE |
LOCATION |
POSTAL_CODE |
The postal code for the location associated with the party. |
|
IMPORTER_PROVINCE_CODE |
LOCATION |
PROVINCE_CODE |
The abbreviation for the province (or a state in the United States of America) for the location associated with the party. |
|
IMPORTER_ADDRESS |
LOCATION_ADDRESS |
ADDRESS_LINE |
The address line information of the party. |
|
IMP_TAX_ID |
GTM_PARTY_REFNUM |
REFNUM_VALUE |
If there exists a Reference Number Qualifier 'EIN' or 'TAX ID NUMBER' on the party, its corresponding reference number value is used. |
|
Grid |
DESCRIPTION OF GOOD(S) |
ITEM |
ITEM_NAME |
The name of the item. |
HS TARIFF CLASSIFICATION NUMBER |
ITEM_QF |
CLASSIFICATION_CODE |
The product classification code associated with the product classification type of the item qualification. |
|
PREFERENCE CRITERION |
QF_PREFERENCE_CRITERIA |
EXTERNAL_REFERENCE_CODE |
External reference code of the preference criteria on the item qualification. |
|
PRODUCER |
ITEM_QF |
PRODUCER |
Indicates if the supplier/partner is the producer of the goods. |
|
METHOD |
QF_RVC_METHOD |
QF_RVC_METHOD_XID |
Unique regional value content method ID. |
|
COUNTRY OF ORIGIN |
ITEM_ORIGIN |
COUNTRY_OF_ORIGIN |
The country of origin of the item origin. |
Campaign
Section |
Field |
Table Name |
Column Name | Description |
---|---|---|---|---|
Document Header |
Trade Agreement Header |
GTM_TRADE_AGREEMENT |
GTM_TA_SHORT_NAME |
Concatenated value of short name and name of the Trade Agreement. |
GTM_TRADE_AGREEMENT |
GTM_TA_NAME |
|||
Exporter Details |
EXPORTER_COMPANY |
CONTACT |
COMPANY_NAME |
P_EXPORTER_PARTY_QUALIFIER parameter on PREFERENTIAL_CERTIFICATE_OF_ORIGIN_CAMPAIGN_LINE report is used to get the party qualifier. By default, it is SUPPLIER involved party qualifier. |
EXPORTER_EMAIL |
CONTACT |
EMAIL_ADDRESS |
P_EXPORTER_PARTY_QUALIFIER parameter on PREFERENTIAL_CERTIFICATE_OF_ORIGIN_CAMPAIGN_LINE report is used to get the party qualifier. By default, it is SUPPLIER involved party qualifier. The email address of the contact person of that party on campaign line. |
|
EXPORTER_CITY |
LOCATION |
CITY |
P_EXPORTER_PARTY_QUALIFIER parameter on PREFERENTIAL_CERTIFICATE_OF_ORIGIN_CAMPAIGN_LINE report is used to get the party qualifier. By default, it is SUPPLIER involved party qualifier. The name of the city for the location associated with that party on campaign line. |
|
EXPORTER_POSTAL_CODE |
LOCATION |
POSTAL_CODE |
P_EXPORTER_PARTY_QUALIFIER parameter on PREFERENTIAL_CERTIFICATE_OF_ORIGIN_CAMPAIGN_LINE report is used to get the party qualifier. By default, it is SUPPLIER involved party qualifier. The postal code for the location associated with that party on campaign line. |
|
EXPORTER_PROVINCE_CODE |
LOCATION |
PROVINCE_CODE |
P_EXPORTER_PARTY_QUALIFIER parameter on PREFERENTIAL_CERTIFICATE_OF_ORIGIN_CAMPAIGN_LINE report is used to get the party qualifier. By default, it is SUPPLIER involved party qualifier. The abbreviation for the province (or a state in the United States of America) for the location associated with that party, on campaign line. |
|
EXPORTER_ADDRESS |
LOCATION_ADDRESS |
ADDRESS_LINE |
P_EXPORTER_PARTY_QUALIFIER parameter on PREFERENTIAL_CERTIFICATE_OF_ORIGIN_CAMPAIGN_LINE report is used to get the party qualifier. By default, it is SUPPLIER involved party qualifier. The address line information of that party on campaign line. |
|
EXP_TAX_ID |
GTM_PARTY_REFNUM |
REFNUM_VALUE |
P_EXPORTER_PARTY_QUALIFIER parameter on PREFERENTIAL_CERTIFICATE_OF_ORIGIN_CAMPAIGN_LINE report is used to get the party qualifier. By default, it is SUPPLIER involved party qualifier. If there exists a Reference Number Qualifier 'EIN' or 'TAX ID NUMBER' on that party on campaign line, its corresponding reference number value is used. |
|
Blanket Period |
FROM |
|
|
Effective Date on the campaign. |
TO |
Expiration Date on the Campaign. |
|||
Producer Details |
PRODUCER_COMPANY |
CONTACT |
COMPANY_NAME |
The text shown is "Available upon request by the importing authorities". |
PRODUCER_EMAIL |
CONTACT |
EMAIL_ADDRESS |
||
PRODUCER_CITY |
LOCATION |
CITY |
||
PRODUCER_POSTAL_CODE |
LOCATION |
POSTAL_CODE |
||
PRODUCER_PROVINCE_CODE |
LOCATION |
PROVINCE_CODE |
||
PRODUCER_ADDRESS |
LOCATION_ADDRESS |
ADDRESS_LINE |
||
PROD_TAX_ID |
GTM_PARTY_REFNUM |
REFNUM_VALUE |
||
Importer Details |
IMPORTER_COMPANY |
CONTACT |
COMPANY_NAME |
Party defined against SENDING LEGAL ENTITY parameter in logic configuration, which was used to create the campaign. The company name of the party on the campaign line. |
IMPORTER_EMAIL |
CONTACT |
EMAIL_ADDRESS |
Party defined against SENDING LEGAL ENTITY parameter in logic configuration, which was used to create the campaign. The email address of the contact person of the party on the campaign line. |
|
IMPORTER_CITY |
LOCATION |
CITY |
Party defined against SENDING LEGAL ENTITY parameter in logic configuration, which was used to create the campaign. The name of the city for the location associated with the party on the campaign line. |
|
IMPORTER_POSTAL_CODE |
LOCATION |
POSTAL_CODE |
Party defined against SENDING LEGAL ENTITY parameter in logic configuration, which was used to create the campaign. The postal code for the location associated with the party on the campaign line. |
|
IMPORTER_PROVINCE_CODE |
LOCATION |
PROVINCE_CODE |
Party defined against SENDING LEGAL ENTITY parameter in logic configuration, which was used to create the campaign. The abbreviation for the province (or a state in the United States of America) for the location associated with the party on the campaign line. |
|
IMPORTER_ADDRESS |
LOCATION_ADDRESS |
ADDRESS_LINE |
Party defined against SENDING LEGAL ENTITY parameter in logic configuration, which was used to create the campaign. The address line information of the party on the campaign line. |
|
IMP_TAX_ID |
GTM_PARTY_REFNUM |
REFNUM_VALUE |
Party defined against SENDING LEGAL ENTITY parameter in logic configuration, which was used to create the campaign. If there exists a Reference Number Qualifier 'EIN' or 'TAX ID NUMBER' on the party ( on the campaign line), its corresponding reference number value is used. |
|
Grid |
DESCRIPTION OF GOOD(S) |
GTM_CAMPAIGN_LINE |
LINE_DESCRIPTION |
Trading partner item description on campaign line. |
HS TARIFF CLASSIFICATION NUMBER |
GTM_CAMPAIGN_LINE |
CLASSIFICATION_CODE |
The product classification code associated with the product classification type of the item qualification. |
|
PREFERENCE CRITERION |
QF_PREFERENCE_CRITERIA |
EXTERNAL_REFERENCE_CODE |
External reference code of the preference criterion on the item qualification. |
|
PRODUCER |
GTM_CAMPAIGN_LINE |
PRODUCER |
Indicates if the supplier/partner is the producer of the goods. Generally, it would be a Yes/No. |
|
NET COST |
QF_RVC_METHOD |
EXTERNAL_REFERENCE_CODE |
Unique regional value content method ID provided on campaign line. |
|
COUNTRY OF ORIGIN |
COUNTRY_CODE |
COUNTRY_CODE2 |
The country of origin provided on campaign line. |
Transaction Line
Section |
Field |
Table Name |
Column Name | Description |
---|---|---|---|---|
Document Header |
Trade Agreement Header |
GTM_TRADE_AGREEMENT |
GTM_TA_SHORT_NAME |
Concatenated value of short name and name of the Trade Agreement. |
GTM_TRADE_AGREEMENT |
GTM_TA_NAME |
|||
Exported Details |
EXPORTER_COMPANY |
CONTACT |
COMPANY_NAME |
P_EXPORTER_PARTY_QUALIFIER parameter on PREFERENTIAL_CERTIFICATE_OF_ORIGIN_TRANS_LINE report is used to get the party qualifier. By default, it is SUPPLIER involved party qualifier. The company name of that party on transaction line. |
EXPORTER_EMAIL |
CONTACT |
EMAIL_ADDRESS |
P_EXPORTER_PARTY_QUALIFIER parameter on PREFERENTIAL_CERTIFICATE_OF_ORIGIN_TRANS_LINE report is used to get the party qualifier. By default, it is SUPPLIER involved party qualifier. The email address of the contact person of that party on transaction line. |
|
EXPORTER_CITY |
LOCATION |
CITY |
P_EXPORTER_PARTY_QUALIFIER parameter on PREFERENTIAL_CERTIFICATE_OF_ORIGIN_TRANS_LINE report is used to get the party qualifier. By default, it is SUPPLIER involved party qualifier. The name of the city for the location associated with that party on transaction line. |
|
EXPORTER_POSTAL_CODE |
LOCATION |
POSTAL_CODE |
P_EXPORTER_PARTY_QUALIFIER parameter on PREFERENTIAL_CERTIFICATE_OF_ORIGIN_TRANS_LINE report is used to get the party qualifier. By default, it is SUPPLIER involved party qualifier. The postal code for the location associated with that party on transaction line. |
|
EXPORTER_PROVINCE_CODE |
LOCATION |
PROVINCE_CODE |
P_EXPORTER_PARTY_QUALIFIER parameter on PREFERENTIAL_CERTIFICATE_OF_ORIGIN_TRANS_LINE report is used to get the party qualifier. By default, it is SUPPLIER involved party qualifier. The abbreviation for the province (or a state in the United States of America) for the location associated with that party on transaction line. |
|
EXPORTER_ADDRESS |
LOCATION_ADDRESS |
ADDRESS_LINE |
P_EXPORTER_PARTY_QUALIFIER parameter on PREFERENTIAL_CERTIFICATE_OF_ORIGIN_TRANS_LINE report is used to get the party qualifier. By default, it is SUPPLIER involved party qualifier. The address line information of that party on transaction line. |
|
EXP_TAX_ID |
GTM_PARTY_REFNUM |
REFNUM_VALUE |
P_EXPORTER_PARTY_QUALIFIER parameter on PREFERENTIAL_CERTIFICATE_OF_ORIGIN_TRANS_LINE report is used to get the party qualifier. By default, it is SUPPLIER involved party qualifier. If there exists a Reference Number Qualifier 'EIN' or 'TAX ID NUMBER' on that party on transaction line, its corresponding reference number value is used. |
|
Blanket Period |
FROM |
|
|
Effective Date selected in the Generate Certificate of Origin action input screen. |
TO |
Expiration Date selected in the Generate Certificate of Origin action input screen. |
|||
Producer Details |
PRODUCER_COMPANY |
CONTACT |
COMPANY_NAME |
The test shown is "Available upon request by the importing authorities". |
PRODUCER_EMAIL |
CONTACT |
EMAIL_ADDRESS |
||
PRODUCER_CITY |
LOCATION |
CITY |
||
PRODUCER_POSTAL_CODE |
LOCATION |
POSTAL_CODE |
||
PRODUCER_PROVINCE_CODE |
LOCATION |
PROVINCE_CODE |
||
PRODUCER_ADDRESS |
LOCATION_ADDRESS |
ADDRESS_LINE |
||
PROD_TAX_ID |
GTM_PARTY_REFNUM |
REFNUM_VALUE |
||
Importer Details |
IMPORTER_COMPANY |
CONTACT |
COMPANY_NAME |
P_IMPORTER_PARTY_QUALIFIER LEGAL ENTITY parameter on PREFERENTIAL_CERTIFICATE_OF_ORIGIN_TRANS_LINE report is used to get the party qualifier. By default, it is LEGAL ENTITY involved party qualifier. The company name of that party on transaction line. |
IMPORTER_EMAIL |
CONTACT |
EMAIL_ADDRESS |
P_IMPORTER_PARTY_QUALIFIER LEGAL ENTITY parameter on PREFERENTIAL_CERTIFICATE_OF_ORIGIN_TRANS_LINE report is used to get the party qualifier. By default, it is LEGAL ENTITY involved party qualifier. The email address of the contact person of that party on transaction line. |
|
IMPORTER_CITY |
LOCATION |
CITY |
P_IMPORTER_PARTY_QUALIFIER LEGAL ENTITY parameter on PREFERENTIAL_CERTIFICATE_OF_ORIGIN_TRANS_LINE report is used to get the party qualifier. By default, it is LEGAL ENTITY involved party qualifier. The name of the city for the location associated with that party on transaction line. |
|
IMPORTER_POSTAL_CODE |
LOCATION |
POSTAL_CODE |
P_IMPORTER_PARTY_QUALIFIER LEGAL ENTITY parameter on PREFERENTIAL_CERTIFICATE_OF_ORIGIN_TRANS_LINE report is used to get the party qualifier. By default, it is LEGAL ENTITY involved party qualifier. The postal code for the location associated with that party on transaction line. |
|
IMPORTER_PROVINCE_CODE |
LOCATION |
PROVINCE_CODE |
P_IMPORTER_PARTY_QUALIFIER LEGAL ENTITY parameter on PREFERENTIAL_CERTIFICATE_OF_ORIGIN_TRANS_LINE report is used to get the party qualifier. By default, it is LEGAL ENTITY involved party qualifier. The abbreviation for the province (or a state in the United States of America) for the location associated with that party on transaction line. |
|
IMPORTER_ADDRESS |
LOCATION_ADDRESS |
ADDRESS_LINE |
P_IMPORTER_PARTY_QUALIFIER LEGAL ENTITY parameter on PREFERENTIAL_CERTIFICATE_OF_ORIGIN_TRANS_LINE report is used to get the party qualifier. By default, it is LEGAL ENTITY involved party qualifier. The address line information of that party on transaction line. |
|
IMP_TAX_ID |
GTM_PARTY_REFNUM |
REFNUM_VALUE |
P_IMPORTER_PARTY_QUALIFIER LEGAL ENTITY parameter on PREFERENTIAL_CERTIFICATE_OF_ORIGIN_TRANS_LINE report is used to get the party qualifier. By default, it is LEGAL ENTITY involved party qualifier. If there exists a Reference Number Qualifier 'EIN' or 'TAX ID NUMBER' on that party on transaction line, its corresponding reference number value is used. |
|
Grid |
DESCRIPTION OF GOOD(S) |
GTM_TRANSACTION_LINE |
LINE_ITEM_DESCRIPTION |
Transaction line description. |
HS TARIFF CLASSIFICATION NUMBER |
GTM_TRANS_LINE_QF |
CLASSIFICATION_CODE |
The product classification code associated with the product classification type of the transaction line qualification. |
|
PREFERENCE CRITERION |
QF_PREFERENCE_CRITERIA |
EXTERNAL_REFERENCE_CODE |
External reference code of the preference criteria on the transaction line qualification. |
|
PRODUCER |
GTM_TRANS_LINE_QF |
PRODUCER |
Indicates if the supplier/partner is the producer of the goods. |
|
NET COST |
QF_RVC_METHOD |
EXTERNAL_REFERENCE_CODE |
External reference code of the regional value content method ID provided on transaction line qualification. |
|
COUNTRY OF ORIGIN |
COUNTRY_CODE |
COUNTRY_CODE2 |
The country of origin on the transaction line. |