These settings are independent of clients and profiles. They enable the system to point to a lookup table that contains information about which countries are part of the EU and their local currencies. These settings also help to automatically determine tax codes.

The following settings are available.

Validate From DB

If selected, the country is validated against a database.

SQL Connection Group

The SQL connection group that specifies the country database connection string, as set in the Solution Configuration Manager > Global Settings > Database Connection Settings. If no connection group is specified, the system uses group 1.

This option is available only when "Validate From DB" is selected.

DB Table Name

The country database table name. This setting is mandatory for database lookups.

This option is available only when "Validate From DB" is selected.

DB Country

The name of the country database table column with the country key.

This option is available only when "Validate From DB" is selected.

DB Currency

The name of the country database table column with the country currency.

This option is available only when "Validate From DB" is selected.

DB EU Member

The name of the country database table column that indicates if a country is an EU state member.

This option is available only when "Validate From DB" is selected.

DB Name

The name of the country database table column with the full name of the country in English.

This option is available only when "Validate From DB" is selected.

DB VAT Rates

The name of the country database table column with the VAT rates.

This option is available only when "Validate From DB" is selected.