Retrieves invoices related to customer payments.

Table Specific Information

Select

The 本製品 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 本製品.

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.