The UBR table holds a replicated copy of the release information of the USR entry to be able to define different release settings for different business sectors.
If a UBR entry for a given context exists this entry overwrites the default settings of the current USR entry.
| Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
|---|---|---|---|---|---|---|---|---|---|
| INR | Internal Unique ID of User | Text | 8 | 1 | Edit | Yes | Public | ||
| USRINR | INR of Related User | Text | 8 | 1 | Edit | Yes | Public | ||
| BUSSEC | Business Sector / Transaction | Text | 6 | 1 | Edit | Yes | Public | ||
| RELCUR | Release Currency | Text | 3 | 1 | Edit | Yes | Public | CURTXT | |
| RELAMT | Release Amount | Numeric | 18 | 3 | Edit | Yes | Public | ||
| RELAMT2ND | 2nd Release Amount | Numeric | 18 | 3 | Edit | Yes | Public | ||
| RELGRP | Release Group | Text | 1 | 1 | Edit | Yes | Public | SIGTYP | |
| RELTYP | Typ | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| ETYEXTKEY | Entity of profiledata of User | Text | 8 | 1 | Edit | Yes | Public |
| Name | Fields | Properties |
|---|---|---|
| UBR_INR | INR | Unique |
| UBR_SEC | BUSSEC, USRINR | |
| UBR_USRINR | USRINR |
/
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 UBR. The field INR is used to maintain the standard technical 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.
This field hold the INR of the related user as stored in table “USR”.
This field hold the internal unique ID of the related user as stored in table 'User Profile'.
This field holds the business sector for which a user might have special release authorization.
This field holds the business sector for which a user might have special release authorization.
This field contains the currency for the amount of release.
This field contains the currency for the amount of release.
This field contains the amount up to which the user is allowed to release transactions under the business sector as entered in BUSSEC.
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'.
This field contains the amount up to which the user is allowed to release his own transactions under the business sector as entered in BUSSEC.
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'.
This field contain the release rights for the user under the selected business sector.
This field contain the release rights for the user under the selected business sector.
This field defines the entity of the profiledata of the user in a multi-entity environment, where users are associated to different entities. Thus the same userid is defined in different entities with different profiles (i.e. transaction execution profile, release rights, language).
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.
Defines if the specified release profile is per a defined business sector or for a transaction.
Defines if the specified release profile is per a defined business sector or for a transaction.
| Code | Text |
|---|---|
| B | Business Sector |
| T | Transaction |