This table holds all regions used in the application.
Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
---|---|---|---|---|---|---|---|---|---|
INR | Internal Unique ID of Region | Text | 8 | 1 | Edit | Yes | Public | ||
COD | Code | Text | 4 | 1 | Edit | Yes | Public | REGTXT | |
VER | Version Counter | Text | 4 | 1 | Edit | Yes | Public | ||
GETFLDNRM | Field holding the normalized search fields | Text | 10 | 1 | Edit | Yes | Public |
Name | Fields | Properties |
---|---|---|
REG_COD | COD | |
REG_GETFLDNRM | GETFLDNRM | |
REG_INR | INR | Unique |
/
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 REG. The field INR is used to maintain links from other tables into this table. Additionally for performance reasons, the COD of a region is used in many application tables as a link, as often only the code is needed. 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 is the systemwide used unique code to identify a region.
This is the system-wide unique code used to identify a region.
This field holds the version counter to keep track of the version history of an REG 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.
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.
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.