InvoicePayments
Get the list of payments made for an invoice.
Table Specific Information
Select
The {i 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 {i.
- InvoiceId supports the '=' comparison.
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 | 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. |