This table holds the main control entry for every defined filter.
The concrete users and user groups, which are part of a filter definition are stored in the table USFUSR and USFUSG.
There are two different types of entries.
The user-definable default filters are identified by the USRINR of the owning user and an empty EXTKEY.
Additional filters might be defined in later versions with an empty USRINR, as these entries are intended to be available for everybody and an EXTKEY as search key and NAM as visible longname.
Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
---|---|---|---|---|---|---|---|---|---|
INR | Internal Unique ID of User Filter | Text | 8 | 1 | Edit | Yes | Public | ||
USRINR | INR of Owner of Filter | Text | 8 | 1 | Edit | Yes | Public | ||
EXTKEY | Filter ID | Text | 6 | 1 | Edit | Yes | Public | ||
NAM | Descriptive Name | Text | 40 | 1 | Edit | Yes | Public |
Name | Fields | Properties |
---|---|---|
USF_IDX | EXTKEY, USRINR | |
USF_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 USF. 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.
If a default filter entry is used, this field holds the INR of the owning USR entry.
If a default filter entry is used, this field holds the unique ID of the holding user entry.
If a default filter entry is used, this field has to be empty.
If a default filter entry is used, this field has to be empty.
This field holds an externally visible name used to describe the filter.
This field holds an external visible name used to describe the filter.