Get the list of payments made for an invoice.
Table Specific Information
The connector will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.
- InvoiceId supports the '=' comparison.
SELECT * FROM InvoicePayments WHERE InvoiceId = '1864543000000078539'
|InvoicePaymentId [KEY]||String||ID of an invoice payment.|
|ID of an invoice.|
|PaymentId||String||ID of payment.|
|PaymentNumber||Integer||Number through which payment is made.|
|PaymentMode||String||Mode through which payment is made.|
|Description||String||Description of the invoice payment.|
|Date||Date||Date of an invoice payment.|
|ReferenceNumber||String||Reference number of an invoice payment.|
|ExchangeRate||Decimal||Exchange rate provided for this invoice.|
|Amount||Decimal||Amount of the invoice payments.|
|TaxAmountWithheld||Decimal||Amount withheld for tax.|
|OnlineTransactionId||String||ID of online transaction.|
|IsSingleInvoicePayment||Boolean||Check if the invoice is single invoice payment.|