InvoicePayments
Get the list of payments made for an invoice.
Table Specific Information
Select
The connector uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:
- InvoiceId supports the '=' comparison.
The rest of the filter is executed client-side in the connector.
For example:
SELECT * FROM InvoicePayments WHERE InvoiceId = '1864543000000078539'
Columns
| Name | Type | References | SupportedOperators | Description |
| InvoicePaymentId [KEY] | String | Id of an invoice payment. | ||
| InvoiceId | String |
Invoices.InvoiceId | Id of an invoice. | |
| PaymentId | String | Id of payment. | ||
| PaymentNumber | String | 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. |