COLLDESC

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

Column Descriptions:

Name	Type	Description
COLLATERAL_ID	INTEGER NOT NULL	The internal reference number that indicates the Collateral that this language specific information relates to.
LANGUAGE_ID	INTEGER NOT NULL	The Identifier of the language. For a list of language components, see the LANGUAGE table.
LOCATION	VARCHAR (254)	The full image path of the Collateral in the Web application.
MARKETINGTEXT	VARCHAR (4000)	The marketing text of the Collateral. It describes the marketing objective intended by the marketing campaign.
LONGMKTGTEXT	CLOB (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.
FIELD1	VARCHAR (254)	Customizable.
FIELD2	VARCHAR (254)	Customizable.
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>	LANGUAGE_ID+COLLATERAL_ID	Primary Key
I0001249	COLLATERAL_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_250	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade
F_251	COLLATERAL_ID	COLLATERAL	COLLATERAL_ID	Cascade

Related reference
Collateral and promotions data model