Power BI Connector for Zoho Books

Build 22.0.8479

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479