SalesOrderLineItems
Get line items related to salesorder
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.
- 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. |