invantive documentation
Invantive Support ForumsLog In / Sign Up

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_CODE varchar2(30) Calling Code Calling code.
DIALING_PLAN_PREFIX varchar2(30) Dialing Plan Prefix Dialing plan prefix.
IBAN_ACCOUNT_LENGTH uint16 IBAN Account Length Length of the IBAN-accounts.
ISO_CODE varchar2(2) ISO Code ISO code.
IS_EU_MEMBER boolean Is EU Member Whether the country is a member state of the European Union.
IS_SEPA_MEMBER boolean Is SEPA Member Whether the country is a member state of the Single European Payment Area (SEPA).
IS_SERVICE_AREA boolean Is Service Area Whether the country is within the Invantive service area.
NAME varchar2(240) Name Name in English.
RESOURCE_CODE varchar2(60) Resource Code Code of the resource for the country name.
SINGLE_LANGUAGE_CODE varchar2(30) Single-Language Code ISO code of the language when there is only one official language.
TIMEZONE_OFFSETS varchar2(240) Time Zone Offsets Timezone offsets used in the country.
TOP_LEVEL_DOMAIN varchar2(30) Top-level Domain Top-level domain.

Referenced By

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: