Entity Definition

Logical Name : ItemLabel
Physical Name : AS_LB_ITM

A means of conveying information about a RETAIL ITEM to the CUSTOMER and/or EMPLOYEE. This information is available on or adjacent to the ITEM. It may be in the form of an item tag or paper or electronic shelf label.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ItemLabelID (PK) A unique system assigned identifier for the ItemLabel. ID_LB_ITM Identity integer
LanguageID (FK) 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)
EquipmentID (FK) The fixed asset number assigned by the retailer for this particular piece of equipment. ID_EQ Identity integer Equipment(AS_EQ)
BusinessUnitGroupID (FK) A unique system assigned identifier for a group of BusinessUnits. ID_BSNGP Identity integer BusinessUnitGroupItem(AS_BSNGP_ITM)
ItemID (FK) A unique system assigned identifier for the retailer's SKU being labelled. ID_ITM IdentityUUID char(32) BusinessUnitGroupItem(AS_BSNGP_ITM)
EffectiveDateTime (FK) The date from which the BusinessUnits in the group carry the Item being labelled. TS_EF EffectiveDateTime datetime BusinessUnitGroupItem(AS_BSNGP_ITM)
TypeCode Identifies the type of label to be created. TY_LB Code2 char(2)


Parent Entity Verb Phrase Child Entity
Equipment defines content of ItemLabel
BusinessUnitGroupItem defines content of ItemLabel
Language defines content of ItemLabel
ItemLabel can be a ItemTicket
ItemLabel can be a ItemElectronicLabel
ItemLabel can be a ItemShelfLabel

Logical Views containing ItemLabel

Logical View
Logical 01050 - Item Description - Labelling View
Logical 01300 - Item Price Maintenance View
Logical 21000 - Fresh Item Management Macro View