PurchaseReceiveLineItems
List line tiems of purchase receives.
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.
- ReceiveId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM PurchaseReceiveLineItems WHERE ReceiveId = '3350895000000089001'
Columns
| Name | Type | References | Description |
| ReceiveId | Long | Unique ID generated by the server for the Purchase Receive. | |
| Description | String | Descripition of line item. | |
| Item_id | Long | Item ID of line item. | |
| Item_order | Integer | Item Order of line item. | |
| Line_item_id [KEY] | Long | Line item id of line item. | |
| Name | String | Name of line item. | |
| Quantity | Integer | Quantity of line item. | |
| Unit | String | Unit of line item. |