FuelingTransaction

Entity Definition

Logical Name : FuelingTransaction
Physical Name : EV_TR_FUEL

An auditing event, recording a particular NOZZLE completing a delivery of fuel.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
FuelingTransactionID (PK) A unique identifier for the fuelling transaction ID_TRN_FUEL Identity integer
RetailStoreID (FK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_BSN_UN Identity integer Nozzle(AS_NZL)
ItemID (FK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) Item(AS_ITM)
FuelingPointID (FK) A unique identifier for the FuelingPoint at a particular retail store ID_PNT_FUEL Identity integer Nozzle(AS_NZL)
NozzleID (FK) A unique identifier for the Nozzle ID_NZL Identity integer Nozzle(AS_NZL)
ItemPriceID (FK) A unique identifier for the ItemPrice. ID_PRC_ITM Identity integer FuelItemPrice(CO_PRC_ITM)
OperatorID (FK) A unique, automatically assigned number used to identify a workstation OPERATOR. ID_OPR Identity integer Operator(PA_OPR)
TypeCode A two charcter code denoting the type of FuelingTransactionEvent being recorded. Possible values include PostPay: Where the FuelingTransaction is yet to be sold by a FuelSalesLineItem in a RetailTransaction PrePayCompletion: Where money has been collected for the FuelingTransaction in a previous FuelSalesLineItem and there is no refund required. PrePayRefund: Where too much money was collected for the FuelingTransaction in a previous FuelSalesLineItem, and a further FuelSalesLineItem in a RetailTransaction is required to deal with the refund. CD_TRN_FUEL Code varchar(20)
TimeStamp The date & time of the completion of the fuelling transaction TS_TRN_FUEL AuditDateTime datetime
Volume The volume of fuel delivered in the fuelling transaction. QV_TRN_FUEL QuantityShortCount decimal(3,0)
UnitPrice The price per volume unit charged by the FUELLING POINT for the fuel delivered in the FUELLING TRANSACTION RP_TRN_FUEL MoneyShortRetail decimal(7,2)
TotalPrice The total price charged by the FUELLING POINT for the fuel delivered in the FUELLING TRANSACTION. TP_TRN_FUEL MoneyShortRetail decimal(7,2)
TotalSalesTax The sales tax charged by the FUELLING POINT for the fuel delivered in the FUELLING TRANSACTION. MO_TX_SLS MoneyShortRetail decimal(7,2)
TotalPriceIncludesSalesTax A flag denoting the inclusion (or non-inclusion) of the reported sales tax in the total price figure. FL_SLS_TX_INC Flag integer
AuthorizationElapsedTime The number of milli-seconds elapsed between CUSTOMER lifting NOZZLE and FUELING TRANSACTION commencing MI_AZN_ELPSD QuantityShortCountMilliseconds decimal(5,0)
DeliveryElapsedTime The number of seconds between FUELING TRANSACTION commencing and completing. SI_DV_ELPSD QuantityShortCountSeconds decimal(5,0)
SaleElapsedTime The number of seconds elapsed between FUELING TRANSACTION completing and being sold at a point of sale. SI_SLS_ELPSD QuantityShortCountSeconds decimal(5,0)

Relationships

Parent Entity Verb Phrase Child Entity
FuelItemPrice is used by FuelingTransaction
Operator authorizes FuelingTransaction
Item was dispensed by FuelingTransaction
Nozzle measured FuelingTransaction
FuelingTransaction is sold via FuelSalesLineItem
FuelingTransaction is cleared by TestDelivery
FuelingTransaction is applied through ItemInventoryJournalEntry
FuelingTransaction is cleared by DriveOffTransaction

Logical Views containing FuelingTransaction

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