| 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 | SOURCEGUID | Internal ID for Source in a Relationship | varbinary | 16 | 0 | | | | |
| 4 | DESTINGUID | Internal ID for Destination in a Relationship | varbinary | 16 | 0 | | | | |
| 5 | RELTYPE | Relationship Type | nvarchar | 6 | 0 | | | | Allow NULL? |
| 6 | LINK_PARTNER_FCT | Relationship Product-Partner: Partner Function | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | LINK_VALID_FROM | Valid from (Time Stamp) for Relationship, No Creation Date | decimal | 15 | 0 | | | | |
| 8 | LINK_VALID_TO | Valid To (Time Stamp), No Delete Date for Relationship | decimal | 15 | 0 | | | | |
| 9 | NUMERATOR | Relationships: Numerator for Ratio | int | 10 | 0 | | | | Allow NULL? |
| 10 | DENOMINATOR | Relationships: Denominator for Ratio | int | 10 | 0 | | | | Allow NULL? |
| 11 | LINK_BP_MAIN | Relationships: Main Partner(When Partner Function Ambiguous) | char | 1 | 0 | | | | Allow NULL? |
| 12 | IL_PRDBP | Dummy function in length 1 | char | 1 | 0 | | | | Allow NULL? |
| 13 | LOGSYS | Logical System in Which the Relationship Was Created | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | UPNAME | Relationship Last Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 15 | VALID_FROM | Valid From (Time Stamp) | decimal | 15 | 0 | | | | |
| 16 | HISTEX | Indicates That History Records Exist | char | 1 | 0 | | | | Allow NULL? |
