TransferOrderLineItems
List line items of transfer orders.
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.
- TransferOrderId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM TransferOrderLineItems WHERE TransferOrderId = '3350895000000089001'
Columns
Name | Type | References | Description |
TransferOrderId | Long | Unique ID generated by the server for the Transfer Order | |
Description | String | Description of the line item. | |
ItemId | Long | Unique ID generated by the server for the item. | |
LineItemId [KEY] | Long | Unique ID generated by the server for each line item. | |
Name | String | Name of the line item. | |
QuantityTransfer | Integer | Quantity of the line item to be transferred. | |
Unit | String | Unit of line item. |