Table of all countries.
| Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
|---|---|---|---|---|---|---|---|---|---|
| INR | Internal Unique ID of Country | Text | 8 | 1 | Edit | Yes | Public | ||
| COD | Country Code | Text | 2 | 1 | Edit | Yes | Public | CTYTXT | |
| CUR | Currency | Text | 3 | 1 | Edit | Yes | Public | CURTXT | |
| REG | Region | Text | 4 | 1 | Edit | Yes | Public | REGTXT | |
| VER | Version Counter | Text | 4 | 1 | Edit | Yes | Public | ||
| FMTDOMADRTYP | Domestic Address | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| FMTINTADRTYP | International Address Type | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| IBANCCPOS | IBAN Country Code Position | Numeric | 2 | 0 | Edit | Yes | Public | ||
| IBANCCLEN | IBAN Country Code length | Numeric | 1 | 0 | Edit | Yes | Public | ||
| IBANCHKDIGPOS | IBAN Check Digits Position | Numeric | 2 | 0 | Edit | Yes | Public | ||
| IBANCHKDIGLEN | IBAN Check digits length | Numeric | 2 | 0 | Edit | Yes | Public | ||
| IBANBANKIDPOS | Start position of bank identifier in the IBAN | Numeric | 2 | 0 | Edit | Yes | Public | ||
| IBANBANKIDLEN | Bank Identifier length | Numeric | 2 | 0 | Edit | Yes | Public | ||
| IBANBRANCHIDPOS | Branch identifier position in IBAN | Numeric | 2 | 0 | Edit | Yes | Public | ||
| IBANBRANCHIDLEN | Branch Identifier Length in IBAN | Numeric | 2 | 0 | Edit | Yes | Public | ||
| IBANNATIDLEN | IBAN National ID Length | Numeric | 2 | 0 | Edit | Yes | Public | ||
| IBANACCNBPOS | IBAN Account number position | Numeric | 2 | 0 | Edit | Yes | Public | ||
| IBANACCNBLEN | Account number length | Numeric | 2 | 0 | Edit | Yes | Public | ||
| IBANTOTLEN | IBAN Total length | Numeric | 2 | 0 | Edit | Yes | Public | ||
| SEPA | IBAN used in SEPA scheme | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| IBANOPTCOMDAT | Optional commence date | Date | 12 | 0 | Date | Yes | Public | ||
| IBANMANCOMDAT | Mandatory commence date | Date | 12 | 0 | Date | Yes | Public | ||
| ISOFLG | ISO13616 | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| ANFRECKEY | ANF Record Key | Text | 12 | 1 | Edit | Yes | Public | ||
| IBNCTYCOD | IBAN Country Codes | Text | 2 | 1 | Edit | Yes | Public | CTYTXT | |
| AWVNBR | Country key | Text | 3 | 1 | Edit | Yes | Public | ||
| GETFLDNRM | Field holding the normalized search fields | Text | 10 | 1 | Edit | Yes | Public |
| Name | Fields | Properties |
|---|---|---|
| CTY_COD | COD | Unique |
| CTY_GETFLDNRM | GETFLDNRM | |
| CTY_INR | INR | Unique |
/
INR
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter CTY. The field INR is used to maintain links from other tables into this table. Additionally for performance reasons the COD of a country is used in many application tables as a link, as often only the code is needed and in this case no resolution of a link is necessary to get this information.
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter of this table. The field INR is used to enable links from other tables to this table.
For contractdata the INR also links the two tables xxD and xxT as associated entries hold the same INR.
This is the systemwide used unique code to identify a country.
This is the unique code used throughout the system to identify a country.
This field holds the currency code of the currency used in that country.
This field holds the currency code of the currency used in that country.
This field holds the region code of the region this country is associated to.
This field holds the code of the region associated to this country.
This field holds the version counter to keep track of the version history of a CTY entry. The individual versions are controlled by entries in the SLG table.
This field holds the version counter used to keep track of the history of an entry of this table. The individual versions are managed by entries in the SLG table.
Selection field for sample domestic address field
Selection field for sample domestic address formats
| Code | Text |
|---|---|
| A | Address Type A |
| B | Address Type B |
| C | Address Type C |
| D | Address Type D |
Selection field for sample international address field
Selection field for sample international address formats.
| Code | Text |
|---|---|
| A | Address Type A |
| B | Address Type B |
| C | Address Type C |
| D | Address Type D |
added for use in germany (Aussenwirtschaftsverkehrsnummer der Bundesbank)
added for use in germany (Aussenwirtschaftsverkehrsnummer der Bundesbank)
Start position of the country code in IBAN
Start position of the country code in IBAN
Number of Characters of the Country Code in the IBAN
Number of Characters of the Country Code in the IBAN
Start position of check digits in the IBAN
Start position of check digits in the IBAN
Number of check digitd in the IBAN
Number of characters of IBAN check digits
Start position of bank identifier in the IBAN
Start position of bank identifier in the IBAN
Number of characters of the bank identifier in the IBAN
Number of characters of the bank identifier in the IBAN
Start position of the branch identifier in the IBAN (Value is empty if the branch identifier is not applied in the country's IBAN format)
Start position of the branch identifier in the IBAN. (Value is empty if the branch identifier is not applied in the country's IBAN format)
Number of characters of the branch identifier in the IBAN (Value is 0 if the branch identifier is not applied in the country's IBAN format)
Number of characters of the branch identifier in the IBAN. (Value is 0 if the branch identifier is not applied in the country's IBAN format)
Number of significant characters of the national ID value that are used by SWIFT to populate the IBAN NATIONAL ID , and that are sufficient to derive the IBAN BIC correctly. This number can be different from (that is, smaller than) the length of the national bank/branch identifier defined in the IBAN Registry. As SWIFT refines its IBAN to BIC translation algorithms, this number may change from release to release.
Number of significant characters of the national ID value that are used by SWIFT to populate the IBAN NATIONAL ID , and that are sufficient to derive the IBAN BIC correctly. This number can be different from (that is, smaller than) the length of the national bank/ branch identifier defined in the IBAN Registry. As SWIFT refines its IBAN to BIC translation algorithms, this number may change from release to release.
Start position of the account number in IBAN
Start position of the account number in IBAN
Number of characters of account number in IBAN
Number of characters of account number in IBAN
The total number of characters of the IBAN
Total Length of IBAN
This flag indicates if the IBAN is used in the SEPA Scheme: Y if it does N if it does not
This flag indicates if the IBAN is used in the SEPA Scheme
| Code | Text |
|---|---|
| Y | Yes |
| N | No |
The date from which the IBAN structure is an optional requirement
The date from which the IBAN structure is an optional requirement
The date from which the IBAN structure is a mandatory requirement
The date from which the IBAN structure is a mandatory requirement
Field holding the concatenated and normalized sum of all search fields used by quick search. This is one of the fields set in a SdbSetNRMFields method defined in the table definition module.
Field holding the concatenated and normalized sum of all search fields used by quick search. This is one of the fields set in a SdbSetNRMFields method defined in the table definition module.
Indicates whether the IBAN format has been registered with ISO13616 in file IBANSTRUCTURE_V2: (“Y” means yes) or not (“N” means no)
Indicates whether the IBAN format has been registered with ISO13616 in file IBANSTRUCTURE_V2: (“Y” means yes) or not (“N” means no)
| Code | Text |
|---|---|
| Y | Registered with ISO13616 |
| N | Not registered with ISO13616 |
The RECORD KEY of the corresponding record, also defining the format of the IBAN, in the ACCOUNT NUMBER FORMAT file
The RECORD KEY of the corresponding record, also defining the format of the IBAN, in the ACCOUNT NUMBER FORMAT file
Alternative ISO Country code in case the IBAN Country code is different from Country ISO Code. Example: The ISO Code for Guernsay is “GG” but in IBAN the Code GB is used.