Read, Insert and Delete 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.

• Id supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM TransferOrders WHERE Id = '3350895000000089001'

Insert

Insert can be executed by specifying the TransferOrderNumber, Date, FromWarehouseId, ToWarehouseId and LineItems column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO TransferOrders (TransferOrderNumber, Date, FromWarehouseId, ToWarehouseId, LineItems) VALUES ('TO-00001', '2018-03-23', '4815000000035003', '4815000000035003', 'TransferOrderLINEITEMS#TEMP')

Delete

Delete can be executed by specifying the Id in the WHERE Clause For example:

DELETE FROM TransferOrders WHERE Id = '3350895000000089001'

Columns