CustomerBalancesReport
Generated schema file.
Table Specific Information
Select
The add-in 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 add-in.
For example:
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. |