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 in the online help.
Column Name | Column Type | Column Description |
---|---|---|
BIGINTFIELD1 | BIGINT NULL |
A BIGINT field used to store terms and conditions data. |
BIGINTFIELD2 | BIGINT NULL |
A BIGINT field used to store terms and conditions data. |
BIGINTFIELD3 | BIGINT NULL |
A BIGINT field used to store terms and conditions data. |
CHANGEABLE | INTEGER NOT NULL, DEFAULT 0 |
This column indicates if the trading agreement participant can change the term. (0 - no; 1 - yes). |
DECIMALFIELD1 | DECIMAL (20,5) NULL |
A DECIMAL field used to store terms and conditions data. |
DECIMALFIELD2 | DECIMAL (20,5) NULL |
A DECIMAL field used to store terms and conditions data. |
DECIMALFIELD3 | DECIMAL (20,5) NULL |
A DECIMAL field used to store terms and conditions data. |
FLOATFIELD1 | DOUBLE NULL |
A DOUBLE field used to store terms and conditions data. |
FLOATFIELD2 | DOUBLE NULL |
A DOUBLE field used to store terms and conditions data. |
FLOATFIELD3 | DOUBLE NULL |
A DOUBLE field used to store terms and conditions data. |
INTEGERFIELD1 | INTEGER NULL |
An INTEGER field used to store terms and conditions data. |
INTEGERFIELD2 | INTEGER NULL |
An INTEGER field used to store terms and conditions data. |
INTEGERFIELD3 | INTEGER NULL |
An INTEGER field used to store terms and conditions data. |
MANDATORY | INTEGER NOT NULL, DEFAULT 0 |
This column is used to indicate if the trading agreement participant must respond to this term during negotiation. (0 - no; 1 - yes). |
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. |
STRINGFIELD1 | VARCHAR (3200) NULL |
A STRING field used to store terms and conditions data. |
STRINGFIELD2 | VARCHAR (254) NULL |
A STRING field used to store terms and conditions data. |
STRINGFIELD3 | VARCHAR (254) NULL |
A STRING field used to store terms and conditions data. |
TCSUBTYPE_ID | CHARACTER (64) NOT NULL |
Foreign key to the TCSUBTYPE table. This column indicates the sub-type of the term. |
TERMCOND_ID | BIGINT NOT NULL |
Primary key and internal reference number for this term. |
TIMECREATED | TIMESTAMP NULL |
Time created. |
TIMEFIELD1 | TIMESTAMP NULL |
A TIMESTAMP field used to store terms and conditions data. |
TIMEFIELD2 | TIMESTAMP NULL |
A TIMESTAMP field used to store terms and conditions data. |
TIMEFIELD3 | TIMESTAMP NULL |
A TIMESTAMP field used to store terms and conditions data. |
TIMEUPDATED | TIMESTAMP NULL |
Time updated. |
TRADING_ID | BIGINT NOT NULL |
Foreign key to TRADING table. This column indicates the trading agreement this term belongs to. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000246 | TRADING_ID, SEQUENCE | Unique Index |
SQL030416035130510 | TERMCOND_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_834 | TRADING_ID | TRADING | TRADING_ID | Cascade |
F_835 | TCSUBTYPE_ID | TCSUBTYPE | TCSUBTYPE_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_497 | TERMCOND_ID | ORDERITEMS | TERMCOND_ID | Cascade |
F_558 | TERMCOND_ID | PARTICIPNT | TERMCOND_ID | Cascade |
F_571 | TERMCOND_ID | PATTRVALUE | TERMCOND_ID | Cascade |
F_614 | TERMCOND_ID | POLICYTC | TERMCOND_ID | Cascade |
F_632 | TERMCOND_ID | PURCHASELT | TERMCOND_ID | Cascade |
F_691 | TERMCOND_ID | RFQRSPTCRL | RFQRSPTC_ID | Cascade |
F_692 | TERMCOND_ID | RFQRSPTCRL | RFQTC_ID | Cascade |
F_826 | TERMCOND_ID | TCDESC | TERMCOND_ID | Cascade |
F_922 | TERMCOND_ID | PSETADJMNT | TERMCOND_ID | Cascade |
F_923 | TERMCOND_ID | TCATTR | TERMCOND_ID | Cascade |