Home > Technical > Table Definitions > TENDERLANGUAGE

TENDERLANGUAGE

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 TENDER table.

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

The system will automatically create these TENDERLANGUAGE records. When a new tender or language is added, for each available language/tender, it will create an TENDERLANGUAGE 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 TENDERLANGUAGE record for the primary language. Optionally, if the description is the same in other TENDERLANGUAGE records, those descriptions will also change.

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

Example

TENDER     Credit Card

TENDERLANGUAGE English (Primary) :  Credit Card

TENDERLANGUAGE German : Credit Card

If the Discount is changed from Credit Card to Visa we would get:

TENDERLANGUAGE English (Primary) :  Visa

TENDERLANGUAGE German : Visa                   <--- this changed because it had the same description

But if we had started with:

TENDER     Credit Card
TENDERLANGUAGE English (Primary) :  Credit Card

TENDERLANGUAGE German : Kreditkarte       

Then changing Credit Card to Visa we would get:

TENDERLANGUAGE English (Primary) : Visa

TENDERLANGUAGE German : Kreditkarte        <--- this didn't change as it was a different description to start with.

The user would need to change Kreditkarte to Visa manually.

Column Type Description
STRLANGUAGECODE VARCHAR(10) The code of the language.
LANGUAGEAVAIL.strCode
INTTENDERCODE INT The code of the discount

TENDER.intTenderCode

STRDYNAPOSDESCRIPTION VARCHAR(15) The translated description of the tender.
 

Primary Key: STRLANGUAGECODE + INTTENDERCODE

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