tm.payment

A payment can either be an incoming payment when a customer pays for an order, or an outgoing payment when a refund is issued. A payment is always linked to an order

Fields

Field	Description
id int	ID
paidts timestamp	Timestamp of the actual payment
orderid int	Link to the order References: tm.order
paymentmethodid int	Payment method used for this payment References: tm.paymentmethod
amount decimal	Payment amount. Can be positive (incoming payment) or negative (outgoing payment)
userid int	User that received the payment or performed the refund
vouchercodeid int	The id of the vouchercode that is linked to this payment
properties text	Properties of this payment, the contents of this column is dependent on PSP
subpayments text	Sub-payments of this payment, if applicable