These settings are independent of both an organization and a profile. 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.

Database Connection Name

Select the database name that specifies the country database connection string from the list.

This setting is available only when Validate From DB is selected above.

DB Schema

Enter the name of a schema to filter the list of database tables available for the selected Database Connection Name.

If this field is left blank, all database tables that you have permission to access, are displayed.

This setting is available only when Validate From DB is selected above.

DB Table Name

Select the country database table name. The list is populated based on the selected Database Connection Name and if used, the specified schema. If the selected table has columns that match the settings below, they are populated automatically.

This setting is mandatory.

This setting is available only when Validate From DB is selected above.

DB Country

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

This setting is available only when Validate From DB is selected above.

DB Currency

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

This setting is available only when Validate From DB is selected above.

DB EU Member

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

This setting is available only when Validate From DB is selected above.

DB Name

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

This setting is available only when Validate From DB is selected above.

DB VAT Rates

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

This setting is available only when Validate From DB is selected above.

The following buttons are available at the bottom of the window.

Save

Saves your changes and the window is closed.

Reload

Deletes any unsaved changes and resets the field values back to the last saved settings.