SalesOrderLineItems
Get line items related to salesorder
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.
- SalesOrderId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM SalesOrderLineItems WHERE SalesOrderId = '3350895000000089001'
Columns
| Name | Type | References | Description |
| LineItemId [KEY] | Long | Unique ID generated by the server for each line item. | |
| SalesOrderId | Long |
SalesOrders.Id | Id of the salesorder. |
| BcyRate | Integer | Item rate in the organization base currency. | |
| Description | String | Description of the line item. | |
| HsnOrSac | Integer | Add HSN/SAC code for your goods/services. | |
| ImageId | Long | Unique ID generated by the server for the item image. | |
| ImageName | String | Name of the image of the line item. | |
| ImageType | String | The type (file format) of the image. | |
| IsInvoiced | Boolean | Checks whether the Sales Order has been invoiced or not. | |
| ItemId | Long | Unique ID generated by the server for the item. | |
| ItemOrder | Integer | The order of the line items. | |
| ItemTotal | Integer | Total of line item. | |
| Name | String | Name of the line item. | |
| Quantity | Integer | Quantity of the line item. | |
| QuantityInvoiced | Integer | Quantity invoiced of the line item. | |
| QuantityPacked | Integer | Quantity packed of the line item. | |
| QuantityShipped | Integer | Quantity shipped of the line item. | |
| Rate | Integer | Rate / Selling Price of the line item. | |
| TaxId | Long | Unique ID generated by the server for the tax. | |
| TaxName | String | Name of the tax applied on the line item. | |
| TaxPercentage | Integer | Percentage of the tax. | |
| TaxType | String | Denotes the type of the tax. | |
| Unit | String | Unit of line item. | |
| WarehouseId | Long | Unique ID generated by the server for the ware houses. | |
| AttributeName1 | String | Name of attribute 1. | |
| AttributeName2 | String | Name of attribute 2. | |
| AttributeName3 | String | Name of attribute 3. | |
| ComboType | String | Type of combo product. | |
| CustomFieldHash | String | Hash of custom fields. | |
| Discount | Double | Discount applied. | |
| ImageDocumentId | Long | ID of the image document. | |
| ItemCustomFields | String | Custom fields for the item. | |
| ItemType | String | Type of the item. | |
| LineItemTaxes | String | Line item taxes. | |
| MappedItems | String | Mapped items. | |
| PackageDetails | String | Package details. | |
| ProductType | String | Type of the product. | |
| ProjectId | Long | ID of the project. | |
| QuantityBackordered | Integer | Quantity backordered. | |
| QuantityDelivered | Integer | Quantity delivered. | |
| QuantityPicked | Integer | Quantity picked. | |
| QuantityReturned | Integer | Quantity returned. | |
| Sku | String | SKU. | |
| Tags | String | Tags. | |
| VariantId | Long | ID of the variant. | |
| AttributeOptionData1 | String | Attribute option data 1. | |
| AttributeOptionData2 | String | Attribute option data 2. | |
| AttributeOptionData3 | String | Attribute option data 3. | |
| AttributeOptionName1 | String | Attribute option name 1. | |
| AttributeOptionName2 | String | Attribute option name 2. | |
| AttributeOptionName3 | String | Attribute option name 3. | |
| Discounts | String | Discounts applied. | |
| DocumentId | Long | ID of the document. | |
| GroupName | String | Name of the group. | |
| HeaderId | Long | ID of the header. | |
| HeaderName | String | Name of the header. | |
| IsComboProduct | Boolean | Whether this is a combo product. | |
| IsFulfillable | Boolean | Whether the item is fulfillable. | |
| IsModifierItem | Boolean | Whether this is a modifier item. | |
| IsReturnable | Boolean | Whether the item is returnable. | |
| IsUnconfirmedProduct | Boolean | Whether this is an unconfirmed product. | |
| ItemSubTotal | Double | Sub total of the item. | |
| LineItemCategory | String | Category of the line item. | |
| LineItemType | String | Type of the line item. | |
| PackageDetailsDimensionUnit | String | Dimension unit of the package details. | |
| PackageDetailsHeight | String | Height of the package details. | |
| PackageDetailsLength | String | Length of the package details. | |
| PackageDetailsWeight | String | Weight of the package details. | |
| PackageDetailsWeightUnit | String | Weight unit of the package details. | |
| PackageDetailsWidth | String | Width of the package details. | |
| PricebookId | Long | ID of the pricebook. | |
| ProductId | Long | ID of the product. | |
| QuantityCancelled | Integer | Quantity cancelled. | |
| QuantityDropshipped | Integer | Quantity dropshipped. | |
| QuantityInvoicedCancelled | Integer | Quantity invoiced cancelled. | |
| QuantityManuallyfulfilled | Integer | Quantity manually fulfilled. | |
| SalesRate | Double | Sales rate. |