Daily Transaction Report (Reconciliation)

post

https://api.fiuu.com/RMS/API/PSQ/psq-daily.php

PG Daily Transaction Report provides merchant end-of-day (EoD) reconciliation or to verify all transactions for a specific date.

Formula of skey

skey = md5({rdate}{merchantID}{secret_key})

Response

(plain text with newline & TAB characters)

Variable / Parameter	Type Format / Max Length	Description / Example
BillingDate	date/time (YYYY-MM-DD HH:mm:ss)	Transaction date/time
OrderID	alphanumeric, 40 chars	Invoice or order number from merchant system.
TranID	integer, 20 digits	Unique transaction ID for tracking purpose.
Channel	Predefined string in PG system	Channel references for the merchant system.
Amount	2 decimal points numeric value	The payment amount
StatCode	string of 2-digit numeric	00 = Success, 11 = Failure, 22 = Pending
StatName	word	Success: captured, settled, authorized, Failure: failed, cancelled, chargeback, release, reject/hold, blocked, ReqCancel, ReqChargeback, Pending: Pending, Unknown
BillingName	alphanumeric, 128 chars	Buyer full name
ServiceItem	text	Billing Information / Description (newline will be replaced by whitespace)
Additional fields: BillingEmail, TransactionRate, TransactionCost, BillingMobileNumber, TransactionFee, GST, NetAmount, IPAddress, BankName, ExpiryDate, StatusDescription, SettlementDate, PaidDate, TerminalID, PayTransactionID, BuyerName	text (default) or JSON string	BillingEmail = [email protected], TransactionRate = 0.0290, TransactionCost = 0.0000, BillingMobileNumber = 0123456789, TransactionFee = 100.0, GST = 0, NetAmount = 1900.0, IPAddress = 192.168.0.1, BankName = unknownbank, ExpiryDate = 2020, StatusDescription = This is status description, SettlementDate = 2020-05-26 10:51:51, PaidDate = 2020-05-31 10:51:51, TerminalID = 999

Query Params

merchantID

string

required

Merchant ID in PG system. alphanumeric, 32 chars.

skey

string

required

This is the data integrity protection hash string. 32 chars hexadecimal string

rdate

date-time

required

date (YYYY-MM-DD) or date(YYYY-MM-DD HH:ii:ss). The date or beginning time of transactions to query 2020-10-10 or 2020-10-10 07:11:24

rduration

string

optional, second in numeric. Without rduration, the search duration is 24 hours or 86400 seconds starting from rdate

status

string

optional, alphanumeric, 32 chars. 00 - success, 11 - failed, 22 - pending, Combine with delimiter "|" for multiple status or left empty for all status

version

string

version. 2.0, 3.0, or latest is 4.0

additional_fields [New from Version 2]

string

optional, predefined tags. BillingEmail - billing email, TransactionRate - transaction rate, BillingInfo - billing info, TransactionCost - transaction cost, Channel - channel, BillingMobileNumber - billing mobile, TransactionFee - transaction fee, GST - GST (tax), NetAmount - net amount, IPAddress - IP address, BankName - bank name, BIN - card no (hidden), ExpiryDate - card expiry date, StatusDescription - status description, SettlementDate - settlement date, PaidDate - paid date, TerminalID - terminal ID, PayTransactionID - transaction ID, BuyerName - buyer name, CaptureRefID - Capture Reference ID (Only in v3), RefundRefID - Refund Reference ID (Only in v3), AcquirerName - Acquiring bank or processor name (For gateway solution merchant only), CardScheme - Card brand (VISA, MASTERCARD), CardType - Card type (GOLD, PLATINUM), CardCountry - Country name from the user's card, all - for all additional fields, Combine with delimiter "," for multiple fields

response_type [New from Version 2]

string

optional. Response format in either text/json/csv(only in v2 and v3)

page

string

optional. The total page number with 5000 records per page

Response

Formula of skey

Response

200