SSIS Components for Zoho Books

Build 24.0.9062

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062