How do I match records in the transaction report one-to-one with orders in our system?
We recommend matching in the following order of priority:
- order_id — the primary matching field for most transaction types
- qrph_reference — for QR Ph transactions; coins_order_id / internal_order_id — for QR Ph P2M collections settled through Coins P2P
- invoice_id — for Invoice-type transactions
-
payment_order_id — for reconciliation by payment channel (Note: for the INSTAPAY channel, only the last 6 digits of this field are shown)
We also recommend cross-checking fields such as transaction_type, created_at/bf_created_at, and amount/balance_changed to improve matching accuracy.
What are the sub_uid / sub_merchant_name fields?
If your main account has multiple sub-merchant (tenant) structures configured, these two fields identify the sub-merchant ID and name that a given transaction belongs to; currently only Fiat and Invoice related transactions populate this information. If you do not use a sub-merchant structure, these two fields will be empty, which is expected.