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 |