| Name | Helptext Description | Data Type | Len | Codetable |
|---|---|---|---|---|
| INR | Internal Unique ID | Text | 8 | |
| EXTKEY | Key of GLE Output | Text | 24 | |
| NAM | Name of GLE Output | Text | 40 | |
| VER | Version | Text | 4 | |
| DSPFMT | Format of Output | Text | 4 | Embedded |
| ORDERSTM | holds ORDER for SQL Output | Stream | 1 | |
| SQLSTM | holds the SQL to be executed in Output | Stream | 1 | |
| ETGEXTKEY | Entitygroup | Text | 8 | |
| GETFLDNRM | Field holding the normalized search fields. | Text | 60 |
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 used to keep track of the history of an entry of this table. The individual versions are managed by entries in the SLG table.
| Code | Text |
|---|---|
| CSV | Text (CSV) |
| XML | XML |
| JSON | JSON |
This field holds the external key of the owning entity group 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 group are visible to the user.
Field holding the concatenated and normalized sum of all search fields used by quick search. This is one of the fields set in a SdbSetNRMFields method defined in the table definition module.