The table below explains the meaning of each column in the transaction report. Kindly note that not every field will have a value in every row. Some fields only apply to certain transaction types and is expected to show as empty (NULL) for transaction types where it does not apply.
| Field Name | Meaning | Notes |
|---|---|---|
| transaction_type | Transaction type | See Transaction Types |
| source_user_id | Originating Coins wallet user ID | Mainly used to identify the sender in scenarios such as P2P |
| target_user_id | Receiving / target Coins wallet user ID | Populated for Coins P2P (the recipient); for Convert and Spot Trade it repeats the same user ID, as those are self-transactions |
| order_id | Business order number | From the source business system; one of the primary fields used for reconciliation matching |
| internal_order_id | Internal / client reference number | Populated for Coins P2P (the client transfer reference, which carries the QR Ph P2M tag where applicable) and for certain fiat orders; useful as a supplementary matching field |
| coins_order_id | QR Ph P2M merchant collection order number | Only populated on Coins P2P records created by a QR Ph P2M merchant collection. QR Ph transactions that settle through fiat channels leave this empty — use qrph_reference for those |
| qrph_reference | QR Ph reference number (Request ID) | Populated for QR Ph related records on both sides: InstaPay QR / QR Ph fiat transactions (including Scan to Pay), and the Coins P2P leg of a QR Ph P2M collection |
| block_hash | Blockchain transaction hash | Only populated for on-chain deposit / withdrawal transactions |
| created_at | Order creation time | From the source business system |
| updated_at | Order update time | From the source business system |
| transaction_channel | Transaction channel | For example, INSTAPAY_QR, SWIFTPAY_BILL, SWIFTPAY_LOAD, COINS_WALLET, etc. |
| transaction_outlet | Transaction sub-category / product name | Varies by channel, e.g. bill-payment product name, airtime top-up category, etc. |
| payment_order_id | Payment order number | For INSTAPAY-related channels, only the last 6 digits are shown |
| network | Blockchain network | Only populated for on-chain transactions; shows the chain code, e.g. ETH, TRX, BTC, SOL |
| currency | Transaction currency | Fiat currency (e.g. PHP) or cryptocurrency code |
| amount | Transaction principal amount | Generally excludes fees; for certain types (Convert / Spot) the value matches balance_changed See Amounts, Fees, and Balance Changes |
| invoice_merchant_fee | Invoice transaction merchant fee | Only populated for Invoice-type transactions |
| fiat_platform_fee | Fiat transaction platform fee | Populated for fiat transactions, and for Invoice transactions paid through a fiat channel rather than wallet balance |
| blockchain_transaction_fee | On-chain transaction network fee / spot trading fee | Corresponds respectively to the miner fee for on-chain withdrawals, or the amount of the Spot Trade Fee record itself |
| status | Transaction status | The transaction report only includes records with the status Succeeded (SUCCEEDED) |
| invoice_id | Invoice ID | Only populated for Invoice-type transactions |
| sub_uid | Sub-merchant ID | Populated if a sub-merchant structure is configured under the account; otherwise empty |
| sub_merchant_name | Sub-merchant name | Same as above |
| bf_user_id | Coins wallet user ID the balance change belongs to | Indicates which account the balance change actually occurred under; where both sides of a transfer sit within your account structure, the same transaction appears once per side |
| balance_currency | Balance change currency | The currency corresponding to this balance change; the authoritative source for the currency field |
| balance_changed | Account balance change amount (signed) | Positive = inflow (credit), negative = outflow (debit); use this field as the authoritative reference for the direction of funds |
| running_balance | Account balance after the change | A snapshot of the account balance in that currency after this transaction’s credit / debit |
| bf_created_at | Balance change timestamp | Used to order the transaction report and to determine the data cutoff time |
| version | Balance change version number | Used to order multiple balance changes with the same timestamp; not something the business side needs to worry about |