InvoiceDocuments
Get the attachments associated with invoices.
Table Specific Information
Select
The add-in 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 add-in.
- InvoiceId supports the '=,IN' comparisons.
SELECT * FROM InvoiceDocuments WHERE InvoiceId = '3255827000000101306'
SELECT * FROM InvoiceDocuments WHERE InvoiceId IN ('3255827000000101306', '3255827000000101223')
Columns
| Name | Type | References | SupportedOperators | Description |
| DocumentId [KEY] | String | Id of Document. | ||
| InvoiceId | String |
Invoices.InvoiceId | = | Id of a Invoice. |
| FileName | String | Name of the document attached. | ||
| AttachmentOrder | Integer | Integer denoting the order of attachment. | ||
| CanSendInMail | Boolean | Boolean denoting if the document should be send in mail or not. | ||
| FileSize | String | Size of the file. | ||
| FileType | String | Type of the file. | ||
| Source | String | Source from where file was uploaded. | ||
| UploadedBy | String | The name of the contact who uploaded the file. | ||
| UploadedTime | Datetime | The date and time when file was uploaded. |