Cmdlets for Zoho Books

Build 24.0.8963

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 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963