Checking
Overview
AcctHistSrch Demand Deposit
This operation allows you to obtain account transaction history associated with a specific DDA account.
Behavior
Use the AcctHistSrch
operation to find an amount, check number, or date number range of transaction history, as well as a specific transaction type for a given account, by sending in the following elements on the request:
AccountId
A complex element containing the incoming account identification information. The simple elements within this complex are:AcctId
(Account ID)AcctType
(Account Type)
LowAmt
(Starting point for amount selections)HighAmt
(Ending point for amount selections)ChkNumEnd
(Ending point for check number selections)ChkNumStart
(Starting point for check number selections)EndDt
(Ending point for date selections)StartDt
(Starting point for date selections)TrnType
(monetary transaction code)
Within the request, the MemoPostInc
element determines the behavior
searching history for memo-posted items. Canonical values are Excl
and Only. The default value is Excl (Exclude).
Consider the use of the two values, meaning that the AcctHistSrch
operation
could have to be used twice depending on if the business rules call for the functionality to
either exclude or include memo-posted items in the account transaction history.
XPath Elements
XPath Elements
For this business service, certain template fields, or XPath elements, are sent in on the request and corresponding elements are returned in the response.
The following tables list the elements that you send on the request and what is sent back in the response. Each table also includes any pertinent notes, such as element values or whether it is required for input.
XPath Element | File/Field | Description | Notes |
---|---|---|---|
| N/A | N/A | N/A |
| N/A | N/A | N/A |
| N/A | N/A | N/A |
| JHFREFAPI.MAXREC | Maximum Records | N/A |
| JHFREFAPI.BEGREC | Beginning Record | N/A |
| DDHIST.TRACCT | Account Number | N/A |
| DDHIST.TRATYP | Account Type | N/A |
| DDHIST.SERIAL | Check Number | N/A |
| DDHIST.SERIAL | Check Number | N/A |
| DDHIST.TRDATE | Transaction Date | N/A |
| DDHIST.TRDATE | Transaction Date | N/A |
| DDHIST.AMT | Transaction Amount | N/A |
| DDHIST.AMT | Transaction Amount | N/A |
| N/A | Sort Method | Canonical
|
| DDHIST.DORC | Debit/Credit Code | N/A |
| N/A | Elect Funds Only | N/A |
| N/A | Incl Memo Post Recs | Canonical
|
| N/A | Inquiry Filter 1 | N/A |
| DDHIST.JHTRANID | Transaction ID | N/A |
XPath Element | File/Field | Description | Notes |
---|---|---|---|
| JHFREFAPI.SENTREC | Number Sent Records | N/A |
| JHFREFAPI.MOREREC | More Records? | N/A |
| JHFREFAPI.NEXTREC | Next Record | N/A |
| JHFREFAPI.TOTRECS | Total # Records Exist | N/A |
| DDHIST.TRACCT | Account Number | N/A |
| DDHIST.TRATYP | Account Type | N/A |
| DDHIST.TRSTAT | Transaction Status | N/A |
| DDHIST.TRANCD | Transaction Code | N/A |
| DDPAR3.DESC | Transaction Code Description | N/A |
| DDHIST.TRDATE | Transaction Date | N/A |
| DDHIST.AMT | Transaction Amount | N/A |
| DDHIST.BATCH | Batch Number | N/A |
| DDHIST.SEQ | Sequence Number | N/A |
| N/A | Source Code Description | N/A |
| DDHIST.DORC | Debit/Credit Code | N/A |
| DDHIST.BORI | Affects Code | N/A |
| DDHIST.IMAGE# | Image Item Number | N/A |
| DDHIST.TREFFD | Effective Date | N/A |
| DDHIST.SERIAL | Check Number | N/A |
| DDHIST.NOBOOK | No Book Flag | Canonical
|
| DDHIST.TRRATE | Old Rate | N/A |
| N/A | EFT Description 1 | There are 10 total elements available for you to enter information into. |
| N/A | EFT Description 2 | There are 10 total elements available for you to enter information into. |
| N/A | Description | There are 12 total elements available for you to enter information into. |
| N/A | Memo Post Rec | N/A |
| DDMAST.CBAL | Running Balance | N/A |
| DDHIST.CKPAYEE | Check Payee | N/A |
| DDHIST.DDUSRID | User ID | N/A |
| N/A | Card Number | N/A |
| N/A | Card Number | N/A |
| N/A | Transaction Code | N/A |
| N/A | Transaction Description | N/A |
| N/A | Amount Completed | N/A |
| N/A | Amount Requested | N/A |
| N/A | Cash Amount Completed | N/A |
| N/A | Cash Amount Requested | N/A |
| N/A | Service Charge Amount | N/A |
| N/A | Surcharge Amount | N/A |
| N/A | Merchant Partial Authorization | Canonical
|
| N/A | Exception Amount | N/A |
| N/A | Transaction Completion Code | N/A |
| N/A | Transaction Status Description | N/A |
| N/A | EFT Transaction Status | N/A |
| N/A | Exception Reason Code | N/A |
| N/A | Exception Reason Description | N/A |
| N/A | Transaction Number | N/A |
| N/A | Local Transaction Date | N/A |
| N/A | Local Transaction Time | N/A |
| N/A | Switch Transaction Number | N/A |
| N/A | Switch Transaction Date | N/A |
| N/A | Switch Transaction Time | N/A |
| N/A | Transfer to Account Number | N/A |
| N/A | Transfer to Account Type | N/A |
| N/A | Transaction Type | Canonical
|
| N/A | Switch Transaction | Canonical
|
| N/A | Cash Distribution Code | N/A |
| N/A | Transaction Settlement Type | N/A |
| N/A | Settlement Date | N/A |
| N/A | Settlement Time | N/A |
| N/A | Transaction Process Date | N/A |
| N/A | Transaction Created | N/A |
| N/A | On-Us Transaction | N/A |
| N/A | At-Us Transaction Type | N/A |
| N/A | Authorization Balance | N/A |
| N/A | Receipt Balance | N/A |
| N/A | Preauthorization Remaining Days | N/A |
| N/A | Network Identifier | N/A |
| N/A | Preauthorization Expiration Date | N/A |
| N/A | Merchant Name | N/A |
| N/A | Standard Industry Code | N/A |
| N/A | Standard Industry Code Description | N/A |
| N/A | Card Capture Type | Canonical
|
| N/A | Card Expiration Date | N/A |
| N/A | Address Verified | N/A |
| N/A | Address Verification Code | N/A |
| N/A | Address Verification Description | N/A |
| N/A | Stand-in Approval | N/A |
| N/A | Stand-in Balance | N/A |
| N/A | Transaction Identifier | N/A |
| N/A | ATM Number | N/A |
| N/A | ATM Address | N/A |
| N/A | ATM City, State | N/A |
| N/A | Remark | N/A |
| N/A | Additional Transaction Status Description | N/A |
| N/A | ODP Balance | N/A |
| N/A | Sweep Balance | N/A |
| N/A | ODP Limit Balance | N/A |
| N/A | Bounce Available | N/A |
| N/A | Investment Balance | N/A |
| N/A | Extended Code | N/A |
| N/A | At-Us Transaction | N/A |
| N/A | Transaction Settled at ATM | N/A |
| N/A | Programmer Field | N/A |
| N/A | At-Us Transaction 2 | N/A |
| N/A | Member Number | N/A |
| N/A | Cash Transaction Type | N/A |
| N/A | Transaction Processed by EOD | N/A |
| N/A | On-Us Transaction Type | N/A |
| N/A | Post Transaction Created | N/A |
| N/A | Record Type | N/A |
| N/A | PassPort Pro Stand-in Balance | N/A |
| N/A | Switch Code | N/A |
| N/A | Transfer From Account Number | N/A |
| N/A | Transfer From Account Type | N/A |
| N/A | OD Privilege Transaction Type | N/A |
| N/A | Affects Code Description | N/A |
| DDPAR3.STMDSC | Statement Description | N/A |
| DDHIST.JHTRANID | Transaction ID | N/A |
| DDMAST.CBAL | Running Balance | N/A |
| TRNEXTD.GUID# | EFT Transaction ID | N/A |
| N/A | History Record ID | N/A |
Validations
Validations
Within the response, specific validations can appear in the response if incorrect or different information than what is required is sent in the request.
The following table lists the errors that can be returned and includes what prompts the errors to occur.
Code | Element | System Message | Validation Trigger |
---|---|---|---|
1 | AcctId | Account not found | Presents when the account number/type combination is not found in the Deposit Master File (DDMAST). |
1 | AcctType | Account not found | Presents when the account number/type combination is not found in the Deposit Master File (DDMAST). |
11 | Cursor | Beginning Record cannot be negative | Presents when the value in this element is less than zero. |
43 | EndDt | Date is not valid | Presents when the value in this element is greater than zero and is not in the correct date format. |
43 | StartDt | Date is not valid | Presents when the value in this element is greater than zero and is not in the correct date format. |
45 | N/A | Numeric data is not valid | Presents when a numeric value is not entered in this element. |
48 | MaxRec | Maximum records must be greater than zero and less than or equal to 4000 | Presents when the value in this element is less than or equal to zero or greater than 4000. |
The following table lists the warnings that can be returned and includes what prompts the warnings to occur.
Code | Element | System Message | Validation Trigger |
---|---|---|---|
49 | AcctType | No Records Match Selection Criteria | Presents when no matches are found for the account number/type combination sent in the request. |
49 | AcctId | No Records Match Selection Criteria | Presents when no matches are found for the account number/type combination sent in the request. |
Service Dictionary
Service Dictionary
Service Dictionary Search provides consumers a service that can convey a service provider's element XSD path, requirements, default values, open enumerated canonical values, help/knowledge content, and fault codes per operation.
Within the SvcDictSrch
operation, you can send
AcctHistSrch in the SvcDictName
element and
Rq or Rs in the SvcDictType
element. Within the response, SvcDictSrch
returns all mapped elements,
including any newly mapped elements, and any elements that have specific allowed values. The
following table lists the response information for elements with specified allowed values.
SvcDictFilterCode
and B in SvcDictFilterVal
to get values specific for the time deposit application.Element Name | Field Value (ElemCanocVal) |
---|---|
StmtPasCode | NA |
StmtPasCode | Pas |
StmtPasCode | Stmt |
MerPartAuth | false |
MerPartAuth | true |
EFTTrnActIdType | Blank |
EFTTrnActIdType | ForcePost |
EFTTrnActIdType | Rev |
EFTTrnActIdType | Rq |
SwchtrnType | Blank |
SwchtrnType | MasterMoney |
SwchtrnType | None |
SwchtrnType | Oth |
SwchtrnType | VisaChk |
EFTCardCapType | Blank |
EFTCardCapType | ChipRead |
EFTCardCapType | FallbackMagRead |
EFTCardCapType | Keyed |
EFTCardCapType | NFCChipRead |
EFTCardCapType | NFCMagRead |
SrtMthd | Amt |
SrtMthd | ChkNum |
SrtMthd | EffDt |
SrtMthd | PostDt |
MemoPostInc | Blank |
MemoPostInc | true |
MemoPostInc | Excl |
MemoPostInc | Only |
XtendElem | x_AcctBenf |
XtendElem | x_ACHHistSrchRec |
XtendElem | x_BusDetail |
XtendElem | x_CondNotfInfoRec |
XtendElem | x_DepAcctInfo |
XtendElem | x_DepBalDtInfo |
XtendElem | x_DepInfoRec |
XtendElem | x_DepNSFODInfo |
XtendElem | x_DepRateIntInfo |
XtendElem | x_DepRegRptInfo |
XtendElem | x_DepStmtInfo |
XtendElem | x_DepTaxInfo |
XtendElem | x_EscrwAnlys |
XtendElem | x_EscrwFldInsurArray |
XtendElem | x_EscrwPayeeArray |
XtendElem | x_EscrwPmtBal |
XtendElem | x_EFTCardBlkTrnArray |
XtendElem | x_EFTCardCntryArray |
XtendElem | x_EFTCardHist |
XtendElem | x_EFTCardHistSrchRec |
XtendElem | x_EFTCardMailAddrInfo |
XtendElem | x_EFTCardTrvInfo |
XtendElem | x_FinInstInfoProcRec |
XtendElem | x_IdVerify |
XtendElem | x_IntentAccessInfoRec |
XtendElem | x_IntentCashMgmtInfoRec |
XtendElem | x_IntentInfoRec |
XtendElem | x_IntentValidXferInfoRec |
XtendElem | x_IntentXferInfoRec |
XtendElem | x_LnAcctInfo |
XtendElem | x_LnBalDtInfo |
XtendElem | x_LnDlrInfo |
XtendElem | x_LnInforec |
XtendElem | x_LnMtgInfo |
XtendElem | x_LnPastdueInfo |
XtendElem | x_LnPmtInfo |
XtendElem | x_LnPmtInfo |
XtendElem | x_LnProtInfo |
XtendElem | x_LnRateInfo |
XtendElem | x_LnRealEstateInfo |
XtendElem | x_LnRegRptInfo |
XtendElem | x_LnRenExtInfo |
XtendElem | x_LnStopInfo |
XtendElem | x_LnUnitAcctInfo |
XtendElem | x_LnUnitBalDtInfo |
XtendElem | x_LnUnitInfoRec |
XtendElem | x_LnUnitPmtInfo |
XtendElem | x_LnUnitProtInfo |
XtendElem | x_LnUnitRateInfo |
XtendElem | x_LnUnitRenExtInfo |
XtendElem | x_PersonName |
XtendElem | x_PlnTaxInfo |
XtendElem | x_RegDetail |
XtendElem | x_SafeDepAcctInfo |
XtendElem | x_SafeDepInfoRec |
XtendElem | x_StmtDataHistSrchRec |
XtendElem | x_TaxDetail |
XtendElem | x_TaxPlnDist |
XtendElem | x_TimeDepAcctInfo |
XtendElem | x_TimeDepBalDtInfo |
XtendElem | x_TimeDepInfoRec |
XtendElem | x_TimeDepRateIntInfo |
XtendElem | x_TimeDepRegRptInfo |
XtendElem | x_TimeDepRenInfo |
XtendElem | x_TimeDepStmtInfo |
XtendElem | x_TimeDepTaxInfo |
XtendElem | x_TrckAcctInfoRec |
XtendElem | x_TrnTotArray |
XtendElem | x_UserDefInfoArray |