Read, Insert and Update Vendor Credit Refunds.

g

Table Specific Information

Select

The component 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 component.

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

SELECT * FROM VendorCreditRefund

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,VendorCreditId 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 (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.