SalesOrderDocuments
List documents of sales orders.
Table Specific Information
Select
The connector will use the Zoho Inventory 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.
- DocumentId supports the '=' comparison.
- SalesOrderId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM SalesOrderDocuments WHERE DocumentId = '3350895000000089001' SELECT * FROM SalesOrderDocuments WHERE SalesOrderId = '3350895000000089001'
Columns
| Name | Type | References | Description |
| DocumentId [KEY] | Long | Unique ID generated by the server for the document. | |
| SalesOrderId | Long |
SalesOrders.Id | Id of the salesorder. |
| AttachmentOrder | Integer | This indicates the chronological number of the attachment. | |
| CanSendInMail | Boolean | Checks whether the sales order can be sent as a mail or not. | |
| FileName | String | This indicates the name of the file. | |
| FileSize | Integer | this indicates the size of the attached file. | |
| FileSizeFormatted | String | This indicates the size of the formatted file. | |
| FileType | String | Sales order can have files attached to them. |