Entity Definition

Logical Name : ItemWarranty
Physical Name : AS_ITM_WRTY

A retailer or third party guarantee about an item, often including commitments to repair, replace or provide compensation when the item fails. This entity is currently a placeholder for the attributes it contains.

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) Item(AS_ITM)
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 DescriptionShort VARCHAR(255)
ManufacturerWarrantyDescriptionCode A code to denote the type of warranty offered on the SERIALIZED ITEM by the MANUFACTURER LU_WRTY_MF_SRZ_ITM DescriptionShort VARCHAR(255)
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 DescriptionShort VARCHAR(255)
ManufacturerColorDescription The code to signify the manufacturer's color shade. DE_CLR_MF_SRZ_ITM DescriptionShort VARCHAR(255)


Parent Entity Verb Phrase Child Entity
Item has available ItemWarranty

Logical Views containing ItemWarranty

Logical View
Logical 01000 - Item Description - Macro View
Logical 01004 - Item Description - Branding
Logical 01010 - Item Description - Subtype View
Logical 21000 - Fresh Item Management Macro View