CustomerBalancesReport
Generated schema file.
Table Specific Information
Select
The 本製品 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 本製品.
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 |