The facility table holds an entry for each facility. The facility is linked to a specified party and can be bilateral or participation sold.Each party might have many facilities.A participation sold facility can have many participants which are linked to the facility by entries of the FAE table.
Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
---|---|---|---|---|---|---|---|---|---|
INR | Internal Unique ID of Facility Information | Text | 8 | 1 | Edit | Yes | Public | ||
STA | Status | Text | 2 | 1 | Edit | Yes | Public | Embedded | |
PTYINR | Master party of facility | Text | 8 | 1 | Edit | Yes | Public | ||
SYNFLG | Syndication Flag | Text | 1 | 1 | Edit | Yes | Public | ||
OPNDAT | Opened | Date | 12 | 0 | Date | Yes | Public | ||
CLSDAT | Closed | Date | 12 | 0 | Date | Yes | Public | ||
EXTKEY | Facility ID | Text | 34 | 1 | Edit | Yes | Public | ||
VER | Version Counter | Text | 4 | 1 | Edit | Yes | Public | ||
NAM | Name of Facility | Text | 40 | 1 | Edit | Yes | Public | ||
AGTNAM | Name of the Agent | Text | 40 | 1 | Edit | Yes | Public | ||
OWNRAT | Percentage/Rate of Share | Numeric | 8 | 5 | Edit | Yes | Public | ||
OWNAGT | We are the Agent | Text | 1 | 1 | Edit | Yes | Public | ||
ETYEXTKEY | Facility entity | Text | 8 | 1 | Edit | Yes | Public | ||
GETFLDNRM | Field holding the normalized search fields | Text | 60 | 1 | Edit | Yes | Public |
Name | Fields | Properties |
---|---|---|
FAC_INR | INR | Unique |
FAC_PTYINR | PTYINR, STA |
/
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 MLI. 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.
Shows the status of the facility (created, opened or closed)
Code | Text |
---|---|
O | Open |
C | Closed |
P | Created |
Points to the party to which this facility belongs.
If checked, external participants can be configured.
Date from which the facility is to be considered as opened. The facility can be used only if opened. The field holds the opening/issuing date of the contract. If this field is set, the contract has been legally established and it might be used for business transactions. This date describes the point in time when this contract became legally binding. This might be a date prior to the creation date, when the contract was legally binding before it was stored in the database.
If set, the facility is closed and can not be used anymore. This fields indicates the closing date of a contract. If an entry has been made, the contract is closed and may no longer be used to process business transactions except special transactions like Settling Charges or Common Messages.
ID to uniquely identify a facility
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.
Name of current facility.
Holds the name of the facility agent
This field specifies the percentage of the contract amount in relation to the guarantee amount.
Use FMTORCRAT if the percentage is required in the language of the guarantee text.
The participation rate of the DOKA-NG using bank
This field contains the information whether a copy or a original document should be send to the receiver of the message.
If checked, the DOKA-NG using bank is the agent of the facility.
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.
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.
This table is defined on entity level with separate entries for each entity. This field holds the EXTKEY of the owning entity 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 are visible to the user.
This field holds the external key of the owning entity 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 are visible to the user.