Home > Technical > Table Definitions > ITEMLANGUAGE

ITEMLANGUAGE

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

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

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

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

Example

ITEM     Shoes

ITEMLANGUAGE English (Primary) :  Shoes

ITEMLANGUAGE German : Shoes

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

ITEMLANGUAGE English (Primary) :  Big Shoes

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

But if we had started with:

ITEM     Shoes

ITEMLANGUAGE English (Primary) :  Shoes

ITEMLANGUAGE German : Schuhe

Then changing Shoes to Big Shoes we would get:

ITEMLANGUAGE English (Primary) :  Big Shoes

ITEMLANGUAGE 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 manually.

Column

Type

Description

STRLANGUAGECODE

VARCHAR(10)

The code of the language.
LANGUAGEAVAIL.strCode

LINTITEMNUMBER

INT

The item number to which the descriptions belong.
ITEM.lintItemNumber

STRPRODUCTBRANDNAME

VARCHAR(30)

The product brandname.

STRPRODUCTDESCRIPTION

VARCHAR(30)

The product description.

STRPRODUCTVARIETY

VARCHAR(30)

The product variety.

STRPRODUCTSIZE

VARCHAR(10)

The product size.

STRPRODUCTFIT

VARCHAR(20)

The product fit.

STRPOS20DESCRIPTION

VARCHAR(20)

The POS 20 description.

STRLONGDESCRIPTION

VARCHAR(200)

The long description of the item.

 

Primary Key: STRLANGUAGECODE + LINTITEMNUMBER

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