PurchaseOrderLineItems
List line items of Purchase Orders.
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.
- LineItemId supports the '=' comparison.
- PurchaseOrderId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM PurchaseOrderLineItems WHERE PurchaseOrderId = '3350895000000089001'
Columns
| Name | Type | References | Description |
| PurchaseOrderId | Long | Unique ID generated by the server for the Purchase Order. | |
| AccountId | Long | Account ID of the item. | |
| BcyRate | Integer | Item rate in the organization base currency. | |
| Description | String | Description of the line item. | |
| HsnOrSac | String | HSN or SAC Code for the Item | |
| ImageId | Long | Unique ID generated by the server for the item image. This is used an identifier. | |
| ImageName | String | Name of the image of the line item. | |
| ImageType | String | The type (file format) of the image. | |
| ItemId | Long | Unique ID generated by the server for the item. This is used as an identifier | |
| ItemOrder | Integer | The order of the line items, starts from 0 by default. | |
| ItemTotal | Integer | Total of line item. | |
| LineItemId [KEY] | Long | Id of line item. | |
| Name | String | Name of the line item. | |
| PurchaseRate | Integer | Purchase Price of the line item. | |
| Quantity | Integer | Quantity of the line item. | |
| QuantityReceived | Integer | Quantity invoiced of the line item. | |
| ReverseChargeTaxAmount | Integer | Enter reverse charge tax amount. | |
| ReverseChargeTaxId | Long | Enter reverse charge tax ID. | |
| ReverseChargeTaxName | String | Enter reverse charge tax name. | |
| ReverseChargeTaxPercentage | Integer | Enter reverse charge tax percentage. | |
| SalesorderItemId | Long | Salesorder Item Id. | |
| TaxExemptionCode | String | Enter tax exemption code. | |
| TaxRxemptionId | String | Enter tax exemption id | |
| TaxId | Long | Unique ID generated by the server for the tax. This is used as an identifier. | |
| 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. This can either be a single tax or a tax group. | |
| Unit | String | Unit of line item. | |
| WarehouseId | Long | Warehouse Id. |