Retrieves bills related to vendor credits.

Table Specific Information

Select

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

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.