en:app:020cor:100sys:020ety:0400ety

ETY - Entity

Module ETY


Datafields

Name Helptext Description Data Type Len Codetable
INR Internal unique ID Text 8
EXTKEY External Key Text 8
NAM Name Text 40
ETG Entity's Group Text 8
NGULOG Logo used in top area on the right Text 38
NGLLOG Logo used in lower area on the right Text 38
OFFLOG Logo File of Office Image above Clock Text 38
LETLOG Logo File Used in Letterhead Text 38
USERPIC Image Used in Office in Picture Frame Text 38
DEFICO Default Icon for Entity Text 38
VER Version Text 4
OWNPTAINR INR of the Own PTA Address Text 8
DEFROUUSG Default User Group for Routing Text 6
ETAEXTKEY Relevant Entity Address Text 8 <fixed-length>
OWNBIC BIC of Entity Text 12
OWNTID TID of Entity Text 23
ADMUSR Application Administrator (Optional) Text 8
TIMZON Time Zone Text 6 TIMZON
UIL Default Language Code Text 2 UILTXT
XSIPST Postfix for entityspecific XSI-Files Text 8
CAL Default Calendar for the Entity Text 3
COLOR Color for charts Text 16
BEGTIM1 Begin of working 1st day Numeric 4
BEGTIM2 Begin of working 2nd day Numeric 4
BEGTIM3 Begin of working 3rd day Numeric 4
BEGTIM4 Begin of working 4th day Numeric 4
BEGTIM5 Begin of working 5th day Numeric 4
BEGTIM6 Begin of working 6th day Numeric 4
BEGTIM7 Begin of working 7th day Numeric 4
ENDTIM1 End of working 1st day Numeric 4
ENDTIM2 End of working 2nd day Numeric 4
ENDTIM3 End of working 3rd day Numeric 4
ENDTIM4 End of working 4th day Numeric 4
ENDTIM5 End of working 5th day Numeric 4
ENDTIM6 End of working 6th day Numeric 4
ENDTIM7 End of working 7th day Numeric 4
WRKHRS1 Working hours 1st day Numeric 4
WRKHRS2 Working hours 2nd day Numeric 4
WRKHRS3 Working hours 3rd day Numeric 4
WRKHRS4 Working hours 4th day Numeric 4
WRKHRS5 Working hours 5th day Numeric 4
WRKHRS6 Working hours 6th day Numeric 4
WRKHRS7 Working hours 7th day Numeric 4
ANTETY allNETT Entity Text 3
ANTDPT allNETT Department Text 12
HUBFLG If checked it's a HUB (central processing center) Text 1
ALADIID ALADI Identifier code Text 4
CLEARID Clearing Number Text 4
GETFLDNRM Field holding the normalized search fields. Text 60
PNTETY Hub Entity/ Parent Entity Text 8

Datafield Description and Properties


Datafield INR Internal unique ID

In the MultiEntity module, the EXTKEY of an entity (instead of the INR) in the ETYEXTKEY field is used as a selector in many tables, to facilitate a reduction of the visibility of data of a certain entity. 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 EXTKEY External Key

Externally used descriptive key to identify an entity. This key has to be unique. The field is used in all tables specific to the entity to associate these entries to the entity.


Datafield NAM Name

This field indicates descriptive name of the entity.


Datafield ETG Entity's Group

Externally used descriptive key to identify the group the current entity belongs to. The content of this field is used in all tables specific to the entity group to associate these entries to the entity.


Datafield OFFLOG Logo File of Office Image above Clock

The field indicates the logo file for the image displayed above clock. The file name is specified relatively to the frame partition and might hold the special tag %uil% to represent the current user language when it comes to specifying a language-dependent logo file.


Datafield LETLOG Logo File Used in Letterhead

The field identifies the file to be used to show the logo in the letterhead in correspondence. The file name is specified relative to the frame partition and might hold the special tag %uil% to represent the current user language when it comes to specifying a language-dependent logo file.


Datafield USERPIC Image Used in Office in Picture Frame

File name of the image that can be displayed in the picture frame on the filing cabinet. The file name is specified relatively to the frame partition and might hold the special tag %uil% to represent the current user language when it comes to specifying a language-dependent picture file.


Datafield DEFICO Default Icon for Entity

If set, this icon is automatically used instead of the default icon. The icon file used is specified relative to the frame partition.


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 OWNPTAINR INR of the Own PTA Address

Identification number of the own PTA address used to logically access account information associated to the entity.


Datafield DEFROUUSG Default User Group for Routing

This default user group is used to route incoming messages within this entity, if no other group can be determined.


Datafield ETAEXTKEY Relevant Entity Address

The field contains details of the relevant address (or building) for the entity. This link is normally used to default the address used in the letterhead, if no other building is specified.


Datafield OWNBIC BIC of Entity

This BIC is used when sending SWIFT messages from different entities. The length of this BIC is 12 digits instead of the normal 11, because this BIC must include the Logical Terminal Code as the 9th digit. The terminal code identifies a specific terminal connection within a destination. It consists of one alphanumeric character (“0” and “1” are not permitted).


Datafield OWNTID TID of Entity

This TID is used when sending TradeConnect messages from different entities.


Datafield ADMUSR Application Administrator (Optional)

One user can be defined as application administrator for each entity. This user receives Notify messages necessary to administer the application. The default value which is used, if no default is set in the entity, is defined in DNGPARA.INI in section [Defaults], entry ETY-ADMUSR.


Datafield TIMZON Time Zone

The time zone for this entity. All time stamps relevant for the user are converted to this time zone in displays. In the database, time stamps are stored in system time. The time zone is only used, if the Time Zone system is also used.


Datafield UIL Default Language Code

The language code defines the language to be used of language dependent output where the language is not defined by user or correspondent/document. Used e.g. for language of 'File Copy' Header.


Datafield XSIPST Postfix for entityspecific XSI-Files

To allow a different XSI-file for a different ETY create a XSI-file eg. “A4xxx.XSI”, where xxx is written in this field for the respective entity. An empty field or a not available XSI-file will result in the use of the default value of the document (eg. A4.XSI).


Datafield CAL Default Calendar for the Entity

This optional field specifies an entity-specific calender to be used for date calculations based on working days such as in 'date' fields, or on internal functions where no calendar is specified.


Datafield COLOR Color for charts

Color to be used if entity is represented in charts.

Typically specified in form rgb(rrr,ggg,bbb) as this allows automatic modification of color to create color gradients. This field controls the color in which the entries assigned to the user are displayed in the Dashboard charts.


Datafield BEGTIM1 Begin of working 1st day

This field contains the time the work has to beginn on Sunday. The format is hh.mm.


Datafield BEGTIM2 Begin of working 2nd day

This field contains the time the work has to beginn on Monday. The format is hh.mm.


Datafield BEGTIM3 Begin of working 3rd day

This field contains the time the work has to beginn on Tuesday. The format is hh.mm.


Datafield BEGTIM4 Begin of working 4th day

This field contains the time the work has to beginn on Wednesday. The format is hh.mm.


Datafield BEGTIM5 Begin of working 5th day

This field contains the time the work has to beginn on Thursday. The format is hh.mm.


Datafield BEGTIM6 Begin of working 6th day

This field contains the time the work has to beginn on Friday. The format is hh.mm.


Datafield BEGTIM7 Begin of working 7th day

This field contains the time the work has to beginn on Saturday. The format is hh.mm.


Datafield ENDTIM1 End of working 1st day

This field contains the time the work should end on Sunday. The format is hh.mm.


Datafield ENDTIM2 End of working 2nd day

This field contains the time the work should end on Monday. The format is hh.mm.


Datafield ENDTIM3 End of working 3rd day

This field contains the time the work should end on Tuesday. The format is hh.mm.


Datafield ENDTIM4 End of working 4th day

This field contains the time the work should end on Wednesday. The format is hh.mm.


Datafield ENDTIM5 End of working 5th day

This field contains the time the work should end on Thursday. The format is hh.mm.


Datafield ENDTIM6 End of working 6th day

This field contains the time the work should end on Friday. The format is hh.mm.


Datafield ENDTIM7 End of working 7th day

This field contains the time the work should end on Saturday. The format is hh.mm.


Datafield WRKHRS1 Working hours 1st day

This field contains the time that should be worked on Sunday. The format is hh.mm.


Datafield WRKHRS2 Working hours 2nd day

This field contains the time that should be worked on Monday. The format is hh.mm.


Datafield WRKHRS3 Working hours 3rd day

This field contains the time that should be worked on Tuesday. The format is hh.mm.


Datafield WRKHRS4 Working hours 4th day

This field contains the time that should be worked on Wednesday. The format is hh.mm.


Datafield WRKHRS5 Working hours 5th day

This field contains the time that should be worked on Thursday. The format is hh.mm.


Datafield WRKHRS6 Working hours 6th day

This field contains the time that should be worked on Friday. The format is hh.mm.


Datafield WRKHRS7 Working hours 7th day

This field contains the time that should be worked on Saturday. The format is hh.mm.


Datafield CLEARID Clearing Number

The bank's own clearing ID used in payment messages using the SIC clearing system. This is a field specific for the customer.


Datafield ANTETY allNETT Entity

This field contains the allNETT Entity that is linked to the DOKA Entity, on Incoming and Outgoing allNETT messages.


Datafield ANTDPT allNETT Department

This field contains the allNETT Department that is linked to the Doka Entity, on Incoming and Outgoing allNETT messages. Implementation examples: 1. Implement as customer branch code 2. Implement as DOKA entity id 3. Implement as DOKA entity BIC code


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 NGULOG Logo used in top area on the right

In case the standard logo should not be used in top area on the right any alternate logo file can be defined here.


Datafield NGLLOG Logo used in lower area on the right

In case the standard logo should not be used in lower area on the right any alternate logo file can be defined here.


Datafield HUBFLG If checked it's a HUB (central processing center)

This field specifies if an entity is a Hub, ie considered a central processing center.


Datafield PNTETY Hub Entity/ Parent Entity

Hub/ Parent entity to design multi level branch structures.


Datafield ALADIID ALADI Identifier code

The bank's ALADI Identifier code for the ALADI Inter-bank settlement system.

en/app/020cor/100sys/020ety/0400ety.txt · Last modified: 2022/12/09 15:47 (external edit)