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