WebSphere Commerce 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.

Column Descriptions
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:

  • 0=no

  • 1=yes

CHANGEABLE INTEGER NOT NULL DEFAULT 0 This column indicates if the trading agreement participant can change the term. Valid values are as follows:

  • 0=no

  • 1=yes

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.

Indexes
Index Name Indexed Column Names Index Type
I0000246 TRADING_ID+SEQUENCE Unique Index
SQL060903235259730 TERMCOND_ID Primary Key
I0000810 TCSUBTYPE_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_835 TCSUBTYPE_ID TCSUBTYPE TCSUBTYPE_ID Cascade
F_834 TRADING_ID TRADING TRADING_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1154 TERMCOND_ID DKADJMNT TERMCOND_ID Cascade
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_922 TERMCOND_ID PSETADJMNT TERMCOND_ID Cascade
F_632 TERMCOND_ID PURCHASELT TERMCOND_ID Cascade
F_691 RFQRSPTC_ID RFQRSPTCRL TERMCOND_ID Cascade
F_692 RFQTC_ID RFQRSPTCRL TERMCOND_ID Cascade
F_923 TERMCOND_ID TCATTR TERMCOND_ID Cascade
F_826 TERMCOND_ID TCDESC TERMCOND_ID Cascade
Related reference

Related reference