Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
---|---|---|---|---|---|---|---|---|---|
INR | Internal Unique ID | Text | 40 | 1 | Edit | Yes | Public | ||
TAG | tag | Text | 3 | 1 | Edit | Yes | Public | ||
MODIFICATION | modification Flag | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
RECKEY | record key | Text | 12 | 1 | Edit | Yes | Public | ||
INSTITUTION | Institution name | Text | 105 | 1 | Edit | Yes | Public | ||
CITY | City Heading | Text | 35 | 1 | Edit | Yes | Public | ||
BRANCH | Branch Information | Text | 70 | 1 | Edit | Yes | Public | ||
BIC | BIC Code | Text | 8 | 1 | Edit | Yes | Public | ||
BRANCHCODE | Branch Code | Text | 3 | 1 | Edit | Yes | Public | ||
BICUNIQUE | Unique BIC Code | Text | 8 | 1 | Edit | Yes | Public | ||
BRANCHUNIQUE | Unique Branch Code | Text | 3 | 1 | Edit | Yes | Public | ||
IBANBIC | IBAN Bic Code | Text | 8 | 1 | Edit | Yes | Public | ||
IBANBRANCH | IBAN Branch Code | Text | 3 | 1 | Edit | Yes | Public | ||
ROUTBIC | Routing BIC Code | Text | 8 | 1 | Edit | Yes | Public | ||
ROUTBRANCH | Routing Branch Code | Text | 3 | 1 | Edit | Yes | Public | ||
PARENTBK | Parent Bank Code | Text | 4 | 1 | Edit | Yes | Public | ||
CTY | Country Code | Text | 2 | 1 | Edit | Yes | Public | ||
NATID | National ID | Text | 15 | 1 | Edit | Yes | Public | ||
NATIDUNIQUE | Unique National ID | Text | 15 | 1 | Edit | Yes | Public | ||
IBANCTY | IBAN Country Code | Text | 2 | 1 | Edit | Yes | Public | ||
IBANNATID | IBAN National ID | Text | 15 | 1 | Edit | Yes | Public | ||
IBANNATIDUNIQUE | Unique IBAN National ID | Text | 15 | 1 | Edit | Yes | Public | ||
OTHNATID1 | Other National ID 1 | Text | 17 | 1 | Edit | Yes | Public | ||
OTHNATID2 | Other National ID 2 | Text | 17 | 1 | Edit | Yes | Public | ||
CHIPS | Chips Uid | Text | 6 | 1 | Edit | Yes | Public | ||
SUBTYPE | Subtype Indicator | Text | 4 | 1 | Edit | Yes | Public | ||
SRV | Services Codes | Text | 60 | 1 | Edit | Yes | Public | ||
BRANCHQUA | Branch Qualifier | Text | 35 | 1 | Edit | Yes | Public | ||
SPECCOD | Special Code | Text | 6 | 1 | Edit | Yes | Public | ||
ADR1 | Physical Address 1 | Text | 35 | 1 | Edit | Yes | Public | ||
ADR2 | Physical Address 2 | Text | 35 | 1 | Edit | Yes | Public | ||
ADR3 | Physical Address 3 | Text | 35 | 1 | Edit | Yes | Public | ||
ADR4 | Physical Address 4 | Text | 35 | 1 | Edit | Yes | Public | ||
ZIPCOD | ZIP Code | Text | 15 | 1 | Edit | Yes | Public | ||
LOC | Location | Text | 90 | 1 | Edit | Yes | Public | ||
CTYNAM | Country Name | Text | 70 | 1 | Edit | Yes | Public | ||
POBNO | POB Number | Text | 35 | 1 | Edit | Yes | Public | ||
POBZIBCOD | POB Zip Code | Text | 15 | 1 | Edit | Yes | Public | ||
POBLOC | POB Location | Text | 90 | 1 | Edit | Yes | Public | ||
POBCTY | POB Country Name | Text | 70 | 1 | Edit | Yes | Public | ||
NATIDEXPDAT | National ID Expiry Date | Date | 12 | 0 | Date | Yes | Public | ||
UPDDAT | Date of last Update | Date | 12 | 0 | Date | Yes | Public | ||
IBANKEY | Record Key in IBAN Plus File | Text | 12 | 1 | Edit | Yes | Public |
Name | Fields | Properties |
---|---|---|
BID_BIC | BIC, BRANCHCODE | |
BID_BICUNIQUE | BICUNIQUE, BRANCHUNIQUE | |
BID_INR | INR | Unique |
/
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 BID.
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.
Record Identifier: BI
Record Identifier: BI
Modification flag: - A (addition) - M (modification) - D (deletion) - U (unchanged) - E (expired):reserved for future use
Modification flag: - A (addition) - M (modification) - D (deletion) - U (unchanged) - E (expired):reserved for future use
Code | Text |
---|---|
A | addition |
M | modification |
D | deletion |
U | unchanged |
E | expired |
The unique key of the record in the file: the key is made up of the ISO Country code and a sequential number of 6 digits.
The unique key of the record in the file: the key is made up of the ISO Country code and a sequential number of 6 digits.
Institution name
Institution name
City name
City name
Branch information
Branch information
BIC (institution, country, and location code): - institution code (4 char) - country code (2 char) - location code (2 char) BIC CODE is the BIC related to the National ID (the account servicing institution) if matched with a national code.
BIC (institution, country, and location code): - institution code (4 char) - country code (2 char) - location code (2 char) BIC CODE is the BIC related to the National ID (the account servicing institution) if matched with a national code.
BIC (branch code) Branch code (XXX for main office) associated to BIC CODE
BIC (branch code) Branch code (XXX for main office) associated to BIC CODE
BIC (institution, country, and location code): - institution code (4 char) - country code (2 char) - location code (2 char) UNIQUE BIC CODE is the BIC CODE. For search purposes, the value is unique within the active records (that is, only records with a modification flag of U, A, or M).
BIC (institution, country, and location code): - institution code (4 char) - country code (2 char) - location code (2 char) UNIQUE BIC CODE is the BIC CODE. For search purposes, the value is unique within the active records (that is, only records with a modification flag of U, A, or M).
BIC (branch code) Branch code (XXX for main office) associated to UNIQUE BIC CODE
BIC (branch code) Branch code (XXX for main office) associated to UNIQUE BIC CODE
BIC (institution, country, and location code): - institution code (4 char) - country code (2 char) - location code (2 char) IBAN BIC CODE is the BIC issued together with the IBANs to the bank's clients.
BIC (institution, country, and location code): - institution code (4 char) - country code (2 char) - location code (2 char) IBAN BIC CODE is the BIC issued together with the IBANs to the bank's clients.
BIC (branch code) Branch code (XXX for main office) associated to IBAN BIC CODE.
BIC (branch code) Branch code (XXX for main office) associated to IBAN BIC CODE.
BIC (institution, country, and location code): - institution code (4 char) - country code (2 char) - location code (2 char) ROUTING BIC CODE is meant for SWIFT messaging purposes. When the IBAN BIC CODE is a non-connected BIC (BIC1), the ROUTING BIC CODE is filled to provide an addressable code on the SWIFT network.
BIC (institution, country, and location code): - institution code (4 char) - country code (2 char) - location code (2 char) ROUTING BIC CODE is meant for SWIFT messaging purposes. When the IBAN BIC CODE is a non-connected BIC (BIC1), the ROUTING BIC CODE is filled to provide an addressable code on the SWIFT network.
BIC (branch code) Branch code (XXX for main office) associated to ROUTING BIC CODE.
BIC (branch code) Branch code (XXX for main office) associated to ROUTING BIC CODE.
Bank code of the parent BIC. This field contains the first 4 characters of the BIC CODE of the parent institution (or if not available, of the IBAN BIC CODE).
Bank code of the parent BIC. This field contains the first 4 characters of the BIC CODE of the parent institution (or if not available, of the IBAN BIC CODE).
ISO country code of the financial institution.
ISO country code of the financial institution.
National identifier of the bank
National identifier of the bank
National ID. Value is unique in the data file per COUNTRY CODE (for search purposes). The value is unique within the active records (that is, only records with a modification flag of U, A, or M).
National ID. Value is unique in the data file per COUNTRY CODE (for search purposes). The value is unique within the active records (that is, only records with a modification flag of U, A, or M).
ISO country code prefix of the IBAN that the bank issues.
ISO country code prefix of the IBAN that the bank issues.
The National ID as included in the IBAN. IBAN National ID can slightly differ from the Bank and Branch identifiers as defined in the ISO13616 IBAN structure. See the table in “IBAN Country Codes and BBANs” for the differences.
The National ID as included in the IBAN. IBAN National ID can slightly differ from the Bank and Branch identifiers as defined in the ISO13616 IBAN structure. See the table in “IBAN Country Codes and BBANs” for the differences.
IBAN National ID. For search purposes, value is unique in the data file per IBAN Country Code. The value is unique within the active records (that is, only records with a modification flag of U, A, or M). See the table in “IBAN Country Codes and BBANs” for the differences.
IBAN National ID. For search purposes, value is unique in the data file per IBAN Country Code. The value is unique within the active records (that is, only records with a modification flag of U, A, or M). See the table in “IBAN Country Codes and BBANs” for the differences.
For some countries (for example: Slovakia), 2 types of national ID co-exist; the “Other National ID” fields can take care of these special cases. Furthermore, banks can obtain foreign national IDs, even when they are not physically located in that foreign country. Threrfore, provision is made in the BICPlusIBAN to include National IDs for countries other than the country of residence. For example, Lloyds Bank London can have a BLZ number. In this case, for the corresponding record in the BICPlusIBAN, a field National ID is filled with the appropriate BSC code. An “Other national ID” field will contain DE for Germany, and the appropriate BLZ number. If available for the corresponding National ID, the Special Code is appended after national ID.
For some countries (for example: Slovakia), 2 types of national ID co-exist; the “Other National ID” fields can take care of these special cases. Furthermore, banks can obtain foreign national IDs, even when they are not physically located in that foreign country. Threrfore, provision is made in the BICPlusIBAN to include National IDs for countries other than the country of residence. For example, Lloyds Bank London can have a BLZ number. In this case, for the corresponding record in the BICPlusIBAN, a field National ID is filled with the appropriate BSC code. An “Other national ID” field will contain DE for Germany, and the appropriate BLZ number. If available for the corresponding National ID, the Special Code is appended after national ID.
For some countries (for example: Slovakia), 2 types of national ID co-exist; the “Other National ID” fields can take care of these special cases. Furthermore, banks can obtain foreign national IDs, even when they are not physically located in that foreign country. Threrfore, provision is made in the BICPlusIBAN to include National IDs for countries other than the country of residence. For example, Lloyds Bank London can have a BLZ number. In this case, for the corresponding record in the BICPlusIBAN, a field National ID is filled with the appropriate BSC code. An “Other national ID” field will contain DE for Germany, and the appropriate BLZ number. If available for the corresponding National ID, the Special Code is appended after national ID.
For some countries (for example: Slovakia), 2 types of national ID co-exist; the “Other National ID” fields can take care of these special cases. Furthermore, banks can obtain foreign national IDs, even when they are not physically located in that foreign country. Threrfore, provision is made in the BICPlusIBAN to include National IDs for countries other than the country of residence. For example, Lloyds Bank London can have a BLZ number. In this case, for the corresponding record in the BICPlusIBAN, a field National ID is filled with the appropriate BSC code. An “Other national ID” field will contain DE for Germany, and the appropriate BLZ number. If available for the corresponding National ID, the Special Code is appended after national ID.
CHIPS Universal ID for the financial institution.
CHIPS Universal ID for the financial institution.
Type of financial institution See the BIC Directors Business Codes for a complete list of subtype indicators and their definitions.
Type of financial institution See the BIC Directors Business Codes for a complete list of subtype indicators and their definitions.
Service codes: value added services that the financial institution has subscribed to. For example: RTGSplus in Germany, BIREL in Italy. TGT - Target2 direct participants. STG - Chaps Sterling (RTGS) in United Kingdom. A plus sign (+) as the third character indicates another participant of this service. See the BIC Directory Business Codes for a complete list of service codes. Positions (20 * 3 char, there are no spaces between the codes): - 1- 48: can contain up to 16 three-character service codes in alphabetical order - 49 -51: can contain the preferred service code. If not used, the are left blank - 52-60: are reserved for future use
Service codes: value added services that the financial institution has subscribed to. For example: RTGSplus in Germany, BIREL in Italy. TGT - Target2 direct participants. STG - Chaps Sterling (RTGS) in United Kingdom. A plus sign (+) as the third character indicates another participant of this service. See the BIC Directory Business Codes for a complete list of service codes. Positions (20 * 3 char, there are no spaces between the codes): - 1- 48: can contain up to 16 three-character service codes in alphabetical order - 49 -51: can contain the preferred service code. If not used, the are left blank - 52-60: are reserved for future use
BIC branch qualifiers (see the BIC Directory Business Codes for a complete list of the branch qualifiers and their definitions). For example. ADM = Administration, BKO - Back office. Positions (there are no spaces between the codes): - 1-18: can contain up to 6 three-character branch qualifiers in alphabetic order - 19-35: are unused and left empty
BIC branch qualifiers (see the BIC Directory Business Codes for a complete list of the branch qualifiers and their definitions). For example. ADM = Administration, BKO - Back office. Positions (there are no spaces between the codes): - 1-18: can contain up to 6 three-character branch qualifiers in alphabetic order - 19-35: are unused and left empty
Specific Information (Special Code) from the National record for the financial institution (for a list, sww “Secial Code Field”).
Specific Information (Special Code) from the National record for the financial institution (for a list, see “Special Code Field”).
Physical address (part 1 to 4) Where possible, physical address fields are formatted to show the following logical groups of information, in the following sequence (each logical group is delimited by a “:”): - Contact Person: - Building, Floor, Apartment: - Street Number, Street Name, Street Cardinal Point: - Second Street Number, Second Street Number, Second Street Cardinal Point See also “Text Field”.
Physical address (part 1 to 4) Where possible, physical address fields are formatted to show the following logical groups of information, in the following sequence (each logical group is delimited by a “:”): - Contact Person: - Building, Floor, Apartment: - Street Number, Street Name, Street Cardinal Point: - Second Street Number, Second Street Number, Second Street Cardinal Point See also “Text Field”.
Physical address (part 1 to 4) Where possible, physical address fields are formatted to show the following logical groups of information, in the following sequence (each logical group is delimited by a “:”): - Contact Person: - Building, Floor, Apartment: - Street Number, Street Name, Street Cardinal Point: - Second Street Number, Second Street Number, Second Street Cardinal Point See also “Text Field”.
Physical address (part 1 to 4) Where possible, physical address fields are formatted to show the following logical groups of information, in the following sequence (each logical group is delimited by a “:”): - Contact Person: - Building, Floor, Apartment: - Street Number, Street Name, Street Cardinal Point: - Second Street Number, Second Street Number, Second Street Cardinal Point See also “Text Field”.
Physical address (part 1 to 4) Where possible, physical address fields are formatted to show the following logical groups of information, in the following sequence (each logical group is delimited by a “:”): - Contact Person: - Building, Floor, Apartment: - Street Number, Street Name, Street Cardinal Point: - Second Street Number, Second Street Number, Second Street Cardinal Point See also “Text Field”.
Physical address (part 1 to 4) Where possible, physical address fields are formatted to show the following logical groups of information, in the following sequence (each logical group is delimited by a “:”): - Contact Person: - Building, Floor, Apartment: - Street Number, Street Name, Street Cardinal Point: - Second Street Number, Second Street Number, Second Street Cardinal Point See also “Text Field”.
Physical address (part 1 to 4) Where possible, physical address fields are formatted to show the following logical groups of information, in the following sequence (each logical group is delimited by a “:”): - Contact Person: - Building, Floor, Apartment: - Street Number, Street Name, Street Cardinal Point: - Second Street Number, Second Street Number, Second Street Cardinal Point See also “Text Field”.
Physical address (part 1 to 4) Where possible, physical address fields are formatted to show the following logical groups of information, in the following sequence (each logical group is delimited by a “:”): - Contact Person: - Building, Floor, Apartment: - Street Number, Street Name, Street Cardinal Point: - Second Street Number, Second Street Number, Second Street Cardinal Point See also “Text Field”.
Zip code
Zip code
Location Where possible, the location field is formatted to show the following logical groups of information, in this sequence: “Suburb, City, Region, State”.
Location Where possible, the location field is formatted to show the following logical groups of information, in this sequence: “Suburb, City, Region, State”.
Country name
Country name
POB number
POB number
POB zip code
POB zip code
POB location
POB location
POB country name
POB country name
Expiry Date: the date on which the national ID has been removed by the national authority. This field is reserved for future use.
Expiry Date: the date on which the national ID has been removed by the national authority. This field is reserved for future use.
The date on which a BI record was last updated.
The date on which a BI record was last updated.
Identifies the RECORD KEY in the IBAN Plus - stored in Table IBN
Identifies the RECORD KEY in the IBAN Plus - stored in Table IBN