Entity Type Relationship Details (tgerm3100s000)

Mit diesem Programm display and maintain the entity relationship details.

Felddaten

Entity-Beziehung

entity-type relationship

Version

version

Bezeichnung

The description or name of the version.

Von Entity

The first entity type in the entity relationship.

Beispiel

The entity relationship between an order and an order line is a 1:N relationship. An order is related to one or more order lines. Vice versa, an order line is related to only one order. In this entity relationship the order is the first entity type.

fnnt.desc

The description or name of the entity type.

Bis Objekt

The second entity type in the entity relationship.

Beispiel

The entity relationship between an order and an order line is a 1:N relationship. An order is related to one or more order lines. Vice versa, an order line is related to only one order. In this entity relationship, the order line is the second entity type.

Bezeichnung Von - Bis

The description that identifies the from-to relationship. The description must be a verb in the third person singular.

Beispiel

An order is detailed by one or more order lines. For this relationship the From-To description is: is detailed by.

  • if the relationship is a horizontal line with the name located above, then the diagram should be read from left to right. If the name is located underneath, then the diagram should be read from right to left.
  • if the relationship is a vertical line with the name located on the left, then the diagram should be read from top to bottom. If the name is on the right, then the diagram is read from the bottom up.
Bezeichnung Bis - Von

The description used to identify the to-from relationship. The description must be a verb in the third person singular.

Beispiel

An order line details an order. For this relationship, the To-From description is: details.

  • if the relationship is a horizontal line with the name located above, then the diagram should be read from left to right. If the name is located underneath, the diagram should be read from right to left.
  • if the relationship is a vertical line with the name located on the left, then the diagram should be read from top to bottom. If the name is on the right, then the diagram is read from the bottom up.
Abgelaufen

Wenn dieses Kontrollkästchen markiert ist, the entity-type relationship has expired as the version it is in is no longer valid.

Beziehung ist Spezialisierung

Wenn dieses Kontrollkästchen markiert ist, the entity-type relationship is a subtype relationship.

Physische Datenbankbeziehung vorhanden

Wenn dieses Kontrollkästchen markiert ist, the entity-type relationship is between entity types that have tables from the ERP data dictionary linked to them.

Beziehungstabelle

associative entity type

table.desc

The description or name of the associative table.

Relationskategorie

category

Bezeichnung

The description or name of the category.

Mindestkardinalität Von-Bis

cardinality

Unendlich

Wenn dieses Kontrollkästchen markiert ist, the maximum from-to relationship is infinite.

Mindestkardinalität Bis-Von

cardinality

Unendlich

Wenn dieses Kontrollkästchen markiert ist, the maximum to-from relationship is infinite.

Eigentümer

The login of the owner.

user.name

The name of the owner.

Erstellung am

By default, the date when the entity relationship was generated. However, any authorized BAAN user can change the date into another date.

Text

Wenn dieses Kontrollkästchen markiert ist, text is available that provides you with further information about the entity relationship.

Datum

The date when the latest change was made to the entity-type relationship.

Uhrzeit

The time when the latest change was made to the entity-type relationship.

Anwender

The login of the BAAN user who made the latest change to the entity-type relationship.

User

The name of the BAAN user who made the latest change to the entity-type relationship.