PurchaseReceiveLineItems
Get line items related to purchase receive
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. | |
| AccountId | Long | ID of the account. | |
| AccountName | String | Name of the account. | |
| BillLineItems | String | Bill line items. | |
| ImageDocumentId | Long | ID of the image document. | |
| IsComboProduct | Boolean | Whether this is a combo product. | |
| ItemCustomFields | String | Custom fields for the item. | |
| ItemType | String | Type of the item. | |
| LocationId | Long | ID of the location. | |
| LocationName | String | Name of the location. | |
| QuantityBilled | Double | Quantity billed. | |
| Sku | String | SKU. | |
| ImageName | String | Name of the image. | |
| ImageType | String | Type of the image. |