PurchaseOrderLineItems
List line items of Purchase Orders.
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.
- 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. |