The points transaction model includes details of all events that resulted in points balance accrual or deducation for a given user.

SFTP Exports

Sample points_transactions.csv

Thanx Connex

Table name: points_transactions

Attributes

ColumnData TypeDescription
points_transaction_idstringThe unique identifier of the points transaction in Thanx. This includes any action that results in a change of points balance, e.g. earning or redeeming points.
points_transaction_uidstringThe unique identifier for the points transaction in Thanx APIs.
merchant_idstringThe unique identifier of the merchant in Thanx.
user_idstringThe unique identifier of the user in Thanx.
debit_account_idstringThe unique identifier of the account where the points balance increased after the transaction.
credit_account_idstringThe unique identifier of the account where the points balance is reduced after the transaction.
source_idstringThe unique identifier of the source of the transaction. Use this ID to find the source of the transaction in the report mentioned in SOURCE_TYPE.
source_typestringThe source of the transaction. If it is empty when the reason is set to Third-party provisions. It indicates which report has the corresponding entry (use the ID in SOURCE_ID to find the specific entry in the report mentioned as SOURCE_TYPE). (points transaction, program, purchase, reward, user)
points_transaction_typestringThe type of points transaction.
exchange - User exchanged points for rewards.
issued - User got points for a qualifying action (e.g., placing a purchase).
reverse - User’s transaction was reversed (e.g., Clawbacks, Refunds).
adjust - If a user’s balance falls below 0, it is adjusted until it is 0 since the user cannot have a negative balance.
import - Merchant uploaded a balance (e.g., to apply progress from a previous program during transition).
expire - Points expired.
reasonstringThe reason for the transaction to be created. (account disabled, clawback, expiration, migration, program, purchase, refund / cancellation, reward, third-party provision)
amountnumberThe number of points in the points transaction.
created_attimestampThe date and time the points transaction was created. This is in UTC.