SalesOrderLineItems
Retrieves list of line items of a sales order.
Table Specific Information
Select
The 本製品 will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.
Note: SalesorderId is required in order to query SalesOrderLineItems.
- SalesorderId supports the '=' comparison.
SELECT * FROM SalesOrderLineItems WHERE SalesorderId = '1894553000000077349'
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. |