committedstockdetailsreport
Generated schema file.
Table Specific Information
Select
The provider 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 provider.
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 |