CustomerBalancesReport
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.
- CustomerID supports the '=' comparison.
The rest of the filter is executed client-side in the component.
For example:
SELECT * FROM customerbalancesreport
SELECT * FROM customerbalancesreport WHERE ReportDate = '2022-10-31'
SELECT * FROM customerbalancesreport WHERE CustomerID = '3456743221369'
Columns
| Name | Type | References | SupportedOperators | Description |
| AvailableCredits | Integer | Available Credits | ||
| BcyAdvancePayment | String | BcyAdvance Payment | ||
| BcyAvailableCredits | Integer | Bcy Available Credits | ||
| BcyBalance | Integer | Bcy Balance | ||
| BcyCreditBalance | String | Bcy CreditBalance | ||
| BcyInvoiceBalance | Integer | Bcy Invoice Balance | ||
| BcyJournalCredits | String | Bcy Journal Credits | ||
| ContactCompanyName | String | Contact Company Name | ||
| ContactCreatedBy | String | Contact Created By | ||
| ContactCreatedTime | Datetime | Contact Created Time | ||
| ContactCreditLimit | Integer | Contact Credit Limit | ||
| ContactCustomerSubType | String | Contact Customer SubType | ||
| ContactDepartment | String | Contact Department | ||
| ContactDesignation | String | Contact Designation | ||
| ContactEmail | String | Contact Email | ||
| ContactFacebook | String | Contact Facebook | ||
| ContactFirstName | String | Contact First Name | ||
| ContactLastModifiedTime | Datetime | Contact Last Modified Time | ||
| ContactLastName | String | Contact Last Name | ||
| ContactMobilePhone | String | Contact Mobile Phone | ||
| ContactNotes | String | Contact Notes | ||
| ContactOutstandingReceivableAmount | Integer | Contact Outstanding Receivable Amount | ||
| ContactOutstandingReceivableAmountBcy | Integer | Contact Outstanding Receivable Amount Bcy | ||
| ContactPaymentTerms | String | Contact Payment Terms | ||
| ContactPhone | String | Contact Phone | ||
| ContactSkype | String | Contact Skype | ||
| ContactStatus | String | Contact Status | ||
| ContactTwitter | String | Contact Twitter | ||
| ContactUnusedCreditsReceivableAmount | Integer | Contact Unused Credits Receivable Amount | ||
| ContactUnusedCreditsReceivableAmountBcy | Integer | Contact Unused Credits Receivable Amount Bcy | ||
| ContactWebsite | String | Contact Website | ||
| CreditLimit | Integer | Credit Limit | ||
| CurrencyId | String | Currency Id | ||
| CustomerName | String | Customer Name | ||
| FcyAdvancePayment | String | Fcy AdvancePayment | ||
| FcyBalance | Integer | Fcy Balance | ||
| FcyCreditBalance | String | Fcy Credit Balance | ||
| FcyJournalCredits | String | Fcy Journal Credits | ||
| InvoiceBalance | Integer | Invoice Balance | ||
| TotalBcyAdvancePayment | String | Total Bcy Advance Payment | ||
| TotalBcyAvailableCredits | Integer | Total Bcy Available Credits | ||
| TotalBcyBalance | Integer | Total Bcy Balance | ||
| TotalBcyCreditBalance | String | Total Bcy Credit Balance | ||
| TotalBcyInvoiceBalance | Integer | Total Bcy Invoice Balance | ||
| TotalBcyJournalCredits | String | Total Bcy Journal Credits | ||
| CustomerId | String | = | Customer 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 |