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