User Tools
Add this page to your book 
Remove this page from your book 
Manage book (
Help Table of Contents
STH - System Codetable Header
Module STH
The database table STH is used to store the header of the codetables used by the application. This table is automatically maintained by the system and read by the kernel software. It should not be modified by normal application software. The maintenance should be done via “Maintain Codetables” . The contents of the different tables are stored in “STB - System Codetable Contents”.
Each codetable might be defined in different languages. The maximum key and data length is defined centrally per codetable to assure a consistent layout of the different panels using the decoding functions in different languages. The length is independent from the language. This values should be changed carefully, as the layouts of the panels and documents using this codetable might be affected by the change.
For performance reasons the software caches all code tables read once. To resynchronize the cache after updates to the table have been made a special TD Basic statement “ResetCache” has to be executed.
Datafields
| Name | Helptext Description | Data Type | Len | Codetable |
|---|---|---|---|---|
| TBL | Table ID | Text | 6 | |
| CODLEN | Code Length | Numeric | 1 | |
| TXTLEN | Text Length | Numeric | 2 | |
| SRT | Type of Sort | Text | 1 | Embedded |
| NAM | Name | Text | 40 | |
| LEV | Level | Text | 1 | Embedded |
| NO_TRLFLG | Not translatable Table | Text | 1 | |
| INR | Internal Unique ID | Text | 8 | |
| VER | Version | Text | 4 | |
| UNIFLG | Check uniqueness of longtext | Text | 1 |
Datafield Description and Properties
Datafield TBL Table ID
The table ID identifies a codetable in the system. The table ID is the link to the different entries in the STB table.
Datafield CODLEN Code Length
This field specifies the length (1 - 6) of code field entries.
Datafield TXTLEN Text Length
This field defines the maximum length of text in the codetable.
Datafield SRT Type of Sort
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.
Codetable
| Code | Text |
|---|---|
| C | Code |
| T | Text |
| N | None |
Datafield NAM Name
Every codetable has a longtext description. A codetable is available for descriptions in other languages.
Datafield LEV Level
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.
Codetable
| Code | Text |
|---|---|
| All Entity Groups | |
| E | Entity Group |
Datafield NO_TRLFLG Not translatable Table
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.
Datafield INR Internal Unique ID
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.
Datafield VER Version
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.
