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 |
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'.
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 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 field 'Business Sector'.
This field contain the release rights for the user under the selected business sector.
Defines if the specified release profile is per a defined business sector or for a transaction.
Code | Text |
---|---|
B | Business Sector |
T | Transaction |
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.