COLLDESC

This table holds language-dependent information related to a Collateral.

Column Descriptions:

NameTypeDescription
COLLATERAL_IDINTEGER NOT NULLThe internal reference number that indicates the Collateral that this language specific information relates to.
LANGUAGE_IDINTEGER NOT NULLThe Identifier of the language. For a list of language components, see the LANGUAGE table.
LOCATIONVARCHAR (254)The full image path of the Collateral in the Web application.
MARKETINGTEXTVARCHAR (4000)The marketing text of the Collateral. It describes the marketing objective intended by the marketing campaign.
LONGMKTGTEXTCLOB (1000000)The marketing text of the Collateral. If the text is greater than 4000 characters then it is stored in this column, otherwise the text is stored in the MARKETINGTEXT column.
FIELD1VARCHAR (254)Customizable.
FIELD2VARCHAR (254)Customizable.
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>LANGUAGE_ID+COLLATERAL_IDPrimary Key
I0001249COLLATERAL_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_250LANGUAGE_IDLANGUAGELANGUAGE_IDCascade
F_251COLLATERAL_IDCOLLATERALCOLLATERAL_IDCascade