ProjectInvoices
Retrieves list of invoices created for a project.
Table Specific Information
Select
The 本製品 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 本製品.
- ProjectId supports the '=' comparison.
SELECT * FROM ProjectInvoices WHERE ProjectId = '1894553000000012367'
Columns
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. |