CustomerPaymentsInvoices

Get invoices related to 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.
AllowPartialPayments	Boolean		Whether partial payments are allowed.
ApplyDate	Date		Apply date.
Balance	Double		Balance.
BranchId	Long		ID of the branch.
DiscountAmount	Double		Discount amount.
DueDate	Date		Due date.
InvoicePaymentId	Long		ID of the invoice payment.
LocationId	Long		ID of the location.
PricePrecision	Integer		Price precision.
TaxAmountWithheld	Double		Tax amount withheld.
Total	Double		Total.
BranchName	String		Name of the branch.
Installments	String		Installments.
InvoiceCustomerId	Long		ID of the invoice customer.
InvoiceCustomerName	String		Name of the invoice customer.
InvoiceInstallments	String		Invoice installments.
IsEarlyPaymentDiscountApplicable	Boolean		Whether early payment discount is applicable.
LocationName	String		Name of the location.

Excel Add-In for Zoho Inventory

CustomerPaymentsInvoices

Table Specific Information

Select

Columns