ODBC Driver for Tally

Build 24.0.9062

Report_LedgerOutstandings

Ledger Outstandings Report of Tally

Table Specific Information

Select

The 本製品 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 本製品.

  • 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 Bill date for Report LedgerOutstandings.
BillRef String Bill reference for Report LedgerOutstandings.
BillAmount Decimal Bill amount for Report LedgerOutstandings.
BillDueDate Date Bill due date for Report LedgerOutstandings.
BillOverdue Boolean Bill overdue for Report LedgerOutstandings.
LedgerName 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.

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