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:

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


Indexes:

Name Column Names Type
<SYSTEM-GENERATED> TERMCOND_ID Primary Key
I0000246 TRADING_ID+SEQUENCE Unique Index
I0000810 TCSUBTYPE_ID Non-Unique Index


Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_834 TRADING_ID TRADING TRADING_ID Cascade
F_835 TCSUBTYPE_ID TCSUBTYPE TCSUBTYPE_ID Cascade


Referenced By Child Tables:

Constraint Columns Child Table Child Columns 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_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


Related reference
Contract data model
Order trading agreement data model
Request for Quote (RFQ) data model
TERMCOND database table column mapping