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