Get refund for a vendor credit

Table-Specific Information

Select

The provider uses 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 provider.

• 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

To insert into this table, specify the VendorCreditId, Date, Amount, and AccountId columns. Non-read-only columns can be inserted optionally. For example:

INSERT INTO VendorCreditRefund (VendorCreditId, Date, Amount, AccountId) VALUES ('3782369000000057091', '2026-06-27', 25, '3782369000000000459')

Update

To update this table, specify the Amount, Date, and AccountId in the WHERE clause. Non-read-only columns can be updated. For example:

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

Delete

To delete from this table, specify the VendorCreditId in the WHERE clause. For example:

DELETE FROM VendorCreditRefund WHERE VendorCreditId = '3350895000000089001'

Columns

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.