committedstockdetailsreport

Generated schema file.

Table Specific Information

Select

The component uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:

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

The rest of the filter is executed client-side in the component.

For example:

    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.
ContactStatus	String			Contact Status.
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. The allowed values are Today, ThisWeek, ThisMonth, ThisQuarter, ThisYear, PreviousDay, PreviousWeek, PreviousMonth, PreviousQuarter, PreviousYear, CustomDate.
ToDate	Date		To Date.
FromDate	Date		From Date.
CustomerId	String		Customer Id.

SSIS Components for Zoho Books

committedstockdetailsreport

Table Specific Information

Select

Columns

Pseudo-Columns