CashDrawerEquipmentStatisticsReading

Entity Definition

Logical Name : CashDrawerEquipmentStatisticsReading
Physical Name : DO_EQRDG_CDRWR

A set of performance statistics that have been taken from a cash drawer connected to a Workstation.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
EquipmentID (FK)(PK) The fixed asset number assigned by the retailer for this particular piece of equipment. ID_EQ Identity integer
TimeStamp (FK)(PK) The date and time that the EquipmentStatisticsReading was made. TS_RDG AuditDateTime datetime
DrawerGoodOpenCount The number of successful cash drawer open operations that have taken place since the last statistics reading. QU_CNT_DRWR_OPN_GD QuantityShortCount decimal(3,0)
DrawerFailedOpenCount The number of unsuccessful cash drawer open operations that have taken place since the last statistics reading. QU_CNT_DRWR_OPN_FL QuantityShortCount decimal(3,0)

Relationships

Parent Entity Verb Phrase Child Entity
EquipmentStatisticsReading can be a CashDrawerEquipmentStatisticsReading

Logical Views containing CashDrawerEquipmentStatisticsReading

Logical View
Logical 06400 - Store Equipment View