The country table describes the available countries and specifies the association of a country to a region (see REG - Region).
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 |
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 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 code of the region associated to this country.
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 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 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)
Start position of the country code in IBAN
Number of Characters of the Country Code in the IBAN
Start position of check digits in the IBAN
Number of characters of IBAN check digits
Start position of 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)
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.
Start position of the account number in IBAN
Number of characters of account number in IBAN
Total Length of IBAN
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 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.
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