Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
---|---|---|---|---|---|---|---|---|---|
INR | Internal Unique ID | Text | 40 | 1 | Edit | Yes | Public | ||
BIC | BIC Code | Text | 11 | 1 | Edit | Yes | Public | ||
BICADDRESSEE | Addressee BIC | Text | 11 | 1 | Edit | Yes | Public | ||
BICACCOUNT | Account BIC | Text | 11 | 1 | Edit | Yes | Public | ||
INSTITUTION | Institution name | Text | 105 | 1 | Edit | Yes | Public | ||
CITY | City Heading | Text | 35 | 1 | Edit | Yes | Public | ||
NATSRTCODE | National Sorting Code | Text | 15 | 1 | Edit | Yes | Public | ||
MAINBICFLAG | Main Bic Flag | Text | 1 | 1 | Edit | Yes | Public | ||
MODIFICATION | Modification Flag | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
PARTICIPATIONTYPE | Participation Type | Text | 2 | 1 | Edit | Yes | Public | Embedded | |
CUR | Currency | Text | 3 | 1 | Edit | Yes | Public | ||
BEGDAT | Valid from | Date | 15 | 0 | Date | Yes | Public | ||
ENDDAT | Valid to | Date | 15 | 0 | Date | Yes | Public |
Name | Fields | Properties |
---|---|---|
TAD_BIC | CUR, BIC, BEGDAT | Unique |
TAD_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 TAD.
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.
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 (institution, country, and location code): - institution code (4 char) - country code (2 char) - location code (2 char) Target2 Addressee BIC is the BIC CODE to which target2 messages shall be sent.
BIC (institution, country, and location code): - institution code (4 char) - country code (2 char) - location code (2 char) Target2 Addressee BIC is the BIC CODE to which Target2 messages shall be sent.
Target2 Account BIC
Target2 Account BIC It is the BIC identifying the T2 RTGS DCA (Dedicated Cash Account) or CB (Central Bank) Account. For Target2 this is the account where the funds of a payment will be booked.
Institution name
It is the name stored in the T2 RTGS BIC Directory together with the T2 Addressee BIC.
City name
It is the name of the city where the T2 RTGS Participant is established.
National Sorting Code of the RTGS Participant
National Sorting Code of the T2 RTGS Participant
The Main BIC Flag specifies if the BIC could be used to address the payments if the sender has no other information where to send to
The Main BIC Flag specifies if the BIC could be used to address T2 RTGS payments if the sender has no other information where to send to.
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 |
Participation type
Code | Text |
---|---|
01 | Direct |
02 | Indirect |
03 | Multi Addressee - Credit Institutions |
04 | Multi Addressee - Branch of Direct Participant |
05 | Addressable BIC - Correspondent |
06 | Addressable BIC - Branch of Direct Participant |
07 | Addressable BIC - Branch of Indirect Participant |
08 | Addressable BIC - Branch of Correspondent |
Currency for which this BIC is defined
Currency for which this BIC is defined.
This entriy is valid from the date defined in this field
This entry is valid until the date named in this field