Table of Contents

STB - System Codetable Contents

Module STB

Description

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 data of all defined codetables in all languages.


Datafields

Name Description Data Type Len Dec. View lines View type Inst. Visible Codetable
TBL Table ID Text 6 1 Edit Yes Public
UIL Language Text 2 1 Edit Yes Public UILTXT
COD Code Text 8 1 Edit Yes Public
TXT Text Text 80 1 Edit Yes Public
ETGEXTKEY Entity Group Text 8 1 Edit Yes Public

Indices

Name Fields Properties
STB_COD TBL, UIL, COD, ETGEXTKEY Unique

/


Lock

ETGEXTKEY, TBL, UIL

Datafield Description and Properties


Datafield TBL Table ID

Description

This field defines the table to which this entry is associated.

Helpinformation

This field defines the table to which this entry is associated.


Datafield UIL Language

Description

This field defines the language for this decoding entry.

Helpinformation

This field defines the language for this entry.


Datafield COD Code

Description

This field defines the code to be decoded.

Helpinformation

This field defines the code to be decoded.


Datafield TXT Text

Description

This field defines the longtext to which the code of field COD will be decoded.

Helpinformation

This field defines the longtext for the Code field.


Datafield ETGEXTKEY Entitygroup

Helpinformation

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.