Transactions
This table store unique transaction records.
Transactions occur either to or from a team under your operator. The to_wallet_owner_id specifies the recipient of the transaction, while from_wallet_owner_id denotes the sender. Transactions are connected to charges through the reference_id, given that reference_type == CHARGE.
| Name | Data Type | Description |
|---|---|---|
| transaction_id | INTEGER | Unique ID of the transaction |
| to_wallet_id | INTEGER | Identifier of the wallet in which the deposit was made |
| to_wallet_owner_id | INTEGER | Identifier of the wallet owner to whom the deposit was made |
| to_wallet_owner_type | STRING | Destination wallet owner type |
| from_wallet_owner_id | INTEGER | Identifier of the wallet owner from whom the deposit originated |
| from_wallet_id | INTEGER | Identifier of the wallet from which the deposit was made |
| from_wallet_owner_type | STRING | Source wallet owner type |
| performed_by_user_id | INTEGER | Identifier of the user who performed the transaction |
| reference_id | INTEGER | Extra field for at will data storage |
| completed_at | TIMESTAMP | Date and time when the transaction was completed |
| pending_at | TIMESTAMP | Transaction pending date. |
| failed_at | TIMESTAMP | Transaction failed date |
| updated_at | TIMESTAMP | Date transaction updated |
| created_at | TIMESTAMP | Date and time when the transaction was created |
| kind | STRING | Transaction Kind |
| transaction_country | STRING | The country where transaction took place |
| to_currency_rate_eur | FLOAT | Conversion rate to Euro for destination currency |
| from_currency_rate_eur | FLOAT | Conversion rate to Euro for source currency |
| to_currency_code | STRING | Code of destination currency |
| from_currency_code | STRING | Code of source currency |
| to_amount | FLOAT | Desitination actual amount |
| to_sub_amount | FLOAT | Destination subsidiary amount |
| vat_to_amount | FLOAT | Destination vat amount |
| from_amount | FLOAT | Source actual amount |
| from_sub_amount | FLOAT | Source subsidiary amount |
| vat_from_amount | FLOAT | Source vat amount |
| failed_reason | STRING | Reason transaction failed |
| vat_percentage | FLOAT | Value added tax percentage |
| state | STRING | Transaction state |
| type | STRING | Transaction type: • Deposit (deposit is in the monta wallet) • Withdrawal (withdrawal is from monta wallet) • Internal (both deposit and withdrawal happens in a monta wallet) |
| reference_type | INTEGER | The type of transaction |
Updated 19 days ago