Countries

Create, select, update, and delete information regarding countries.

Table-Specific Information

The add-in processes all filters client-side within the add-in. The following queries are the only ones processed server-side:

SELECT * FROM Countries

SELECT * FROM Countries WHERE Id = '123'

You must specify the Code to create a country.

INSERT INTO Countries (Code) VALUES ("FR")

You must specify the country Id to update a country. For example:

UPDATE Countries SET Tax = 0.1 WHERE Id = '123'

You must specify the Id of the country to delete it.

DELETE FROM Countries WHERE id = '123'


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A unique numeric identifier for the country.
Name	String	True		The name of the country.
Code	String	False		The code of the country.
Tax	Decimal	False		The amount of tax which should be applied for this country.
Provinces	String	False		The sub-regions of a country, such as its provinces or states. Each sub-region has the following properties: code: The two letter province or state code, country_id: The ID for the country to which this sub-region belongs, id: The ID for the particular sub-region, name: The name of the sub-region, tax: The tax value in decimal format, tax_name: The name of the tax as it is referred to in the applicable sub-region. For example, in Canada, the sales tax in the province Ontario is referred to as HST, tax_type: The tax type. Valid values: null, normal, or harmonized. If the value is harmonized, then the tax is compounded of the provincial and federal sales taxes, tax_percentage: The tax value in percent format