Entity Definition

Logical Name : TranslationItem
Physical Name : I8_ITM

An infrastructural entity, mirroring Item, and providing translations of any natural language string attributes in Item.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
LanguageID (FK)(PK) A combination of ISO-639-1 and ISO-3661-1 to denote a lanuage as spoken in a particular country. ID_LGE Code4External char(4) Language(CO_LGE)
ItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) Item(AS_ITM)
ItemName The name of the Item translated into the nominated Language. NM_ITM Name varchar(40)
Description The description of the Item translated into the nominated Language. DE_ITM_TSL DescriptionShort varchar(255)


Parent Entity Verb Phrase Child Entity
Language translates TranslationItem
Item has translations TranslationItem

Logical Views containing TranslationItem

Logical View
Logical 06600 - Language Support