ShelfItem

Entity Definition

Logical Name : ShelfItem
Physical Name : AS_ITM_SH

Extra attributes for Items that are placed upon shelves for display before being sold. These attributes are used when creating Shelving plans for the store as well as managing perishable StockItems.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) StockItem(AS_ITM_STK)
UnitPricingRequiredFlag An indicator to identify if the SHELF ITEM needs to be individually priced rather than conveyed through a shelf lable. Examples include high priced merchandise and variable weight products. FL_RQ_UN_PRC Flag integer
FacingsCount The number of units that can be containied in one facing. For example, if you can fit 30 units of a product on a shelf and there are 3 facings, then the units per facing is 10. QU_FCG Quantity DECIMAL(9,3)
StaplePerishableTypeCode A code to indicate whether the SHELF ITEM is a staple or perishable product. TY_ITM_STPL_PRSH Code2 char(2)
ShelfLifeDayCount The number of business days the SHELF ITEM may be displayed for sale to customers and after which must be removed. This attribute is for perishable produce items, drugs, and other time sensitive items (like newspapers). DI_PRD_SH_LF QuantityDayCount decimal(3,0)
DSDAuthorizedFlag An indicator used to identify whether the RETAIL STORE is authorized to accept the SHELF ITEM as a direct store delivery (DSD) item. FL_DSD_AZN Flag integer
ConsumerPackageDepth The dimension from front to back of the consumer package on the shelf. QL_DPTH_PCKG_CNS Quantity DECIMAL(9,3)
ConsumerPackageWidth The dimension from left to right of the consumer package on the shelf. QL_WD_PCKG_CNS Quantity DECIMAL(9,3)
ConsumerPackageHeight The dimension from top to bottom of the consumer package on the shelf QL_HT_PCKG_CNS Quantity DECIMAL(9,3)
ConsumerPackageDiameter The distance across a round, cylindracal or conic shaped consumer package at it's largest point. QL_DMTR_PCKG_CNS QuantityShortCount decimal(3,0)
ConsumerPackageGrossWeight The weight of the consumer package, including packaging. QW_PCKG_CNS Quantity DECIMAL(9,3)
ConsumerPackageNetWeight The weight of the consumer package, excluding packaging. QW_NT_PCKG_CNS QuantityShortCount decimal(3,0)
ConsumerPackageDrainedWeight The weight of the consumer package, excluding packaging, and after it has been drained of it's liquid. e.g. 225g jar of pickled onions. QW_DRN_PCKG_CNS QuantityShortCount decimal(3,0)
ConsumerPackageNetContent The amount of the Item contained in the ShelfItem, as claimed on the label. e.g. Evian Water 750ml - net content = "750 MLT" 20 count pack of diapers, net content = "20 ea." QU_CNTN_PCKG_CNS QuantityShortCount decimal(3,0)
ConsumerPackageTareWeight The weight of the consumer package without any contents. QW_TR_PCKG_CNS Quantity DECIMAL(9,3)
ConsumerPackageContentsUOMCode (FK) The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. LU_UOM_CNTN_PCKG Code varchar(20) UnitOfMeasure(CO_UOM)
ConsumerPackageWeightUOMCode (FK) The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. LU_UOM_WT Code varchar(20) UnitOfMeasure(CO_UOM)
ConsumerPackageSizeUOMCode (FK) The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. LU_UOM_SZ Code varchar(20) UnitOfMeasure(CO_UOM)
PegHorizontalDistance The horizontal distance from the edge of the Item to the center of the hole into which the peg is inserted when the Item is displayed on a pegboard. QU_PGCT_HRZL_DST QuantityShortCount decimal(3,0)
PegVerticalDistance The vertical from the edge of the Item to the center of the hole into which the peg is inserted when the Item is displayed on a pegboard. QU_PGCT_VRTL_DST QuantityShortCount decimal(3,0)
PegDistanceUOMCode (FK) The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. LU_UOM_PGCT Code varchar(20) UnitOfMeasure(CO_UOM)

Relationships

Parent Entity Verb Phrase Child Entity
UnitOfMeasure defines counting units for contents ShelfItem
StockItem isa ShelfItem
UnitOfMeasure defines distance for peg spacing ShelfItem
UnitOfMeasure defines units of weight for ShelfItem
UnitOfMeasure defines units of size for ShelfItem

Logical Views containing ShelfItem

Logical View
Logical 01000 - Item Description - Macro View
Logical 01004 - Item Description - Branding
Logical 01010 - Item Description - Subtype View
Logical 01050 - Item Description - Labelling View
Logical 01501 - Item Unit of Measure Types