Customs Tariffs (as of version 10.1)

WRDA_CountryGroup

As of version 10.1

The WRDA_CountryGroup view provides the country groups administered in the system settings.

Field description

Field	Description
CountryGroupID	int, not null Internal ID of the country group
CountryGroupName	nvarchar(max), null Name of the country group in the Company language
CountryGroupName _[Country identifier]	nvarchar(max), null Name of the country group in the language according to the country code. Example: CountryGroupName_EN for the English name.
Short	nvarchar(255), null Short label of the country group.
IsValid	bit, null Deletion tag. Returns the value 1 if the country group is to be used, otherwise the value 0 is returned.

 

WRDA_CustomsTariffNumber

As of version 10.1

The WRDA_CustomsTariffNumber view provides the customs tariff numbers administered in the system settings.

Field description

Field	Description
CustomsTariffNumberID	int, not null Internal ID of the customs tariff number
CustomsTariffNumber	nvarchar(255), null Customs Tariff Number
CustomsTariffNumberName	nvarchar(max), null Name of the customs tariff number in the Company language
CustomsTariffNumberName _[Country identifier]	nvarchar(max), null Name of the customs tariff number in the language according to the country code. Example: CustomsTariffNumberName_EN for the English name.
CustomsTariffNumberDescription	nvarchar(max), null Description of the customs tariff number in the Company language
CustomsTariffNumberDescription _[Country identifier]	nvarchar(max), null Description of the customs tariff number in the language according to the country code. Example: CustomsTariffNumberDescription_EN for the English description.
IsValid	bit, null Deletion tag. Returns the value 1 if the customs tariff number is to be used, otherwise, the value 0 is returned.

WRDA_CustomsTariffs

The WRDA_CustomsTariffs view provides the customs tariff administered in the Data Administration.

Relations

Field (WRDA_CustomsTariffs)	Field	Table / View
CustomsTariffNumberID	CustomsTariffNumberID	WRDA_CustomsTariffNumber
OriginCountryGroupId	CountryGroupID	WRDA_CountryGroup
ReveivingCountryGroupId	CountryGroupID	WRDA_CountryGroup
CustomsTariffRateUnitID	UnitID	WRDA_Units
CreatorID	DAUserID	WRDA_Users
ModifierID	DAUserID	WRDA_Users

Field description

Field	Description
DACustomsTariffID	int, not null Internal ID of the customs tariff.
CustomsTariffNumberID	int, not null Internal ID of the customs tariff number (see WRDA_CustomsTariffNumber)
OriginCountryGroupId	int, not null Internal ID of the country group of the origin country (see WRDA_CountryGroup)
ReceivingCountryGroupId	int, not null Internal ID of the country group of the receiving country (see WRDA_CountryGroup)
ValidFrom	int, not null The year as of which the customs tariff is valid
CustomsTariffRate	int, not null Value of the customs tariff The value 0.1 equals 10%
CustomsTariffRateUnitID	int, not null Internal unit ID of the customs tariff (see WRDA_Units)
CreatorID	int, null Internal ID of the user who created the data record. The name of the user can be determined via the foreign key (DAUserID) in the WRDA_Users view.
CreationDateTime	datetime, null Creation date of the data record
ModifierID	int, null Internal ID of the user who last updated the data record. The name of the user can be determined via the foreign key (DAUserID) in the WRDA_Users view.
LastUpdateDateTime	datetime, null Modification date