en:app:090zzz:010dbf:9999fac

FAC - Facility Information

Module FAC


Datafields

Name Helptext Description Data Type Len Codetable
INR Internal Unique ID Text 8
STA Facility Status Text 2 Embedded
PTYINR Master party of facility Text 8
SYNFLG Participation Sold Facility Flag Text 1
OPNDAT Opening Date Date 12
CLSDAT Closed Date Date 12
EXTKEY Facilit ID Text 34
VER Version Text 4
NAM Name of Facility Text 40
AGTNAM Name of the Agent Text 40
OWNRAT Own participation in percent Numeric 8
OWNAGT Agent Flag Text 1
ETYEXTKEY Entity Text 8
GETFLDNRM Field holding the normalized search fields. Text 60

Datafield Description and Properties


Datafield INR Internal Unique ID

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.


Datafield STA Facility Status

Shows the status of the facility (created, opened or closed)

Codetable
Code Text
O Open
C Closed
P Created

Datafield SYNFLG Participation Sold Facility Flag

If checked, external participants can be configured.


Datafield OPNDAT Opening Date

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.


Datafield CLSDAT Closed Date

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.


Datafield EXTKEY Facilit ID

ID to uniquely identify a facility


Datafield VER Version

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.


Datafield AGTNAM Name of the Agent

Holds the name of the facility agent


Datafield OWNRAT Own participation in percent

The participation rate of the DOKA-NG using bank


Datafield OWNAGT Agent Flag

If checked, the DOKA-NG using bank is the agent of the facility.


Datafield GETFLDNRM Field holding the normalized search fields.

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.


Datafield ETYEXTKEY Entity

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.

en/app/090zzz/010dbf/9999fac.txt · Last modified: 2022/10/20 12:58 (external edit)