SFTP Exports
Sample
points_transactions.csvThanx Connex
Table name:
points_transactionsAttributes
| Column | Data Type | Description |
|---|---|---|
points_transaction_id | string | The 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_uid | string | The unique identifier for the points transaction in Thanx APIs. |
merchant_id | string | The unique identifier of the merchant in Thanx. |
user_id | string | The unique identifier of the user in Thanx. |
debit_account_id | string | The unique identifier of the account where the points balance increased after the transaction. |
credit_account_id | string | The unique identifier of the account where the points balance is reduced after the transaction. |
source_id | string | The 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_type | string | The 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_type | string | The 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. | ||
reason | string | The reason for the transaction to be created. (account disabled, clawback, expiration, migration, program, purchase, refund / cancellation, reward, third-party provision) |
amount | number | The number of points in the points transaction. |
created_at | timestamp | The date and time the points transaction was created. This is in UTC. |