Liquid Controls EZConnect Office - Manual (Page 38)

38
Appendix
field # field name description field Type example
1 dateTime Date and time record was written. yy/mm/dd hh:mm:ss. A17 10/08/15 05:46:46
2 ownerID ID of owner of truck making deliveries. A4 45
3 truck Truck number that made the delivery.
Integer
(0-4294967295)
1
4 fueler Fueler number. A16 80
5 recordType Type of record. (See record types in shaded boxes below.) A1 0
recordType = 0 (Fueler Logon)
6 odometer Odometer reading at the time of the logon. A11 0.0
7 unaccounted Unaccounted fuel at the time of the logon. A11 0.0
recordType = 1 (Fueler Logoff)
6 odometer Odometer reading at the time of the logoff. A11 0.0
7 unaccounted Unaccounted fuel at the time of the logoff. A11 802.1
recordType = 3 (Vehicle Fill)
6 invoice
Invoice number = mmdduunsss where mm is the month, dd
is the day, uu is the last two characters of the LCR Unit ID,
n is the last digit of the LCR node address, and sss is the
last three digits of the LCR sale number.
A19 090911020
7 beginDelivery Delivery start date and time. mm/dd/yy hh:mm:ss. A17 09/09/10 10:33:24
8 endDelivery Delivery end date and time. mm/dd/yy hh:mm:ss. A17 09/09/10 10:37:26
9 account Customer account number. A13 50
10 vehicle Customer vehicle number that received the fuel. A13 H25
11 department Department that is billed for the vehicle. A16 - - -
12 onRoad On-road indicator of vehicle being fueled. A3 No
13 product Product code delivered to the vehicle. A8 001
14 grossBegin Gross totalizer at the beginning of the delivery. A12 750.3
15 grossEnd Gross totalizer at the end of the delivery. A12 828.2
16 grossQty Gross quantity of fuel delivered. A12 77.9
17 netBegin Net totalizer at the beginning of the delivery. A12 0.0
18 netEnd Net totalizer at the end of the delivery. A12 0.0
19 netQty Net quantity of fuel delivered. A12 0.0
20 longitude Longitude where record was created. A9 0.0000
21 latitude Latitude where record was created. A8 0.0000
22 altitude Altitude where record was created. A7 0.0000
23 accuracy Horizontal dilution of precision. A4 0.0000
24 fixType Fix Type: 0=None, 1=Non-DGPS, 2=DGPS, 6=Estimated. A1 0
Completed Transactions file (
CoMp502.Trn - CompTran.txt
)
daTa fIles
"10/09/09 10:33:12","45","1","80","0","0.0","0.0" (Fueler Logon Record - see example below)
"10/09/09 10:37:26","45","1","80","3","090911020","09/09/10 10:33:24","09/09/10 10:37:26","50","H25","","
No","001","750.3","828.2","77.9","0.0","0.0","0.0","0.0000","0.0000","0.0000","0.0000","0" (Vehicle Fill Record - see
example below)
"10/09/09 10:43:11","45","1","80","1","0.0","802.1" (Fueler Logoff Record - see example below)
Each record in the CompTran.txt file includes the first five field numbers listed in the table. The 5th field signifies the record type. Fields after the 5th field make
up one of the 5 record types in the table. The following three records are listed out in the example coumn of the table for reference.