BillVendorCredits
Retrieves bills related to vendor credits.
Table Specific Information
Select
The 本製品 uses the Zoho Books API to process WHERE clause conditions built with the BillId column, which supports '=,IN' comparisons.The rest of the filter is executed client-side in the 本製品.
For example:
SELECT * FROM BillVendorCredits WHERE billid = '3255827000000099202' SELECT * FROM BillVendorCredits WHERE billid IN ('3255827000000099202', '3255827000000102354')
Columns
Name | Type | References | SupportedOperators | Description |
VendorCreditBillId [KEY] | Long | The Vendor Credit Bill Id | ||
VendorCreditId | String |
VendorCredits.VendorCreditId | The Id of a vendor credit. | |
BillId | String |
Bills.BillId | = | The Bill Id. |
Amount | Integer | The Amount that is credited in the bill. | ||
Date | Date | The Date of the vendor credit. | ||
VendorCreditNumber | String | The Number of a vendor credit. |