VendorBalancesReport
Generated schema file.
Table Specific Information
Select
The connector 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 connector.
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. |