NXTCountries
Returns a list of countries.
Table Specific Information
Select
The driver will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the driver.
- Id supports the '=' operator.
SELECT * FROM NXTCountries SELECT * FROM NXTCountries WHERE Id = 1
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | The immutable system record ID of the country. | |
| Name | String | The country name. | |
| Abbreviation | String | The country abbreviation. | |
| IsoCode | String | The ISO code for the country. | |
| LabelFormatCountry | String | The label format identifier for the country. | |
| CurrencyType | String | The currency type name. | |
| CurrencyTypeId | Integer | The currency type ID. | |
| CurrencySymbol | String | The currency symbol. | |
| CurrencyPlacementId | String | The placement of the currency symbol relative to the amount. | |
| ExchangeRate | Double | The exchange rate relative to the base currency. | |
| ThousandSeparator | String | The thousands separator character. | |
| DecimalSeparator | String | The decimal separator character. | |
| DecimalDigits | Integer | The number of decimal digits for currency amounts. | |
| LeadingZero | Boolean | Whether to display a leading zero for decimal amounts. |