PurchaseOrderLineItems
Get the details of line items of purchase orders.
Table Specific Information
Select
The connector 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 connector.
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. |