Home > Technical > Table Definitions > 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. |
LINTITEMNUMBER |
INT |
The item number to which the descriptions belong. |
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) |