SalesOrderLineItems
Retrieves list of line items of a sales order.
Table Specific Information
Select
The connector uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:
- SalesorderId supports the '=' and IN operators.
NOTE: SalesorderId is required to query SalesOrderLineItems.
The rest of the filter is executed client-side in the connector.
For example:
SELECT * FROM SalesOrderLineItems WHERE SalesorderId = '1894553000000077349'
SELECT * FROM SalesOrderLineItems WHERE SalesorderId IN (SELECT SalesorderId FROM SalesOrders)
SELECT * FROM SalesOrderLineItems WHERE SalesorderId IN ('1894553000000077349','1894553000000077350')
Columns
| Name | Type | References | SupportedOperators | Description |
| LineItemId [KEY] | String | Id of a line item. | ||
| SalesorderId | String |
SalesOrders.SalesorderId | Id of a sales order. | |
| BcyRate | Decimal | Rate of Base Currency. | ||
| CustomFields | String | Custom Fields added for the line item. | ||
| Description | String | Description of the sales order line item. | ||
| Discount | String | Discount given to specific item in sales order. | ||
| DiscountAmount | Decimal | Amount of discount applied for items of sales order. | ||
| ImageDocumentId | String | Id of image document. | ||
| ImageName | String | Name of the image. | ||
| ImageType | String | Type of image. | ||
| IsInvoiced | Boolean | Check if the sales order is invoiced. | ||
| ItemId | String |
Items.ItemId | Id of an item. | |
| ItemOrder | Integer | Order of an item. | ||
| ItemTotal | Decimal | Total amount of an item. | ||
| ItemType | String | Type of item. | ||
| Name | String | Name of the sales order. | ||
| ProjectId | String |
Projects.ProjectId | Id of the project. | |
| Quantity | Decimal | Total number of quantity. | ||
| QuantityCancelled | Decimal | Total number of quantity canceled for salesorder. | ||
| Rate | Decimal | Rate of the line item. | ||
| Tags | String | Details of tags related to sales order line items. | ||
| TaxId | String |
Taxes.TaxId | Id of tax. | |
| TaxName | String | Name of the tax. | ||
| TaxPercentage | Integer | Percentage applied for tax. | ||
| TaxType | String | Type of tax. | ||
| Unit | String | Total quantity included in sales order items. | ||
| SKU | String | The SKU of the Line Item. |