Read, Insert and Update Vendor Credit Refunds.

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.

• VendorCreditId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM VendorCreditRefund WHERE VendorCreditId = '3350895000000089001'

SELECT * FROM VendorCreditRefund WHERE VendorCreditNumber = '983872973'

Insert

Insert can be executed by specifying the Amount, Date 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 VendorCreditRefund (Amount, Date) VALUES (66, 12-12-20)

Update

Update can be executed by specifying the Amount, Date and AccountId in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE VendorCreditRefund SET Description = 'test2', Date = '12-12-19', Amount = 90 WHERE AccountId = '3285934000000136008'

Delete

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

DELETE FROM VendorCreditRefund WHERE Id = '3350895000000089001'

Columns