Report_StockVouchers
StockVouchers Report of Tally
Table Specific Information
Select
The connector 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 connector.
- 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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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. |