TCDESC

This table stores descriptions for terms and conditions for a contract.

Column Descriptions:

NameTypeDescription
TERMCOND_IDBIGINT NOT NULLA unique identifier for the term or condition.
LANGUAGE_IDINTEGER NOT NULLThe language ID. For a list of language components, see the LANGUAGE table.
DESCRIPTIONVARCHAR (254)A brief description of the term or condition.
LONGDESCRIPTIONVARCHAR (4000)A detailed description of the term or condition.
TIMECREATEDTIMESTAMPTime that this term and condition was created.
TIMEUPDATEDTIMESTAMPTime that this term and condition was last updated.
OPTCOUNTERSMALLINTThe 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+LANGUAGE_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_825LANGUAGE_IDLANGUAGELANGUAGE_IDCascade
F_826TERMCOND_IDTERMCONDTERMCOND_IDCascade