This is an internal system module / table and must not be changed.
TradeDesign does not support customization of this module / table.
This table holds the codetable definition for all defined codetables.
Every codetable is defined by one entry in this table, defining the
codetable name and its properties.
| Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
|---|---|---|---|---|---|---|---|---|---|
| TBL | Table ID | Text | 6 | 1 | Edit | Yes | Public | ||
| CODLEN | Code Length | Numeric | 1 | 0 | Edit | Yes | Public | ||
| TXTLEN | Text Length | Numeric | 2 | 0 | Edit | Yes | Public | ||
| SRT | Type of Sort | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| NAM | Description (in SYSUIL) | Text | 40 | 1 | Edit | Yes | Public | ||
| LEV | Level | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| NO_TRLFLG | Not translatable codetable | Text | 1 | 1 | Edit | Yes | Public | ||
| INR | Internal unique Id | Text | 8 | 1 | Edit | Yes | Public | ||
| VER | Version Counter | Text | 4 | 1 | Edit | Yes | Public | ||
| UNIFLG | Check uniqueness of longtext | Text | 1 | 1 | Edit | Yes | Public |
| Name | Fields | Properties |
|---|---|---|
| STH_TBL | TBL | Unique |
/
TBL
The table ID is the systemwide unique identification of a codetable. The table ID is the link to the different entries in the STB table.
The table ID identifies a codetable in the system. The table ID is the link to the different entries in the STB table.
This field specifies the length of the code field of the entries in the table STB. Valid values are in the range of 1 to 6.
This field specifies the length (1 - 6) of code field entries.
This field specifies the maximum length of the text values used to decode the codes (thus the usable length of STB\TXT). The valid range is 1 to 80. This value is used to determine the size of comboboxes when being used to hold decoded longtexts.
This field defines the maximum length of text in the codetable.
This switch defines the sort order that is normally used in this codetable. If it is sorted by code, the sorting is the same in all languages. If it is sorted by text, the order might differ between the languages. If no sorting is specified, the order is specified by the application.
This switch defines the sorting order normally used in the codetable. If sorted by code, the order is the same for all languages. If sorted by text, the order will vary depending on the languages. If no sorting has been specified, the order is specified by the application.
| Code | Text |
|---|---|
| C | Code |
| T | Text |
| N | None |
Any codetable has a longtext description. To use a translatable description, the additional codetable SYSCOD might be used to get a description for the codetable in all available languages.
Every codetable has a longtext description. A codetable is available for descriptions in other languages.
Field to define the multientity level of this code table. Currently only global or EntityGroup related codetable are supported. Global code table have to hold an empty value in the ETGEXTKEY field of the STB entries. EntityGroup related code table have to hold the relevant ETGEXTKEY in all related STB entries.
IMPORTANT: Any logic implemented has to accept 'G' as value to select EntityGroup. The initial implemented “E” to mark EntityGroup entries might be used in future version to flag Entity related code table.
Field to define the multientity level of this code table. Currently only global or EntityGroup related codetable are supported. Global code table have to hold an empty value in the ETGEXTKEY field of the STB entries. EntityGroup related code table have to hold the relevant ETGEXTKEY in all related STB entries.
IMPORTANT: Any logic implemented has to accept 'G' as value to select EntityGroup. The initial implemented “E” to mark EntityGroup entries might be used in future version to flag Entity related code table.
| Code | Text |
|---|---|
| All Entity Groups | |
| E | Entity Group |
Any non empty content flags a codetable where the entries in all available languages are identical and no translation is allowed.
If this checkbox is ticket the codetable will only be available in system language. This is important for some message related tables. For those the text has to be in system language independent from current user language.
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 STH. The field INR is used to maintain 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 holds the version counter to keep track of the version history of an STH 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.