This table contains terms and conditions used in trading agreements (business accounts, contracts, RFQs). To see how columns are used by different terms and conditions, refer to TERMCOND column mapping.
Column Description(s):
Column Name | Column Type | Description |
TERMCOND_ID |
BIGINT NOT NULL |
Primary key and internal reference number for this term. |
TCSUBTYPE_ID |
CHAR(64) NOT NULL |
Foreign key to the TCSUBTYPE table. This column indicates the sub-type of the term. |
TRADING_ID |
BIGINT NOT NULL |
Foreign key to TRADING table. This column indicates the trading agreement this term belongs to. |
MANDATORY |
INTEGER NOT NULL DEFAULT 0 |
This column is used to indicate if the trading agreement participant must respond to this term during negotiation. Valid values are as follows:
|
CHANGEABLE |
INTEGER NOT NULL DEFAULT 0 |
This column indicates if the trading agreement participant can change the term. Valid values are as follows:
|
TIMECREATED |
TIMESTAMP |
Time that this term and condition was created. |
TIMEUPDATED |
TIMESTAMP |
Time that this term and condition was last updated. |
STRINGFIELD1 |
VARCHAR(3200) |
A STRING field used to store terms and conditions data. |
STRINGFIELD2 |
VARCHAR(254) |
A STRING field used to store terms and conditions data. |
STRINGFIELD3 |
VARCHAR(254) |
A STRING field used to store terms and conditions data. |
INTEGERFIELD1 |
INTEGER |
An INTEGER field used to store terms and conditions data. |
INTEGERFIELD2 |
INTEGER |
An INTEGER field used to store terms and conditions data. |
INTEGERFIELD3 |
INTEGER |
An INTEGER field used to store terms and conditions data. |
BIGINTFIELD1 |
BIGINT |
A BIGINT field used to store terms and conditions data. |
BIGINTFIELD2 |
BIGINT |
A BIGINT field used to store terms and conditions data. |
BIGINTFIELD3 |
BIGINT |
A BIGINT field used to store terms and conditions data. |
FLOATFIELD1 |
DOUBLE |
A DOUBLE field used to store terms and conditions data. |
FLOATFIELD2 |
DOUBLE |
A DOUBLE field used to store terms and conditions data. |
FLOATFIELD3 |
DOUBLE |
A DOUBLE field used to store terms and conditions data. |
TIMEFIELD1 |
TIMESTAMP |
A TIMESTAMP field used to store terms and conditions data. |
TIMEFIELD2 |
TIMESTAMP |
A TIMESTAMP field used to store terms and conditions data. |
DECIMALFIELD1 |
DECIMAL (20,5) |
A DECIMAL field used to store terms and conditions data. |
DECIMALFIELD2 |
DECIMAL (20,5) |
A DECIMAL field used to store terms and conditions data. |
TIMEFIELD3 |
TIMESTAMP |
A TIMESTAMP field used to store terms and conditions data. |
DECIMALFIELD3 |
DECIMAL (20,5) |
A DECIMAL field used to store terms and conditions data. |
SEQUENCE |
INTEGER NOT NULL |
This column contains a number indicating the sequence of the term within a trading agreement. This number must be unique within a trading agreement. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |