Connections (FKs) to business class Source table

Overview of all foreign key connections that originate from forms within a business class. Here you can see which characteristics in the source forms refer to other forms. This helps you to understand and document the data relationships within a business class. Use this evaluation to analyze data structures and for quality assurance of the metadata.

List

Detailed list of all foreign key connections with information on the start form, info area, characteristic and target form. You get a complete overview of all connections as well as quality information on tooltips and product assignments.

Property	Description
Traffic light	Color quality indicator for the maintenance status of the foreign key connection. See the associated notes for more information on the displayed traffic light color.
Note	Explanation of the traffic light color with specific recommendations for action. Follow these instructions to eliminate red and yellow traffic lights in particular through targeted measures.
Start form	Form in which the feature with the foreign key connection is defined. From here, the connection leads to the target form.
Info area	Info area in the start form in which the characteristic with the foreign key connection is arranged.
Static feature	Feature in the start form that creates the foreign key connection to the target form.
Feature tooltip	Tooltip text of the feature that defines the foreign key connection. This text is displayed to users as an aid.
Target form	Form to which this foreign key connection refers and to which you can navigate via the feature.
Support article link	Direct link to the support article with further information on the foreign key connection, if available.
Contained in product(s)	eTASK products in which this foreign key connection is used. This information is important for product maintenance and licensing.
Included in product suite(s)	eTASK product suites that contain this foreign key connection. This enables a higher-level assignment to product packages.
Product Owner	Responsible product owner for the maintenance and further development of this foreign key connection in the product context.
Menu path	Navigation path to the start form in the eTASK menu. Use this path to quickly find the form in the application.
Foreign key	Technical name of the foreign key connection in the database system. This is used for technical analyses and database operations.
Feature type	Technical control element type of the feature (e.g. ENumberField for ID-based or ETextField for GUID-based foreign keys). This determines the display in the form.
Namespace	The namespace defines the unique identification area for the characteristic within the system architecture. It enables precise assignment and structuring of properties, which is particularly important when managing and analyzing foreign key relationships between business classes and source tables.
System name	Unique technical system name of the feature in eTASK. This is used for programmatic accesses and configurations.
Foreign key DB	Name of the foreign key relationship at database level. This information is relevant for database administrators and technical analyses.
Foreign key Name	Speaking name of the foreign key connection. This describes the functional relationship between the forms.
Sequence	Sorting number based on the menu structure in eTASK. This enables a thematically meaningful arrangement of the foreign key connections.
Form tooltip	Tooltip text of the start form. This explains the purpose and use of the form to users.
Form tooltip length	Number of words in the tooltip of the start form. Serves as a quality feature for the completeness of the documentation.
Feature Tooltip length	Number of words in the tooltip of the feature. Serves as a quality feature for the completeness of the feature documentation.
discontinued	Indicates whether this foreign key connection has been discontinued and will be removed in future versions. Do not use discontinued connections in new developments.
Target form canceled	Indicates whether the target form has been discontinued and will be removed in future versions. Do not use this link in new developments.
Target form - application discontinued	Indicates whether the application of the target form has been discontinued and will be removed in future versions. Do not use this link in new developments.
Mandatory field	Indicates whether the characteristic with the foreign key connection is a mandatory field. Mandatory fields must be filled in when saving a data record.
visible	Indicates whether the characteristic with the foreign key connection in the form is visible to users or is only used technically in the background.
activated	Indicates whether the feature with the foreign key connection is activated. Deactivated features cannot be edited by users.
NULL values allowed?	Indication at database level as to whether the characteristic may remain empty (NULL values permitted) or is a mandatory entry.
Data type DB	Data type of the column at database level (e.g. int, uniqueidentifier, varchar). This information is relevant for database administrators and technical analyses.
Data type eTASK	Data type of the feature in eTASK (e.g. integer, string, GUID). This determines the validation and display of the feature in the application.

IDs and UIDs for links

This group contains identifiers and unique identifiers that are used to link data records and tables. It enables the assignment and referencing between different entities in the system.

Property	Description
Range	Unique UID of the info area in which the characteristic with the foreign key connection is arranged. Is used for programmatic accesses.
UID table	Unique UID of the start form in which the foreign key connection is defined. Is used for programmatic accesses.
UID of the column	Unique UID of the feature with the foreign key connection. Is used for programmatic accesses and API operations.
UID table tooltip	Unique UID of the form tooltip in the text table. Is used for multilingualism and text management.
Feature Sequence	Position number of the characteristic within the info area. This determines the arrangement of the characteristics. Dynamic characteristics can overwrite this configuration.
UID primary key table	Unique UID of the target form to whose primary key the foreign key connection refers. Used for technical analyses.
Internal ID (client)	Unique ID of the client to which this foreign key connection is assigned. Is used for multi-client capable systems.
Internal ID (class)	Unique technical ID for linking to the business class. Used for API access and internal system processing.
UID column tooltip	Unique UID of the feature tooltip in the text table. Is used for multilingualism and text management.
UID column label	Unique UID of the characteristic label in the text table. Is used for multilingualism and text management.
Sequence area	Position number of the info area within the start form. This determines the arrangement of the areas in the form.
UID table label	Unique UID of the form label in the text table. Is used for multilingualism and text management.
Internal UID (table)	Unique UID of the base table of the business class. Is used for the link to the central business object.
Internal ID (foreign key)	Unique ID of the foreign key cache entry. Is used for the link to the foreign key table.