CustomerPaymentInvoices
Retrieves invoices related to customer payments.
Table Specific Information
Select
The connector uses the Zoho Books API to process WHERE clause conditions built with the PaymentId column, which supports '=,IN' comparisons.The rest of the filter is executed client-side in the connector.
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 | The Invoice PaymentId. | ||
InvoiceId | String |
Invoices.InvoiceId | The Invoice Id. | |
PaymentId | String |
CustomerPayments.PaymentId | The Customer Payment Id. | |
InvoiceCustomerId | Long | The Invoice Customer Id. | ||
InvoiceCustomerName | String | The Invoice Customer Name. | ||
AmountApplied | Integer | The Amount applied to the Entity. | ||
Balance | Integer | The unpaid amount. | ||
DiscountAmount | Integer | The Discount Amount. | ||
Date | Date | The Date when invoice was created. | ||
Total | Integer | The Total amount. | ||
InvoiceNumber | String | The Invoice Number. |