Entity Definition

Logical Name : TestDelivery
Physical Name : TR_DV_TST

A type of TRANSATION that records the clearing of a FUELLING TRANSACTION without accepting payment because the fuelling transaction was for testing or calibrating the FUELLING POINT. The fuel delivered may or may not have been put back into a storage

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)
LocationID (FK) A unique system assigned identifier for the Location. ID_LCN Identity integer InventoryLocation(LO_LCN_INV)
FuelingTransactionID (FK) A unique identifier for the fuelling transaction ID_TRN_FUEL Identity integer FuelingTransaction(EV_TR_FUEL)
ReasonCode A ReasonCode denoting why the TEST DELIVERY was performed. RC_DV_TST Code2 char(2)


Parent Entity Verb Phrase Child Entity
InventoryLocation accepted TestDelivery
FuelingTransaction is cleared by TestDelivery
TestDelivery is applied through ItemInventoryJournalEntry
ForecourtTransaction can be a TestDelivery

Logical Views containing TestDelivery

Logical View
Logical 02200 - Transaction Macro View
Logical 04300 - Financial Ledger - Inventory Control View
Logical 20000 - Forecourt Macro View
Logical 20030 - Forecourt Transaction View