Developer Resources
Details
SoapAction | http://jackhenry.com/ws/EFTCardTrnHistSrch |
Input Name | EFTCardTrnHistSrch |
Output Name | EFTCardTrnHistSrchResponse |
Input Namespace | http://jackhenry.com/jxchange/TPG/2008 |
Group Name | Inquiry |
Container | TPG_InquiryMaster.xsd |
XML Examples
EFTCardTrnHistSrch-XML-Request
<?xml version="1.0" encoding="UTF-8"?> <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <SOAP-ENV:Header> <wsse:Security xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd"> <wsse:UsernameToken xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd"> <wsse:Username>{Insert}</wsse:Username> <wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">{Insert}</wsse:Password> <wsu:Created xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">2018-12-31T19:49:41Z</wsu:Created> </wsse:UsernameToken> </wsse:Security> </SOAP-ENV:Header> <SOAP-ENV:Body> <EFTCardTrnHistSrch xmlns="http://jackhenry.com/jxchange/TPG/2008"> <SrchMsgRqHdr> <jXchangeHdr> <JxVer/> <AuditUsrId></AuditUsrId> <AuditWsId></AuditWsId> <AuthenUsrId/> <ConsumerName/> <ConsumerProd/> <Ver_1/> <jXLogTrackingId>{Insert}</jXLogTrackingId> <Ver_2/> <InstRtId JHANull="" Rstr="">011001276</InstRtId> <InstEnv>TEST</InstEnv> <Ver_3/> <BusCorrelId/> <Ver_4/> <WorkflowCorrelId/> <Ver_5/> <ValidConsmName>{Insert}</ValidConsmName> <ValidConsmProd>{Insert}</ValidConsmProd> <Ver_6/> </jXchangeHdr> <MaxRec>20</MaxRec> <Cursor/> <Ver_1/> <Ver_2/> <Ver_3/> </SrchMsgRqHdr> <EFTCardNum>4311230036277860</EFTCardNum> <EFTCardSufxNum></EFTCardSufxNum> <StartTimeDt>
2019-06-05T05:00:00.000Z</StartTimeDt> <EndTimeDt>
2022-02-05T05:00:00.000Z</EndTimeDt> <Custom/> <Ver_1/> </EFTCardTrnHistSrch> </SOAP-ENV:Body> </SOAP-ENV:Envelope>
EFTCardTrnHistSrch-XML-Response
<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:u="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">
<s:Header>
<o:Security s:mustUnderstand="1"
xmlns:o="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">
<u:Timestamp u:Id="_0">
<u:Created>2019-06-18T19:37:41.971Z</u:Created>
<u:Expires>2019-06-18T19:42:41.971Z</u:Expires>
</u:Timestamp>
</o:Security>
</s:Header>
<s:Body>
<EFTCardTrnHistSrchResponse xmlns="http://jackhenry.com/jxchange/TPG/2008"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<SrchMsgRsHdr>
<jXchangeHdr>
<JxVer>R2017.4</JxVer>
<AuditUsrId/>
<AuditWsId/>
<AuthenUsrId/>
<ConsumerName/>
<ConsumerProd/>
<Ver_1/>
<jXLogTrackingId>f6628bf2-1007-4e2d-898a-1f8573b6b2f2</jXLogTrackingId>
<Ver_2/>
<InstRtId>062006505</InstRtId>
<InstEnv>TEST</InstEnv>
<Ver_3/>
<BusCorrelId>b66b6ea0-a5b8-461a-b249-017d4dd423fd</BusCorrelId>
<Ver_4/>
<WorkflowCorrelId/>
<Ver_5/>
</jXchangeHdr>
<SentRec>280</SentRec>
<MoreRec>false</MoreRec>
<Cursor>0</Cursor>
<TotRec>280</TotRec>
<Ver_1/>
</SrchMsgRsHdr>
<EFTCardTrnHistSrchRecArray>
<EFTCardHistSrchRec>
<EFTCardNum>431123xxxxxx7860</EFTCardNum>
<EFTTrnCode>9640</EFTTrnCode>
<EFTTrnDesc>Pre auth (9640)</EFTTrnDesc>
<EFTTrnAmt>.00</EFTTrnAmt>
<EFTTrnRqAmt>9.99</EFTTrnRqAmt>
<EFTCashTrnAmt>.00</EFTCashTrnAmt>
<EFTCashTrnRqAmt>.00</EFTCashTrnRqAmt>
<SerChgAmt>.00</SerChgAmt>
<SurChgAmt>.00</SurChgAmt>
<MerPartAuth>false</MerPartAuth>
<EFTExcAmt>.00</EFTExcAmt>
<EFTTrnStat>50</EFTTrnStat>
<EFTTrnStatDesc>NSF - DDA (50)</EFTTrnStatDesc>
<EFTTrnStatRmk>Recurring transaction (D)</EFTTrnStatRmk>
<ExcRsnCode>8</ExcRsnCode>
<ExcRsnDesc>Outstanding POS Auth (8)</ExcRsnDesc>
<EFTTrnSeqId>66141592</EFTTrnSeqId>
<EFTTrnDt>2019-06-14</EFTTrnDt>
<EFTTrnTime>08:53:59-05:00</EFTTrnTime>
<EFTSwchSeqId>084024</EFTSwchSeqId>
<EFTSwchTrnDt>2019-06-14</EFTSwchTrnDt>
<EFTSwchTrnTime>08:53:59-05:00</EFTSwchTrnTime>
<EFTXferToAcctId>0</EFTXferToAcctId>
<EFTTrnActIdType>Rq</EFTTrnActIdType>
<SwchTrnType>Oth</SwchTrnType>
<CashDistrType>false</CashDistrType>
<ATMTrnSttlType>Y</ATMTrnSttlType>
<TrnSttlDt>2019-06-14</TrnSttlDt>
<TrnSttlTime>14:31:13-05:00</TrnSttlTime>
<EFTTrnProcDt>2019-06-14</EFTTrnProcDt>
<AppTrnGenr>false</AppTrnGenr>
<EFTOnUsTrnType>true</EFTOnUsTrnType>
<EFTAtUsATMType>false</EFTAtUsATMType>
<EFTTrnAuthBalAmt>3.02</EFTTrnAuthBalAmt>
<EFTTrnRcptBalAmt>3.02</EFTTrnRcptBalAmt>
<EFTNtwkId>VNT</EFTNtwkId>
<StdIndustCode>5735</StdIndustCode>
<EFTCardCapType>Keyed</EFTCardCapType>
<EFTCardExpDt>2020-04-30</EFTCardExpDt>
<AddrVerifText>1433 352131317</AddrVerifText>
<AddrVerifCode>05</AddrVerifCode>
<AddrVerifDesc>Address and 5 digit zip match</AddrVerifDesc>
<EFTPrvdApprvTrn>false</EFTPrvdApprvTrn>
<EFTPrvdApprvBalAmt>.00</EFTPrvdApprvBalAmt>
<EftDescArray>
<EftDescInfo>
<EftDesc>08VISA99999999</EftDesc>
<Ver_1/>
</EftDescInfo>
<EftDescInfo>
<EftDesc>APL*ITUNES.COM/BILL</EftDesc>
<Ver_1/>
</EftDescInfo>
<EftDescInfo>
<EftDesc>866-712-7753 CA</EftDesc>
<Ver_1/>
</EftDescInfo>
</EftDescArray>
<Ver_1/>
<Ver_2/>
<Ver_3/>
</EFTCardHistSrchRec>
<EFTCardHistSrchRec>
<EFTCardNum>431123xxxxxx7860</EFTCardNum>
<EFTTrnCode>40</EFTTrnCode>
<EFTTrnDesc>D/C SETTLEMENT (0040)</EFTTrnDesc>
<EFTTrnAmt>35.59</EFTTrnAmt>
<EFTTrnRqAmt>35.59</EFTTrnRqAmt>
<EFTCashTrnAmt>.00</EFTCashTrnAmt>
<EFTCashTrnRqAmt>.00</EFTCashTrnRqAmt>
<SerChgAmt>.00</SerChgAmt>
<SurChgAmt>.00</SurChgAmt>
<MerPartAuth>false</MerPartAuth>
<EFTExcAmt>.00</EFTExcAmt>
<EFTTrnStat>1</EFTTrnStat>
<EFTTrnStatDesc>Authorized (01)</EFTTrnStatDesc>
<EFTTrnSeqId>26017036</EFTTrnSeqId>
<EFTTrnDt>2019-05-20</EFTTrnDt>
<EFTTrnTime>21:23:09-05:00</EFTTrnTime>
<EFTSwchSeqId>044184</EFTSwchSeqId>
<EFTSwchTrnDt>2019-05-21</EFTSwchTrnDt>
<EFTSwchTrnTime>21:23:09-05:00</EFTSwchTrnTime>
<EFTXferToAcctId>0</EFTXferToAcctId>
<EFTTrnActIdType>ForcePost</EFTTrnActIdType>
<SwchTrnType>Oth</SwchTrnType>
<CashDistrType>false</CashDistrType>
<ATMTrnSttlType>Y</ATMTrnSttlType>
<TrnSttlDt>2019-05-22</TrnSttlDt>
<TrnSttlTime>14:30:20-05:00</TrnSttlTime>
<EFTTrnProcDt>2019-05-22</EFTTrnProcDt>
<AppTrnGenr>true</AppTrnGenr>
<EFTOnUsTrnType>true</EFTOnUsTrnType>
<EFTAtUsATMType>false</EFTAtUsATMType>
<EFTTrnAuthBalAmt>.00</EFTTrnAuthBalAmt>
<EFTTrnRcptBalAmt>.00</EFTTrnRcptBalAmt>
<EFTNtwkId>VNT</EFTNtwkId>
<StdIndustCode>5921</StdIndustCode>
<EFTCardCapType>MagRead</EFTCardCapType>
<EFTPrvdApprvTrn>false</EFTPrvdApprvTrn>
<EFTPrvdApprvBalAmt>.00</EFTPrvdApprvBalAmt>
<EftDescArray>
<EftDescInfo>
<EftDesc>07VISA</EftDesc>
<Ver_1/>
</EftDescInfo>
<EftDescInfo>
<EftDesc>BEACH LIQUORS #2</EftDesc>
<Ver_1/>
</EftDescInfo>
<EftDescInfo>
<EftDesc>FT WALTON BCHFL</EftDesc>
<Ver_1/>
</EftDescInfo>
</EftDescArray>
<Ver_1/>
<Ver_2/>
<Ver_3/>
</EFTCardHistSrchRec>
<EFTCardHistSrchRec>
<EFTCardNum>431123xxxxxx7860</EFTCardNum>
<EFTTrnCode>0</EFTTrnCode>
<EFTTrnDesc>POS Debit Pri (0000)</EFTTrnDesc>
<EFTTrnAmt>105.44</EFTTrnAmt>
<EFTTrnRqAmt>105.44</EFTTrnRqAmt>
<EFTCashTrnAmt>.00</EFTCashTrnAmt>
<EFTCashTrnRqAmt>.00</EFTCashTrnRqAmt>
<SerChgAmt>.00</SerChgAmt>
<SurChgAmt>.00</SurChgAmt>
<MerPartAuth>false</MerPartAuth>
<EFTExcAmt>.00</EFTExcAmt>
<EFTTrnStat>1</EFTTrnStat>
<EFTTrnStatDesc>Authorized (01)</EFTTrnStatDesc>
<EFTTrnSeqId>0034258</EFTTrnSeqId>
<EFTTrnDt>2019-04-13</EFTTrnDt>
<EFTTrnTime>14:05:46-05:00</EFTTrnTime>
<EFTSwchSeqId>457976</EFTSwchSeqId>
<EFTSwchTrnDt>2019-04-13</EFTSwchTrnDt>
<EFTSwchTrnTime>14:05:46-05:00</EFTSwchTrnTime>
<EFTXferToAcctId>0</EFTXferToAcctId>
<EFTTrnActIdType>Rq</EFTTrnActIdType>
<SwchTrnType>Oth</SwchTrnType>
<CashDistrType>false</CashDistrType>
<ATMTrnSttlType>Y</ATMTrnSttlType>
<TrnSttlDt>2019-04-13</TrnSttlDt>
<TrnSttlTime>14:30:39-05:00</TrnSttlTime>
<EFTTrnProcDt>2019-04-13</EFTTrnProcDt>
<AppTrnGenr>true</AppTrnGenr>
<EFTOnUsTrnType>true</EFTOnUsTrnType>
<EFTAtUsATMType>false</EFTAtUsATMType>
<EFTTrnAuthBalAmt>518.67</EFTTrnAuthBalAmt>
<EFTTrnRcptBalAmt>518.67</EFTTrnRcptBalAmt>
<EFTNtwkId>PLX</EFTNtwkId>
<MerName>PUBLIX</MerName>
<StdIndustCode>5411</StdIndustCode>
<EFTCardCapType>MagRead</EFTCardCapType>
<EFTCardExpDt>2020-04-30</EFTCardExpDt>
<EFTPrvdApprvTrn>false</EFTPrvdApprvTrn>
<EFTPrvdApprvBalAmt>.00</EFTPrvdApprvBalAmt>
<EftDescArray>
<EftDescInfo>
<EftDesc>01PRESP1059103</EftDesc>
<Ver_1/>
</EftDescInfo>
<EftDescInfo>
<EftDesc>1325 MONTCLAIR RD</EftDesc>
<Ver_1/>
</EftDescInfo>
<EftDescInfo>
<EftDesc>BIRMINGHAM AL</EftDesc>
<Ver_1/>
</EftDescInfo>
</EftDescArray>
<Ver_1/>
<Ver_2/>
<Ver_3/>
</EFTCardHistSrchRec>
</EFTCardTrnHistSrchRecArray>
<Ver_1/>
</EFTCardTrnHistSrchResponse>
</s:Body>
</s:Envelope>
FAQ
EFTCardTrnHistSrchFAQ
A: EFTTrnCode doesn't have default canonical values, that's why you're not seeing them in contracts.
Q: How can we check/ get declined transactions of a card?
A: If there are any declined transactions they should still be passed back in the response depending on the request. EFTTrnStat is the completion code they would look at for approved/declined statuses.
Q: How can we lookup Specific Transactions?
A: It appears they would need to search by a date and then look within the search results since the API uses only EFTCardNum and start/stop dates.
Q: Can we get Transaction details on the basis of any unique number?
A: In the EFTCardTrnHistSrch response, the following three elements used together provide a unique value.
<EFTTrnSeqId>66141592</EFTTrnSeqId>
<EFTTrnDt>2019-06-14</EFTTrnDt>
<EFTTrnTime>08:53:59-05:00</EFTTrnTime>
Q: How can a consumer tell if an EFT Transaction is a debit, credit or other?
A: Using AcctHistSrch a consumer would pass in the IncXtendElemArray passing in XtendElem = x_EFTCardHistSrchRec. This will return enhanced EFT information with the AcctHistSrch API and provide the EFTCardNumber in the results. Within the non-EFT part of the results for a transaction there will be the TrnType element with the values: C (credit) or D (debit) or Oth (other).