ODBC Driver for Zoho Books

Build 24.0.9060

InventorySummaryReport

Generated schema file.

Table Specific Information

Select

The driver 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.
  • WarehouseId supports the '=' comparison.
  • StockAvailability supports the '=' comparison.
  • Status supports the '=' comparison.
  • ItemId supports the 'IN' comparison.

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

For example:

    SELECT * FROM InventorySummaryReport WHERE TransactionDate = 'Today'

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

    SELECT * FROM InventorySummaryReport WHERE FromDate = '2022-10-10' AND ToDate = '2022-10-31'

    SELECT * FROM InventorySummaryReport WHERE warehouseid = '3285934000000113095'

    SELECT * FROM InventorySummaryReport WHERE StockAvailability = 'AvailableStock'

    SELECT * FROM InventorySummaryReport WHERE ItemId IN ('5672409674565')

    SELECT * FROM InventorySummaryReport WHERE Status = 'Active'

Columns

Name Type References SupportedOperators Description
CategoryId String Category Id.
CategoryName String Category Name.
IsComboProduct Boolean Is Combo Product.
QuantityAvailable Double Quantity Available.
QuantityAvailableForSale Double Quantity AvailableForSale.
QuantityDemanded Double Quantity Demanded.
QuantityOrdered Double Quantity Ordered.
QuantityPurchased Double Quantity Purchased.
QuantitySold Double Quantity Sold.
ReorderLevel String Reorder Level.
Unit String Unit.
ItemName String Item Name.
Status String Status.

The allowed values are All, Active, Inactive.

The default value is All.

Sku String Sku.
ItemId String Item Id.

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
WarehouseId String Warehouse Id.
StockAvailability String Stock Availability.

The allowed values are AvailableStock, OutOfStock, StockLessThanZero, StockEqualToZero.

The default value is All.

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060