Data Relationships Terminology

This table describes terminology that is used for data relationships:

Term

Description

Relationship tables

The tables that are supported for data relationships functionality:

  • Business Unit Master (F0006)

  • Contract Master (F5201)

Relationship columns

The columns that are supported for the data relationships functionality. These columns can have a relationship with one another and must be part of the F0006 or F51006 table.

Basis column

The column in a table that is considered the basis of a data relationship. In a data relationship, the basis column drives the default value for the destination column.

Basis value

The value in the basis column that drives the default values in a data relationship.

Destination column

The column in a table that is considered the destination in a data relationship. In a data relationship, the default value for the destination column is driven by the basis column.

Destination value

The default value that is based on the basis value in a data relationship.

Value relationships

The relationship between the values in the basis and destination columns.

Column relationships

The relationship between the basis column and destination column.

Column set

A set of column relationships that are in the same table and that have the same effective date. Typically, the column set is identified with a column set description (name).

Column pair

Within a column set, the basis column and destination column for a single data relationship. A column set usually consists of multiple column pairs.