Power BI Connector for Zoho Books

Build 22.0.8479

CommittedStockDetailsReport

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' comparison.
  • ItemName supports the '=, !=, LIKE, NOT LIKE, CONTAINS, IS NULL, IS NOT NULL' comparison.
For example:
    SELECT * FROM committedstockdetailsreport

    SELECT * FROM committedstockdetailsreport WHERE TransactionDate = 'Today'

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

    SELECT * FROM committedstockdetailsreport WHERE FromDate = '2022-10-10' and ToDate = '2022-10-31'

    SELECT * FROM committedstockdetailsreport WHERE CustomerID IN ('3456743221369')

    SELECT * FROM committedstockdetailsreport WHERE ItemName IS NULL

Columns

Name Type References SupportedOperators Description
SalesOrderId String Sales OrderId
SalesOrderNumber String Sales OrderNumber
OrderType String Order Type
CustomerName String Customer Name
CommittedStock Double Committed Stock
IsSalesOrder Double Is SalesOrder
CreatedTime Datetime Created Time
Date Date Date
ItemUnit String Item Unit
ItemProductType String Item ProductType
ItemCreatedBy String Item CreatedBy
ItemStatus String Item Status
ItemDescription String Item Description
ItemPurchaseDescription String Item Purchase Description
ItemPurchaseRate String Item Purchase Rate
ItemItemType String Item ItemType
ItemRate String Item Rate
ItemLastModitfiedTime Datetime Item Last Moditfied Time
ItemCreatedTime Datetime Item Created Time
ContactCompanyName String Contact Company Name
ContactNotes String Contact Notes
ContactPaymentTerms String Contact Payment Terms
ContactOutstandingReceivableAmountBcy Integer Contact Outstanding Receivable Amount Bcy
ContactSkype String Contact Skype
ContactTwitter String Contact Twitter
ContactUnusedCreditsReceivableAmountBcy Integer Contact Unused Credits Receivable Amount Bcy
ContactMobilePhone String Contact Mobile Phone
ContactCreditLimit Integer Contact Credit Limit
ContactDepartment String Contact Department
ContactFirstName String Contact First Name
ContactEmail String Contact Email
ContactCreatedTime Datetime Contact Created Time
ContactOutstandingReceivableAmount Integer Contact Outstanding Receivable Amount
ContactWebsite String Contact Website
ContactLastModifiedTime Datetime Contact Last ModifiedTime
ContactCustomerSubType String Contact Customer SubType
ContactFacebook String Contact Facebook
ContactLastName String Contact LastName
ContactCreatedBy String Contact Created By
ContactPhone String Contact Phone
ContactDesignation String Contact Designation
ContactCompanyName String Contact Company Name
ItemName String =, !=, LIKE, NOT LIKE, CONTAINS, IS NULL, IS NOT NULL ItemName

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
CustomerId String Customer Id

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