Entity Definition

Logical Name : Equipment
Physical Name : AS_EQ

A device that is used to conduct retail store operations. Examples include: Workstation, FuelPump, TankGauge, TankProbe.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
EquipmentID (PK) The fixed asset number assigned by the retailer for this particular piece of equipment. ID_EQ Identity integer
EquipmentClassID (FK) A unique identifier for the class of equipment. ID_EQ_CLS Identity integer EquipmentClass(AS_EQ_CLS)
EquipmentTypeCode A 2 character code denoting the kind of equipment. Choices are currently Workstation, FuelPump, TankGauge and TankProbe TY_EQ Code2 char(2)
ModelNumber The model number assigned to the piece of equipment by the manufacturer. NM_MDL_NMB Name varchar(40)
ItemID (FK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) SerializedUnit(AS_UN_SRZ)
SerialNumber (FK) A unique code, which can be either alpha, numeric or alpha-numeric, to identify an individual ITEM. ID_NMB_SRZ Name varchar(40) SerializedUnit(AS_UN_SRZ)


Parent Entity Verb Phrase Child Entity
SerializedUnit is a Equipment
EquipmentClass classifies Equipment
Equipment is used in ItemProcessingEquipment
Equipment is a TenderAuthorizationTerminal
Equipment is a SerializedUnit
Equipment has components AssociatedEquipment
Equipment is a Workstation
Equipment is a TimeClock
Equipment defines content of ItemLabel
Equipment is a TankLevelGauge
Equipment is a TankProbe
Equipment is a FuelPump
Equipment is a component AssociatedEquipment
Equipment provides EquipmentStatisticsReading

Logical Views containing Equipment

Logical View
Logical 01000 - Item Description - Macro View
Logical 01004 - Item Description - Branding
Logical 01040 - Item Description - Rental View
Logical 01050 - Item Description - Labelling View
Logical 06400 - Store Equipment View
Logical 20000 - Forecourt Macro View
Logical 20010 - Forecourt Fueling Point View
Logical 20050 - Forecourt Tank Gauge View
Logical 21000 - Fresh Item Management Macro View