Liquid Controls FlightConnect Office - Manual (Page 24)

24
Appendix
daTa fIles
Completed Transactions file (
CompTran.txt - COMP501.trn - CR501201.trn
)
COMP501.trn - FlightConnect DMS Transaction File - includes edit records
CR501201.trn - FlightConnect LCR 600 Transaction File - no edit Records
field # field name description Field Type Example
1 dateTime Date and time record was written. yy/mm/dd hh:mm:ss. A17
10/09/09
12:14:52
2 truck Truck Number. N16 1
3 fueler Fueler number. A16 80
4 baseID ID of the fueling operation’s base. A4 45
5 recordType Type of record. (See record types in shaded boxes below.) A1 0, 1, & 3
recordType = 0 (Fueler Logon)
1 odometer Odometer reading at the time of the logon. A11 0.0
2 unaccounted Unaccounted fuel at the time of the logon. A11 0.0
3 decimals Decimal setting for quantity fields. N (1-255) 1
recordType = 1 (Fueler Logoff)
1 odometer Odometer reading at the time of the logoff. A11 0.0
2 unaccounted Unaccounted fuel at the time of the logoff. A11 0.0
3 decimals Decimal setting for quantity fields. N (1-255) 1
DMS COMPLETED TRANSACTIONS FILE (COMP501.TRN)
"10/09/09 12:14:52","1","80","45","0","0.0","0.0","1" (Fueler Logon Record - see example below)
"10/09/09 12:16:41","1","80","45","1","0.0","0.0","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 consist
of the fields of the record type signified in field 5. The following two records are listed out in the example column of the table for reference.
COMPLETED TRANSACTIONS FILE (COMPTRAN.TXT)
recordType = 2 (Recirculation)
1 beginDelivery Date/Time delivery began. yy/mm/dd hh:mm:ss A17 - - -
2 endDelivery Date/Time delivery ended. yy/mm/dd hh:mm:ss A17 - - -
3 saleNumber LCR sale number of the delivery. N ±10 - - -
4 grossQty Gross quantity of fuel recirculated. N ±10 - - -
5 netQty Net quantity of fuel recirculated. N ±10 - - -
6 transType Transaction type of delivery. A3 - - -
7 decimals Decimal setting for quantity fields. N (0-2) - - -
8 averageTemp Average temperature of product during delivery. F5 - - -
9 maxPressure Maximum dP during delivery. F5 - - -
10 maxPressureRate Flow rate when maximum dP was read. N ±10 - - -