CustomerPaymentsInvoices
Get Invoices of Customer Payments.
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.
- 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. |