Transactions
This table store unique transaction records.
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 about 8 hours ago