<?xml version="1.0" standalone="yes"?>
<StarrliPOS>
  <Table>
    <Date>2016/8/23 12:16:30</Date>
    <Message>Application Start</Message>
  </Table>
  <Table>
    <Date>2016/8/23 12:29:41</Date>
    <Message>Application Start</Message>
  </Table>
  <Table>
    <Date>2016/8/23 13:32:23</Date>
    <Message>Begin Credit Authorize:Amont:10.75|Tips:0</Message>
  </Table>
  <Table>
    <Date>2016/8/23 13:32:23</Date>
    <Message> Table Fill: select InvoiceID from credittransinfomps where InvoiceID = 380651</Message>
  </Table>
  <Table>
    <Date>2016/8/23 13:32:23</Date>
    <Message> Update DB: insert into credittransinfomps(InvoiceID, AcctNo, ExpDate, CardType, AmountPurchase, AmountAuthorize, AmountGratuity,TimStamp, AvsZip, TranCode, RecordNo, OperatorID,Track2,cvvdata,AvsAddress,AcqRefData,TransactionIDVCode,VarLenFIDValue,isVoid) values(380651,'5KnsodKZMqyEbwpqxmSLYqq2pRkLATog','0520','VISA','10.75','10.75',0.00 ,current_timestamp,'','DateReady','',151,'Swiped','','',' ','','',0)</Message>
  </Table>
  <Table>
    <Date>2016/8/23 13:32:23</Date>
    <Message> Table Fill: select * from credittransinfomps where AcctNo='5KnsodKZMqyEbwpqxmSLYqq2pRkLATog' and InvoiceID =380651</Message>
  </Table>
  <Table>
    <Date>2016/8/23 13:32:24</Date>
    <Message>VXN Trans:Error ,Response Code:62 
MID:849256425885
TID:416499
DID:00028801259257226623
SERVICE_ID:104
APPLICATION_ID:STARRLIENPOSCOM2
PrimarySDCURL:https://vxn.datawire.net/sd
SecondarySDCURL:https://vxn1.datawire.net/sd
HexString:452E3834393235363432353838353431363439391C7040484E1C31311C313037351C343439353031353030363432343437393D32303035323031303335373030303030303030301C4130313459202020202020202020202020202020202020202020303030303030303030303030303030303030303030303030413036383231314130363930313130422020202020303030303030303030303030564D533030341B413056493030301C39301C311C3030
ClientRef:1620974V200000
(Trans Response:62 )
Response Date:
Approval Code:
TransactionIDVCode:
VarLenFIDValue:
ResponseAvs:
Outmessage:</Message>
  </Table>
  <Table>
    <Date>2016/8/23 13:32:24</Date>
    <Message> Update DB: update credittransinfomps set  TranCode = 'PreAuthFail'    where InvoiceID = 380651</Message>
  </Table>
  <Table>
    <Date>2016/8/23 13:32:24</Date>
    <Message>End Credit PreAuthorize:Result:False|Status Code:62|ApprovalCode:|Status Message:Error 62|TransactionId:</Message>
  </Table>
  <Table>
    <Date>2016/8/23 13:42:16</Date>
    <Message>Application Start</Message>
  </Table>
  <Table>
    <Date>2016/8/23 13:46:02</Date>
    <Message>Application Start</Message>
  </Table>
  <Table>
    <Date>2016/8/23 13:58:08</Date>
    <Message>Begin Credit Authorize:Amont:2|Tips:0</Message>
  </Table>
  <Table>
    <Date>2016/8/23 13:58:08</Date>
    <Message> Table Fill: select InvoiceID from credittransinfomps where InvoiceID = 380653</Message>
  </Table>
  <Table>
    <Date>2016/8/23 13:58:08</Date>
    <Message> Update DB: insert into credittransinfomps(InvoiceID, AcctNo, ExpDate, CardType, AmountPurchase, AmountAuthorize, AmountGratuity,TimStamp, AvsZip, TranCode, RecordNo, OperatorID,Track2,cvvdata,AvsAddress,AcqRefData,TransactionIDVCode,VarLenFIDValue,isVoid) values(380653,'DnWUUFOXoKfnqRcqN01A7L61DQ7+Z6cx','1019','VISA','2','2',0.00 ,current_timestamp,'','DateReady','',001,'Swiped','','',' ','','',0)</Message>
  </Table>
  <Table>
    <Date>2016/8/23 13:58:09</Date>
    <Message> Table Fill: select * from credittransinfomps where AcctNo='DnWUUFOXoKfnqRcqN01A7L61DQ7+Z6cx' and InvoiceID =380653</Message>
  </Table>
  <Table>
    <Date>2016/8/23 13:58:09</Date>
    <Message>VXN Trans:Error ,Response Code:62 
MID:849256425885
TID:416499
DID:00028801259257226623
SERVICE_ID:104
APPLICATION_ID:STARRLIENPOSCOM2
PrimarySDCURL:https://vxn.datawire.net/sd
SecondarySDCURL:https://vxn1.datawire.net/sd
HexString:452E3834393235363432353838353431363439391C7040484E1C31311C3230301C343033363233303130343539313330333D31393130323031303331363330313537331C4130313459202020202020202020202020202020202020202020303030303030303030303030303030303030303030303030413036383231314130363930313130422020202020303030303030303030303030564D533030341B413056493030301C39301C311C3030
ClientRef:1622520V200000
(Trans Response:62 )
Response Date:
Approval Code:
TransactionIDVCode:
VarLenFIDValue:
ResponseAvs:
Outmessage:</Message>
  </Table>
  <Table>
    <Date>2016/8/23 13:58:09</Date>
    <Message> Update DB: update credittransinfomps set  TranCode = 'PreAuthFail'    where InvoiceID = 380653</Message>
  </Table>
  <Table>
    <Date>2016/8/23 13:58:09</Date>
    <Message>End Credit PreAuthorize:Result:False|Status Code:62|ApprovalCode:|Status Message:Error 62|TransactionId:</Message>
  </Table>
  <Table>
    <Date>2016/8/23 13:58:09</Date>
    <Message> Table Fill: select orders.* ,orderdetails.printtime,orderdetails.finished as detailsfinished from orders, orderdetails where orderdetails.printtime<'2016-08-23 13:58:09' and orders.finished=false and orderdetails.finished=false and orders.OrderID =orderdetails.OrderID group by OrderID</Message>
  </Table>
</StarrliPOS>
