VendorCreditRefund
Read, Insert and Update Vendor Credit Refunds.
g
Table Specific Information
Select
The 本製品 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 本製品.
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
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. |