Entity Definition

Logical Name : SerializedItem
Physical Name : AS_ITM_SRZ

Extra attributes for a StockItem that can be identified by a (normally) Manufacturer assigned Serial Number.

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)
ValidationFlag An indicator used to identify if the SERIALIZED ITEM requires operator validation after payment has been made and prior to customer pickup. FL_VLD_SRZ_ITM Flag integer
StoreWarrantyDescriptionCode A code to signify the type of warranty offered by the RETAIL STORE. This warranty normally supplements the warranty offered by the MANUFACTURER LU_WRTY_STR_SRZ Code4 char(4)
ManufacturerWarrantyDescriptionCode A code to denote the type of warranty offered on the SERIALIZED ITEM by the MANUFACTURER LU_WRTY_MF_SRZ_ITM Code4 char(4)
ManufacturerSizeDescription A code to signify the maufacturer's size reference. DE_SZ_MF_SRZ_ITM DescriptionShort varchar(255)
ModelYear The year of release or production of the SERIALIZED ITEM CY_MDL_SRZ_ITM DateCalendarYear char(4)
ModelNumber The model reference for a specific SERIALIZED ITEM. NM_NMB_SRZ_ITM Name varchar(40)
ManufacturerColorDescription The code to signify the manufacturer's color shade. DE_CLR_MF_SRZ_ITM DescriptionShort varchar(255)


Parent Entity Verb Phrase Child Entity
StockItem isa SerializedItem
SerializedItem is identified by SerializedUnit

Logical Views containing SerializedItem

Logical View
Logical 01000 - Item Description - Macro View
Logical 01004 - Item Description - Branding
Logical 01010 - Item Description - Subtype View
Logical 01040 - Item Description - Rental View
Logical 01100 - Item Selling Rules - Macro View
Logical 02120 - Item Inventory - Order View
Logical 02130 - Item Inventory - Receiving View
Logical 02311 - Retail Transaction Item KIT Sale View
Logical 02370 - Retail Transaction - Rental View
Logical 21000 - Fresh Item Management Macro View