CustomerPaymentsInvoices
Get Invoices of Customer Payments.
Table Specific Information
Select
The connector 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 connector.
- InvoiceId supports the '=' comparison.
- CustomerPaymentId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM CustomerPaymentsInvoices WHERE InvoiceId = '3350895000000089001' SELECT * FROM CustomerPaymentsInvoices WHERE CustomerPaymentId = '4534543100'
Columns
| Name | Type | References | Description |
| CustomerPaymentId | String | Unique ID of the payment generated by the server. | |
| AmountApplied | Integer | Amount paid for the invoice. | |
| BalanceAmount | Integer | Unpaid amount of the invoice. | |
| Date | Date | Date on which the invoice was raised. | |
| InvoiceAmount | Integer | Total amount raised for the invoice. | |
| InvoiceId | String | Invoice ID of the required invoice. | |
| InvoiceNumber | String | Unique ID (starts with INV) of an invoice. |