Read, Insert and Update Vendor Credit Refunds.

g

Table Specific Information

Select

The connector uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:

• VendorCreditId supports the '=' comparison.

The rest of the filter is executed client-side within the connector.

For example, the following queries are processed server-side:

SELECT * FROM VendorCreditRefund WHERE VendorCreditId = '3350895000000089001'

SELECT * FROM VendorCreditRefund WHERE VendorCreditId = '3285934000000134009' AND VendorCreditRefundId = '3285934000000435001'

Insert

INSERT can be executed by specifying the Amount, Date, AccountId, and VendorCreditId columns. The columns that are not read-only can be inserted optionally. The following is an example of how to insert into this table.

INSERT INTO VendorCreditRefund (Date, Amount, AccountId, VendorCreditId) VALUES ('2023-02-27', '1200', 3285934000000259036, 3285934000000134009)

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' WHERE vendorcreditrefundid = 3285934000000435001 AND VendorCreditId = 3285934000000134009

Delete

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

DELETE FROM VendorCreditRefund WHERE VendorCreditId = 3285934000000134009 AND vendorcreditrefundid = 3285934000000432043

Columns

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.