TCATTR

This table stores information about the terms and conditions attributes specified within a contract. This table stores the XML data required by a term and condition.

Column Descriptions:

NameTypeDescription
TERMCOND_IDBIGINT NOT NULLThe TermsAndConditions ID.
TYPEINTEGER NOT NULLThe type of attribute for the terms and conditions as follows: 0 = TermCondition 1 = Policy
TRADING_IDBIGINT NOT NULLThe trading agreement identifier.
SEQUENCEINTEGER NOT NULL DEFAULT 0The sequence of the data.
XMLDEFINITIONCLOB (1000000) NOT NULLThe XML definition of the term and condition.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>TERMCOND_ID+TYPE+SEQUENCEPrimary Key
I0000807TRADING_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_923TERMCOND_IDTERMCONDTERMCOND_IDCascade
F_924TRADING_IDTRADINGTRADING_IDCascade