RetainerInvoiceDocuments
Get the attachments associated with retainer invoices.
Table Specific Information
Select
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.
- RetainerInvoiceId supports the '=,IN' comparisons.
SELECT * FROM RetainerInvoiceDocuments WHERE RetainerInvoiceId = '3255827000000101306'
SELECT * FROM RetainerInvoiceDocuments WHERE RetainerInvoiceId IN ('3255827000000101306', '3255827000000101223')
Columns
| Name | Type | References | SupportedOperators | Description |
| DocumentId [KEY] | String | Id of Document. | ||
| RetainerInvoiceId | String |
RetainerInvoices.RetainerInvoiceId | = | Id of a retainer 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. |