| 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 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |