JDBC Driver for Tally

Build 22.0.8462

Report_StockVouchers

StockVouchers Report of Tally

Table Specific Information

Select

The driver will use the Tally API to process WHERE clause conditions built with the following column and operator. The StockItemName is required to make a request and the rest of the filter is executed client side within the driver.

  • StockItemName supports the '=' comparisons.
  • FromDate supports the '=' comparisons.
  • ToDate supports the '=' comparisons.

For example these queries are processed server side:

SELECT * FROM Report_StockVouchers WHERE StockItemName = 'StockItem1'

SELECT * FROM Report_StockVouchers WHERE StockItemName = 'StockItem1' AND FromDate = '01/01/2019' AND ToDate = '01/01/2020'

Columns

Name Type Description
Account String Account for Report StockVouchers.
Date Date Date for Report StockVouchers.
Type String Type for Report StockVouchers.
InQuantity String Quantity for Report StockVouchers.
InAmount Decimal Amount for Report StockVouchers.
OutQuantity String OutQuantity for Report StockVouchers.
OutAmount Decimal OutAmount for Report StockVouchers.
StockItemName String This is a mirror column.
FromDate Date This is a mirror column.
ToDate Date This is a mirror column.

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
Company String Name of the Company whose data need to be fetched. Please make sure it is selected and unlocked atleast once in the Tally tool after the tool is launched. It need not be in the selected state at the moment.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462