Database Table: TERMCOND

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000246 TRADING_ID, SEQUENCE Unique Index
SQL030416035130510 TERMCOND_ID Primary Key
Constraints:
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

Referenced By:
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