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:
|
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. |