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 | TYPE | 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 |