PurchaseOrderLineItems
Get the details of line items of purchase orders.
Table Specific Information
Select
The 本製品 will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.
Note: PurchaseorderId is required in order to query PurchaseOrderLineItems.
- PurchaseorderId supports the '=' comparison.
SELECT * FROM PurchaseOrderLineItems WHERE PurchaseorderId = '1894553000000087078'
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 item 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. |