CustomerBalancesReport
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.
- CustomerID supports the '=' comparison.
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 |