Retrieves list of invoices created for a project.
Table Specific Information
The connector will use 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 within the connector.
- ProjectId supports the '=' comparison.
SELECT * FROM ProjectInvoices WHERE ProjectId = '1894553000000012367'
|ID of an invoice.|
|InvoiceNumber||String||Number of an invoice.|
|Id of a project.|
|Balance||Decimal||Total amount available in invoice.|
|CreatedTime||Datetime||Time at which the project invoice was created.|
|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.|