JDBC Driver for Tally

Build 20.0.7654

Report_LedgerOutstandings

Ledger Outstandings Report of Tally

Table Specific Information

Select

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

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

For example these queries are processed server side:

SELECT * FROM Report_LedgerOutstandings WHERE LedgerName = 'Ledger1'

SELECT * FROM Report_LedgerOutstandings WHERE LedgerName = 'Ledger1' AND FromDate = '01/01/2019' AND ToDate = '01/01/2020'

Columns

Name Type Description
BillDate Date
BillRef String
BillAmount Decimal
BillDueDate Date
BillOverdue Boolean
LedgerName String
FromDate Date
ToDate Date

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654