TERMCOND column name |
Column type | Column description |
---|---|---|
trading_id | Bigint not null | Primary key, foreign key to the trading agreement table. |
termcond_id | BIGINT not null | The primary key ID. |
tcSubType_id | CHAR(64) | The type of the term and condition. Foreign key to to TCSUBTYPE table. The value of this column must be ReferralInterfaceTC |
mandatory | Integer default 0 | 0 - no 1 - yes (participant must respond to this term and condition during negotiation). |
changeable | Integer default 0 | 0 - no 1 - yes (participant can change the term and condition). |
timeCreated | TimeStamp | Time created |
timeUpdated | TimeStamp | Time updated |
elementData | LongVARCHAR Default null | |
StringField1 | VARChar (3000) | |
StringField2 | VARChar (254) | |
StringField3 | VARChar (254) | |
IntegerField1 | Integer | |
IntegerField2 | Integer | |
IntegerField3 | Integer | |
FloatField1 | Double | |
FloatField2 | Double | |
FloatField3 | Double | |
BigIntField1 | BigInt | |
BigIntField2 | BigInt | |
BigIntField3 | BigInt | |
DecimalField1 | Decimal (20,5) | |
DecimalField2 | Decimal (20,5) | |
DecimalField3 | Decimal (20,5) | |
TimeField1 | TimeStamp | |
TimeField2 | TimeStamp | |
TimeField3 | TimeStamp |