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.

NameData TypeDescription
idINTEGERUnique ID of the transaction
to_wallet_idINTEGERIdentifier of the wallet in which the deposit was made
to_wallet_owner_idINTEGERIdentifier of the wallet owner to whom the deposit was made
to_wallet_owner_typeSTRINGDestination wallet owner type
to_wallet_operator_nameSTRINGOperator name for the owner of the destination wallet
to_wallet_vat_numberSTRINGDestination wallet vat number
from_wallet_owner_idINTEGERIdentifier of the wallet owner from whom the deposit originated
from_wallet_idINTEGERIdentifier of the wallet from which the deposit was made
from_wallet_owner_typeSTRINGSource wallet owner type
from_wallet_operator_nameSTRINGOperator name for the owner of the source wallet
from_wallet_vat_numberSTRINGSource wallet vat number
performed_by_user_idINTEGERIdentifier of the user who performed the transaction
reference_idINTEGERExtra field for at will data storage
completed_atTIMESTAMPDate and time when the transaction was completed
pending_atTIMESTAMPTransaction pending date.
failed_atTIMESTAMPTransaction failed date
updated_atTIMESTAMPDate transaction updated
created_atTIMESTAMPDate and time when the transaction was created
kindSTRINGTransaction Kind
transaction_countrySTRINGThe country where transaction took place
to_currency_codeSTRINGCode of destination currency
from_currency_codeSTRINGCode of source currency
to_amountFLOATDesitination actual amount
to_sub_amountFLOATDestination subsidiary amount
vat_to_amountFLOATDestination vat amount
from_amountFLOATSource actual amount
from_sub_amountFLOATSource subsidiary amount
vat_from_amountFLOATSource vat amount
failed_reasonSTRINGReason transaction failed
vat_percentageFLOATValue added tax percentage
stateSTRINGTransaction state
typeSTRINGTransaction 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_typeINTEGERThe type of transaction
noteVARCHARTransaction note
exchange_rateFLOATTransaction exchange rate
metadata_idINTEGERid field of the metadata. Can be tax_refund or charge id, see metadata_type
metadata_kwhFLOATKWH charged in the charge or KWH attributed to the tax_refund, see metadata_type
metadata_typeVARCHAROne of tax-refund-metadata or charge-metadata
metadata_charge_idINTEGERThe charge_id corresponding to the tax_refund. Only set if metadata_type is tax-refund-metadata