CustomerPaymentInvoices
Get invoices related to customer payments.
Table Specific Information
Select
The component uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:
- PaymentId supports the '=,IN' comparison.
The rest of the filter is executed client-side in the component.
For example:
SELECT * FROM CustomerpaymentInvoices where PaymentId = '3255827000000101040'
SELECT * FROM CustomerpaymentInvoices where PaymentId IN ('3255827000000101040','3255827000000102354')
Columns
| Name | Type | References | SupportedOperators | Description |
| InvoicePaymentId [KEY] | Long | Invoice PaymentId | ||
| InvoiceId | String |
Invoices.InvoiceId | Invoice Id | |
| PaymentId | String |
CustomerPayments.PaymentId | Customer Payment Id | |
| InvoiceCustomerId | Long | Invoice Customer Id | ||
| InvoiceCustomerName | String | Invoice Customer Name | ||
| AmountApplied | Integer | Amount applied to the Entity | ||
| Balance | Integer | The unpaid amount | ||
| DiscountAmount | Integer | Discount Amount | ||
| Date | Date | Date when invoice was created | ||
| Total | Integer | Total amount | ||
| InvoiceNumber | String | Invoice Number |