Entity Definition

Logical Name : ForecourtSettlementTransaction
Physical Name : TR_STLM_FCRT

A special kind of forecourt transaction, that causes the system to do the following: 1. Perform an automatic PhysicalInventory of the tank Locations via TankGauge equipment. 2. Take a set of StockMeter and/or Sales/Meter Readings 3. Close-off the set of open NozzleHistory records.

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)
EventID (FK) A unique, automatically assigned identifier for the Event ID_EV Identity integer PhysicalInventoryEvent(CO_EV_PHY_INV)


Parent Entity Verb Phrase Child Entity
PhysicalInventoryEvent is caused by ForecourtSettlementTransaction
ForecourtSettlementTransaction causes StockMeterReading
ForecourtSettlementTransaction causes SalesMeterReading
ForecourtSettlementTransaction is closed by NozzleHistory
ForecourtTransaction can be a ForecourtSettlementTransaction

Logical Views containing ForecourtSettlementTransaction

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