Transaction Search
Search for transactions based on parameters
{
"Query": "(A=-1)&&(B=-1)&&(C>='4/13/2023')&&(C<'4/29/2023')"
}{
"Transaction_QueryResult": {
"ErrCode": 0,
"ErrMsg": "",
"FunctionOk": true,
"NumRecords": 5,
"RespMsg": "Successfully Returned Transaction Records : 5",
"Transactions": [
{
"ACCT_FIRST_NAME": "Sean",
"ACCT_LAST_NAME": "Wood",
"ACCT_NO": "4788XXXXXXXX8291",
"AMOUNT": 10,
"AVSr": "Y",
"AcctHolderID": 3,
"BatchLogID": 0,
"BatchNO": 0,
"BatchStatus": "N",
"CARD_TYPE": "VI",
"CASHBACK": 0,
"CVVr": "",
"CardPresent": true,
"ConsentID": 0,
"CreatedOn": "2024-12-01T11:19:01.000Z",
"Credits": 0,
"EMVPresent": false,
"EMVRecTags": "",
"EXP_DATE": "1028",
"EndCustID": 44,
"Flags": "",
"HAuthorizedAmount": -1,
"ID": 44,
"IsLocked": false,
"IsPartialApproval": false,
"LAST_CHANGED_BY": "vidya_Venkatraman",
"LastChangedOn": "2024-12-01T11:19:01.000Z",
"MerchID": 1,
"Origin": "API",
"PAYMENT_TYPE": "C",
"PartialAuthApproved": -1,
"PreAuthID": 0,
"PrepaidBalance": -1,
"REF_ID": "A97689#",
"RPGUID": "adf98580-b4ab-42fc-bb99-01c89964afe9",
"RefTxID": 0,
"SALE_TAX": 0,
"SEQ_NO": 51,
"SERVER": "",
"SURCHARGE": 0,
"TIP": 0,
"TXN_CODE": 92682,
"TXN_DATE": 42419,
"TXN_DATETIME": "2024-12-01T11:19:01.000Z",
"TXN_TIME": 82544,
"TxLOCK": "7A639CD720CE4B14",
"TxSTATUS": "OPEN",
"TxType": "CCSALE",
"UserID": 2547
}
]
}
}Last updated
Was this helpful?