VendorBalancesReport

Generated schema file.

Table Specific Information

Select

The component uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:

ReportDate supports the '=' comparison.
VendorId supports the '=' comparison.

The rest of the filter is executed client-side in the component.

For example:

    SELECT * FROM VendorBalancesReport WHERE ReportDate = '2022-10-31'
    SELECT * FROM VendorBalancesReport WHERE VendorId = '3285934000000104023'

Columns


Name	Type	References	SupportedOperators	Description
VendorName	String			Vendor Name.
BillBalance	Integer			Bill Balance.
BcyAdvancePayment	String			Bcy Advance Payment.
BcyBalance	Integer			Bcy Balance.
BcyBillBalance	Integer			Bcy Bill Balance.
BcyCreditBalance	String			Bcy Credit Balance.
BcyExcessPayment	Integer			Bcy Excess Payment.
BcyJournalCredits	String			Bcy Journal Credits.
CurrencyId	String			CurrencyId.
ExcessPayment	Integer			Excess Payment.
FcyAdvancePayment	String			Fcy Advance Payment.
FcyBalance	Integer			Fcy Balance.
FcyCreditBalance	String			Fcy Credit Balance.
FcyJournalCredits	String			Fcy Journal Credits.
VendorCompanyName	String			Vendor Company Name.
VendorCreatedBy	String			Vendor Created By.
VendorCreatedTime	Datetime			Vendor Created Time.
VendorDepartment	String			Vendor Department.
VendorDesignation	String			Vendor Designation.
VendorEmail	String			Vendor Email.
VendorFacebook	String			Vendor Facebook.
VendorFirstName	String			Vendor FirstName.
VendorLastModifiedTime	Datetime			Vendor Last Modified Time.
VendorLastName	String			Vendor Last Name.
VendorMobilePhone	String			Vendor Mobile Phone.
VendorNotes	String			Vendor Notes.
VendorOutstandingPayableAmount	Integer			Vendor Outstanding Payable Amount.
VendorOutstandingPayableAmountBcy	Integer			Vendor Outstanding Payable AmountBcy.
VendorPaymentTerms	String			Vendor PaymentTerms.
VendorPhone	String			Vendor Phone.
VendorSkype	String			Vendor Skype.
VendorStatus	String			Vendor Status.
VendorTwitter	String			Vendor Twitter.
VendorUnusedCreditsPayableAmount	Integer			Vendor Unused Credits Payable Amount.
VendorUnusedCreditsPayableAmountBcy	Integer			Vendor Unused Credits Payable AmountBcy.
VendorWebsite	String			Vendor Website.
VendorId	String		=	Vendor Id.

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
ReportDate	Date		Report Date.

SSIS Components for Zoho Books

VendorBalancesReport

Table Specific Information

Select

Columns

Pseudo-Columns