Developer Programs

Learn

Docs

Mappings

API by Reference > Core Services > Account Exception Transaction Search > Providers > SilverLake > Mappings

Request JHACMFREF MAXREC Maximun Records SrchMsgRqHdr.MaxRec 6 Integer BEGREC Begining Record SrchMsgRqHdr.Cursor ACCTNO Account Number InAcctId.AcctId 16 ACTYPE Account Type InAcctId.AcctType 1 NA String CHECKNUM Check number start ChkNumStart 10 Check number end ChkNumEnd DATE_D Start Date StartDt Date End Date EndDt AMT_13_2 Low Amount LowAmt 13 2 High Amount HighAmt YORN Unresolved Only UnResolveOnly CODE2 Exception Reason Code ExcRsnCode jXchange Version SrchMsgRqHdr.jXchangeHdr.JxVer JHA User ID SrchMsgRqHdr.jXchangeHdr.AuditUsrId 24 Work Station SrchMsgRqHdr.jXchangeHdr.AuditWsId Consumer Name SrchMsgRqHdr.jXchangeHdr.ConsumerName 32 Consumer Product SrchMsgRqHdr.jXchangeHdr.ConsumerProd Group Id SrchMsgRqHdr.AuthenUsrCred.Security User name Response SENTREC Number Sent Recs SrchMsgRsHdr.SentRec MOREREC More Recs? SrchMsgRsHdr.MoreRec NEXTREC Next Record SrchMsgRsHdr.Cursor TOTREC Total # Recs Exist SrchMsgRsHdr.TotRec 15 Echo Account Number Echo Account Type Echo Check number start Echo Check number end Echo Start Date Echo End Date Echo Low Amount Echo High Amount Echo Unresolved Only Echo Reason Code KEY256 Exception Item Id ExcTrnSrchRecArray.ExcTrnSrchRec.ExcItemId 256 NSF Item Id ExcTrnSrchRecArray.ExcTrnSrchRec.NSFItemId Posting date ExcTrnSrchRecArray.ExcTrnSrchRec.PostDt Effective date ExcTrnSrchRecArray.ExcTrnSrchRec.EffDt Check number ExcTrnSrchRecArray.ExcTrnSrchRec.ChkNum Amount ExcTrnSrchRecArray.ExcTrnSrchRec.Amt Resolved (Y/N) ExcTrnSrchRecArray.ExcTrnSrchRec.ExcResolveType TRANCODE Transaction code ExcTrnSrchRecArray.ExcTrnSrchRec.TrnCodeCode 5 DESC30 Transaction code description ExcTrnSrchRecArray.ExcTrnSrchRec.TrnCodeDesc 30 Disposition code ExcTrnSrchRecArray.ExcTrnSrchRec.ExcDispCode DESC20 Disposition code description ExcTrnSrchRecArray.ExcTrnSrchRec.ExcDispDesc 20 Source code ExcTrnSrchRecArray.ExcTrnSrchRec.ExcActnCode DESC35 Source code description ExcTrnSrchRecArray.ExcTrnSrchRec.ExcActnDesc 35 Reason code ExcTrnSrchRecArray.ExcTrnSrchRec.ExcRsnRecArray.ExcRsnRec.ExcRsnCode DESC80 Reason code description ExcTrnSrchRecArray.ExcTrnSrchRec.ExcRsnRecArray.ExcRsnRec.ExcRsnDesc 80 CODE1 Rec Status ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.RecStat NBR_4_0 Batch Number ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.BatchNum 4 NBR_10_0 Sequence Number ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.SeqNum AMT_5_2 NSF Fee Amt ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.NSFFeeAmt IMAGENUM Image number ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.ImgNum CARDNUMBER PAN ISO Card Number ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTCardNum 19 ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTCardNum.MaskVal Transaction Code ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTTrnCode DESC44 Transaction Desc ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTTrnDesc 44 Amount Completed ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTTrnAmt Amount Requested ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTTrnRqAmt Cash Amt Completed ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTCashTrnAmt Cash Amt Requested ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTCashTrnRqAmt AMT_6_2 Service Charge Amt ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.SerChgAmt Surcharge Amount ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.SurChgAmt CODE3 Part Auth Support ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.MerPartAuth 3 Exception amount ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTExcAmt NBR_2_0 Completion code ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTTrnStat DESC26 Transaction status ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTTrnStatDesc 26 DESC488 Long addition status ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTTrnStatDescAddl 488 Additional status in ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTTrnStatRmk Exception code ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.ExcRsnCode DESC25 Exception reason ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.ExcRsnDesc 25 CODE8 Transaction number ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTTrnSeqId 8 Local date Jul ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTTrnDt TIME_6 Local time HHMMSS ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTTrnTime Switch Transaction ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTSwchSeqId Switch Date CCYYDDD ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTSwchTrnDt Switch Time HHMMSS ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTSwchTrnTime To account number ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTXferToAcctId To account type ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTXferToAcctType Record type RQ,RV,FP ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTTrnActIdType ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.SwchTrnType Cash code ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.CashDistrType ATM Settlement ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.ATMTrnSttlType Date settled Jul ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.TrnSttlDt EOD Time ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.TrnSttlTime EOD Setl Jul ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTTrnProcDt Transaction created? ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.AppTrnGenr On-Us Transaction ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTOnUsTrnType At-Us Transaction ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTAtUsATMType BAL_14_2 Available balance ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTTrnAuthBalAmt 14 BAL_13_2 Receipt balance ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTTrnRcptBalAmt NBR_1_0 Days left to hold ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.PreAuthRemDays DESC10 Netword identifier ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTNtwkId DESC13 Authorization Expiration ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.PreAuthExpDt Merchant name ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.MerName CODE4 Merchant category ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.StdIndustCode Standard Industry desc ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.StdIndustDesc CODE7 Read/Keyed ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTCardCapType 7 ATM Address Ver ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.AddrVerifText Addr Ver Comp Code ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.AddrVerifCode Addr Ver Desc ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.AddrVerifDesc Standin ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTPrvdApprvTrn Standin Balance ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTPrvdApprvBalAmt DESC15 Transaction ID ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTTrnCorrelId DESC19 ATM Nnumber ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EftDescArray.EftDescInfo.EftDesc ATM Address ATM City/State Remark ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.RmkArray.RmkInfo.Rmk ODP Available ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.ODPBal Sweep Available ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.SweepBal ODLimit Available ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.ODLmtBal Bounce Available ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.BnceBal Investment balance ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.InvestBal Extended code ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.ExtCode Alt-US Tran Y/N ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.AtUsTrn Trans settled at ATM ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.TrnSttlAtATM Pgmr FLD 04 ALPHA 20 ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.PgmrFld ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.AtUsTrn2 Member Number ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.MbrNum Cash type transaction ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.CashTypeTrn Trans proc by EOD ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.TrnProcByEOD ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.OnUsTrn Post trans created ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.PostTrnCreated Record type ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.RecType PP Pro Standin/Balance ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.PPProStandinBal Switch code ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.SwchCode From account number ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.FrmAcctNum From account type ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.FrmAcctType Exp date received 7 ExcTrnSrchRecArray.ExcTrnSrchRec.SvcPrvdInfo.SilverLake.EFTCardHistSrchRec.EFTCardExpDt ALPHA16 ACH Company Name ExcTrnSrchRecArray.ExcTrnSrchRec.ACHCompName ACH Standard Entry Class ExcTrnSrchRecArray.ExcTrnSrchRec.ACHStdEntryClass DESC60 EFT Description 1 ExcTrnSrchRecArray.ExcTrnSrchRec.EftDescArray.EftDescInfo.EftDesc 60 EFT Description 2 Account number ExcTrnSrchRecArray.ExcTrnSrchRec.InAcctId.AcctId Account type ExcTrnSrchRecArray.ExcTrnSrchRec.InAcctId.AcctType ExcTrnSrchRecArray.ExcTrnSrchRec.SeqNum ExcTrnSrchRecArray.ExcTrnSrchRec.BatchNum SrchMsgRsHdr.jXchangeHdr.JxVer JHFREFAPI JHUSERID Audit User Id SrchMsgRsHdr.jXchangeHdr.AuditUsrId JHWSID Audit Work Station SrchMsgRsHdr.jXchangeHdr.AuditWsId CONSUMNM SrchMsgRsHdr.jXchangeHdr.ConsumerName CONSUMPR SrchMsgRsHdr.jXchangeHdr.ConsumerProd Message code SrchMsgRsHdr.MsgRecInfoArray.MsgRec.ErrCode Message category SrchMsgRsHdr.MsgRecInfoArray.MsgRec.ErrCat Message description SrchMsgRsHdr.MsgRecInfoArray.MsgRec.ErrDesc 512 Element error name SrchMsgRsHdr.MsgRecInfoArray.MsgRec.ErrElem 100 Element error value SrchMsgRsHdr.MsgRecInfoArray.MsgRec.ErrElemVal Procedure name SrchMsgRsHdr.MsgRecInfoArray.MsgRec.ErrLoc


Have a Question?
  • Have a how-to question? Seeing a weird error? Get help on our collaborative Discourse page.
  • Register for the Developer Office Hours where we answer technical Q&A, in real time, from the audience.

Did this page help you?

Last updated Mon Sep 14 2026