| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | | | |
| 3 | VALID_TO | Valid To (Time Stamp) | decimal | 15 | 0 | | | | |
| 4 | SOURCEGUID | Internal ID for Source in a Relationship | varbinary | 16 | 0 | | | | |
| 5 | DESTINGUID | Internal ID for Destination in a Relationship | varbinary | 16 | 0 | | | | |
| 6 | RELTYPE | Relationship Type | nvarchar | 6 | 0 | | | | Allow NULL? |
| 7 | OBJECT_TYPE_FROM | MDF Object Type | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | OBJVERS_ID_FROM | Object Version Key | varbinary | 16 | 0 | | | | |
| 9 | OBJECT_TYPE_TO | MDF Object Type | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | OBJVERS_ID_TO | Object Version Key | varbinary | 16 | 0 | | | | |
| 11 | CHANGE_ORDER | Change Order | varbinary | 16 | 0 | | | | |
| 12 | CHANGE_COUNTER | Change Management Counter | smallint | 5 | 0 | | | | |
| 13 | DELETEFLAG | Deletion Indicator | char | 1 | 0 | | | | Allow NULL? |
| 14 | ORDER_ID | Position of Characteristic Within Definition Scope | nvarchar | 5 | 0 | | | | Allow NULL? |
| 15 | INHERITED | Characteristic Inherited from Superordinate Definition Scope | char | 1 | 0 | | | | Allow NULL? |
| 16 | RELEVANT | Characteristic Belongs to This Definition Scope | char | 1 | 0 | | | | Allow NULL? |
| 17 | DET_HIERARCHIE | Characteristic Determines Hierarchy | char | 1 | 0 | | | | Allow NULL? |
| 18 | VALUE_RANGE | Hierarchy-Determining Value GUID of Data Type | varbinary | 16 | 0 | | | | |
| 19 | CHAR_NOATTR | Characteristic Does Not Have a Master Record | char | 1 | 0 | | | | Allow NULL? |
| 20 | IL_SCPCHR | Dummy function in length 1 | char | 1 | 0 | | | | Allow NULL? |
| 21 | LOGSYS | Logical System in Which the Relationship Was Created | nvarchar | 10 | 0 | | | | Allow NULL? |
| 22 | UPNAME | Relationship Last Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 23 | VALID_FROM | Valid From (Time Stamp) | decimal | 15 | 0 | | | | |
| 24 | DELETED | Deletion Indicator for Relationship | char | 1 | 0 | | | | Allow NULL? |