SalesOrderDocuments
Get the attachments associated with salesorders.
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.
- SalesorderId supports the '=,IN' comparisons.
SELECT * FROM SalesorderDocuments WHERE SalesorderId = '3255827000000101306'
SELECT * FROM SalesorderDocuments WHERE SalesorderId IN ('3255827000000101306', '3255827000000101223')
Columns
| Name | Type | References | SupportedOperators | Description |
| DocumentId [KEY] | String | Id of Document. | ||
| SalesOrderId | String |
SalesOrders.SalesorderId | = | Id of Salesorder. |
| FileName | String | Name of the document attached. | ||
| AttachmentOrder | Integer | Integer denoting the order of attachment. | ||
| CanShowInPortal | Boolean | Boolean denoting if the document should be shown in portal 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. |