SalesOrderDocuments
List documents of sales orders.
Table Specific Information
Select
The add-in 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 add-in.
- 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. |