iby_trxn_summaries_all.status & TRXNTYPEID

The table below contains the different statuses of transactions .Here is the meaning for them.

iby_trxn_summaries_all.status

SUCCESS 0

ERROR
1, Communication error
2, Duplicate request, order id
3, Duplicate batch id
4, Mandatory fields required or missing
5, Payment system specific error
6, Batch partially succeeded
7, Batch failed
8, Request action not supported
14, Request cancelled
15, Failed to schedule
16, Payment system failed
17, Unable to pay (insufficient funds)
19, Invalid Credit Card number
20, Declined
21, Failed (requires voice auth)
101, Trxn was sent in a batch that resulted in communication error
114, Trxn was cancelled in an open batch (void)
120, iPayment max number of batches exceeded for the day
-99, Invalid request

Value data-source is IBY_TRXN_SUMMARIES_ALL.TRXNTYPEID

• 2 (Auth only)
• 3 (Auth capture)
• 5 (Return)
• 8/9 (Capture/Settlement)
• 11 (Credit)
  
  

References:
http://sairamgoudmalla.blogspot.com/2014/05/ibytrxnsummariesallstatus.html