Home > Technical > Table Definitions > REASONLANGUAGE

REASONLANGUAGE

This is part of the multi-language functionality. If you need to have different descriptions for tenders, for example English and German, then those descriptions will be recorded in this table. These descriptions correspond to fields in the REASON table.

First of all, you need to have languages defined in LANGUAGEAVAIL.

The system will automatically create these REASONLANGUAGE records. When a new tender or language is added, for each available language/tender, it will create an REASONLANGUAGE record. So if you have an English and German language defined, you will end up with two records, one for English and one for German, for each tender. As the user edits the tender, if they change descriptions, it will automatically change the description in the REASONLANGUAGE record for the primary language. Optionally, if the description is the same in other REASONLANGUAGE records, those descriptions will also change.

NOTE: The changes are done via code. It is not done via database triggers.

Example

REASON     Faulty Product

REASONLANGUAGE English (Primary) :  Faulty Product

REASONLANGUAGE German : Faulty Product

If the Discount is changed from Faulty Product to Broken Product we would get:

REASONLANGUAGE English (Primary) :  Broken Product

REASONLANGUAGE German : Broken Product<--- this changed because it had the same description

But if we had started with:

REASON     Faulty Product

REASONLANGUAGE English (Primary) :  Faulty Product

REASONLANGUAGE German : Fehlerhafte Produkt       

Then changing Faulty Product to Broken Product we would get:

REASONLANGUAGE English (Primary) : Broken Product

REASONLANGUAGE German : Fehlerhafte Produkt      <--- this didn't change as it was a different description to start with.

The user would need to change Fehlerhafte Produkt to Ware Defekt manually.

Column Type Description
STRLANGUAGECODE VARCHAR(10) The code of the language.
LANGUAGEAVAIL.strCode
INTCODE INT The code of the reason.
REASONS.intCode
STRPOSDESCRIPTION VARCHAR(50) The description of the reason.
 

Primary Key: STRLANGUAGECODE + INTCODE

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)