ACH Transaction Search
ACH Transaction Search
ACH Transaction Search is a jXchange service designed to allow consumers to obtain ACH transactions.
Message Flow
In jXchange, the ACH Transaction Search service uses a typical exchange of
MType
messages to allow consumers to obtain ACH transactions.
Primary Request
The consumer forwards the ACHTrnSrchRq_MType
message to the service
provider. The message contains the following simple elements:
- EndDt
- IncEDIOnly
- StartDt
Primary Response
The service provider returns the ACHTrnSrchRs_MType
message to the
consumer. The message contains the following simple elements:
- EndDt
- IncEDIOnly
- StartDt
ACH Transaction Search Behavior
The ACH Transaction Search (ACHTrnSrch
) service behavior is as
follows:
The ACH Transaction Search root request (ACHTrnSrchRq_MType
) requires a
valid Account Identification (AccountId_CType
).
The ACH Transaction Search root request (ACHTrnSrchRq_MType
) optionally
allows for the filters Start Date (StartDt), End Date
(EndDt), and Include EDI Only
(IncEDIOnly).
A consumer request with a Start Date (StartDt) but without an End Date (EndTimeDt) returns all the qualified ACH Transaction records with a date equal to and greater than the Effective Date (EffDt).
A consumer request with an End Date (EndDt) but without a Start Date (StartDt) returns all the qualified ACH Transaction records with a date equal to and less than the Effective Date (EffDt).
A consumer request with a Start Date (StartDt) and an End Date (EndDt) returns all the qualified ACH Transaction records with a date equal to and greater than the Effective Date (EffDt) and a date equal to and less than the Effective Date (EffDt).
The service provider reserves the right to limit the date range when a consumer's request does not include a Start Date (StartDt) and End Date (EndDt).
The ACH Transaction Search root response message (ACHTrnSrchRs_MType
) echoes
back the request elements.
The ACH Transaction Search Array (ACHTrnSrchRs_MType
) returns the ACH
Transaction items that matched the request filters.
The ACH Transaction Search Array (ACHTrnSrchRs_MType
) contains ACH
Transaction Search Array (ACHTrnSrchArray_Atype
), which contains the ACH
Transaction Identifier (ACHTrnId), ACH Transaction Status Type
(ACHTrnStatType), Effective Date (EffDt), Post
Date (PostDt), Transaction Code Code
(TrnCodeCode), ACH Company Name (ACHCompName),
ACH Standard Entry Class (ACHStdEntryClass), ACH Company Identifier
(ACHCompId), ACH EDI Type (ACHEDIType), and
Amount (Amt) simple elements.
The response elements are returned in LIFO order.
The standard Search message header tenets are applicable.
The standard Search message tenets are applicable.
ACHTrnSrchRq_MType
ACHTrnSrchRq_MType
is a message MType
element.
Contains:
AccountId_CType
Custom_CType
SrchMsgRqHdr_CType
Simple Elements
The following simple elements are contained within this message.
- EndDt
- The date that designates the ending point for date selections.
- IncEDIOnly
- Answers the question: only include EDI-impacted ACH transactions? Canonical values
are:
- True
- False
- StartDt
- The date that designates the starting point for date selections.
AccountId_CType
AccountId_CType
is a complex
CType
element. This element contains the incoming account
identification information and any restrictions.
Simple Elements
The following simple elements are contained within this complex.
- AcctId
- The number or character that identifies an account record.
- AcctType
- The number or character that categorizes the AcctId.
- Rstr
- The level of restrictions that can exist at a parent and/or child node. Canonical
values are:
- Hid
- NoAccess
- NoAccessPart
- ReadOnly
- ReadOnlyPart
- ReadWrite
- ReadWritePart
Custom_CType
Custom_CType
is a complex CType
element.
This element is optional.
SrchMsgRqHdr_CType
SrchMsgRqHdr_CType
is a complex
CType
element. This is a
standard request message header.
Contains:
AuthenUsrCred_CType
jXchangeHdr_CType
Simple Elements
The following simple elements are contained within this complex.
- AuthenProdCred
- Authentication of the Consumer Product Credentials in the form of a WS Security element that contains a single SAML V2.0 Assertion.
- Cursor
- The state information that allows the next call to understand where it left off when returning multiple records and allowing a subsequent call to retrieve more records.
- MaxRec
- The maximum number of records when multiple records are returned.
AuthenUsrCred_CType
AuthenUsrCred_CType
is a complex CType
element. This element represents authentication of the end-user credentials in
the form of a WS Security element that contains a single SAML V2.0
Assertion.
Simple Elements
The following simple elements are contained within this complex.
- Security
- Defines the wsse:Security SOAP header element per section 4.
jXchangeHdr_CType
jXchangeHdr_CType
is a complex
CType
element.
Simple Elements
The following simple elements are contained within this complex.
- AuditUsrId
- The user ID that the consumer would like written in the audit as performing the requested service. It varies, but it could be the same as the user ID. It is not used to authenticate. It is used to audit the Soap Header Fault.
- AuditWsId
- The workstation ID that the consumer would like written in the audit as performing the requested service for the Soap Header Fault. It varies, but it could be the same as the user ID.
- AuthenUsrId
- The user ID which the consumer would like the service provider to authenticate with
for the Soap Header Fault. It is a user ID that the provider understands.
This element deprecates in accordance with XSD contract tenets. Effective date: 2017–01–01. The new complex element for user authentication credentials was added to both the Search Message Request Header
SrchMsgRqHdr_CType
and the Message Request HeaderMsgRqHdr_CType
. AuthenUsrId is ignored by the service providers when the authentication user credentialsAuthenUsrCred_CType
package is delivered. The expectation is that the password credentials and the user name token are provided in the authentication user credential complex element in accordance with the standards established by WS-Security. - BusCorrelId
- The correlation identification as related to business functions and activities.
- ConsumerName
- The name of the service consumer (business name) for the Soap Header Fault.
- ConsumerProd
- The name of the product which is consuming the service (business product name) for the Soap Header Fault.
- InstEnv
- An identification provided by the consumer that defines the environment in which the
institution is operating. Canonical values are:
- Prod
- InstRtId
- The identification of the entity of the submitted message. A
financial institution entity uses the routing transit or nine-digit number assigned to
financial institutions for routing as assigned by the American Bankers Association. Any
leading zeros must be provided for a complete routing and transit number. A
non-financial institution entity should use a mutually agreed upon identification that
must contain at least one non-integer character. The canonical value is
JHA.
The element is required in all message requests.
- jXLogTrackingId
- An identification provided by jXchange to be able to trace the request and response of a message from the third-party gateway, internal gateway, and service provider for the Soap Header Fault.
- JxVer
- Contains the version jXchange is running for the Soap Header Fault.
- ValidConsmName
- The consumer name that can be validated by enterprise governance. The canonical values are managed in a consumer/product enterprise table. The canonical value is: JHA.
- ValidConsmProd
- The consumer product name that can be validated by enterprise governance. The canonical values are managed in a consumer/product enterprise table.
- WorkflowCorrelId
- The correlation identification as related to workflow functions and activities.
jXchangeHdr_CType Deprecation Details
- AuthenUserId
- This element deprecates in three years in accordance with XSD contract tenets.
Effective date: 2012–01–01. The new complex element for user authentication credentials
was added to the Search Message Request Header,
SrchMsgRqHdr_CType
, and the Message Request Header,MsgRqHdr_CType
.AuthenUsrId
is ignored by the service providers when the authentication user credentialsAuthenUsrCred_CType
package is delivered. The expectation is that the password credentials and the user name token are provided in the authentication user credential complex element in accordance with the standards established byWS-Security
.
ACHTrnSrchRs_MType
ACHTrnSrchRs_MType
is a message MType
element.
Contains:
AccountId_CType
ACHTrnSrchArray_AType
Custom_CType
SrchMsgRsHdr_CType
Simple Elements
The following simple elements are contained within this message.
- EndDt
- The date that designates the ending point for date selections.
- IncEDIOnly
- Answers the question: only include EDI-impacted ACH transactions? Canonical values
are:
- True
- False
- StartDt
- The date that designates the starting point for date selections.
AccountId_CType
AccountId_CType
is a complex
CType
element. This element contains the incoming account
identification information and any restrictions.
Simple Elements
The following simple elements are contained within this complex.
- AcctId
- The number or character that identifies an account record.
- AcctType
- The number or character that categorizes the AcctId.
- Rstr
- The level of restrictions that can exist at a parent and/or child node. Canonical
values are:
- Hid
- NoAccess
- NoAccessPart
- ReadOnly
- ReadOnlyPart
- ReadWrite
- ReadWritePart
ACHTrnSrchArray_AType
ACHTrnSrchArray_AType
is an array AType
element. This
is an array of account ACH transactions.
Contains:
ACHTrnSrchRec_CType
ACHSrchRec_CType
ACHSrchRec_CType
is a complex CType
element.
Contains:
Custom_CType
Simple Elements
The following simple elements are contained within this complex.
- ACHCompId
- The ACH company ID.
- ACHCompName
- The ACH company name, as governed by NACHA rules.
- ACHEDITYPE
- Answers the question: Is the ACH transaction included in EDI addenda
data? Canonical values are:
- True
- False
- ACHStdEntryClass
- The ACH standard entry class.
- ACHTrnId
- The identification given to an ACH transaction.
- ACHTrnStatType
- The status of the ACH transaction. Canonical values are:
- Pend
- Post
- Amt
- The amount or quantity.
- EffDt
- The date assigned to transactions when it is different from the posting date.
- PostDt
- The date a transaction has posted or is scheduled to be posted to an account.
- TrnCodeCode
- The code that identifies the behavior of a monetary transaction.
Custom_CType
Custom_CType
is a complex CType
element.
This element is optional.
Custom_CType
Custom_CType
is a complex CType
element.
This element is optional.
SrchMsgRsHdr_CType
SrchMsgRsHdr_CType
is a complex
CType
element. It searches specific message response
headers.
Contains:
jXchangeHdr_CType
MsgRecInfoArray_AType
Simple Elements
The following simple elements are contained within this complex.
- Cursor
- The state information that allows the next call to understand where it left off when returning multiple records and allowing a subsequent call to retrieve more records.
- MoreRec
- Indicates if there are more records that could be returned. Canonical values are:
- false
- true
- SentRec
- The number of records sent in the response.
- TotRec
- Indicates the total records the request selected, which could be larger than
MaxRec.
jXchangeHdr_CType
jXchangeHdr_CType
is a complex
CType
element.
Simple Elements
The following simple elements are contained within this complex.
- AuditUsrId
- The user ID that the consumer would like written in the audit as performing the requested service. It varies, but it could be the same as the user ID. It is not used to authenticate. It is used to audit the Soap Header Fault.
- AuditWsId
- The workstation ID that the consumer would like written in the audit as performing the requested service for the Soap Header Fault. It varies, but it could be the same as the user ID.
- AuthenUsrId
- The user ID which the consumer would like the service provider to authenticate with
for the Soap Header Fault. It is a user ID that the provider understands.
This element deprecates in accordance with XSD contract tenets. Effective date: 2017–01–01. The new complex element for user authentication credentials was added to both the Search Message Request Header
SrchMsgRqHdr_CType
and the Message Request HeaderMsgRqHdr_CType
. AuthenUsrId is ignored by the service providers when the authentication user credentialsAuthenUsrCred_CType
package is delivered. The expectation is that the password credentials and the user name token are provided in the authentication user credential complex element in accordance with the standards established by WS-Security. - BusCorrelId
- The correlation identification as related to business functions and activities.
- ConsumerName
- The name of the service consumer (business name) for the Soap Header Fault.
- ConsumerProd
- The name of the product which is consuming the service (business product name) for the Soap Header Fault.
- InstEnv
- An identification provided by the consumer that defines the environment in which the
institution is operating. Canonical values are:
- Prod
- InstRtId
- The identification of the entity of the submitted message. A
financial institution entity uses the routing transit or nine-digit number assigned to
financial institutions for routing as assigned by the American Bankers Association. Any
leading zeros must be provided for a complete routing and transit number. A
non-financial institution entity should use a mutually agreed upon identification that
must contain at least one non-integer character. The canonical value is
JHA.
The element is required in all message requests.
- jXLogTrackingId
- An identification provided by jXchange to be able to trace the request and response of a message from the third-party gateway, internal gateway, and service provider for the Soap Header Fault.
- JxVer
- Contains the version jXchange is running for the Soap Header Fault.
- ValidConsmName
- The consumer name that can be validated by enterprise governance. The canonical values are managed in a consumer/product enterprise table. The canonical value is: JHA.
- ValidConsmProd
- The consumer product name that can be validated by enterprise governance. The canonical values are managed in a consumer/product enterprise table.
- WorkflowCorrelId
- The correlation identification as related to workflow functions and activities.
jXchangeHdr_CType Deprecation Details
- AuthenUserId
- This element deprecates in three years in accordance with XSD contract tenets.
Effective date: 2012–01–01. The new complex element for user authentication credentials
was added to the Search Message Request Header,
SrchMsgRqHdr_CType
, and the Message Request Header,MsgRqHdr_CType
.AuthenUsrId
is ignored by the service providers when the authentication user credentialsAuthenUsrCred_CType
package is delivered. The expectation is that the password credentials and the user name token are provided in the authentication user credential complex element in accordance with the standards established byWS-Security
.
MsgRecInfoArray_AType
MsgRecInfoArray_AType
is an array
AType
element. This is an array of messages that can be
returned in a response.
Contains:
MsgRec_CType
MsgRec_CType
MsgRec_CType
is a complex
CType
element.
Simple Elements
The following simple elements are contained within this complex.
- ErrCat
- The Soap Header Fault error category.
- ErrCode
- The Soap Header Fault error code.
- ErrDesc
- The Soap Header Fault error description.
- ErrElem
- The Soap Header Fault when an error or fault occurs. This optional element contains the element which is causing the error condition.
- ErrElemVal
- The Soap Header Fault when an error or fault occurs. This optional element contains the value of the element which is causing the error condition.
- ErrLoc
- The Soap Header Fault error location. This is typically the program that generated the error condition.