Entity Definition

Logical Name : ItemLabelContent
Physical Name : CO_ITM_LB_CNTN

A cross reference of lable content types to items. This supports a variety of label content types for each item which may vary item or inventory item. Examples of items that might use this entity are Carbon Footprint indicator, Dietary Rules, Third Party Endorsments/Certifications, etc.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ItemLabelContentID (PK) A unique system assigned identifier for a cross reference of label content types to items or inventory items. ID_CNTN_LB Identity integer
Value The content that is to appear on a lable. Examples include a carbon footprint value of "34kg CO2 per 100 hours of Use". DE_CNTN_LB DescriptionNarrative varchar(4000)
ItemTraceableUnitID (FK) A universally unique identifier used to identify an instance of a distinguisable instance of a retail item. The item traceable unit ID is similar to a serial number in that it allows each selling unit to be explicitly identified and distinguished from other sellling units of the same Item. ID_ITM_UN_TRC IdentityUUID CHAR(32) ItemTraceableUnit(AS_ITM_TRCBL_UN)
LabelContentTypeCode (FK) A code that indicates a categorization of of label content. TY_CNTN_LB Code4 CHAR(4) LabelContentType(LU_LB_CNTN_TYP)


Parent Entity Verb Phrase Child Entity
LabelContentType defines category of ItemLabelContent
ItemTraceableUnit is described by ItemLabelContent

Logical Views containing ItemLabelContent

Logical View
Logical 21000 - Fresh Item Management Macro View