PApaymentology
Credit account status

Get Credit Transaction List

Changed on

This web service gets the transaction details for credit accounts based on filter provided

post/pws/pws_cr_get_transaction_list/

Request

  • Base URL
    https://api.uat.paymentology.com/ppws/api
  • URL
    https://api.uat.paymentology.com/ppws/api/pws/pws_cr_get_transaction_list/
  • Auth
    none declared

Request body

api_call_unique_identifierstring required

Unique number that must be passed at each API request. Identifier to make each API request unique

client_idinteger required

Unique identifier for the client which Paymentology will provide at outset

date_fromstring required

From Date,accepted format yyyy-mm-dd hh:mm:ss.

date_tostring required

To Date,accepted format yyyy-mm-dd hh:mm:ss.

txn_type_liststring required
<p>transaction Type value can be accepted in Comma separated form. Following are the type that can be accepted:</p> <br /><ul> <li class="docBullet"> Au = Authorization.</li><li class="docBullet">Ad = Advisement.</li><li class="docBullet">Re = Reversals.</li><li class="docBullet">Se = Settlement.</li><li class="docBullet">Cb = Chargeback.</li><li class="docBullet">Lo = Load.</li><li class="docBullet">Un = UnLoad.</li><li class="docBullet">Ra = Rules Applied.</li><li class="docBullet">Fe = Fee Applied.</li><li class="docBullet">It = Interest Applied.</li><li class="docBullet">Rw = Reward Applied.</li><li class="docBullet">Fc = Financial Adjustment Credit.</li><li class="docBullet">Fd = Financial Adjustment Debit.</li><li class="docBullet">Ip = Installment Principal.</li></ul>
user_idstring

User Id of the Customer who triggered the API request.

remarksstring

Remarks for API request

t_status_liststring

transaction status. Value can be accepted in comma separated. Following are the list of values that can be accepted:

<ul> <li class="docBullet">1 = Normal Spend-Approved (not Settled)</li> <li class="docBullet">2 = Normal Spend-Declined </li> <li class="docBullet">3 = Normal Spend-Approved then Reversed</li> <li class="docBullet">4 = Zero Amt Auth (bal/pin change etc)-Approved</li> <li class="docBullet">5 = Zero Amt Auth (bal/pin change etc)-Declined</li> <li class="docBullet">10 = Normal Spend-Declined then Partial Reversal</li> <li class="docBullet">11 = Normal Spend-Approved then Partial Reversal</li> <li class="docBullet">12 = Normal Partial Spend-Approved not Settled</li> <li class="docBullet">14 = Normal Spend-Approved then Unblocked</li> <li class="docBullet">15 = Normal Spend-Approved then Unblocked Failed</li> <li class="docBullet">16 = Normal Spend-Approved then Advisement</li> <li class="docBullet">17 = ATM Approved & Settled</li> <li class="docBullet">18 = ATM -Declined</li> <li class="docBullet">19 = Normal Spend - Declined then Advisement</li> <li class="docBullet">20 = Reversal-Manual unblock (Paymentology generated)</li> <li class="docBullet">21 = Reversal-Auto Unblock (Paymentology generated)</li> <li class="docBullet">24 = Reversal-Scheme delivered-Approved</li> <li class="docBullet">25 = Reversal-Scheme delivered-Declined</li> <li class="docBullet">26 = Reversal-Partial- Scheme delivered-Approved</li> <li class="docBullet">30 = Advisement-Approved Spend, preceeding spend exists (Balance impacting)</li> <li class="docBullet">31 = Advisement-Approved Spend (Not balance impacting)</li> <li class="docBullet">32 = Advisement-Approved Spend, No preceeding spend (balance impacting)</li> <li class="docBullet">35 = Advisement-Reversal (0420), preceeding spend exists (Balance impacting)</li> <li class="docBullet">36 = Advisement-Reversal (0420), No preceeding spend (Not balance impacting)</li> <li class="docBullet">37 = Reversal-Manual unblock (Paymentology generated)</li> <li class="docBullet">38 = Reversal-Auto Unblock (Paymentology generated)</li> <li class="docBullet">501 = Normal Spend-Approved-Now Settled</li> <li class="docBullet">502 = Normal Spend-Declined-Now Settled</li> <li class="docBullet">503 = Normal Spend-Approved then Reversed-Now Settled</li> <li class="docBullet">504 = Zero Amt Auth (bal/pin change etc)-Approved-Now Settled</li> <li class="docBullet">505 = Zero Amt Auth (bal/pin change etc)-Declined-Now Settled</li> <li class="docBullet">510 = Normal Spend-Declined then Partial Reversal-Now Settled</li> <li class="docBullet">511 = Normal Spend-Approved then Partial Reversal-Now Settled</li> <li class="docBullet">524 = Reversal-Scheme delivered-Approved-Now Settled</li> <li class="docBullet">525 = Reversal-Scheme delivered-Declined-Now Settled</li> <li class="docBullet">530 = Advisement-Approved Spend, preceeding spend exists (Balance impacting)-Now Settled</li> <li class="docBullet">531 = Advisement-Declined Spend (Not balance impacting)-Now Settled</li> <li class="docBullet">532 = Advisement-Approved Spend, No preceeding spend (balance impacting)-Now Settled</li> <li class="docBullet">535 = Advisement-Reversal (0420), preceeding spend exists (Balance impacting)-Now Settled</li> <li class="docBullet">536 = Advisement-Reversal (0420), No preceeding spend (Not balance impacting)-Now Settled</li> <li class="docBullet">1000 = Settlement-No preceeding spend</li> <li class="docBullet">1001 = Settlement-Full match to spend</li> <li class="docBullet">1002 = Settlement-Partial match to spend</li> <li class="docBullet">1005 = Settlement-Auth had been declined</li> <li class="docBullet">1006 = Settlment-Advisement had been declined</li> <li class="docBullet">1007 = Settlement-No auth, just reversal received</li> <li class="docBullet">1010 = Settlement reversed by a settlement reversal</li> <li class="docBullet">1011 = Settlement reversal (reversed a preceeding settlement)</li> <li class="docBullet">1012 = Settlement reversal (No preceeding settlemnt found)</li> <li class="docBullet">1030 = Load-Settled</li> <li class="docBullet">1031 = Unload-Settled</li> <li class="docBullet">1035 = Balance transfer (out) Settled</li> <li class="docBullet">5100 = Authorization Fee</li> <li class="docBullet">5101 = Periodic Fee</li> <li class="docBullet">5102 = System Fee</li> <li class="docBullet">5103 = Over-Limit Fee</li> <li class="docBullet">5104 = Late Payment Fee</li> <li class="docBullet">5106 = Currency Conversion Fee</li> <li class="docBullet">5107 = Dormancy Fee</li> <li class="docBullet">5108 = Miscellaneous Fee </li> <li class="docBullet">5109 = Miscellaneous Fee Rebate</li> <li class="docBullet">5200 = Interest</li> <li class="docBullet">5300 = Installment</li> <li class="docBullet">5301 = Regular-to-Installment</li> <li class="docBullet">5302 = Installments-to-Regular</li> <li class="docBullet">5400 = Rewards Granted</li> <li class="docBullet">5401 = Rewards Reversed</li> <li class="docBullet">5500 = Murahaba Markup</li> <li class="docBullet">5600 = Financial Adjustment</li> <li class="docBullet">5601 = Financial Adjustment Credit</li> <li class="docBullet">5601 = Financial Adjustment Debit</li> <li class="docBullet">5700 = Tax</li> <li class="docBullet">5701 = Tax on Fees</li> </ul>
spend_type_liststring
<p>transaction spend type comma separated values accepted</p> <ul> <li class="docBullet">00 = Normal Purchase DE3_1</li> <li class="docBullet">01 = ATM Withdrawal DE3_1</li> <li class="docBullet">09 = Purchase with Cashback DE3_1</li> <li class="docBullet">17 = Cash Disbursement DE3_1</li> <li class="docBullet">20 = Purchase Refund DE3_1</li> <li class="docBullet">28 = Payment transaction(Credit) DE3_1</li> <li class="docBullet">30 = Balance Enquiry DE3_</li> <li class="docBullet">40 = account Transfer DE3_1</li> <li class="docBullet">91 = pin Unblock DE3_1</li> <li class="docBullet">92 = pin Change DE3_1</li> <li class="docBullet">93 = card on file Token Processing DE3_1</li> </ul>
tokeninteger

Public token for the card

ac_idinteger

Account Id

txn_idinteger

transaction id. If provided retrieves back the transaction data for specific transaction only

Example request

{
  "api_call_unique_identifier": "438574845790657485",
  "client_id": 760131,
  "date_from": "2020-01-24 13:13:08",
  "date_to": "2020-10-25 13:13:08",
  "txn_type_list": "Au,Ad,Se,Lo,It,Rw",
  "t_status_list": "1,2",
  "spend_type_list": "00,01,09,20",
  "token": 311012081,
  "ac_id": 632304584
}

Response

Successful Response

Example response

{
  "header": {
    "error_desc": "success"
  },
  "body": [
    {
      "id": 119649,
      "type": "Authorisation",
      "token": 336869349,
      "source": "MARKET PLACE BY JASONS",
      "country": "HKG",
      "city": "CENTRAL",
      "note": "CVV Type Passed",
      "claimid": "1234",
      "chargebackid": 1234,
      "txn_id": "115858012345000010",
      "txn_status": "Approved (not Settled)",
      "proc_code": 5200,
      "central_date": "2020-03-04 12:47:14.315044+00",
      "local_date": "2020-03-04 20:47:11",
      "loc_ccy": "HKD HKD-$",
      "loc_amt": -3758.21,
      "bill_ccy": "HKD HKD-$",
      "bill_amt": -3758.21,
      "settle_bal": -2494.13,
      "block_amount": -288,
      "avl_bal": -2782.13,
      "advanced_detail": "DE39=00: Cvv Type:4 Rslt:1  ARQC:1: soh 78 ",
      "prod_name": "Credit Product",
      "product_type": 30,
      "txn_stat_id": 1,
      "txn_type": 100,
      "ac_id": 749153081,
      "tc_id": 10450,
      "rsn_code": "00",
      "additional_data": "DE39=00",
      "contract_eligible_status": 1,
      "contract_eligible": [
        1,
        2,
        3
      ],
      "client_id": 123456,
      "type_detail": "Interest",
      "fee_title": "miscellaneous fee",
      "fee_description": "miscellaneous fee 1",
      "external_fee_reference_id": "fee123",
      "external_fee_reference_description": "externalfee123",
      "external_txn_reference_id": "1234",
      "txn_code": "CreditPay",
      "txn_code_description": "Pay Transaction Code"
    }
  ]
}

Changes