Customs Product Database functionalities
The purpose of the Customs Product Database is that a company can Create Products by means of registering ten digit commodity codes (Taric). On this basis all relevant Tariff data as provided by the api is made available to the User.
In addition to below mock ups, the basis is that a User should be able to retrieve data easily by entering the 10 digit Commodity code + origin. Similar to the Website of the authorities.


What we want to offer is the combination of the Legal data with the practical business data.
Overview Page
Showing the Taric codes created via Create Product i.e. enter 10 digit code which is validate on existence upon save. Indeed existing the related data from the Tariff database is retrieved and stored. On this Page only the Legal description shows , the start date and the Excise additional code. The other columns are manual input in relation to Products by commercial names that are registered by he User under a Taric code. For example, under the Taric code 2707500080, you see multiple commercial Products, such as "Blend TN 160", "C7 "(Toluene)" etc.


Create Product
![]()
Via the Create Product a User specifies the 10 digit commodity code (Taric). Upon save it is validated to verify existence. If existing it is saved.

Consider the Taric code as a 'bucket'.
In addition to the mock ups, I would like to be able to add a a description describing the characteristics of the Taric code. So effectively on the main page it should show a column called Characteristics next to to the column Legal description.
After registering the 'bucket' commercial Products can be added with details that are relevant on different levels, such as on the Product level itself, start date, end date, etc. Details on a National level, related to national taxes (Country details). Lastly, details on the company level can be added, such as 'labels' created by the company itself. In this case "Quality group" and "Usual Forms of Handling".
Excise additional reference (Product Country Detail)
Below another example. Here you see the "Product Country Details" under Excise Controlled populated with Y, because from the Tariff information it is found that there is an U code, showing under "Excise Additional Reference" for Taric Code 2710201129. It could be that there are more codes available. In that case the User can choose and save his selection here. The U code is an element also showing on the main page in a column.

From the main Page, the User can also enter the Tariff information as provided by the authorities.

When selecting the details are shown similar to the website from Dutch Customs


All Blue text are hyperlinks to underlying data, e.g.
Here it should also show the duty rates, etc.
Tariff Measures Page