CONTRACTREL

The CONTRACTREL table represents the relationship that an agreement can have with another agreement.

This table is used by the following domains.
Name Comment Datatype Null Option Is PK
CONTRACT_REL_ID A unique, system-generated key that identifies a contract relationship in the system. BIGINT Not Null Yes
TO_CONTRACT_ID A unique, system-generated key that identifies a contract in the system. BIGINT Not Null No
FROM_CONTRACT_ID A unique, system-generated key that identifies a contract in the system. BIGINT Not Null No
CONTR_REL_TP_CD Describes the type of relationship. Examples include master contract and contract term. BIGINT Not Null No
CONTR_REL_ST_TP_CD Identifies the status of the relationship between two contracts, such as "pending", "active", and "terminated". BIGINT Null No
START_DT The date when this record becomes active. TIMESTAMP Not Null No
END_DT The date when this record becomes inactive. TIMESTAMP Null No
REL_DESCRIPTION Provides for comments that a user might have concerning the contract relationship. VARCHAR(255) Null No
LAST_UPDATE_TX_ID A unique, system-generated key that identifies the specific transaction within the log system that either created, updated, or deleted the data row. BIGINT Null No
LAST_UPDATE_DT When a record is added or updated, this field is updated with the date and time. On subsequent updates, the system uses this information to ensure that the update request includes a matching date and time on this field; if it does not, the update fails. TIMESTAMP Not Null No
LAST_UPDATE_USER The ID of the user who last updated the data. VARCHAR(20) Null No