| Anchor | ||||
|---|---|---|---|---|
|
The Load Summary report is automatically generated each time EFI transactions are loaded (FFEL). The Load Summary report is an "exception report"; it prints information for thAnchor
At the bottom of the Load Summary report, the totals show how many transactions were processed and loaded, how many transactions were rejected, and how many of the loaded transactions have special messages that warrant attention. The Pump Summary is also included to provide a quick summary of the fuel cost and quantity dispensed from the pumps. Be sure to compare the computed totals against actual totals (from fuel logs, reports from fueling system, etc.) to validate the loaded data prior to processing the fuel transactions.
The report columns are as follows:
ColumnsDescriptions
...
Column Descriptions
Date- Fueling date
TimeFueling Time- Fueling time
SiteFuel Site- Fuel site/fuel island number
Trn#Transaction Trn# Transaction number
TypTransaction Typ- Transaction type
Crd-1Driver 1- Driver card number
Crd-2- 2Vehicle Vehicle fuel card number
Vehicle # Vehicle #Vehicle number
PumpPump Pump- Pump number
PrdProduct Prd- Product code
QuantityFuel Quantity- Fuel quantity
PriceFuel Price- Fuel price
OdomVehicle Odom- Vehicle meter reading
Department #Department # Department number
RVTransaction status; Not applicable for this report
MessageSpecial Message-Special messages regarding the transaction
Summary
...
Info/Descriptions
Records: ProcessedTotal Processed- Total number of fuel transactions in the specified date and time range
Records: RejectedNumber Rejected- Number of fuel transactions not loaded
Records: Spcl MsgsNumber Msgs- Number of transactions with special messages
Totals: Trans-Added- AddedTotal Total number of fuel transactions loaded
Totals: QuantityTotal Quantity- Total fuel quantity loaded
Totals: Total-CostTotal Cost- Total fuel cost loaded
Pump Summary
...
Info/Descriptions
*An "N" in this column indicates the pump is not on file
PumpPump Pump- Pump facility and number
ProductProduct Product- Product code and fuel type
SiteFuel Site- Fuel site number where the pump is located
Accm-TrnTotal Trn- Total number of fuel transactions loaded for the pump
Accm-QtyTotal Qty- Total fuel quantity loaded for the pump
Accm-Cost- CostTotal Total fuel cost loaded for the pump. "***" is printed next to the total fuel cost to flag a potential problem (e.g. fuel price not found)
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
Special Load Messages
Refer to the following table for the special messages that may be printed on the Load Summary report. It is very important to look over the messages that are printed on the Load Summary report, and take any necessary action in order to avoid potential problems.
Message | Meaning | Actions needed |
No F-xref crd | Vehicle EFI fuel cross-reference number not on file |
|
No U-xref crd | Vehicle unit cross-reference number not on file |
|
Tnk not found | Pump record found but the attached tank record is not on file |
|
Pmp not found | Pump record not on file |
|
Fty not found | Fuel type specified in product code not on file |
|
Stg not found | Product storage variable missing in fuel type record |
|
Pc not found | Product code not on file |
|
Fuel Transfer | Transaction processed as a tank transfer |
|
Reject Tran | Transaction dropped |
|
Trans on file | Transaction has already been loaded |
|
...