en:app:020cor:100sys:010usr:0410ubr

UBR - User Business Rights

Module UBR


Datafields

Name Helptext Description Data Type Len Codetable
INR Internal Unique ID Text 8
USRINR Internal Unique ID of Related User Text 8
BUSSEC Business Sector Text 6
RELCUR Release Currency Text 3 CURTXT
RELAMT Release Amount Numeric 18
RELAMT2ND 2nd Release Amount Numeric 18
RELGRP Release Group Text 1 SIGTYP
RELTYP Typ Text 1 Embedded
ETYEXTKEY Entity of the user profile of the user Text 8

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.


This field hold the internal unique ID of the related user as stored in table 'User Profile'.


Datafield BUSSEC Business Sector

This field holds the business sector for which a user might have special release authorization.


Datafield RELCUR Release Currency

This field contains the currency for the amount of release.


Datafield RELAMT Release Amount

This field contains the amount up to which the user is allowed to release transactions under the business sector as entered in field 'Business Sector'.


Datafield RELAMT2ND 2nd Release Amount

This field contains the amount up to which the user is allowed to release his own transactions under the business sector as entered in field 'Business Sector'.


Datafield RELGRP Release Group

This field contain the release rights for the user under the selected business sector.


Datafield RELTYP Typ

Defines if the specified release profile is per a defined business sector or for a transaction.

Codetable
Code Text
B Business Sector
T Transaction

Datafield ETYEXTKEY Entity of the user profile of the user

In a Multi-entity installation, it is displayed here which user profile a single user has in the various entities. The same user may have different user profiles in various entities (executable transactions, release rights, user language). 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/020cor/100sys/010usr/0410ubr.txt · Last modified: 2022/12/09 15:48 (external edit)