Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
---|---|---|---|---|---|---|---|---|---|
INR | Internal Unique ID of User Absence Entry | Text | 8 | 1 | Edit | Yes | Public | ||
USREXTKEY | User ID | Text | 8 | 1 | Edit | Yes | Public | ||
BEGTIM | Begin of Absence | Numeric | 4 | 2 | Edit | Yes | Public | ||
ENDTIM | End of Absence | Numeric | 4 | 2 | Edit | Yes | Public | ||
DAT | Date for Absence | Date | 12 | 0 | Date | Yes | Public | ||
DUR | Duration of Absence | Numeric | 4 | 2 | Edit | Yes | Public | ||
REA | Reason of Absence | Text | 6 | 1 | Edit | Yes | Public | UABREA | |
VER | Version Counter | Text | 4 | 1 | Edit | Yes | Public |
Name | Fields | Properties |
---|---|---|
UAB_IDX | INR | Unique |
UAB_USR | USREXTKEY, DAT |
/
INR
This is the key to identify a user within an installation.
This is the key to identify a user within an installation.
This field contains the time the absence begins. The format is hh.mm.
This field contains the time the absence begins. The format is hh.mm.
This field contains the time the absence ends. The format is hh.mm.
This field contains the time the absence ends. The format is hh.mm.
This is the date the User has defined an absence for.
This is the date the User has defined an absence for.
This field contains the duration of the abesence. The format is hh.mm.
This field contains the duration of the abesence. The format is hh.mm.
Codetable with reasons for absence of a user.
Codetable with reasons for absence of a user.
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 UAB. The field INR is used to maintain the standard technical links from other tables into this table. Additionally for performance reasons the EXTKEY of a user is used in many application tables as a link, as only the user ID is often needed and in this case no resolution of a link is necessary to get this information.
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 holds the version counter to keep track of the version history of a USR entry. The individual versions are controlled by entries in the SLG table.
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.