InvoicePayments
Get the list of payments made for an invoice.
Table Specific Information
Select
The add-in 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 add-in.
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. |