SalesOrderLineItems

Retrieves list of line items of a sales order.

Table Specific Information

The 本製品 uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:

NOTE: SalesorderId is required to query SalesOrderLineItems.

The rest of the filter is executed client-side in the 本製品.

For example:

    SELECT * FROM SalesOrderLineItems WHERE SalesorderId = '1894553000000077349'


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.