Entity Definition

Logical Name : DriveOffTransaction
Physical Name : TR_DRV_OFF

A type of TRANSATION that records the clearing of a FUELLING TRANSACTION without accepting payment because the customer simply drove off wthout paying. Operator may record some details about the vehicle that has driven off

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32)
FuelingTransactionID (FK) A unique identifier for the fuelling transaction ID_TRN_FUEL Identity integer FuelingTransaction(EV_TR_FUEL)
VehicleColor The color of the vehicle that did the drive-off NM_CLR_VH Name varchar(40)
VehicleManufacturer The make of the vehicle that did the drive-off NM_MF_VH Name varchar(40)
VehicleModel The model of the vehicle that did the drive-off NM_MDL_VH Name varchar(40)
VehicleRegistrationNumber The registration nujmber of the vehicle that did the drive-off NM_RGST_VH Name varchar(40)


Parent Entity Verb Phrase Child Entity
FuelingTransaction is cleared by DriveOffTransaction
ForecourtTransaction can be a DriveOffTransaction

Logical Views containing DriveOffTransaction

Logical View
Logical 02200 - Transaction Macro View
Logical 20000 - Forecourt Macro View
Logical 20030 - Forecourt Transaction View