User Tools
Add this page to your book 
Remove this page from your book 
Manage book (
Help Table of Contents
CTY - Country
Module CTY
The country table describes the available countries and specifies the association of a country to a region (see REG - Region).
Datafields
| Name | Helptext Description | Data Type | Len | Codetable |
|---|---|---|---|---|
| INR | Internal Unique ID | Text | 8 | |
| COD | Country Code | Text | 2 | CTYTXT |
| CUR | Currency | Text | 3 | CURTXT |
| REG | Region | Text | 4 | REGTXT |
| VER | Version | Text | 4 | |
| FMTDOMADRTYP | Domestic Address Format | Text | 1 | Embedded |
| FMTINTADRTYP | International Address Format | Text | 1 | Embedded |
| IBANCCPOS | IBAN Country Code Position | Numeric | 2 | |
| IBANCCLEN | IBAN Country Code Length | Numeric | 1 | |
| IBANCHKDIGPOS | IBAN Check Digits Position | Numeric | 2 | |
| IBANCHKDIGLEN | IBAN Check Digits Length | Numeric | 2 | |
| IBANBANKIDPOS | Bank Identifier Position | Numeric | 2 | |
| IBANBANKIDLEN | Bank Identifier Length | Numeric | 2 | |
| IBANBRANCHIDPOS | Branch Identifier Position | Numeric | 2 | |
| IBANBRANCHIDLEN | Branch Identifier Length | Numeric | 2 | |
| IBANNATIDLEN | IBAN National ID Length | Numeric | 2 | |
| IBANACCNBPOS | IBAN Account Number position | Numeric | 2 | |
| IBANACCNBLEN | Account Number Length | Numeric | 2 | |
| IBANTOTLEN | IBAN Total Length | Numeric | 2 | |
| SEPA | IBAN used in SEPA scheme | Text | 1 | Embedded |
| IBANOPTCOMDAT | Optional Commence Date | Date | 12 | |
| IBANMANCOMDAT | Mandatory Commence Date | Date | 12 | |
| ISOFLG | ISO13616 | Text | 1 | Embedded |
| ANFRECKEY | ANF Record Key | Text | 12 | |
| IBNCTYCOD | IBAN Country Codes | Text | 2 | CTYTXT |
| AWVNBR | country key | Text | 3 | |
| GETFLDNRM | Field holding the normalized search fields. | Text | 10 |
Datafield Description and Properties
Datafield INR Internal Unique ID
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.
Datafield COD Country Code
This is the unique code used throughout the system to identify a country.
Datafield CUR Currency
This field holds the currency code of the currency used in that country.
Datafield REG Region
This field holds the code of the region associated to this country.
Datafield VER Version
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.
Datafield FMTDOMADRTYP Domestic Address Format
Selection field for sample domestic address formats
Codetable
| Code | Text |
|---|---|
| A | Address Type A |
| B | Address Type B |
| C | Address Type C |
| D | Address Type D |
Datafield FMTINTADRTYP International Address Format
Selection field for sample international address formats.
Codetable
| Code | Text |
|---|---|
| A | Address Type A |
| B | Address Type B |
| C | Address Type C |
| D | Address Type D |
Datafield AWVNBR country key
added for use in germany (Aussenwirtschaftsverkehrsnummer der Bundesbank)
Datafield IBANCCPOS IBAN Country Code Position
Start position of the country code in IBAN
Datafield IBANCCLEN IBAN Country Code Length
Number of Characters of the Country Code in the IBAN
Datafield IBANCHKDIGPOS IBAN Check Digits Position
Start position of check digits in the IBAN
Datafield IBANCHKDIGLEN IBAN Check Digits Length
Number of characters of IBAN check digits
Datafield IBANBANKIDPOS Bank Identifier Position
Start position of bank identifier in the IBAN
Datafield IBANBANKIDLEN Bank Identifier Length
Number of characters of the bank identifier in the IBAN
Datafield IBANBRANCHIDPOS Branch Identifier Position
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)
Datafield IBANBRANCHIDLEN Branch Identifier Length
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)
Datafield IBANNATIDLEN IBAN National ID Length
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.
Datafield IBANACCNBPOS IBAN Account Number position
Start position of the account number in IBAN
Datafield IBANACCNBLEN Account Number Length
Number of characters of account number in IBAN
Datafield IBANTOTLEN IBAN Total Length
Total Length of IBAN
Datafield SEPA IBAN used in SEPA scheme
This flag indicates if the IBAN is used in the SEPA Scheme
Codetable
| Code | Text |
|---|---|
| Y | Yes |
| N | No |
Datafield IBANOPTCOMDAT Optional Commence Date
The date from which the IBAN structure is an optional requirement
Datafield IBANMANCOMDAT Mandatory Commence Date
The date from which the IBAN structure is a mandatory requirement
Datafield GETFLDNRM Field holding the normalized search fields.
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.
Datafield ISOFLG ISO13616
Indicates whether the IBAN format has been registered with ISO13616 in file IBANSTRUCTURE_V2: (“Y” means yes) or not (“N” means no)
Codetable
| Code | Text |
|---|---|
| Y | Registered with ISO13616 |
| N | Not registered with ISO13616 |
Datafield ANFRECKEY ANF Record Key
The RECORD KEY of the corresponding record, also defining the format of the IBAN, in the ACCOUNT NUMBER FORMAT file
