Home > Technical > Table Definitions > DISCLANGUAGE

DISCLANGUAGE

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

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

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

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

Example

DISCHDR     Shoes

DISCLANGUAGE English (Primary) :  Shoes

DISCLANGUAGE German : Shoes

If the Discount is changed from Shoes to Big Shoes we would get:

DISCLANGUAGE English (Primary) :  Big Shoes

DISCLANGUAGE German : Big Shoes                  <--- this changed because it had the same description

But if we had started with:

DISCHDR     Shoes
DISCLANGUAGE English (Primary) :  Shoes

DISCLANGUAGE German : Schuhe

Then changing Shoes to Big Shoes we would get:

DISCLANGUAGE English (Primary) :  Big Shoes

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

The user would need to change Schuhe to Gross Schuhe automatically.

Column Type Description
STRLANGUAGECODE VARCHAR(10) The code of the language.
LANGUAGEAVAIL.strCode
LINTDISCOUNTCODE INT The code of the discount.
DISCHDR.ctrCode
STRPOSDESCRIPTION VARCHAR(40) The translated POS description of the discount.
 

Primary Key: STRLANGUAGECODE + LINTDISCOUNTCODE

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