SYSTEMCOUNTRIES: Data Dictionary Countries
read only
- Catalog:
DataDictionary - Schema:
Invantive - Label: Countries
Countries.
Can only retrieve data.
Table Columns
The columns of the table SYSTEMCOUNTRIES are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
CALLING_ |
varchar2 |
Calling Code | Calling code. | ||
DIALING_ |
varchar2 |
Dialing Plan Prefix | Dialing plan prefix. | ||
IBAN_ |
uint16 |
IBAN Account Length | Length of the IBAN-accounts. | ||
ISO_ |
varchar2 |
ISO Code | ISO code. | ||
IS_ |
boolean |
Is EU Member | Whether the country is a member state of the European Union. | ||
IS_ |
boolean |
Is SEPA Member | Whether the country is a member state of the Single European Payment Area (SEPA). | ||
IS_ |
boolean |
Is Service Area | Whether the country is within the Invantive service area. | ||
NAME |
varchar2 |
Name | Name in English. | ||
RESOURCE_ |
varchar2 |
Resource Code | Code of the resource for the country name. | ||
SINGLE_ |
varchar2 |
Single-Language Code | ISO code of the language when there is only one official language. | ||
TIMEZONE_ |
varchar2 |
Time Zone Offsets | Timezone offsets used in the country. | ||
TOP_ |
varchar2 |
Top-level Domain | Top-level domain. |
Referenced By
- SYSTEMTIMEZONES
COUNTRY_CODE(Key)
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: