VendorCreditRefund
Read, Insert and Update Vendor Credit Refunds.
g
Table Specific Information
Select
The driver 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 driver.
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
Name | Type | ReadOnly | References | SupportedOperators | Description |
VendorCreditId [KEY] | String | False |
VendorCredits.VendorCreditId | = |
Vendor Credit Id. |
VendorCreditRefundId [KEY] | String | True | = |
Vendor Credit Refund Id. | |
Amount | Integer | False |
Amount. | ||
AmountBcy | Integer | True |
Amount BCY. | ||
AmountFcy | Integer | True |
Amount FCY. | ||
CustomerName | String | True |
Customer Name. | ||
Date | Date | False |
Date. | ||
Description | String | False |
Description. | ||
ExchangeRate | Decimal | False |
Exchange Rate. | ||
ReferenceNumber | String | False |
Reference Number. | ||
RefundMode | String | False |
Refund Mode. | ||
VendorName | String | True |
Vendor Name. | ||
VendorCreditNumber | String | True |
Vendor Credit Number. |
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.
Name | Type | Description |
AccountId | String |
Id of the Bank Account. |