Entity Definition

Logical Name : SerializedUnit
Physical Name : AS_UN_SRZ

A specific instance of an item with a unique serial number, usually allocated by the manufacturer, and is used for identifying the individual instances of ITEMS for inventory control, installation and maintenance service and warranty management purposes.

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) SerializedItem(AS_ITM_SRZ)
SerialNumber (PK) A unique code, which can be either alpha, numeric or alpha-numeric, to identify an individual ITEM. ID_NMB_SRZ Name varchar(40)
EquipmentID (FK) The fixed asset number assigned by the retailer for this particular piece of equipment. ID_EQ Identity integer Equipment(AS_EQ)
TypeCode A code to indicate the type of SERIAL ITEM, eg TV, refrigerator, PC, etc. TY_ITM_SRZ Code2 char(2)
WarrantyCode A code to signify the type of warranty associated with the SERIAL ITEM. This code will include the length of the warranty. LU_WRTY_SRZ_UN Code2 char(2)
IssuedByPartyID (FK) A unique, system assigned identity for a Party. ID_PRTY_ISS Identity integer Party(PA_PRTY)
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)


Parent Entity Verb Phrase Child Entity
Equipment is a SerializedUnit
Party issues SerializedUnit
ItemTraceableUnit describes traceability of SerializedUnit
SerializedItem is identified by SerializedUnit
SerializedUnit is moved based on ICDMerchandiseLineItem
SerializedUnit is received via ICDMerchandiseSerializedUnit
SerializedUnit is a Equipment
SerializedUnit is a RentalUnit
SerializedUnit sells SerializedUnitModifier

Logical Views containing SerializedUnit

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 02110 - Item Inventory - Location View
Logical 02120 - Item Inventory - Order View
Logical 02130 - Item Inventory - Receiving View
Logical 02310 - Retail Transaction - Item Sale View
Logical 02311 - Retail Transaction Item KIT Sale View
Logical 02370 - Retail Transaction - Rental View
Logical 06400 - Store Equipment View
Logical 21000 - Fresh Item Management Macro View