Report_LedgerOutstandings
Ledger Outstandings Report of Tally
Table Specific Information
Select
The adapter 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 adapter.
- 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
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. |