PurchaseOrderLineItems
Get the details of line items of purchase orders.
Table Specific Information
Select
The add-in uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:
- PurchaseorderId supports the '=' and IN operators.
NOTE: PurchaseorderId is required to query PurchaseOrderLineItems.
The rest of the filter is executed client-side in the add-in.
For example:
SELECT * FROM PurchaseOrderLineItems WHERE PurchaseorderId = '1894553000000087078'
SELECT * FROM PurchaseOrderLineItems WHERE PurchaseOrderId IN (SELECT PurchaseOrderId FROM PurchaseOrders)
SELECT * FROM PurchaseOrderLineItems WHERE PurchaseOrderId IN ('1894553000000087078','1894553000000087079')
Columns
| Name | Type | References | SupportedOperators | Description |
| LineItemId [KEY] | String | Id of line item. | ||
| PurchaseorderId | String |
PurchaseOrders.PurchaseorderId | Id of purchase order. | |
| ItemId | String |
Items.ItemId | Id of an item. | |
| ItemOrder | Integer | Order of an item. | ||
| ItemTotal | Decimal | Total number of items in purchase order. | ||
| ItemType | String | Types of item. | ||
| AccountId | String |
BankAccounts.AccountId | Id of the Bank Account. | |
| AccountName | String | Name of the account. | ||
| BcyRate | Decimal | Rate of base currency. | ||
| CustomFields | String | Custom Fields added for the line item. | ||
| Description | String | Description of the purchase order line item. | ||
| Discount | Double | Discount to be applied on purchase order line item. | ||
| Name | String | Name of the line item. | ||
| ProjectId | String |
Projects.ProjectId | Id of the project. | |
| Quantity | Double | Total number of items added in purchase order. | ||
| QuantityCancelled | Double | Total number of cancelled quantity added in purchase order. | ||
| Rate | Decimal | Rate of the line item. | ||
| Tags | String | Details of tags related to purchase 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 | Number of quantity. | ||
| SKU | String | The SKU of the Line Item. |