Payment
Money received from or paid back to a customer for a sales order, sales invoice, sales invoice correction or sales credit note.
PaymentFields
The ID of the payment.
What the payment stands for. Known values: REGULAR, DUNNING_FEE_PAYMENT, CASH_DISCOUNT, VOUCHER_REDEMPTION. Treat unknown values as unknown.
Whether money came in or went out; follows from the sign of 'amount'.
The amount with two decimals: positive for money received, negative for money paid back.
The currency of the amount (ISO 4217): the currency of the document the payment counts for.
The date of the payment. Can be empty for old records that were imported without one.
The payment method. Can be empty for old records that were imported without one.
The kind of sales document the payment counts for. Known values: SALES_ORDER, SALES_INVOICE, SALES_INVOICE_CORRECTION, SALES_CREDIT_NOTE.
The sales order of the payment. Also set for most payments of its invoices and corrections; never for credit notes.
The sales invoice the payment counts for; for a payment of an invoice correction, the corrected invoice when it is known.
The sales invoice correction the payment counts for. Never a sales credit note.
The sales credit note the payment counts for. Only payouts count for one; when it is cancelled, they leave QueryPayments.
The ID of the transaction at the payment provider, the marketplace or the bank, as it was delivered. For some shop orders it holds the payment note of the shop instead.
A free note.
Whether the payment is a down payment. A label for accounting; it does not change how the payment counts.
The general ledger account the payment is posted to in the accounting export.
Whether the payment is left out of the accounting export.
The payment transaction (bank, payment provider or marketplace) the payment was created from or matched with.
The refund that booked this payment.
The user who recorded the payment.
Was this page helpful?