VendorBalancesReport
Generated schema file.
Table Specific Information
Select
The 本製品 will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.
- ReportDate supports the '=' comparison.
- VendorId supports the '=' comparison.
SELECT * FROM VendorBalancesReport 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 |