The entity address is used as a table to hold address information
used in letterheads and other messages as address of the different
departments of the bank using the application.
Thus, normal users and entities might be pointing to an ETA entry to
identify the address information to be used. Beneath the ETA table
there is a language-specific subtable ETAUIL, where address
information might be stored in different languages for each ETA
entry.
Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
---|---|---|---|---|---|---|---|---|---|
INR | Internal Unique ID of Entity Address | Text | 8 | 1 | Edit | Yes | Public | ||
EXTKEY | Entity Address ID | Text | 8 | 1 | 20 | Unknown | Yes | Public | |
NAM | Name of the Entity Address | Text | 40 | 1 | Edit | Yes | Public | ||
VER | Version Counter | Text | 4 | 1 | Edit | Yes | Public | ||
ETY | Entity | Text | 8 | 1 | Edit | Yes | Public | ||
PRIFLG | Main ETA | Text | 1 | 1 | Edit | Yes | Public | ||
BOLEML | Email Address for Bolero Terminal | Text | 140 | 1 | 80 | Edit | Yes | Public | |
BOLPWD | Password for Private Key (obfuscated) | Text | 80 | 1 | Edit | Yes | Public | ||
BOLRID | Bolero RID | Text | 80 | 1 | Edit | Yes | Public | ||
BOLCOUNAM | Name of counter for SntEnvelopeId | Text | 8 | 1 | Edit | Yes | Public | ||
PRTBUSFLG | Print Business Sector on Outgoing Letters | Text | 1 | 1 | Edit | Yes | Public | ||
ETGEXTKEY | Entity Group of Entity Address | Text | 8 | 1 | Edit | Yes | Public | ||
GETFLDNRM | Field holding the normalized search fields. | Text | 60 | 1 | Edit | Yes | Public | ||
ETGEML | Entity Group E-Mail Address | Text | 140 | 1 | 80 | Edit | Yes | Public | |
TEL | Phone Number | Text | 20 | 1 | Edit | Yes | Public | ||
FAX | Fax Number | Text | 20 | 1 | Edit | Yes | Public | ||
TLX | Telex Number | Text | 20 | 1 | Edit | Yes | Public | ||
EML | Email Address | Text | 140 | 1 | 40 | Edit | Yes | Public | |
BIC | BIC | Text | 12 | 1 | Edit | Yes | Public | ||
WEB | Internet Address | Text | 35 | 1 | Edit | Yes | Public | ||
BLZ | Bankleitzahl (German Clearing Code) | Text | 8 | 1 | Edit | Yes | Public | ||
TID | TradeConnect ID | Text | 23 | 1 | Edit | Yes | Public |
Name | Fields | Properties |
---|---|---|
ETA_ETGEXTKEY | ETGEXTKEY | |
ETA_EXTKEY | EXTKEY | Unique |
ETA_EXTKEY | EXTKEY, ETGEXTKEY | Unique |
ETA_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 ETA. The field INR is used to maintain links from other tables into this table.
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.
The external key is used to uniquely identify an entity address. The key may consist of both letters and digits and is usually the unique ID under which an entity address is identified.
The external key is used to uniquely identify an entity address. The key may consist of both letters and digits and is usually the unique ID under which an entity address is identified.
This is the visible name of an Entity Address. This name is used in selection list and on panels to identify an Entity Address.
This is the visible name of an Entity Address. This name is used in selection list and on panels to identify an Entity Address.
This field holds the version counter to keep track of the version history of an ETA 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.
Entity where this entity address belongs to.
Indicates the entity for this entity.
If not empty, this ETA is the primary address used for routing of incoming messages.
May be used, if multiple ETA records contain the same BIC/TID/…
If not empty, this ETA is the primary address used for routing of incoming messages.
May be used, if multiple entity address records contain the same BIC/TID/…
Email for Bolero Terminal are sent from / to this address
Emails for Bolero Terminal are sent from / to this address
This field holds the obfuscated password used to access to the private key used by the bolero terminal software.
This field holds the obfuscated password used to access to the private key used by the bolero terminal software.
This field contains the Bolero RID.
This field contains the Bolero RID.
Contains the name of DBcounter used to get SntEnvelopeId when messages are sent via Bolero Terminal. Default is mid('BOL'+EXTKEY,1,8)
Contains the name of DBcounter when messages are sent via Bolero Terminal.
Checking the box prints business sector on header of outgoing letters.
When this checkbox is checked, the long name of the business sector is printed in the header section of the outgoing correspondence.
This table is defined on entity group level with separate entries for each entity group. This field holds the EXTKEY of the entity group which is the logical owner of this entry. This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the entity group of the currently active entity are visible to the user.
This field holds the external key of the owning entity group to identify the logical owner of this entry. This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the currently active entity group are visible to the user.
This field contains the email address of the entity group.
This field contains the Email address of the entity group.
This field contains the telephone number of the entity address.
This field contains the telephone number of the entity address.
This field holds the fax number of the entity address.
This field holds the fax number of the entity address.
This field contains the telex number of the entity address.
This field contains the telex number of the entity address.
This field contains the Email address of the entity address.
This field contains the Email address of the entity address.
This field contains the optional ISO bank identifier code (BIC) of the entity address. Searching within a table is usually be done by entering parts of this field. All matching records are usually displayed to enable the selection of the desired address. The BIC is used to uniquely identify the address in all S.W.I.F.T messages. The SWIFT BIC is made up of a maximum of 11 characters, and a minimum of 8 characters.
This BIC can only comprise a maximum of 11 characters. The first 8 characters are used as the bank code with the last three characters used for the branch code. The terminal ID (9th position) is automatically provided by the SWIFT sending service.
This field contains the Internet address of the entity address.
This field contains the internet address of the entity address.
This field contains the 8-digit German Bankleitzahl or the bank clearing code of the entity address. Hence this field can be filled in only for banks and financial institutions located in Germany and which have been assigned a BLZ.
This field contains the 8-digit German Bankleitzahl or the bank clearing code of the entity address. Hence this field can be filled in only for banks and financial institutions located in Germany and which have been assigned a BLZ.
This TID is used for TradeConnect messages from different entity addresses.
This TID is used for TradeConnect messages from different entity addresses.
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.