SYSTEMCOUNTRIES: Data Dictionary Countries |
Countries.
Catalog: DataDictionary
Schema: Invantive
Alias: cty
Label: Countries
This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive UniversalSQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API.
View Columns
The columns of the view SYSTEMCOUNTRIES are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
CALLING_CODE |
string(30) |
Calling Code |
☐ |
Calling code. |
DIALING_PLAN_PREFIX |
string(30) |
Dialing Plan Prefix |
☐ |
Dialing plan prefix. |
IBAN_ACCOUNT_LENGTH |
uint16 |
IBAN Account Length |
☐ |
Length of the IBAN-accounts. |
IS_EU_MEMBER |
boolean |
|
☑ |
Whether the country is a member state of the European Union. |
IS_SEPA_MEMBER |
boolean |
|
☑ |
Whether the country is a member state of the Single European Payment Area (SEPA). |
ISO_CODE |
string(2) |
ISO Code |
☑ |
ISO code. |
NAME |
string(240) |
Name |
☑ |
Name in English. |
RESOURCE_CODE |
string(60) |
Resource Code |
☑ |
Code of the resource for the country name. |
SINGLE_LANGUAGE_CODE |
string(30) |
Single-Language Code |
☐ |
ISO code of the language when there is only one official language. |
TIMEZONE_OFFSETS |
string(240) |
Timezone Offsets |
☑ |
Timezone offsets used in the country. |
TOP_LEVEL_DOMAIN |
string(30) |
Top-level Domain |
☐ |
Top-level domain. |
18-10-2024 06:49 Version 24.0.345-PROD+4945