Retrieves invoices related to customer payments.

Table Specific Information

Select

The driver 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 driver.

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