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 |
|---|---|---|
| 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 |
| to_wallet_operator_name | STRING | Operator name for the owner of the destination wallet |
| to_wallet_vat_number | STRING | Destination wallet vat number |
| 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 |
| from_wallet_operator_name | STRING | Operator name for the owner of the source wallet |
| from_wallet_vat_number | STRING | Source wallet vat number |
| 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_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 |
| note | VARCHAR | Transaction note |
| exchange_rate | FLOAT | Transaction exchange rate |
| metadata_id | INTEGER | id field of the metadata. Can be tax_refund or charge id, see metadata_type |
| metadata_kwh | FLOAT | KWH charged in the charge or KWH attributed to the tax_refund, see metadata_type |
| metadata_type | VARCHAR | One of tax-refund-metadata or charge-metadata |
| metadata_charge_id | INTEGER | The charge_id corresponding to the tax_refund. Only set if metadata_type is tax-refund-metadata |
Updated 4 months ago