Payin Transaction Detail Report ​

Purpose

Displays all completed Payin transactions for the merchant within the specified date range. Suitable for reconciling daily incoming transactions and identifying anomalies.

Filter Criteria

Filtered by Txn Complete Time(transaction completion time).

Report Template

Merchant ID_payin.xlsx

Report Example

Field Name	Field Label	Description	Example 1	Example 2	Enum / Notes
AppID	Application ID	Unique identifier for the merchant application on the platform.	b1de8a8f728840739fcb7ab49b02f4cd	f65bdb49d4924fb399e341559b02dca6
Txn Create Time	Transaction Created Time	Timestamp when the user submitted the transaction request.	31:00.0	40:00.0
Txn Complete Time	Transaction Completion Time	Timestamp when the transaction reaches a final status.	32:00.0	57:00.0
User ID	User ID	Internal identifier for the user who initiated the transaction.	341678574	234541234
Transaction Type	Transaction Type	Indicates the type of transaction. See enum values.	PAYMENT	REFUND	PAYMENT: Payin REFUND: Refund PAY_LINK: Payment Link SUBSCRIPTION: Subscription CHARGE_BACK: Dispute CHARGE_BACK_ASSIST: Dispute Assist COLLECTION: VA Collection ADJUSTMENT_INCREASE: Balance Adjustment + ADJUSTMENT_DECREASE: Balance Adjustment -
OriginalMerchant Txn ID	Original Merchant Txn ID	Original transaction ID submitted by the merchant (e.g. for refund tracking).	3c19e61450645ec4b1a11115518195
Merchant Txn ID	Merchant Transaction ID	Unique transaction ID defined by the merchant.	3c19e61450645ec4b1a11115518195	3c19e07427642abf078f47ac51c1ca
Trade Order ID	Checus Transaction ID	Unique transaction ID generated by Checus.	TOKEN20230512228823425324	O20230505034046314647849721
Txn Status	Transaction Status	Status of the transaction, such as success or failure.	FAILED	CB Request	SUCCESS: Success FAILED: Failure CLOSED: Closed CB Request: Dispute Frozen CB Reversed: Dispute Reversed
Country	Country	Country where the transaction was initiated.	SA	QA
Txn Amount	Transaction Amount	Original amount paid by the user to the merchant.	7	100
Txn Currency	Transaction Currency	-	SAR	QAR
Payment Amount	Paid Amount	Actual amount paid by the user.	7
Payment Currency	Paid Currency	-	SAR
Payment Method Type	Payment Method Type	Type of payment method, such as card, bank transfer, etc.	CARD	CARD
Payment Method	Payment Method	Specific payment method used (e.g. Visa, Mastercard).	MADA	NAPS
Target Org / Card Org	Target Org / Card Scheme	Target institution or card scheme.	MADA	NAPS
Txn Fee	Transaction Fee	Total fee charged for the transaction. Txn Fee = Rate Fee + Fixed Fee	-1	-36.61
Txn Fee Currency	Fee Currency	-	SAR	QAR
Rate Fee	Rate-based Fee	Percentage-based fee calculated from the transaction amount.	0	0
Fixed Fee	Fixed Fee	Flat fee charged per transaction.	-1	-36.61
Txn Tax	Platform Withholding Tax	Tax amount withheld by the platform.	-0.2
Txn Tax Currency	Tax Currency	-	SAR	QAR
Merchant Txn Tax	Merchant Withholding Tax	Tax amount withheld and remitted on behalf of the merchant.	-0.3
Merchant Txn Tax Currency	Merchant Tax Currency	Currency of the merchant withholding tax.	SAR
Merchant Txn Tax Rate	Merchant Tax Rate	Tax rate used for calculating the merchant withholding tax.
Net Amount	Net Settlement Amount	Net amount to be settled to the merchant. Net = Txn Amount + Fee + Tax + Merchant Tax	5.5	-136.61
Net Currency	Net Currency	-	SAR	QAR
Failure Reason	Failure Reason	Reason for transaction failure, such as “Card declined”, “Insufficient funds”, etc.	Payment was not completed on time.
Trade Description	Transaction Description	Description provided by the merchant; may be shown to the end user.	subject
Reference	Reference	Custom metadata passed by the merchant.	This is reference
Exchange Rate	Settlement Exchange Rate Reserved	Reserved field for exchange rate (used in settlement calculation).
Exchange Rate Time	Exchange Rate Time Reserved	Reserved field indicating when the exchange rate was effective.
Exchange Type	Exchange Type	Reserved Reserved field indicating exchange rate mechanism (e.g. real-time).
Fields to be added	Reserved Fields Reserved	Reserved for new business use cases.