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 tm order docid jxcubxabuusuhkqcpean fields field type description id int id paidts timestamp timestamp of the actual payment orderid int link to the order references tm order docid jxcubxabuusuhkqcpean paymentmethodid int payment method used for this payment references tm paymentmethod docid\ fusfsbzbhwcivf 3dujoz 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