ODBC Driver for Zoho Books

Build 22.0.8479

SalesByCustomerReport

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 本製品.

  • TransactionDate supports the '=' comparison.
  • ToDate supports the '=' comparison.
  • FromDate supports the '=' comparison.
  • CustomerId supports the 'IN, NOT IN' comparison.
  • EntityList supports the 'IN' comparison.
For example:
    SELECT * FROM SalesByCustomerReport

    SELECT * FROM SalesByCustomerReport WHERE TransactionDate = 'Today'

    SELECT * FROM SalesByCustomerReport WHERE ToDate = '2022-10-31'

    SELECT * FROM SalesByCustomerReport WHERE FromDate = '2022-10-10' and ToDate = '2022-10-31'
	
	SELECT * FROM SalesByCustomerReport WHERE CustomerId NOT IN ('3285934000000152001')
	
	SELECT * FROM SalesByCustomerReport WHERE EntityList In ('invoice')

Columns

Name Type References SupportedOperators Description
ContactBillingAttention String Contact Billing Attention
ContactBillingCity String Contact Billing City
ContactBillingCountry String Contact Billing Country
ContactBillingFax String Contact Billing Fax
ContactBillingPhone String Contact Billing Phone
ContactBillingState String Contact Billing State
ContactBillingStreet1 String Contact Billing Street1
ContactBillingStreet2 String Contact Billing Street2
ContactBillingZipcode String Contact Billing Zipcode
ContactCompanyName String Contact Company Name
ContactCreatedBy String Contact Created By
ContactCreatedTime Datetime Contact CreatedTime
ContactCreditLimit Integer Contact CreditLimit
ContactCustomerSubType String Contact CustomerSubType
ContactDepartment String Contact Department
ContactDesignation String Contact Designation
ContactEmail String Contact Email
ContactFacebook String Contact Facebook
ContactFirstName String Contact FirstName
ContactLastModifiedTime Datetime Contact LastModifiedTime
ContactLastName String Contact LastName
ContactMobilePhone String Contact MobilePhone
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
ContactShippingAttention String Contact Shipping Attention
ContactShippingCity String Contact Shipping City
ContactShippingCountry String Contact Shipping Country
ContactShippingFax String Contact Shipping Fax
ContactShippingPhone String Contact Shipping Phone
ContactShippingState String Contact Shipping State
ContactShippingStreet1 String Contact Shipping Street1
ContactShippingStreet2 String Contact Shipping Street2
ContactShippingZipcode String Contact Shipping Zipcode
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
Count Integer Count
CreditNoteCount Integer Credit Note Count
CreditNoteAmount Integer Credit Note Amount
CurrencyCode String Currency Code
CustomFieldsList String Custom Fields List
CustomerName String Customer Name
FcyCreditnoteAmount Integer Fcy Creditnote Amount
FcyInvoiceAmount Integer Fcy Invoice Amount
FcySales Integer Fcy Sales
FcySalesWithTax Integer Fcy Sales With Tax
FcySalesWithoutDiscount Integer Fcy Sales Without Discount
InvoiceAmount Integer Invoice Amount
JournalCount Integer Journal Count
PreviousValues String Previous Values
Sales Integer Sales
SalesDepositCount Integer Sales Deposit Count
SalesWithTax Integer Sales With Tax
SalesWithoutDiscount Integer Sales Without Discount
CustomerId String IN, NOT IN 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
TransactionDate String Filter transaction by any transaction date.

使用できる値は次のとおりです。Today, ThisWeek, ThisMonth, ThisQuarter, ThisYear, PreviousDay, PreviousWeek, PreviousMonth, PreviousQuarter, PreviousYear and CustomDate

ToDate Date To Date
FromDate Date From Date
EntityList String EntityList

使用できる値は次のとおりです。invoice, creditnote, sales_without_invoices, journal

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