ProjectInvoices

Retrieves list of invoices created for a project.

Table Specific Information

The add-in uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:

The rest of the filter is executed client-side in the add-in.

For example:

    SELECT * FROM ProjectInvoices WHERE ProjectId = '1894553000000012367'


Name	Type	References	SupportedOperators	Description
InvoiceId [KEY]	String	Invoices.InvoiceId		Id of an invoice.
InvoiceNumber	String			Number of an invoice.
ProjectId	String	Projects.ProjectId		Id of a project.
Balance	Decimal			Total amount available in invoice.
CreatedTime	Datetime			Time at which the project invoice was created.
CustomerId	String	Contacts.ContactId		Id of the customer or vendor.
CustomerName	String			Name of the customer or vendor.
Date	Date			Date of project invoice.
DueDate	Date			Delivery date of the project invoice.
ReferenceNumber	String			Reference number of project invoice.
Status	String			Status of the project invoice.
Total	Decimal			Total of project invoices.