InvoiceListPayments
List Payments of Invoices.
Table Specific Information
Select
The add-in will use the Zoho Inventory API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the add-in.
- InvoiceId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM InvoiceListPayments WHERE InvoiceId = '3350895000000089001'
Columns
| Name | Type | References | Description |
| Amount | Double | Amount | |
| Date | Date | Date | |
| Description | String | Description | |
| ExchangeRate | Integer | ExchangeRate | |
| InvoiceId | Long |
Invoices.Id | Invoice Id |
| InvoicePaymentId [KEY] | Long | Invoice Payment Id | |
| IsSingleInvoicePayment | Boolean | IsSingleInvoice Payment | |
| OnlineTransactionId | String | OnlineTransaction Id | |
| PaymentId | String | Payment Id | |
| PaymentMode | String | Payment Mode | |
| PaymentNumber | Integer | Payment Number | |
| ReferenceNumber | Integer | Reference Number | |
| TaxAmountWithheld | Integer | Tax Amount Withheld |