UK Trade Tariff

Description

UK Trade Tariff also known as UK Integrated Tariff is a ten digit commodity classification code system based on the EU TARIC (TARiff Integre Communautaire).

Codes are assigned to imported and exported goods in order to identify what duties and controls apply and ensure a correct customs declaration.

1WorldSync Content Solutions assigns UK Trade Tariff codes to the SKUs based on the specifically defined attribute mapping rules. These rules are maintained and updated according to UK Trade Tariff codes changes to ensure the coverage and the quality of the codes assignment.

Database structure

UK Trade Tariff codes are provided in the Alternative Categorization tables.

Please click here to see the related tables.

Related Queries

SELECT p.prodid,
       p.catid,
       v.categoryname,
       p.isprimary,
       v.languageid,
       c.breadcrumbs
FROM   cds_cct_products p
       JOIN cds_cct_vocabulary v
         ON v.catid = p.catid
       JOIN cds_cct_categories c
         ON c.catid = p.catid
       JOIN cds_cct_version ve
         ON ve.versionid = p.versionid
WHERE  p.prodid = 'PRODUCTID'
       AND ve.versiondescription LIKE'UKTT%'
ORDER  BY Length(p.catid),
          p.catid