List of principal subdivisions.

Table Specific Information

The connector uses the Wave Financial API to process some of the filters. The connector processes other filters client-side within the connector. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause inconsistent data. For example, the following queries are processed server side.

SELECT

SELECT * FROM Provinces WHERE CountryCode = 'US'

Columns

Name	Type	References	SupportedOperators	Description
Code [KEY]	String			[ISO 3166-2](https://en.wikipedia.org/wiki/ISO_3166-2) identifier.
CountryCode	String	Countries.Code		Country code.
Name	String			Plain-language representation.