Saltar al contenido

Tally Connection Details

Introduction

Connector Version

This documentation is based on version 23.0.8936 of the connector.

Get Started

Tally Version Support

The connector leverages the Tally API to enable access to Tally. The connector supports both Tally ERP 9 and Tally Prime.

Establish a Connection

Connect to Tally

Set the following connection properties to connect to Tally Instance:

  • URL (Set this to the URL for Tally instance. For example: http://localhost:9000).

Important Notes

Configuration Files and Their Paths

  • All references to adding configuration files and their paths refer to files and locations on the Jitterbit agent where the connector is installed. These paths are to be adjusted as appropriate depending on the agent and the operating system. If multiple agents are used in an agent group, identical files will be required on each agent.

Advanced Features

This section details a selection of advanced features of the Tally connector.

User Defined Views

The connector allows you to define virtual tables, called user defined views, whose contents are decided by a pre-configured query. These views are useful when you cannot directly control queries being issued to the drivers. See User Defined Views for an overview of creating and configuring custom views.

SSL Configuration

Use SSL Configuration to adjust how connector handles TLS/SSL certificate negotiations. You can choose from various certificate formats; see the SSLServerCert property under "Connection String Options" for more information.

Proxy

To configure the connector using Private Agent proxy settings, select the Use Proxy Settings checkbox on the connection configuration screen.

Query Processing

The connector offloads as much of the SELECT statement processing as possible to Tally and then processes the rest of the query in memory (client-side).

See Query Processing for more information.

User Defined Views

The Tally connector allows you to define a virtual table whose contents are decided by a pre-configured query. These are called User Defined Views, which are useful in situations where you cannot directly control the query being issued to the driver, e.g. when using the driver from Jitterbit. The User Defined Views can be used to define predicates that are always applied. If you specify additional predicates in the query to the view, they are combined with the query already defined as part of the view.

There are two ways to create user defined views:

  • Create a JSON-formatted configuration file defining the views you want.
  • DDL statements.

Define Views Using a Configuration File

User Defined Views are defined in a JSON-formatted configuration file called UserDefinedViews.json. The connector automatically detects the views specified in this file.

You can also have multiple view definitions and control them using the UserDefinedViews connection property. When you use this property, only the specified views are seen by the connector.

This User Defined View configuration file is formatted as follows:

  • Each root element defines the name of a view.
  • Each root element contains a child element, called query, which contains the custom SQL query for the view.

For example:

{
    "MyView": {
        "query": "SELECT * FROM Company WHERE MyColumn = 'value'"
    },
    "MyView2": {
        "query": "SELECT * FROM MyTable WHERE Id IN (1,2,3)"
    }
}

Use the UserDefinedViews connection property to specify the location of your JSON configuration file. For example:

"UserDefinedViews", "C:\Users\yourusername\Desktop\tmp\UserDefinedViews.json"

Define Views Using DDL Statements

The connector is also capable of creating and altering the schema via DDL Statements such as CREATE LOCAL VIEW, ALTER LOCAL VIEW, and DROP LOCAL VIEW.

Create a View

To create a new view using DDL statements, provide the view name and query as follows:

CREATE LOCAL VIEW [MyViewName] AS SELECT * FROM Customers LIMIT 20;

If no JSON file exists, the above code creates one. The view is then created in the JSON configuration file and is now discoverable. The JSON file location is specified by the UserDefinedViews connection property.

Alter a View

To alter an existing view, provide the name of an existing view alongside the new query you would like to use instead:

ALTER LOCAL VIEW [MyViewName] AS SELECT * FROM Customers WHERE TimeModified > '3/1/2020';

The view is then updated in the JSON configuration file.

Drop a View

To drop an existing view, provide the name of an existing schema alongside the new query you would like to use instead.

DROP LOCAL VIEW [MyViewName]

This removes the view from the JSON configuration file. It can no longer be queried.

Schema for User Defined Views

User Defined Views are exposed in the UserViews schema by default. This is done to avoid the view's name clashing with an actual entity in the data model. You can change the name of the schema used for UserViews by setting the UserViewsSchemaName property.

Work with User Defined Views

For example, a SQL statement with a User Defined View called UserViews.RCustomers only lists customers in Raleigh:

SELECT * FROM Customers WHERE City = 'Raleigh';

An example of a query to the driver:

SELECT * FROM UserViews.RCustomers WHERE Status = 'Active';

Resulting in the effective query to the source:

SELECT * FROM Customers WHERE City = 'Raleigh' AND Status = 'Active';

That is a very simple example of a query to a User Defined View that is effectively a combination of the view query and the view definition. It is possible to compose these queries in much more complex patterns. All SQL operations are allowed in both queries and are combined when appropriate.

SSL Configuration

Customize the SSL Configuration

By default, the connector attempts to negotiate SSL/TLS by checking the server's certificate against the system's trusted certificate store.

To specify another certificate, see the SSLServerCert property for the available formats to do so.

Data Model

Overview

This section shows the available API objects and provides more information on executing SQL to Tally APIs.

Key Features

  • The connector models Tally entities like documents, folders, and groups as relational views, allowing you to write SQL to query Tally data.
  • Stored procedures allow you to execute operations to Tally
  • Live connectivity to these objects means any changes to your Tally account are immediately reflected when using the connector.

Views

Views describes the available views. Views are statically defined to entities such as Company, Employees, and Ledgers.

Stored Procedures

Stored Procedures are function-like interfaces to Tally. Stored procedures allow you to execute operations to Tally, including downloading documents and moving envelopes.

Views

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

Tally Connector Views

Name Description
Company Retrieve Company Details.
Employees Retrieve Employee Details.
Ledger Retrieve Ledger Details.
Payhead Retrieve Payhead Details.
PriceList Retrieve PriceList.
Report_BalanceSheet Balance Sheet Report of Tally
Report_BankGroupSummary Bank Group Summary Report of Tally
Report_BillsPayable Bills Payable Report of Tally
Report_BillsReceivable Bills Receivable Report of Tally
Report_GodownSummary Godown Summary Report of Tally
Report_GroupOutstandings Group Outstandings Report of Tally
Report_GroupSummary Group Summary Report of Tally
Report_GroupVouchers Group Vouchers Report of Tally
Report_ItemMonthlySummary ItemMonthlySummary Report of Tally
Report_LedgerOutstandings Ledger Outstandings Report of Tally
Report_LedgerVouchers Ledger Vouchers Report of Tally
Report_NegativeLedger Negative Ledger Report of Tally
Report_NegativeStock Negative Stock Report of Tally
Report_ProfitAndLoss Profit and Loss Report of Tally
Report_RatioAnalysis Ratio Analysis Report of Tally
Report_Statistics Statistics Report of Tally
Report_StockGroupSummary Stock Summary Report of Tally
Report_StockItemSummary Stock Summary Report of Tally
Report_StockVouchers StockVouchers Report of Tally
Report_TrialBalance Trial Balance Report of Tally
Report_VoucherRegister Voucher Register Report of Tally
StockItem Retrieve StockItems.

Company

Retrieve Company Details.

Table Specific Information
Select

The connector will use the Tally API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.

  • String supports the '=, !=,<, <=, >, >=, LIKE, ORDER BY' comparisons.

For example these queries are processed server side:

SELECT * FROM Company WHERE Name LIKE 'cdata%'

SELECT * FROM Company WHERE CompanyFBTAssesseeType != 'Default'

SELECT * FROM Company WHERE StateName = 'Karnataka' AND PINCode >= '560034'

SELECT * FROM Company WHERE CountryName = 'India' OR CountryName = 'US'

SELECT * FROM Company WHERE PINCode > '560034'

SELECT * FROM Company ORDER BY DBName ASC
Columns
Name Type Description
StartingFrom Date The StartingFrom value of the Company.
BooksFrom Date The BooksFrom value of the Company.
VatApplDate Date The VatApplDate value of the Company.
CompositeApplicableDate Date The CompositeApplicableDate value of the Company.
VATRegDate Date The VATRegDate value of the Company.
DeactivateExciseFrom Date The DeactivateExciseFrom value of the Company.
STRegDate Date The STRegDate value of the Company.
DeactivateServiceTaxFrom Date The DeactivateServiceTaxFrom value of the Company.
LBTRegnDate Date The LBTRegnDate value of the Company.
DeactivateVATFrom Date The DeactivateVATFrom value of the Company.
CSTApplDate Date The CSTApplDate value of the Company.
GSTApplicableDate Date The GSTApplicableDate value of the Company.
AuditedUpto Date The AuditedUpto value of the Company.
FIFOApplicableFrom Date The FIFOApplicableFrom value of the Company.
ReturnsStartFrom Date The ReturnsStartFrom value of the Company.
Name String The Name value of the Company.
BasicCompanyFormalName String The BasicCompanyFormalName value of the Company.
Guid String The Guid value of the Company.
Email String The Email value of the Company.
StateName String The StateName value of the Company.
PINCode String The PINCode value of the Company.
PhoneNumber String The PhoneNumber value of the Company.
CMPEmployerId String The CMPEmployerId value of the Company.
FaxNumber String The FaxNumber value of the Company.
Website String The Website value of the Company.
IncomeTaxNumber String The IncomeTaxNumber value of the Company.
SalesTaxNumber String The SalesTaxNumber value of the Company.
InterStateSTNumber String The InterStateSTNumber value of the Company.
TANumber String The TANumber value of the Company.
VATTINNumber String The VATTINNumber value of the Company.
CompositeTIN String The CompositeTIN value of the Company.
EECDebtors String The EECDebtors value of the Company.
EECCreditors String The EECCreditors value of the Company.
CountryName String The CountryName value of the Company.
VATPymtPeriod String The VATPymtPeriod value of the Company.
CSTPymtPeriod String The CSTPymtPeriod value of the Company.
STPymtPeriod String The STPymtPeriod value of the Company.
TDSPymtPeriod String The TDSPymtPeriod value of the Company.
TCSPymtPeriod String The TCSPymtPeriod value of the Company.
PFPymtPeriod String The PFPymtPeriod value of the Company.
PTPymtPeriod String The PTPymtPeriod value of the Company.
ESIPymtPeriod String The ESIPymtPeriod value of the Company.
FBTPymtPeriod String The FBTPymtPeriod value of the Company.
FBTYearEndPymtPeriod String The FBTYearEndPymtPeriod value of the Company.
ITDeductorWard String The ITDeductorWard value of the Company.
ITDeductorRespPersonName String The ITDeductorRespPersonName value of the Company.
ITDeductorRespPersonFatherName String The ITDeductorRespPersonFatherName value of the Company.
ITDeductorRespPersonDesig String The ITDeductorRespPersonDesig value of the Company.
TANRegNo String The TANRegNo value of the Company.
VATFilingPeriodicity String The VATFilingPeriodicity value of the Company.
ITDeductorBranch String The ITDeductorBranch value of the Company.
ExciseRegn String The ExciseRegn value of the Company.
ExciseRange String The ExciseRange value of the Company.
ExciseRangeAddress String The ExciseRangeAddress value of the Company.
ExciseDivision String The ExciseDivision value of the Company.
ExciseDivisionAddress String The ExciseDivisionAddress value of the Company.
CMPIECCode String The CMPIECCode value of the Company.
ExciseAssesseeType String The ExciseAssesseeType value of the Company.
ExciseCommissionerate String The ExciseCommissionerate value of the Company.
ExciseRangeCode String The ExciseRangeCode value of the Company.
ExciseDivisionCode String The ExciseDivisionCode value of the Company.
ExciseFocalBankCode String The ExciseFocalBankCode value of the Company.
ExciseFocalBankName String The ExciseFocalBankName value of the Company.
ExciseFocalBankAddr String The ExciseFocalBankAddr value of the Company.
STRegNumber String The STRegNumber value of the Company.
STAssesseeCode String The STAssesseeCode value of the Company.
STOrgType String The STOrgType value of the Company.
STMajorService String The STMajorService value of the Company.
STDivisionCode String The STDivisionCode value of the Company.
STDivisionName String The STDivisionName value of the Company.
STRangeCode String The STRangeCode value of the Company.
STRangeName String The STRangeName value of the Company.
STCommrtCode String The STCommrtCode value of the Company.
STCommrtName String The STCommrtName value of the Company.
STFocalBankCode String The STFocalBankCode value of the Company.
STFocalBankName String The STFocalBankName value of the Company.
STFocalBankAddr String The STFocalBankAddr value of the Company.
STAdjExpenses String The STAdjExpenses value of the Company.
STLargeTaxPayerUnit String The STLargeTaxPayerUnit value of the Company.
STPremisesCodeNo String The STPremisesCodeNo value of the Company.
ServiceTaxLiabilityType String The ServiceTaxLiabilityType value of the Company.
RevChargeType String The RevChargeType value of the Company.
DeductorWard String The DeductorWard value of the Company.
DeductorStatus String The DeductorStatus value of the Company.
DeductorRespPersonName String The DeductorRespPersonName value of the Company.
DeductorRespPersonDesig String The DeductorRespPersonDesig value of the Company.
DeductorRespPersonFatherName String The DeductorRespPersonFatherName value of the Company.
HeadOfficeTANumber String The HeadOfficeTANumber value of the Company.
TDSDeductorType String The TDSDeductorType value of the Company.
PersonResponsiblePAN String The PersonResponsiblePAN value of the Company.
PersonResponsibleFlatNo String The PersonResponsibleFlatNo value of the Company.
PersonResponsiblePremises String The PersonResponsiblePremises value of the Company.
PersonResponsibleRoad String The PersonResponsibleRoad value of the Company.
PersonResponsibleArea String The PersonResponsibleArea value of the Company.
PersonResponsibleCity String The PersonResponsibleCity value of the Company.
PersonResponsibleState String The PersonResponsibleState value of the Company.
PersonResponsiblePincode String The PersonResponsiblePincode value of the Company.
PersonResponsibleMobile String The PersonResponsibleMobile value of the Company.
PersonResponsibleSTDCode String The PersonResponsibleSTDCode value of the Company.
PersonResponsiblePhone String The PersonResponsiblePhone value of the Company.
PersonResponsibleEMail String The PersonResponsibleEMail value of the Company.
PersonResponsibleAltSTDCode String The PersonResponsibleAltSTDCode value of the Company.
PersonResponsibleAltPhone String The PersonResponsibleAltPhone value of the Company.
PersonResponsibleAltEMail String The PersonResponsibleAltEMail value of the Company.
PersonResponsibleAltMobile String The PersonResponsibleAltMobile value of the Company.
DeductorResponsibleAltSTDCode String The DeductorResponsibleAltSTDCode value of the Company.
DeductorResponsibleAltPhone String The DeductorResponsibleAltPhone value of the Company.
DeductorResponsibleAltEMail String The DeductorResponsibleAltEMail value of the Company.
DeductorResponsibleAltMobile String The DeductorResponsibleAltMobile value of the Company.
ITDeductorRespPersonPAN String The ITDeductorRespPersonPAN value of the Company.
DeductorBranch String The DeductorBranch value of the Company.
CompanyFBTAssesseeType String The CompanyFBTAssesseeType value of the Company.
CompanyFBTAssesseeCategory String The CompanyFBTAssesseeCategory value of the Company.
CMPPFCode String The CMPPFCode value of the Company.
CMPPFAccountGroupCode String The CMPPFAccountGroupCode value of the Company.
CMPPFSecurityCode String The CMPPFSecurityCode value of the Company.
CMPESICode String The CMPESICode value of the Company.
CMPESIBranchOffice String The CMPESIBranchOffice value of the Company.
CMPESIWorkingDays String The CMPESIWorkingDays value of the Company.
XBRLCIN String The XBRLCIN value of the Company.
XBRLIndustryType String The XBRLIndustryType value of the Company.
LBTRegnNo String The LBTRegnNo value of the Company.
LBTZone String The LBTZone value of the Company.
EconomicActivityCode String The EconomicActivityCode value of the Company.
AuthorisedPersonName String The AuthorisedPersonName value of the Company.
AuthorisedPersonDesignation String The AuthorisedPersonDesignation value of the Company.
AuthorisedPlace String The AuthorisedPlace value of the Company.
CircleSector String The CircleSector value of the Company.
CircleDivision String The CircleDivision value of the Company.
ExportImportCode String The ExportImportCode value of the Company.
TaxAuthorisedPerson String The TaxAuthorisedPerson value of the Company.
CircleWard String The CircleWard value of the Company.
VATReturnForm String The VATReturnForm value of the Company.
GSTRegistrationNumber String The GSTRegistrationNumber value of the Company.
GSTRegistrationType String The GSTRegistrationType value of the Company.
CmpTypeOfSupply String The CmpTypeOfSupply value of the Company.
CompanyNameNative String The CompanyNameNative value of the Company.
CompanyEmirateNative String The CompanyEmirateNative value of the Company.
CompanyCountryNative String The CompanyCountryNative value of the Company.
VATDealerType String The VATDealerType value of the Company.
ConnectName String The ConnectName value of the Company.
SMSShortCode String The SMSShortCode value of the Company.
SMSPrefix String The SMSPrefix value of the Company.
CompanyContactPerson String The CompanyContactPerson value of the Company.
CompanyContactNumber String The CompanyContactNumber value of the Company.
CompanySMSName String The CompanySMSName value of the Company.
LogoPath String The LogoPath value of the Company.
CompanyChequeName String The CompanyChequeName value of the Company.
TDSNatureOfPayment String The TDSNatureOfPayment value of the Company.
TCSNatureofGood String The TCSNatureofGood value of the Company.
CRNumber String The CRNumber value of the Company.
BranchCRNumber String The BranchCRNumber value of the Company.
ShowBankDetails String The ShowBankDetails value of the Company.
GenerateBatchesOn String The GenerateBatchesOn value of the Company.
UploadLastRefresh String The UploadLastRefresh value of the Company.
IsAggregate String The IsAggregate value of the Company.
IndianVat String The IndianVat value of the Company.
IsVATRegdDealer String The IsVATRegdDealer value of the Company.
IsVATCompositeDealer String The IsVATCompositeDealer value of the Company.
IsDaywiseCashAggregate String The IsDaywiseCashAggregate value of the Company.
ITDeductorType String The ITDeductorType value of the Company.
IsAuditWorkingPaperOn String The IsAuditWorkingPaperOn value of the Company.
IsAuditCategoryOn String The IsAuditCategoryOn value of the Company.
IsRoundOffExceOn String The IsRoundOffExceOn value of the Company.
IsCSTWithAddlTax String The IsCSTWithAddlTax value of the Company.
IsSalesTaxCessOn String The IsSalesTaxCessOn value of the Company.
IsExciseClassificationOn String The IsExciseClassificationOn value of the Company.
STIsSTLargeTaxPayer String The STIsSTLargeTaxPayer value of the Company.
STXIsRoundOffApplicable String The STXIsRoundOffApplicable value of the Company.
ServiceTaxIsSEZ String The ServiceTaxIsSEZ value of the Company.
STIsMultiUnit String The STIsMultiUnit value of the Company.
STUserDefinedClass String The STUserDefinedClass value of the Company.
STIsInputServDistributor String The STIsInputServDistributor value of the Company.
IsSTStockItemOn String The IsSTStockItemOn value of the Company.
IsReverseApplicable String The IsReverseApplicable value of the Company.
STIsMonthlyReturns String The STIsMonthlyReturns value of the Company.
DeductorType String The DeductorType value of the Company.
IgnoreITExemption String The IgnoreITExemption value of the Company.
IgnoreTCSITExemption String The IgnoreTCSITExemption value of the Company.
IsTDSStockItemOn String The IsTDSStockItemOn value of the Company.
IsFBTSurchargeApplicable String The IsFBTSurchargeApplicable value of the Company.
XBRLIsConsolidatedRepType String The XBRLIsConsolidatedRepType value of the Company.
IsLBTOn String The IsLBTOn value of the Company.
IsVATClassOn String The IsVATClassOn value of the Company.
IsMRPOn String The IsMRPOn value of the Company.
IsRevisedAnnexureOn String The IsRevisedAnnexureOn value of the Company.
EnableVATOnItemRate String The EnableVATOnItemRate value of the Company.
EnableVATOnQuantity String The EnableVATOnQuantity value of the Company.
IsInZRBasicServices String The IsInZRBasicServices value of the Company.
IsDesignatedZone String The IsDesignatedZone value of the Company.
STMaintainSepAccForExempt String The STMaintainSepAccForExempt value of the Company.
IsDeviceDetailsReq String The IsDeviceDetailsReq value of the Company.
CMPIsUnderNPVScheme String The CMPIsUnderNPVScheme value of the Company.
IsSecurityOn String The IsSecurityOn value of the Company.
IsAccountingOn String The IsAccountingOn value of the Company.
IsInventoryOn String The IsInventoryOn value of the Company.
IsIntegrated String The IsIntegrated value of the Company.
IsBillWiseOn String The IsBillWiseOn value of the Company.
IsAllBillWiseOn String The IsAllBillWiseOn value of the Company.
IsCostCentresOn String The IsCostCentresOn value of the Company.
IsCostCategoryOn String The IsCostCategoryOn value of the Company.
IsStockCategoryOn String The IsStockCategoryOn value of the Company.
IsBatchWiseOn String The IsBatchWiseOn value of the Company.
IsPerishableOn String The IsPerishableOn value of the Company.
IsMultiGodownOn String The IsMultiGodownOn value of the Company.
IsMultiCurrencyOn String The IsMultiCurrencyOn value of the Company.
IsInvoicingOn String The IsInvoicingOn value of the Company.
IsRevJrnlOn String The IsRevJrnlOn value of the Company.
IsRemindersOn String The IsRemindersOn value of the Company.
IsDCNoteOn String The IsDCNoteOn value of the Company.
IsRejectionOn String The IsRejectionOn value of the Company.
IsTrackingOn String The IsTrackingOn value of the Company.
IsExciseOn String The IsExciseOn value of the Company.
IsChqPrintingOn String The IsChqPrintingOn value of the Company.
DiffActualQty String The DiffActualQty value of the Company.
UseZeroEntries String The UseZeroEntries value of the Company.
AddlAmount String The AddlAmount value of the Company.
IsTallyAuditOn String The IsTallyAuditOn value of the Company.
IsBudgetsOn String The IsBudgetsOn value of the Company.
IsPayrollOn String The IsPayrollOn value of the Company.
IsTDSOn String The IsTDSOn value of the Company.
IsServiceTaxOn String The IsServiceTaxOn value of the Company.
IsJobCostingOn String The IsJobCostingOn value of the Company.
IsTCSOn String The IsTCSOn value of the Company.
IsExciseReportsOn String The IsExciseReportsOn value of the Company.
IsCompositeDealer String The IsCompositeDealer value of the Company.
IsBOMOn String The IsBOMOn value of the Company.
IsSalesOrdersOn String The IsSalesOrdersOn value of the Company.
IsPurcOrdersOn String The IsPurcOrdersOn value of the Company.
IsDiscountsOn String The IsDiscountsOn value of the Company.
CNoteAsInvoice String The CNoteAsInvoice value of the Company.
UKVATReturns String The UKVATReturns value of the Company.
UsePriceLevels String The UsePriceLevels value of the Company.
IsInterestOn String The IsInterestOn value of the Company.
IsAdvInterestOn String The IsAdvInterestOn value of the Company.
PurcAsInvoice String The PurcAsInvoice value of the Company.
UseAutoCost String The UseAutoCost value of the Company.
DNoteAsInvoice String The DNoteAsInvoice value of the Company.
PLasIncomeExpense String The PLasIncomeExpense value of the Company.
AllowinMobile String The AllowinMobile value of the Company.
IsIndentOn String The IsIndentOn value of the Company.
IsFBTOn String The IsFBTOn value of the Company.
IsExciseMfgrTraderOn String The IsExciseMfgrTraderOn value of the Company.
IsSalesTaxOn String The IsSalesTaxOn value of the Company.
IsPayrollStatOn String The IsPayrollStatOn value of the Company.
ConnectCompany String The ConnectCompany value of the Company.
ConnectCompanyOnLoad String The ConnectCompanyOnLoad value of the Company.
IsEntryTaxApplicable String The IsEntryTaxApplicable value of the Company.
RevenueLedForOpBal String The RevenueLedForOpBal value of the Company.
EnableSMSAccess String The EnableSMSAccess value of the Company.
IsRcptsPymtsOn String The IsRcptsPymtsOn value of the Company.
IsLogoEnabled String The IsLogoEnabled value of the Company.
IsXBRLOn String The IsXBRLOn value of the Company.
IsProprietorship String The IsProprietorship value of the Company.
IsYearWise String The IsYearWise value of the Company.
IsCmpLTUOn String The IsCmpLTUOn value of the Company.
IsGSTOn String The IsGSTOn value of the Company.
IsGSTClassifOn String The IsGSTClassifOn value of the Company.
IsDisallowInEduMode String The IsDisallowInEduMode value of the Company.
IsMultiAddressOn String The IsMultiAddressOn value of the Company.
IsEbankingOn String The IsEbankingOn value of the Company.
IsJobWorkOn String The IsJobWorkOn value of the Company.
IsMaterialTransferOn String The IsMaterialTransferOn value of the Company.
IsCostTrackingOn String The IsCostTrackingOn value of the Company.
EnablePwdPolicy String The EnablePwdPolicy value of the Company.
RestrictPwdReuse String The RestrictPwdReuse value of the Company.
ResetPwdOnFirstLogin String The ResetPwdOnFirstLogin value of the Company.
AllowPwdReset String The AllowPwdReset value of the Company.
NotifyOfExpiry String The NotifyOfExpiry value of the Company.
IsDefPwdPolicyAltered String The IsDefPwdPolicyAltered value of the Company.
IsBankingVchMigrated String The IsBankingVchMigrated value of the Company.
IsBeneficiaryCodeOn String The IsBeneficiaryCodeOn value of the Company.
IsTransferModeOn String The IsTransferModeOn value of the Company.
IsBankingforCCOn String The IsBankingforCCOn value of the Company.
IsImpBankDetailsOn String The IsImpBankDetailsOn value of the Company.
IsApprovalOn String The IsApprovalOn value of the Company.
IsExportOnVchCreate String The IsExportOnVchCreate value of the Company.
IsExportWithErrors String The IsExportWithErrors value of the Company.
IsResetBankStatus String The IsResetBankStatus value of the Company.
IsISOCurrencyApplicable String The IsISOCurrencyApplicable value of the Company.
IsIgnoreWithWarnings String The IsIgnoreWithWarnings value of the Company.
IsFIFOApplied String The IsFIFOApplied value of the Company.
IsTrackVouchersOn String The IsTrackVouchersOn value of the Company.
ResetTrackedChanges String The ResetTrackedChanges value of the Company.
CompanyNumber Decimal The CompanyNumber value of the Company.
StatutoryVersion Decimal The StatutoryVersion value of the Company.
VATPymtDueDate Decimal The VATPymtDueDate value of the Company.
CSTPymtDueDate Decimal The CSTPymtDueDate value of the Company.
STPymtDueDate Decimal The STPymtDueDate value of the Company.
TDSPymtDueDate Decimal The TDSPymtDueDate value of the Company.
TCSPymtDueDate Decimal The TCSPymtDueDate value of the Company.
PFPymtDueDate Decimal The PFPymtDueDate value of the Company.
PTPymtDueDate Decimal The PTPymtDueDate value of the Company.
ESIPymtDueDate Decimal The ESIPymtDueDate value of the Company.
FBTPymtDueDate Decimal The FBTPymtDueDate value of the Company.
FBTYearEndPymtDueDate Decimal The FBTYearEndPymtDueDate value of the Company.
STCrAdjPercent Decimal The STCrAdjPercent value of the Company.
CmpTaxAmountTolerence Decimal The CmpTaxAmountTolerence value of the Company.
PwdLength Decimal The PwdLength value of the Company.
LettersInPwd Decimal The LettersInPwd value of the Company.
NumeralsInPwd Decimal The NumeralsInPwd value of the Company.
SpclCharsInPwd Decimal The SpclCharsInPwd value of the Company.
PwdHistory Decimal The PwdHistory value of the Company.
PwdExpiry Decimal The PwdExpiry value of the Company.
ExpiryNotifPeriod Decimal The ExpiryNotifPeriod value of the Company.
NACHVersion Decimal The NACHVersion value of the Company.
MaxCashValue String The MaxCashValue value of the Company.
MinCashValue String The MinCashValue value of the Company.
CMPESIEligibleAmount String The CMPESIEligibleAmount value of the Company.
RTGSLimit String The RTGSLimit value of the Company.
Address String The Address value of the Company.
CompanyAddressNative String The CompanyAddressNative value of the Company.
PriceLevel String The PriceLevel value of the Company.
MobileNumbers String The MobileNumbers value of the Company.
UserAccountIds Decimal The UserAccountIds value of the Company.
Dbname String The Dbname value of the Company.
Thisyearbeg Date The Thisyearbeg value of the Company.
Thisyearend Date The Thisyearend value of the Company.
Prevyearbeg Date The Prevyearbeg value of the Company.
Prevyearend Date The Prevyearend value of the Company.
Thisquarterbeg Date The Thisquarterbeg value of the Company.
Thisquarterend Date The Thisquarterend value of the Company.
Prevquarterbeg Date The Prevquarterbeg value of the Company.
Prevquarterend Date The Prevquarterend value of the Company.
Name String The Name value of the Company.
Address1 String The Address1 value of the Company.
Address2 String The Address2 value of the Company.
Address3 String The Address3 value of the Company.
Address4 String The Address4 value of the Company.
Address5 String The Address5 value of the Company.
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.

Employees

Retrieve Employee Details.

Table Specific Information
Select

The connector will use the Tally API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.

  • String supports the '=, !=,<, <=, >, >=, LIKE, ORDER BY' comparisons.

For example these queries are processed server side:

SELECT * FROM Employees WHERE EMailID LIKE '%cdata%'

SELECT * FROM Employees WHERE BloodGroup != 'A Positive'

SELECT * FROM Employees WHERE Gender = 'Male' AND FatherName >= 'abc'

SELECT * FROM Employees WHERE BankBranch = 'Delhi' OR BankBranch = 'Bangalore'

SELECT * FROM Employees WHERE ForPayroll > 'No'

SELECT * FROM Employees ORDER BY Guid ASC
Columns
Name Type Description
Name String The Name value of the Employees.
ActiveFrom Date The ActiveFrom value of the Employees.
ActiveTo Date The ActiveTo value of the Employees.
DateOfBirth Date The DateOfBirth value of the Employees.
DateOfJoin Date The DateOfJoin value of the Employees.
DeactivationDate Date The DeactivationDate value of the Employees.
VisaExpiryDate Date The VisaExpiryDate value of the Employees.
ContractStartDate Date The ContractStartDate value of the Employees.
ContractExpiryDate Date The ContractExpiryDate value of the Employees.
PassportExpiryDate Date The PassportExpiryDate value of the Employees.
PFJoiningDate Date The PFJoiningDate value of the Employees.
PFRelievingDate Date The PFRelievingDate value of the Employees.
IdentityExpiryDate Date The IdentityExpiryDate value of the Employees.
Guid String The Guid value of the Employees.
Parent String The Parent value of the Employees.
Category String The Category value of the Employees.
MobileNumber String The MobileNumber value of the Employees.
MICRCode String The MICRCode value of the Employees.
IFSCode String The IFSCode value of the Employees.
Narration String The Narration value of the Employees.
RemoteGUID String The RemoteGUID value of the Employees.
RemoteAltGUID String The RemoteAltGUID value of the Employees.
RequestorRule String The RequestorRule value of the Employees.
BankDetails String The BankDetails value of the Employees.
BankDetailsBankID String The BankDetailsBankID value of the Employees.
Function String The Function value of the Employees.
Location String The Location value of the Employees.
Designation String The Designation value of the Employees.
PFAccountNumber String The PFAccountNumber value of the Employees.
PanNumber String The PanNumber value of the Employees.
ESINumber String The ESINumber value of the Employees.
PassportDetails String The PassportDetails value of the Employees.
Gender String The Gender value of the Employees.
BloodGroup String The BloodGroup value of the Employees.
FatherName String The FatherName value of the Employees.
ContactNumbers String The ContactNumbers value of the Employees.
EMailID String The EMailID value of the Employees.
BankAccountNumber String The BankAccountNumber value of the Employees.
BankBranch String The BankBranch value of the Employees.
VisaNumber String The VisaNumber value of the Employees.
WorkPermitNumber String The WorkPermitNumber value of the Employees.
CountryofIssue String The CountryofIssue value of the Employees.
SpouseName String The SpouseName value of the Employees.
FPFAccountNumber String The FPFAccountNumber value of the Employees.
ReasonsForLeaving String The ReasonsForLeaving value of the Employees.
ESIDispensaryName String The ESIDispensaryName value of the Employees.
EmpDisplayName String The EmpDisplayName value of the Employees.
IdentityNumber String The IdentityNumber value of the Employees.
PRAccountNumber String The PRAccountNumber value of the Employees.
AadharNumber String The AadharNumber value of the Employees.
UANNumber String The UANNumber value of the Employees.
RevenueLedForOpBal String The RevenueLedForOpBal value of the Employees.
IsMstFromSync String The IsMstFromSync value of the Employees.
IsUpdatingTargetId String The IsUpdatingTargetId value of the Employees.
AsOriginal String The AsOriginal value of the Employees.
AffectsStock String The AffectsStock value of the Employees.
ForPayroll String The ForPayroll value of the Employees.
ForJobCosting String The ForJobCosting value of the Employees.
IsEmployeeGroup String The IsEmployeeGroup value of the Employees.
SortPosition Decimal The SortPosition value of the Employees.
Alterid Decimal The Alterid value of the Employees.
RemoteAlterID Decimal The RemoteAlterID value of the Employees.
DefaultLanguage Decimal The DefaultLanguage value of the Employees.
Address String The Address value of the Employees.
MailingName String The MailingName value of the Employees.
TargetRemoteId String The $TargetRemoteId value of the Employees.
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.

Ledger

Retrieve Ledger Details.

Table Specific Information
Select

The connector will use the Tally API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.

  • String supports the '=, !=,<, <=, >, >=, LIKE, ORDER BY' comparisons.

For example these queries are processed server side:

SELECT * FROM Ledger WHERE TaxType LIKE '%GST%'

SELECT * FROM Ledger WHERE GSTType != 'Applicable'

SELECT * FROM Ledger WHERE GSTTypeofSupply = 'Goods' AND GSTDutyHead = 'Central Tax'

SELECT * FROM Ledger WHERE Parent = 'Sales Accounts' OR Parent = 'Bank Accounts'

SELECT * FROM Ledger WHERE IsChequePrintingEnabled > 'No'

SELECT * FROM Ledger ORDER BY Guid Desc
Columns
Name Type Description
Name String The Name value of the Ledger.
StartingFrom Date The StartingFrom value of the Ledger.
STRegDate Date The STRegDate value of the Ledger.
LBTRegnDate Date The LBTRegnDate value of the Ledger.
SamplingDateOneFactor Date The SamplingDateOneFactor value of the Ledger.
SamplingDateTwoFactor Date The SamplingDateTwoFactor value of the Ledger.
ActiveFrom Date The ActiveFrom value of the Ledger.
ActiveTo Date The ActiveTo value of the Ledger.
CreatedDate Date The CreatedDate value of the Ledger.
AlteredOn Date The AlteredOn value of the Ledger.
VATApplicableDate Date The VATApplicableDate value of the Ledger.
ExciseRegistrationDate Date The ExciseRegistrationDate value of the Ledger.
PANApplicableFrom Date The PANApplicableFrom value of the Ledger.
PayInsRunningFileDate Date The PayInsRunningFileDate value of the Ledger.
VATTaxExemptionDate Date The VATTaxExemptionDate value of the Ledger.
Guid String The Guid value of the Ledger.
CurrencyName String The CurrencyName value of the Ledger.
Email String The Email value of the Ledger.
StateName String The StateName value of the Ledger.
PINCode String The PINCode value of the Ledger.
Website String The Website value of the Ledger.
IncomeTaxNumber String The IncomeTaxNumber value of the Ledger.
SalesTaxNumber String The SalesTaxNumber value of the Ledger.
InterStateSTNumber String The InterStateSTNumber value of the Ledger.
VATTINNumber String The VATTINNumber value of the Ledger.
CountryName String The CountryName value of the Ledger.
ExciseRange String The ExciseRange value of the Ledger.
ExciseDivision String The ExciseDivision value of the Ledger.
ExciseCommissionerate String The ExciseCommissionerate value of the Ledger.
LBTRegnNo String The LBTRegnNo value of the Ledger.
LBTZone String The LBTZone value of the Ledger.
ExportImportCode String The ExportImportCode value of the Ledger.
GSTRegistrationType String The GSTRegistrationType value of the Ledger.
VATDealerType String The VATDealerType value of the Ledger.
PriceLevel String The PriceLevel value of the Ledger.
UploadLastRefresh String The UploadLastRefresh value of the Ledger.
Parent String The Parent value of the Ledger.
SamplingMethod String The SamplingMethod value of the Ledger.
SamplingStrOneFactor String The SamplingStrOneFactor value of the Ledger.
IFSCode String The IFSCode value of the Ledger.
Narration String The Narration value of the Ledger.
RemoteGUID String The RemoteGUID value of the Ledger.
RemoteAltGUID String The RemoteAltGUID value of the Ledger.
RequestorRule String The RequestorRule value of the Ledger.
GrpDebitParent String The GrpDebitParent value of the Ledger.
GrpCreditParent String The GrpCreditParent value of the Ledger.
SysDebitParent String The SysDebitParent value of the Ledger.
SysCreditParent String The SysCreditParent value of the Ledger.
TDSApplicable String The TDSApplicable value of the Ledger.
TCSApplicable String The TCSApplicable value of the Ledger.
GSTApplicable String The GSTApplicable value of the Ledger.
CreatedBy String The CreatedBy value of the Ledger.
AlteredBy String The AlteredBy value of the Ledger.
TaxClassificationName String The TaxClassificationName value of the Ledger.
TaxType String The TaxType value of the Ledger.
BillCreditPeriod String The BillCreditPeriod value of the Ledger.
BankDetails String The BankDetails value of the Ledger.
BankBranchName String The BankBranchName value of the Ledger.
BankBSRCode String The BankBSRCode value of the Ledger.
DeducteeType String The DeducteeType value of the Ledger.
BusinessType String The BusinessType value of the Ledger.
TypeOfNotification String The TypeOfNotification value of the Ledger.
MSMERegNumber String The MSMERegNumber value of the Ledger.
CountryofResidence String The CountryofResidence value of the Ledger.
RelatedPartyId String The RelatedPartyId value of the Ledger.
RelPartyIssuingAuthority String The RelPartyIssuingAuthority value of the Ledger.
ImporterExporterCode String The ImporterExporterCode value of the Ledger.
EMailCC String The EMailCC value of the Ledger.
Description String The Description value of the Ledger.
LedAddlAllocType String The LedAddlAllocType value of the Ledger.
TransporterId String The TransporterId value of the Ledger.
LedgerPhone String The LedgerPhone value of the Ledger.
LedgerFax String The LedgerFax value of the Ledger.
LedgerContact String The LedgerContact value of the Ledger.
LedgerMobile String The LedgerMobile value of the Ledger.
RelationType String The RelationType value of the Ledger.
MailingNameNative String The MailingNameNative value of the Ledger.
StateNameNative String The StateNameNative value of the Ledger.
CountryNameNative String The CountryNameNative value of the Ledger.
BasicTypeOfDuty String The BasicTypeOfDuty value of the Ledger.
GSTType String The GSTType value of the Ledger.
ExemptionType String The ExemptionType value of the Ledger.
AppropriateFor String The AppropriateFor value of the Ledger.
SubTaxType String The SubTaxType value of the Ledger.
STXNatureOfParty String The STXNatureOfParty value of the Ledger.
NameOnPAN String The NameOnPAN value of the Ledger.
UsedForTaxType String The UsedForTaxType value of the Ledger.
eCommMerchantID String The eCommMerchantID value of the Ledger.
PartyGSTIN String The PartyGSTIN value of the Ledger.
GSTDutyHead String The GSTDutyHead value of the Ledger.
GSTAppropriateTo String The GSTAppropriateTo value of the Ledger.
GSTTypeofSupply String The GSTTypeofSupply value of the Ledger.
GSTNatureofSupply String The GSTNatureofSupply value of the Ledger.
CessValuationMethod String The CessValuationMethod value of the Ledger.
PayType String The PayType value of the Ledger.
PayslipName String The PayslipName value of the Ledger.
AttendanceType String The AttendanceType value of the Ledger.
LeaveType String The LeaveType value of the Ledger.
CalculationPeriod String The CalculationPeriod value of the Ledger.
RoundingMethod String The RoundingMethod value of the Ledger.
ComputationType String The ComputationType value of the Ledger.
CalculationType String The CalculationType value of the Ledger.
PayStatType String The PayStatType value of the Ledger.
ProfessionalTaxNumber String The ProfessionalTaxNumber value of the Ledger.
UserDefinedCalenderType String The UserDefinedCalenderType value of the Ledger.
ITNature String The ITNature value of the Ledger.
ITComponent String The ITComponent value of the Ledger.
NotificationNumber String The NotificationNumber value of the Ledger.
RegistrationNumber String The RegistrationNumber value of the Ledger.
ServiceCategory String The ServiceCategory value of the Ledger.
AbatementNotificationNo String The AbatementNotificationNo value of the Ledger.
STXDutyHead String The STXDutyHead value of the Ledger.
STXClassification String The STXClassification value of the Ledger.
NotificationSlNo String The NotificationSlNo value of the Ledger.
ServiceTaxApplicable String The ServiceTaxApplicable value of the Ledger.
ExciseLedgerClassification String The ExciseLedgerClassification value of the Ledger.
ExciseRegistrationNumber String The ExciseRegistrationNumber value of the Ledger.
ExciseAccountHead String The ExciseAccountHead value of the Ledger.
ExciseDutyType String The ExciseDutyType value of the Ledger.
ExciseDutyHeadCode String The ExciseDutyHeadCode value of the Ledger.
ExciseAllocType String The ExciseAllocType value of the Ledger.
ExciseDutyHead String The ExciseDutyHead value of the Ledger.
NatureOfSales String The NatureOfSales value of the Ledger.
ExciseNotificationNo String The ExciseNotificationNo value of the Ledger.
ExciseImportsRegistartionNo String The ExciseImportsRegistartionNo value of the Ledger.
ExciseApplicability String The ExciseApplicability value of the Ledger.
ExciseTypeofBranch String The ExciseTypeofBranch value of the Ledger.
ExciseDefaultRemoval String The ExciseDefaultRemoval value of the Ledger.
ExciseNotificationSlNo String The ExciseNotificationSlNo value of the Ledger.
TypeOfTariff String The TypeOfTariff value of the Ledger.
ExciseRegNo String The ExciseRegNo value of the Ledger.
ExciseNatureofPurchase String The ExciseNatureofPurchase value of the Ledger.
TDSDeducteeTypeMst String The TDSDeducteeTypeMst value of the Ledger.
TdsRateName String The TdsRateName value of the Ledger.
TDSDeducteeSectionNumber String The TDSDeducteeSectionNumber value of the Ledger.
PANStatus String The PANStatus value of the Ledger.
DeducteeReference String The DeducteeReference value of the Ledger.
TDSDeducteeType String The TDSDeducteeType value of the Ledger.
ITExemptApplicable String The ITExemptApplicable value of the Ledger.
TaxIdentificationNo String The TaxIdentificationNo value of the Ledger.
LedgerFBTCategory String The LedgerFBTCategory value of the Ledger.
BranchCode String The BranchCode value of the Ledger.
ClientCode String The ClientCode value of the Ledger.
BankingConfigBank String The BankingConfigBank value of the Ledger.
BankingConfigBankID String The BankingConfigBankID value of the Ledger.
BankAccHolderName String The BankAccHolderName value of the Ledger.
UseForPOSType String The UseForPOSType value of the Ledger.
PaymentGateway String The PaymentGateway value of the Ledger.
TypeOfInterestOn String The TypeOfInterestOn value of the Ledger.
BankConfigIFSC String The BankConfigIFSC value of the Ledger.
BankConfigMICR String The BankConfigMICR value of the Ledger.
BankConfigShortCode String The BankConfigShortCode value of the Ledger.
PymtInstoutputName String The PymtInstoutputName value of the Ledger.
ProductCodeType String The ProductCodeType value of the Ledger.
SalaryPymtProductCode String The SalaryPymtProductCode value of the Ledger.
OtherPymtProductCode String The OtherPymtProductCode value of the Ledger.
PaymentInstLocation String The PaymentInstLocation value of the Ledger.
EncrptionLocation String The EncrptionLocation value of the Ledger.
NewIMFLocation String The NewIMFLocation value of the Ledger.
ImportedIMFLocation String The ImportedIMFLocation value of the Ledger.
BankNewStatements String The BankNewStatements value of the Ledger.
BankImportedStatements String The BankImportedStatements value of the Ledger.
BankMICR String The BankMICR value of the Ledger.
CorporateUserNoECS String The CorporateUserNoECS value of the Ledger.
CorporateUserNoACH String The CorporateUserNoACH value of the Ledger.
CorporateUserName String The CorporateUserName value of the Ledger.
IMFName String The IMFName value of the Ledger.
PayInsBatchName String The PayInsBatchName value of the Ledger.
LastUsedBatchName String The LastUsedBatchName value of the Ledger.
PayInsFileNumPeriod String The PayInsFileNumPeriod value of the Ledger.
EncryptedBy String The EncryptedBy value of the Ledger.
EncryptedId String The EncryptedId value of the Ledger.
ISOCurrencyCode String The ISOCurrencyCode value of the Ledger.
BankCapsuleID String The BankCapsuleID value of the Ledger.
SalesTaxCessApplicable String The SalesTaxCessApplicable value of the Ledger.
BankIBAN String The BankIBAN value of the Ledger.
VATTaxExemptionNature String The VATTaxExemptionNature value of the Ledger.
VATTaxExemptionNumber String The VATTaxExemptionNumber value of the Ledger.
LedStateName String The LedStateName value of the Ledger.
VATApplicable String The VATApplicable value of the Ledger.
PartyBusinessType String The PartyBusinessType value of the Ledger.
PartyBusinessStyle String The PartyBusinessStyle value of the Ledger.
IsBillWiseOn String The IsBillWiseOn value of the Ledger.
IsCostCentresOn String The IsCostCentresOn value of the Ledger.
IsInterestOn String The IsInterestOn value of the Ledger.
AllowinMobile String The AllowinMobile value of the Ledger.
IsCostTrackingOn String The IsCostTrackingOn value of the Ledger.
IsBeneficiaryCodeOn String The IsBeneficiaryCodeOn value of the Ledger.
IsMstFromSync String The IsMstFromSync value of the Ledger.
IsUpdatingTargetId String The IsUpdatingTargetId value of the Ledger.
AsOriginal String The AsOriginal value of the Ledger.
IsCondensed String The IsCondensed value of the Ledger.
AffectsStock String The AffectsStock value of the Ledger.
IsRateInclusiveVAT String The IsRateInclusiveVAT value of the Ledger.
ForPayroll String The ForPayroll value of the Ledger.
IsABCEnabled String The IsABCEnabled value of the Ledger.
IsCreditDaysChkOn String The IsCreditDaysChkOn value of the Ledger.
InterestonBillwise String The InterestonBillwise value of the Ledger.
OverrideInterest String The OverrideInterest value of the Ledger.
OverrideAdvInterest String The OverrideAdvInterest value of the Ledger.
UseForVAT String The UseForVAT value of the Ledger.
IgnoreTDSExempt String The IgnoreTDSExempt value of the Ledger.
IsTCSApplicable String The IsTCSApplicable value of the Ledger.
IsTDSApplicable String The IsTDSApplicable value of the Ledger.
IsFBTApplicable String The IsFBTApplicable value of the Ledger.
IsGSTApplicable String The IsGSTApplicable value of the Ledger.
IsExciseApplicable String The IsExciseApplicable value of the Ledger.
IsTDSExpense String The IsTDSExpense value of the Ledger.
IsEDLIApplicable String The IsEDLIApplicable value of the Ledger.
IsRelatedParty String The IsRelatedParty value of the Ledger.
UseForESIEligibility String The UseForESIEligibility value of the Ledger.
IsInterestInclLastDay String The IsInterestInclLastDay value of the Ledger.
AppropriateTaxValue String The AppropriateTaxValue value of the Ledger.
IsBehaveAsDuty String The IsBehaveAsDuty value of the Ledger.
InterestInclDayOfAddition String The InterestInclDayOfAddition value of the Ledger.
InterestInclDayOfDeduction String The InterestInclDayOfDeduction value of the Ledger.
IsOthTerritoryAssessee String The IsOthTerritoryAssessee value of the Ledger.
OverRideCreditLimit String The OverRideCreditLimit value of the Ledger.
IsAgainstFormC String The IsAgainstFormC value of the Ledger.
IsChequePrintingEnabled String The IsChequePrintingEnabled value of the Ledger.
IsPayUpLoad String The IsPayUpLoad value of the Ledger.
IsPayBatchOnlySAL String The IsPayBatchOnlySAL value of the Ledger.
IsBNFCodeSupported String The IsBNFCodeSupported value of the Ledger.
AllowExportWithErrors String The AllowExportWithErrors value of the Ledger.
ConsiderPurchaseforExport String The ConsiderPurchaseforExport value of the Ledger.
IsTransporter String The IsTransporter value of the Ledger.
UseForNotionalITC String The UseForNotionalITC value of the Ledger.
IseCommOperator String The IseCommOperator value of the Ledger.
ShowinPayslip String The ShowinPayslip value of the Ledger.
UseForGratuity String The UseForGratuity value of the Ledger.
IsTDSProjected String The IsTDSProjected value of the Ledger.
ForServiceTax String The ForServiceTax value of the Ledger.
IsInputCredit String The IsInputCredit value of the Ledger.
IsExempted String The IsExempted value of the Ledger.
IsAbatementApplicable String The IsAbatementApplicable value of the Ledger.
IsSTXParty String The IsSTXParty value of the Ledger.
IsSTXNonRealizedType String The IsSTXNonRealizedType value of the Ledger.
IsUsedForCVD String The IsUsedForCVD value of the Ledger.
LedBelongsToNonTaxable String The LedBelongsToNonTaxable value of the Ledger.
IsExciseMerchantExporter String The IsExciseMerchantExporter value of the Ledger.
IsPartyExempted String The IsPartyExempted value of the Ledger.
IsSEZParty String The IsSEZParty value of the Ledger.
TDSDeducteeIsSpecialRate String The TDSDeducteeIsSpecialRate value of the Ledger.
IseChequeSupported String The IseChequeSupported value of the Ledger.
IseDDSupported String The IseDDSupported value of the Ledger.
HaseChequeDeliveryMode String The HaseChequeDeliveryMode value of the Ledger.
HaseChequeDeliveryTo String The HaseChequeDeliveryTo value of the Ledger.
HaseChequePrintLocation String The HaseChequePrintLocation value of the Ledger.
HaseChequePayableLocation String The HaseChequePayableLocation value of the Ledger.
HaseChequeBankLocation String The HaseChequeBankLocation value of the Ledger.
HaseDDDeliveryMode String The HaseDDDeliveryMode value of the Ledger.
HaseDDDeliveryTo String The HaseDDDeliveryTo value of the Ledger.
HaseDDPrintLocation String The HaseDDPrintLocation value of the Ledger.
HaseDDPayableLocation String The HaseDDPayableLocation value of the Ledger.
HaseDDBankLocation String The HaseDDBankLocation value of the Ledger.
IseBankingEnabled String The IseBankingEnabled value of the Ledger.
IsExportFileEncrypted String The IsExportFileEncrypted value of the Ledger.
IsBatchEnabled String The IsBatchEnabled value of the Ledger.
IsProductCodeBased String The IsProductCodeBased value of the Ledger.
HaseDDCity String The HaseDDCity value of the Ledger.
HaseChequeCity String The HaseChequeCity value of the Ledger.
IsFileNameFormatSupported String The IsFileNameFormatSupported value of the Ledger.
HasClientCode String The HasClientCode value of the Ledger.
PayInsIsBatchApplicable String The PayInsIsBatchApplicable value of the Ledger.
PayInsIsFileNumApp String The PayInsIsFileNumApp value of the Ledger.
IsSalaryTransGroupedForBRS String The IsSalaryTransGroupedForBRS value of the Ledger.
IseBankingSupported String The IseBankingSupported value of the Ledger.
IsSCBUAE String The IsSCBUAE value of the Ledger.
IsBankStatusApp String The IsBankStatusApp value of the Ledger.
IsSalaryGrouped String The IsSalaryGrouped value of the Ledger.
UseForPurchaseTax String The UseForPurchaseTax value of the Ledger.
Audited String The Audited value of the Ledger.
SamplingNumOneFactor Decimal The SamplingNumOneFactor value of the Ledger.
SamplingNumTwoFactor Decimal The SamplingNumTwoFactor value of the Ledger.
SortPosition Decimal The SortPosition value of the Ledger.
Alterid Decimal The Alterid value of the Ledger.
RemoteAlterID Decimal The RemoteAlterID value of the Ledger.
DefaultLanguage Decimal The DefaultLanguage value of the Ledger.
RateofTaxCalculation Decimal The RateofTaxCalculation value of the Ledger.
GratuityMonthDays Decimal The GratuityMonthDays value of the Ledger.
GratuityLimitMonths Decimal The GratuityLimitMonths value of the Ledger.
CalculationBasis Decimal The CalculationBasis value of the Ledger.
RoundingLimit Decimal The RoundingLimit value of the Ledger.
AbatementPercentage Decimal The AbatementPercentage value of the Ledger.
TDSDeducteeSpecialRate Decimal The TDSDeducteeSpecialRate value of the Ledger.
BeneficiaryCodeMaxLength Decimal The BeneficiaryCodeMaxLength value of the Ledger.
eChequePrintLocationVersion Decimal The eChequePrintLocationVersion value of the Ledger.
eChequePayableLocationVersion Decimal The eChequePayableLocationVersion value of the Ledger.
eDDPrintLocationVersion Decimal The eDDPrintLocationVersion value of the Ledger.
eDDPayableLocationVersion Decimal The eDDPayableLocationVersion value of the Ledger.
PayInsRunningFileNum Decimal The PayInsRunningFileNum value of the Ledger.
TransactionTypeVersion Decimal The TransactionTypeVersion value of the Ledger.
PayInsFileNumLength Decimal The PayInsFileNumLength value of the Ledger.
SamplingAmtOneFactor String The SamplingAmtOneFactor value of the Ledger.
SamplingAmtTwoFactor String The SamplingAmtTwoFactor value of the Ledger.
OpeningBalance Decimal The OpeningBalance value of the Ledger.
CreditLimit String The CreditLimit value of the Ledger.
GratuityLimitAmount String The GratuityLimitAmount value of the Ledger.
ODLimit String The ODLimit value of the Ledger.
tempGSTCGSTRate Decimal The tempGSTCGSTRate value of the Ledger.
tempGSTSGSTRate Decimal The tempGSTSGSTRate value of the Ledger.
tempGSTIGSTRate Decimal The tempGSTIGSTRate value of the Ledger.
tempGSTStateCessRate Decimal The tempGSTStateCessRate value of the Ledger.
tempIsVATfieldsEdited String The tempIsVATfieldsEdited value of the Ledger.
tempApplDate Date The tempApplDate value of the Ledger.
tempClassification String The tempClassification value of the Ledger.
tempNature String The tempNature value of the Ledger.
tempPartyEntity String The tempPartyEntity value of the Ledger.
tempBusinessNature String The tempBusinessNature value of the Ledger.
tempVATRate Decimal The tempVATRate value of the Ledger.
tempAddlTax Decimal The tempAddlTax value of the Ledger.
tempCessOnVat Decimal The tempCessOnVat value of the Ledger.
tempTaxType String The tempTaxType value of the Ledger.
tempMajorCommodityName String The tempMajorCommodityName value of the Ledger.
tempCommodityName String The tempCommodityName value of the Ledger.
tempCommodityCode String The tempCommodityCode value of the Ledger.
tempSubCommodityCode String The tempSubCommodityCode value of the Ledger.
tempUOM String The tempUOM value of the Ledger.
tempTypeofGoods String The tempTypeofGoods value of the Ledger.
tempTradeName String The tempTradeName value of the Ledger.
tempGoodsNature String The tempGoodsNature value of the Ledger.
tempSchedule String The tempSchedule value of the Ledger.
tempScheduleslNo String The tempScheduleslNo value of the Ledger.
tempIsInvDetailsEnable String The tempIsInvDetailsEnable value of the Ledger.
tempLocalVATRate Decimal The tempLocalVATRate value of the Ledger.
tempValuationType String The tempValuationType value of the Ledger.
tempIsCalcOnQty String The tempIsCalcOnQty value of the Ledger.
tempIsSaletoLocalCitizen String The tempIsSaletoLocalCitizen value of the Ledger.
LEDIsTDSApplicableCurrLiab String The LEDIsTDSApplicableCurrLiab value of the Ledger.
IsProductCodeEdited String The IsProductCodeEdited value of the Ledger.
Address String The Address value of the Ledger.
MailingName String The MailingName value of the Ledger.
TargetRemoteId String The TargetRemoteId value of the Ledger.
AddressNative String The AddressNative value of the Ledger.
BankUserLoginID String The BankUserLoginID value of the Ledger.
OldAuditEntryIds Decimal The OldAuditEntryIds value of the Ledger.
Closingbalance Decimal The Closingbalance value of the Ledger.
Address1 String The Address1 value of the Ledger.
Address2 String The Address2 value of the Ledger.
Address3 String The Address3 value of the Ledger.
Address4 String The Address4 value of the Ledger.
Address5 String The Address5 value of the Ledger.
Primarygroup String The Primarygroup value of the Ledger.
Overduebills Decimal The Overduebills value of the Ledger.
Onaccountvalue String The Onaccountvalue value of the Ledger.
Cashinflow Decimal The Cashinflow value of the Ledger.
Cashoutflow Decimal The Cashoutflow value of the Ledger.
Performance Decimal The Performance value of the Ledger.
Drinterest Decimal The Drinterest value of the Ledger.
Crinterest String The Crinterest value of the Ledger.
Lastinterestdate Date The Lastinterestdate value of the Ledger.
Thisyearbalance Decimal The Thisyearbalance value of the Ledger.
Prevyearbalance String The Prevyearbalance value of the Ledger.
Thisquarterbalance Decimal The Thisquarterbalance value of the Ledger.
Prevquarterbalance String The Prevquarterbalance value of the Ledger.
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.

Payhead

Retrieve Payhead Details.

Table Specific Information
Select

The connector will use the Tally API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.

  • String supports the '=, !=,<, <=, >, >=, LIKE, ORDER BY' comparisons.

For example these queries are processed server side:

SELECT * FROM PayHead WHERE Parent LIKE '%Maruti%'

SELECT * FROM PayHead WHERE RemoteAltGUID != NULL

SELECT * FROM PayHead WHERE TCSApplicable = 'True' AND OpeningValue > '0.00'

SELECT * FROM PayHead WHERE BaseUnits = 'Nos' OR BaseUnits = 'POS'

SELECT * FROM PayHead ORDER BY BaseUnits Desc
Columns
Name Type Description
StartingFrom String The StartingFrom value of the Payhead.
STRegDate String The STRegDate value of the Payhead.
LBTRegnDate String The LBTRegnDate value of the Payhead.
SamplingDateOneFactor String The SamplingDateOneFactor value of the Payhead.
SamplingDateTwoFactor String The SamplingDateTwoFactor value of the Payhead.
ActiveFrom String The ActiveFrom value of the Payhead.
ActiveTo String The ActiveTo value of the Payhead.
CreatedDate String The CreatedDate value of the Payhead.
AlteredOn String The AlteredOn value of the Payhead.
VATApplicableDate String The VATApplicableDate value of the Payhead.
ExciseRegistrationDate String The ExciseRegistrationDate value of the Payhead.
PANApplicableFrom String The PANApplicableFrom value of the Payhead.
PayInsRunningFileDate String The PayInsRunningFileDate value of the Payhead.
VATTaxExemptionDate String The VATTaxExemptionDate value of the Payhead.
Name String The Name value of the Payhead.
Address String The Address value of the Payhead.
GUID String The GUID value of the Payhead.
CurrencyName String The CurrencyName value of the Payhead.
EMail String The EMail value of the Payhead.
StateName String The StateName value of the Payhead.
PINCode String The PINCode value of the Payhead.
Website String The Website value of the Payhead.
IncomeTaxNumber String The IncomeTaxNumber value of the Payhead.
SalesTaxNumber String The SalesTaxNumber value of the Payhead.
InterStateSTNumber String The InterStateSTNumber value of the Payhead.
VATTINNumber String The VATTINNumber value of the Payhead.
CountryName String The CountryName value of the Payhead.
ExciseRange String The ExciseRange value of the Payhead.
ExciseDivision String The ExciseDivision value of the Payhead.
ExciseCommissionerate String The ExciseCommissionerate value of the Payhead.
LBTRegnNo String The LBTRegnNo value of the Payhead.
LBTZone String The LBTZone value of the Payhead.
ExportImportCode String The ExportImportCode value of the Payhead.
GSTRegistrationType String The GSTRegistrationType value of the Payhead.
VATDealerType String The VATDealerType value of the Payhead.
PriceLevel String The PriceLevel value of the Payhead.
UploadLastRefresh String The UploadLastRefresh value of the Payhead.
Parent String The Parent value of the Payhead.
MailingName String The MailingName value of the Payhead.
SamplingMethod String The SamplingMethod value of the Payhead.
SamplingStrOneFactor String The SamplingStrOneFactor value of the Payhead.
IFSCode String The IFSCode value of the Payhead.
Narration String The Narration value of the Payhead.
RemoteGUID String The RemoteGUID value of the Payhead.
RemoteAltGUID String The RemoteAltGUID value of the Payhead.
TargetRemoteId String The TargetRemoteId value of the Payhead.
RequestorRule String The RequestorRule value of the Payhead.
GrpDebitParent String The GrpDebitParent value of the Payhead.
GrpCreditParent String The GrpCreditParent value of the Payhead.
SysDebitParent String The SysDebitParent value of the Payhead.
SysCreditParent String The SysCreditParent value of the Payhead.
TDSApplicable String The TDSApplicable value of the Payhead.
TCSApplicable String The TCSApplicable value of the Payhead.
GSTApplicable String The GSTApplicable value of the Payhead.
CreatedBy String The CreatedBy value of the Payhead.
AlteredBy String The AlteredBy value of the Payhead.
TaxClassificationName String The TaxClassificationName value of the Payhead.
TaxType String The TaxType value of the Payhead.
BillCreditPeriod String The BillCreditPeriod value of the Payhead.
BankDetails String The BankDetails value of the Payhead.
BankBranchName String The BankBranchName value of the Payhead.
BankBSRCode String The BankBSRCode value of the Payhead.
DeducteeType String The DeducteeType value of the Payhead.
BusinessType String The BusinessType value of the Payhead.
TypeOfNotification String The TypeOfNotification value of the Payhead.
MSMERegNumber String The MSMERegNumber value of the Payhead.
CountryofResidence String The CountryofResidence value of the Payhead.
RelatedPartyId String The RelatedPartyId value of the Payhead.
RelPartyIssuingAuthority String The RelPartyIssuingAuthority value of the Payhead.
ImporterExporterCode String The ImporterExporterCode value of the Payhead.
EmailCC String The EmailCC value of the Payhead.
Description String The Description value of the Payhead.
LedAddlAllocType String The LedAddlAllocType value of the Payhead.
TransporterId String The TransporterId value of the Payhead.
LedgerPhone String The LedgerPhone value of the Payhead.
LedgerFax String The LedgerFax value of the Payhead.
LedgerContact String The LedgerContact value of the Payhead.
LedgerMobile String The LedgerMobile value of the Payhead.
RelationType String The RelationType value of the Payhead.
MailingNameNative String The MailingNameNative value of the Payhead.
AddressNative String The AddressNative value of the Payhead.
StateNameNative String The StateNameNative value of the Payhead.
CountryNameNative String The CountryNameNative value of the Payhead.
BasicTypeOfDuty String The BasicTypeOfDuty value of the Payhead.
GSTType String The GSTType value of the Payhead.
ExemptionType String The ExemptionType value of the Payhead.
AppropriateFor String The AppropriateFor value of the Payhead.
SubTaxType String The SubTaxType value of the Payhead.
STXNatureOfParty String The STXNatureOfParty value of the Payhead.
NameOnPAN String The NameOnPAN value of the Payhead.
UsedForTaxType String The UsedForTaxType value of the Payhead.
eCommMerchantID String The eCommMerchantID value of the Payhead.
PartyGSTIN String The PartyGSTIN value of the Payhead.
GSTDutyHead String The GSTDutyHead value of the Payhead.
GSTAppropriateTo String The GSTAppropriateTo value of the Payhead.
GSTTypeofSupply String The GSTTypeofSupply value of the Payhead.
GSTNatureofSupply String The GSTNatureofSupply value of the Payhead.
CessValuationMethod String The CessValuationMethod value of the Payhead.
PayType String The PayType value of the Payhead.
PayslipName String The PayslipName value of the Payhead.
AttendanceType String The AttendanceType value of the Payhead.
LeaveType String The LeaveType value of the Payhead.
CalculationPeriod String The CalculationPeriod value of the Payhead.
RoundingMethod String The RoundingMethod value of the Payhead.
ComputationType String The ComputationType value of the Payhead.
CalculationType String The CalculationType value of the Payhead.
PayStatType String The PayStatType value of the Payhead.
ProfessionalTaxNumber String The ProfessionalTaxNumber value of the Payhead.
UserDefinedCalenderType String The UserDefinedCalenderType value of the Payhead.
ITNature String The ITNature value of the Payhead.
ITComponent String The ITComponent value of the Payhead.
NotificationNumber String The NotificationNumber value of the Payhead.
RegistrationNumber String The RegistrationNumber value of the Payhead.
ServiceCategory String The ServiceCategory value of the Payhead.
AbatementNotificationNo String The AbatementNotificationNo value of the Payhead.
STXDutyHead String The STXDutyHead value of the Payhead.
STXClassification String The STXClassification value of the Payhead.
NotificationSlNo String The NotificationSlNo value of the Payhead.
ServiceTaxApplicable String The ServiceTaxApplicable value of the Payhead.
ExciseLedgerClassification String The ExciseLedgerClassification value of the Payhead.
ExciseRegistrationNumber String The ExciseRegistrationNumber value of the Payhead.
ExciseAccountHead String The ExciseAccountHead value of the Payhead.
ExciseDutyType String The ExciseDutyType value of the Payhead.
ExciseDutyHeadCode String The ExciseDutyHeadCode value of the Payhead.
ExciseAllocType String The ExciseAllocType value of the Payhead.
ExciseDutyHead String The ExciseDutyHead value of the Payhead.
NatureOfSales String The NatureOfSales value of the Payhead.
ExciseNotificationNo String The ExciseNotificationNo value of the Payhead.
ExciseImportsRegistartionNo String The ExciseImportsRegistartionNo value of the Payhead.
ExciseApplicability String The ExciseApplicability value of the Payhead.
ExciseTypeofBranch String The ExciseTypeofBranch value of the Payhead.
ExciseDefaultRemoval String The ExciseDefaultRemoval value of the Payhead.
ExciseNotificationSlNo String The ExciseNotificationSlNo value of the Payhead.
TypeOfTariff String The TypeOfTariff value of the Payhead.
ExciseRegNo String The ExciseRegNo value of the Payhead.
ExciseNatureofPurchase String The ExciseNatureofPurchase value of the Payhead.
TDSDeducteeTypeMst String The TDSDeducteeTypeMst value of the Payhead.
TDSRateName String The TDSRateName value of the Payhead.
TDSDeducteeSectionNumber String The TDSDeducteeSectionNumber value of the Payhead.
PANStatus String The PANStatus value of the Payhead.
DeducteeReference String The DeducteeReference value of the Payhead.
TDSDeducteeType String The TDSDeducteeType value of the Payhead.
ITExemptApplicable String The ITExemptApplicable value of the Payhead.
TaxIdentificationNo String The TaxIdentificationNo value of the Payhead.
LedgerFBTCategory String The LedgerFBTCategory value of the Payhead.
BranchCode String The BranchCode value of the Payhead.
ClientCode String The ClientCode value of the Payhead.
BankingConfigBank String The BankingConfigBank value of the Payhead.
BankingConfigBankID String The BankingConfigBankID value of the Payhead.
BankAccHolderName String The BankAccHolderName value of the Payhead.
UseForPOSType String The UseForPOSType value of the Payhead.
PaymentGateway String The PaymentGateway value of the Payhead.
TypeOfInterestOn String The TypeOfInterestOn value of the Payhead.
BankConfigIFSC String The BankConfigIFSC value of the Payhead.
BankConfigMICR String The BankConfigMICR value of the Payhead.
BankConfigShortCode String The BankConfigShortCode value of the Payhead.
PymtInstoutputName String The PymtInstoutputName value of the Payhead.
ProductCodeType String The ProductCodeType value of the Payhead.
SalaryPymtProductCode String The SalaryPymtProductCode value of the Payhead.
OtherPymtProductCode String The OtherPymtProductCode value of the Payhead.
PaymentInstLocation String The PaymentInstLocation value of the Payhead.
EncrptionLocation String The EncrptionLocation value of the Payhead.
NewIMFLocation String The NewIMFLocation value of the Payhead.
ImportedIMFLocation String The ImportedIMFLocation value of the Payhead.
BankNewStatements String The BankNewStatements value of the Payhead.
BankImportedStatements String The BankImportedStatements value of the Payhead.
BankMICR String The BankMICR value of the Payhead.
CorporateUserNoECS String The CorporateUserNoECS value of the Payhead.
CorporateUserNoACH String The CorporateUserNoACH value of the Payhead.
CorporateUserName String The CorporateUserName value of the Payhead.
BankUserLoginID String The BankUserLoginID value of the Payhead.
IMFName String The IMFName value of the Payhead.
PayInsBatchName String The PayInsBatchName value of the Payhead.
LastUsedBatchName String The LastUsedBatchName value of the Payhead.
PayInsFileNumPeriod String The PayInsFileNumPeriod value of the Payhead.
EncryptedBy String The EncryptedBy value of the Payhead.
EncryptedId String The EncryptedId value of the Payhead.
ISOCurrencyCode String The ISOCurrencyCode value of the Payhead.
BankCapsuleID String The BankCapsuleID value of the Payhead.
SalesTaxCessApplicable String The SalesTaxCessApplicable value of the Payhead.
BankIBAN String The BankIBAN value of the Payhead.
VATTaxExemptionNature String The VATTaxExemptionNature value of the Payhead.
VATTaxExemptionNumber String The VATTaxExemptionNumber value of the Payhead.
LedStateName String The LedStateName value of the Payhead.
VATApplicable String The VATApplicable value of the Payhead.
PartyBusinessType String The PartyBusinessType value of the Payhead.
PartyBusinessStyle String The PartyBusinessStyle value of the Payhead.
IsBillWiseOn String The IsBillWiseOn value of the Payhead.
IsCostCentresOn String The IsCostCentresOn value of the Payhead.
IsInterestOn String The IsInterestOn value of the Payhead.
AllowinMobile String The AllowinMobile value of the Payhead.
IsCostTrackingOn String The IsCostTrackingOn value of the Payhead.
IsBeneficiaryCodeOn String The IsBeneficiaryCodeOn value of the Payhead.
IsMstFromSync String The IsMstFromSync value of the Payhead.
IsUpdatingTargetId String The IsUpdatingTargetId value of the Payhead.
AsOriginal String The AsOriginal value of the Payhead.
IsCondensed String The IsCondensed value of the Payhead.
AffectsStock String The AffectsStock value of the Payhead.
IsRateInclusiveVAT String The IsRateInclusiveVAT value of the Payhead.
ForPayroll String The ForPayroll value of the Payhead.
IsABCEnabled String The IsABCEnabled value of the Payhead.
IsCreditDaysChkOn String The IsCreditDaysChkOn value of the Payhead.
InterestonBillwise String The InterestonBillwise value of the Payhead.
OverrideInterest String The OverrideInterest value of the Payhead.
OverrideAdvInterest String The OverrideAdvInterest value of the Payhead.
UseForVAT String The UseForVAT value of the Payhead.
IgnoreTDSExempt String The IgnoreTDSExempt value of the Payhead.
IsTCSApplicable String The IsTCSApplicable value of the Payhead.
IsTDSApplicable String The IsTDSApplicable value of the Payhead.
IsFBTApplicable String The IsFBTApplicable value of the Payhead.
IsGSTApplicable String The IsGSTApplicable value of the Payhead.
IsExciseApplicable String The IsExciseApplicable value of the Payhead.
IsTDSExpense String The IsTDSExpense value of the Payhead.
IsEDLIApplicable String The IsEDLIApplicable value of the Payhead.
IsRelatedParty String The IsRelatedParty value of the Payhead.
UseForESIEligibility String The UseForESIEligibility value of the Payhead.
IsInterestInclLastDay String The IsInterestInclLastDay value of the Payhead.
AppropriateTaxValue String The AppropriateTaxValue value of the Payhead.
IsBehaveAsDuty String The IsBehaveAsDuty value of the Payhead.
InterestInclDayOfAddition String The InterestInclDayOfAddition value of the Payhead.
InterestInclDayOfDeduction String The InterestInclDayOfDeduction value of the Payhead.
IsOthTerritoryAssessee String The IsOthTerritoryAssessee value of the Payhead.
OverRideCreditLimit String The OverRideCreditLimit value of the Payhead.
IsAgainstFormC String The IsAgainstFormC value of the Payhead.
IsChequePrintingEnabled String The IsChequePrintingEnabled value of the Payhead.
IsPayUpLoad String The IsPayUpLoad value of the Payhead.
IsPayBatchOnlySAL String The IsPayBatchOnlySAL value of the Payhead.
IsBNFCodeSupported String The IsBNFCodeSupported value of the Payhead.
AllowExportWithErrors String The AllowExportWithErrors value of the Payhead.
ConsiderPurchaseforExport String The ConsiderPurchaseforExport value of the Payhead.
IsTransporter String The IsTransporter value of the Payhead.
UseForNotionalITC String The UseForNotionalITC value of the Payhead.
IseCommOperator String The IseCommOperator value of the Payhead.
ShowinPayslip String The ShowinPayslip value of the Payhead.
UseForGratuity String The UseForGratuity value of the Payhead.
IsTDSProjected String The IsTDSProjected value of the Payhead.
ForServiceTax String The ForServiceTax value of the Payhead.
IsInputCredit String The IsInputCredit value of the Payhead.
IsExempted String The IsExempted value of the Payhead.
IsAbatementApplicable String The IsAbatementApplicable value of the Payhead.
IsSTXParty String The IsSTXParty value of the Payhead.
IsSTXNonRealizedType String The IsSTXNonRealizedType value of the Payhead.
IsUsedForCVD String The IsUsedForCVD value of the Payhead.
LedBelongsToNonTaxable String The LedBelongsToNonTaxable value of the Payhead.
IsExciseMerchantExporter String The IsExciseMerchantExporter value of the Payhead.
IsPartyExempted String The IsPartyExempted value of the Payhead.
IsSEZParty String The IsSEZParty value of the Payhead.
TDSDeducteeIsSpecialRate String The TDSDeducteeIsSpecialRate value of the Payhead.
IseChequeSupported String The IseChequeSupported value of the Payhead.
IseDDSupported String The IseDDSupported value of the Payhead.
HaseChequeDeliveryMode String The HaseChequeDeliveryMode value of the Payhead.
HaseChequeDeliveryTo String The HaseChequeDeliveryTo value of the Payhead.
HaseChequePrintLocation String The HaseChequePrintLocation value of the Payhead.
HaseChequePayableLocation String The HaseChequePayableLocation value of the Payhead.
HaseChequeBankLocation String The HaseChequeBankLocation value of the Payhead.
HaseDDDeliveryMode String The HaseDDDeliveryMode value of the Payhead.
HaseDDDeliveryTo String The HaseDDDeliveryTo value of the Payhead.
HaseDDPrintLocation String The HaseDDPrintLocation value of the Payhead.
HaseDDPayableLocation String The HaseDDPayableLocation value of the Payhead.
HaseDDBankLocation String The HaseDDBankLocation value of the Payhead.
IsEBankingEnabled String The IsEBankingEnabled value of the Payhead.
IsExportFileEncrypted String The IsExportFileEncrypted value of the Payhead.
IsBatchEnabled String The IsBatchEnabled value of the Payhead.
IsProductCodeBased String The IsProductCodeBased value of the Payhead.
HaseDDCity String The HaseDDCity value of the Payhead.
HaseChequeCity String The HaseChequeCity value of the Payhead.
IsFileNameFormatSupported String The IsFileNameFormatSupported value of the Payhead.
HasClientCode String The HasClientCode value of the Payhead.
PayInsIsBatchApplicable String The PayInsIsBatchApplicable value of the Payhead.
PayInsIsFileNumApp String The PayInsIsFileNumApp value of the Payhead.
IsSalaryTransGroupedForBRS String The IsSalaryTransGroupedForBRS value of the Payhead.
IseBankingSupported String The IseBankingSupported value of the Payhead.
IsSCBUAE String The IsSCBUAE value of the Payhead.
IsBankStatusApp String The IsBankStatusApp value of the Payhead.
IsSalaryGrouped String The IsSalaryGrouped value of the Payhead.
UseForPurchaseTax String The UseForPurchaseTax value of the Payhead.
Audited String The Audited value of the Payhead.
SamplingNumOneFactor String The SamplingNumOneFactor value of the Payhead.
SamplingNumTwoFactor String The SamplingNumTwoFactor value of the Payhead.
SortPosition String The SortPosition value of the Payhead.
AlterID String The AlterID value of the Payhead.
RemoteAlterID String The RemoteAlterID value of the Payhead.
DefaultLanguage String The DefaultLanguage value of the Payhead.
OldAuditEntryIds String The OldAuditEntryIds value of the Payhead.
RateOfTaxCalculation String The RateOfTaxCalculation value of the Payhead.
GratuityMonthDays String The GratuityMonthDays value of the Payhead.
GratuityLimitMonths String The GratuityLimitMonths value of the Payhead.
CalculationBasis String The CalculationBasis value of the Payhead.
RoundingLimit String The RoundingLimit value of the Payhead.
AbatementPercentage String The AbatementPercentage value of the Payhead.
TDSDeducteeSpecialRate String The TDSDeducteeSpecialRate value of the Payhead.
BeneficiaryCodeMaxLength String The BeneficiaryCodeMaxLength value of the Payhead.
eChequePrintLocationVersion String The eChequePrintLocationVersion value of the Payhead.
eChequePayableLocationVersion String The eChequePayableLocationVersion value of the Payhead.
eDDPrintLocationVersion String The eDDPrintLocationVersion value of the Payhead.
eDDPayableLocationVersion String The eDDPayableLocationVersion value of the Payhead.
PayInsRunningFileNum String The PayInsRunningFileNum value of the Payhead.
TransactionTypeVersion String The TransactionTypeVersion value of the Payhead.
PayInsFileNumLength String The PayInsFileNumLength value of the Payhead.
SamplingAmtOneFactor String The SamplingAmtOneFactor value of the Payhead.
SamplingAmtTwoFactor String The SamplingAmtTwoFactor value of the Payhead.
OpeningBalance String The OpeningBalance value of the Payhead.
CreditLimit String The CreditLimit value of the Payhead.
GratuityLimitAmount String The GratuityLimitAmount value of the Payhead.
ODLimit String The ODLimit value of the Payhead.
Closingbalance String The Closingbalance value of the Payhead.
Address1 String The Address1 value of the Payhead.
Address2 String The Address2 value of the Payhead.
Address3 String The Address3 value of the Payhead.
Address4 String The Address4 value of the Payhead.
Address5 String The Address5 value of the Payhead.
Primarygroup String The Primarygroup value of the Payhead.
Overduebills String The Overduebills value of the Payhead.
Onaccountvalue String The Onaccountvalue value of the Payhead.
Cashinflow String The Cashinflow value of the Payhead.
Cashoutflow String The Cashoutflow value of the Payhead.
Performance String The Performance value of the Payhead.
Drinterest String The Drinterest value of the Payhead.
Crinterest String The Crinterest value of the Payhead.
Lastinterestdate String The Lastinterestdate value of the Payhead.
Thisyearbalance String The Thisyearbalance value of the Payhead.
Prevyearbalance String The Prevyearbalance value of the Payhead.
Thisquarterbalance String The Thisquarterbalance value of the Payhead.
Prevquarterbalance String The Prevquarterbalance value of the Payhead.
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.

PriceList

Retrieve PriceList.

Table Specific Information
Select

The connector will use the Tally API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.

  • String supports the '=, !=,<, <=, >, >=, LIKE, ORDER BY' comparisons.

For example these queries are processed server side:

SELECT * FROM PriceList WHERE Guid LIKE '%4da0-b84f5%'

SELECT * FROM PriceList WHERE RemoteGUID != NULL

SELECT * FROM PriceList WHERE GSTApplicable = 'Applicable' AND CostingMethod = 'Avg. Cost'

SELECT * FROM PriceList WHERE Parent = 'Ashok Leyland' OR Parent = 'Maruti Limited'

SELECT * FROM PriceList WHERE IsBatchWiseOn > 'No'

SELECT * FROM PriceList ORDER BY Guid Asc
Columns
Name Type Description
Name String The Name value of the PriceList.
ActiveFrom Date The ActiveFrom value of the PriceList.
ActiveTo Date The ActiveTo value of the PriceList.
Guid String The Guid value of the PriceList.
Parent String The Parent value of the PriceList.
Narration String The Narration value of the PriceList.
RemoteGUID String The RemoteGUID value of the PriceList.
RemoteAltGUID String The RemoteAltGUID value of the PriceList.
RequestorRule String The RequestorRule value of the PriceList.
TDSApplicable String The TDSApplicable value of the PriceList.
TCSApplicable String The TCSApplicable value of the PriceList.
GSTApplicable String The GSTApplicable value of the PriceList.
CostingMethod String The CostingMethod value of the PriceList.
ValuationMethod String The ValuationMethod value of the PriceList.
BaseUnits String The BaseUnits value of the PriceList.
AdditionalUnits String The AdditionalUnits value of the PriceList.
ExciseTaxType String The ExciseTaxType value of the PriceList.
IsBatchWiseOn String The IsBatchWiseOn value of the PriceList.
IsPerishableOn String The IsPerishableOn value of the PriceList.
IsAddable String The IsAddable value of the PriceList.
IsMstFromSync String The IsMstFromSync value of the PriceList.
IsUpdatingTargetId String The IsUpdatingTargetId value of the PriceList.
AsOriginal String The AsOriginal value of the PriceList.
IgnorePhysicalDifference String The IgnorePhysicalDifference value of the PriceList.
IgnoreNegativeStock String The IgnoreNegativeStock value of the PriceList.
TreatSalesasManufactured String The TreatSalesasManufactured value of the PriceList.
TreatPurchasesasConsumed String The TreatPurchasesasConsumed value of the PriceList.
TreatRejectsasScrap String The TreatRejectsasScrap value of the PriceList.
HasMfgDate String The HasMfgDate value of the PriceList.
AllowUseofExpiredItems String The AllowUseofExpiredItems value of the PriceList.
IgnoreBatches String The IgnoreBatches value of the PriceList.
IgnoreGodowns String The IgnoreGodowns value of the PriceList.
SortPosition Decimal The SortPosition value of the PriceList.
Alterid Decimal The Alterid value of the PriceList.
RemoteAlterID Decimal The RemoteAlterID value of the PriceList.
Denominator Decimal The Denominator value of the PriceList.
Conversion Decimal The Conversion value of the PriceList.
tempGSTCGSTRate Decimal The tempGSTCGSTRate value of the PriceList.
tempGSTSGSTRate Decimal The tempGSTSGSTRate value of the PriceList.
tempGSTIGSTRate Decimal The tempGSTIGSTRate value of the PriceList.
tempGSTStateCessRate Decimal The tempGSTStateCessRate value of the PriceList.
tempIsVATfieldsEdited String The tempIsVATfieldsEdited value of the PriceList.
tempApplDate Date The tempApplDate value of the PriceList.
tempClassification String The tempClassification value of the PriceList.
tempNature String The tempNature value of the PriceList.
tempPartyEntity String The tempPartyEntity value of the PriceList.
tempBusinessNature String The tempBusinessNature value of the PriceList.
tempVATRate Decimal The tempVATRate value of the PriceList.
tempAddlTax Decimal The tempAddlTax value of the PriceList.
tempCessOnVat Decimal The tempCessOnVat value of the PriceList.
tempTaxType String The tempTaxType value of the PriceList.
tempMajorCommodityName String The tempMajorCommodityName value of the PriceList.
tempCommodityName String The tempCommodityName value of the PriceList.
tempCommodityCode String The tempCommodityCode value of the PriceList.
tempSubCommodityCode String The tempSubCommodityCode value of the PriceList.
tempUOM String The tempUOM value of the PriceList.
tempTypeofGoods String The tempTypeofGoods value of the PriceList.
tempTradeName String The tempTradeName value of the PriceList.
tempGoodsNature String The tempGoodsNature value of the PriceList.
tempSchedule String The tempSchedule value of the PriceList.
tempScheduleslNo String The tempScheduleslNo value of the PriceList.
tempIsInvDetailsEnable String The tempIsInvDetailsEnable value of the PriceList.
tempValuationType String The tempValuationType value of the PriceList.
tempIsCalcOnQty String The tempIsCalcOnQty value of the PriceList.
tempMRPRate String The tempMRPRate value of the PriceList.
tempMRPApplDate Date The tempMRPApplDate value of the PriceList.
TargetRemoteId String The TargetRemoteId value of the PriceList.
Closingbalance String The Closingbalance value of the PriceList.
Inwardquantity String The Inwardquantity value of the PriceList.
Outwardquantity String The Outwardquantity value of the PriceList.
Closingvalue String The Closingvalue value of the PriceList.
Inwardvalue String The Inwardvalue value of the PriceList.
Outwardvalue String The Outwardvalue value of the PriceList.
Closingrate String The Closingrate value of the PriceList.
Lastsaledate String The Lastsaledate value of the PriceList.
Lastsaleparty String The Lastsaleparty value of the PriceList.
Lastsaleprice String The Lastsaleprice value of the PriceList.
Lastsaleqty String The Lastsaleqty value of the PriceList.
Lastpurcdate String The Lastpurcdate value of the PriceList.
Lastpurcparty String The Lastpurcparty value of the PriceList.
Lastpurcprice String The Lastpurcprice value of the PriceList.
Lastpurccost String The Lastpurccost value of the PriceList.
Lastpurcqty String The Lastpurcqty value of the PriceList.
Consumption String The Consumption value of the PriceList.
Thisyearbalance String The Thisyearbalance value of the PriceList.
Prevyearbalance String The Prevyearbalance value of the PriceList.
Thisquarterbalance String The Thisquarterbalance value of the PriceList.
Prevquarterbalance String The Prevquarterbalance value of the PriceList.
Baseunits String The Baseunits value of the PriceList.
Additionalunits String The Additionalunits value of the PriceList.
Conversion Decimal The Conversion value of the PriceList.
Openingbalance String The Openingbalance value of the PriceList.
Credittotals String The Credittotals value of the PriceList.
Debittotals String The Debittotals value of the PriceList.
Openingvalue String The Openingvalue value of the PriceList.
Denominator Decimal The Denominator value of the PriceList.
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.

Report_BalanceSheet

Balance Sheet Report of Tally

Columns
Name Type Description
Name String Name for Report BalanceSheet.
MainAmount Decimal Main amount for Report BalanceSheet.
SubAmount Decimal Sub amount for Report BalanceSheet.
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.

Report_BankGroupSummary

Bank Group Summary Report of Tally

Columns
Name Type Description
Name String Name for Report BankGroupSummary.
DebitAmount Decimal DebitAmount for Report BankGroupSummary.
CreditAmount Decimal CreditAmount for Report BankGroupSummary.
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.

Report_BillsPayable

Bills Payable Report of Tally

Columns
Name Type Description
BillParty String Bill party for Report BillsPayable.
BillRef String Bill reference for Report BillsPayable.
BillDate Date Bill date for Report BillsPayable.
BillAmount Decimal Bill amount for Report BillsPayable.
BillDueDate Date Bill due date for Report BillsPayable.
BillOverdue Boolean Bill overdue for Report BillsPayable.
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.

Report_BillsReceivable

Bills Receivable Report of Tally

Columns
Name Type Description
BillParty String Bill party for Report BillsReceivable.
BillRef String Bill reference for Report BillsReceivable.
BillDate Date Bill date for Report BillsReceivable.
BillAmount Decimal Bill Amount for Report BillsReceivable.
BillDueDate Date Bill due date for Report BillsReceivable.
BillOverdue Boolean Bill overdue for Report BillsReceivable.
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.

Report_GodownSummary

Godown Summary 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 DspGodownName is required to make a request and the rest of the filter is executed client side within the connector.

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

For example these queries are processed server side:

SELECT * FROM Report_GodownSummary WHERE DspGodownName = 'Karnataka'

SELECT * FROM Report_GodownSummary WHERE DspGodownName = 'Karnataka' AND FromDate = '01/01/2019' AND ToDate = '01/01/2020'
Columns
Name Type Description
Name String Name for Report GodownSummary.
Quantity String Quantity for Report GodownSummary.
Rate String Rate for Report GodownSummary.
Amount Decimal Amount for Report GodownSummary.
DspGodownName 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.

Report_GroupOutstandings

Group Outstandings 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 GroupName is required to make a request and the rest of the filter is executed client side within the connector.

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

For example these queries are processed server side:

SELECT * FROM Report_GroupOutstandings WHERE GroupName = 'Group1'

SELECT * FROM Report_GroupOutstandings WHERE GroupName = 'Group1' AND FromDate = '01/01/2019' AND ToDate = '01/01/2020'
Columns
Name Type Description
Name String Name for Report GroupOutstandings.
DebitAmount Decimal Debit amount for Report GroupOutstandings.
CreditAmount Decimal Credit amount for Report GroupOutstandings.
GroupName 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.

Report_GroupSummary

Group Summary Report of Tally

Columns
Name Type Description
Name String Name for Report GroupSummary.
DebitAmount Decimal Debit amount for Report GroupSummary.
CreditAmount Decimal Credit amount for Report GroupSummary.
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.

Report_GroupVouchers

Group Vouchers 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 GroupName is required to make a request and the rest of the filter is executed client side within the connector.

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

For example these queries are processed server side:

SELECT * FROM Report_GroupVouchers WHERE GroupName = 'Group1'

SELECT * FROM Report_GroupVouchers WHERE GroupName = 'Group1' AND FromDate = '01/01/2019' AND ToDate = '01/01/2020'
Columns
Name Type Description
Account String Account for Report GroupVouchers.
Date Date Date for Report GroupVouchers.
Type String Type for Report GroupVouchers.
DebitAmount Decimal Debit amount for Report GroupVouchers.
CreditAmount Decimal Credit amount for Report GroupVouchers.
GroupName 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 selected state at the moment.

Report_ItemMonthlySummary

ItemMonthlySummary Report of Tally

Columns
Name Type Description
Month String Month for Report ItemMonthlySummary.
Quantity String Quantity for Report ItemMonthlySummary.
Rate String Rate for Report ItemMonthlySummary.
Amount Decimal Amount for Report ItemMonthlySummary.
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.

Report_LedgerOutstandings

Ledger Outstandings 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 LedgerName is required to make a request and the rest of the filter is executed client side within the connector.

  • 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.

Report_LedgerVouchers

Ledger Vouchers 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 LedgerName is required to make a request and the rest of the filter is executed client side within the connector.

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

For example these queries are processed server side:

SELECT * FROM Report_LedgerVouchers WHERE LedgerName = 'Ledger1'

SELECT * FROM Report_LedgerVouchers WHERE LedgerName = 'Ledger1' AND FromDate = '01/01/2019' AND ToDate = '01/01/2020'
Columns
Name Type Description
Account String Acoount for Report LedgerVouchers.
Date Date Date for Report LedgerVouchers.
Type String Type for Report LedgerVouchers.
DebitAmount Decimal Debit amount for Report LedgerVouchers.
CreditAmount Decimal Credit amount for Report LedgerVouchers.
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.

Report_NegativeLedger

Negative Ledger Report of Tally

Columns
Name Type Description
Name String Name for Report NegativeLedger.
DebitAmount Decimal Debit amount Report NegativeLedger.
CreditAmount Decimal Credit amount Report NegativeLedger.
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.

Report_NegativeStock

Negative Stock Report of Tally

Columns
Name Type Description
Name String Name for Report NegativeStock.
Quantity String Quantity for Report NegativeStock.
Rate String Rate for Report NegativeStock.
Amount Decimal Amount for Report NegativeStock.
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.

Report_ProfitAndLoss

Profit and Loss Report of Tally

Columns
Name Type Description
Name String Name for Report ProfitAndLoss
MainAmount Decimal Main amount for Report ProfitAndLoss
SubAmount Decimal Sub amount for Report ProfitAndLoss
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.

Report_RatioAnalysis

Ratio Analysis Report of Tally

Columns
Name Type Description
RatioName String Ratio name for Report RatioAnalysis.
RatioValue String Ratio value for Report RatioAnalysis.
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.

Report_Statistics

Statistics Report of Tally

Columns
Name Type Description
StatisticName String Statistic name for Report Statistics.
StatisticDirectValue Integer Statistic direct value for Report Statistics.
StatisticCancelled String Statistic cancelled value for Report Statistics.
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.

Report_StockGroupSummary

Stock Summary Report of Tally

Columns
Name Type Description
Name String Name for Report StockGroupSummary.
Quantity String Quantity for Report StockGroupSummary.
Rate String Rate for Report StockGroupSummary.
Amount Decimal Amount for Report StockGroupSummary.
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.

Report_StockItemSummary

Stock Summary 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 STOCKGROUPNAME is required to make a request and the rest of the filter is executed client side within the connector.

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

For example these queries are processed server side:

SELECT * FROM Report_StockItemSummary WHERE STOCKGROUPNAME = 'StockItem1'

SELECT * FROM Report_StockItemSummary WHERE STOCKGROUPNAME = 'StockItem1' AND FromDate = '01/01/2019' AND ToDate = '01/01/2020'
Columns
Name Type Description
Name String Name for Report StockItemSummary.
Quantity String Quantity for StockItemSummary.
Rate String Rate for StockItemSummary.
Amount Decimal Amount for StockItemSummary.
STOCKGROUPNAME 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.

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

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.

Report_TrialBalance

Trial Balance Report of Tally

Columns
Name Type Description
Name String Name for Report TrialBalance.
DebitAmount Decimal DebitAmount for Report TrialBalance.
CreditAmount Decimal CreditAmount for Report TrialBalance.
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.

Report_VoucherRegister

Voucher Register 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.

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

For example these queries are processed server side:

SELECT * FROM Report_VoucherRegister WHERE VOUCHERTYPENAME = 'Stock Journal'

SELECT * FROM Report_VoucherRegister WHERE VOUCHERTYPENAME = 'Stock Journal' AND FromDate = '01/01/2019' AND ToDate = '01/01/2020'
Columns
Name Type Description
OBJVIEW String OBJVIEW for Report VoucherRegister
REMOTEID String REMOTEID for Report VoucherRegister
SENDERID String SENDERID for Report VoucherRegister
VCHKEY String VCHKEY for Report VoucherRegister
VCHTYPE String VCHTYPE for Report VoucherRegister
OLDAUDITENTRYIDS_LIST String OLDAUDITENTRYIDS_LIST for Report VoucherRegister
ACCOUNTAUDITENTRIES_LIST String ACCOUNTAUDITENTRIES_LIST for Report VoucherRegister
ACTIVETO String ACTIVETO for Report VoucherRegister
ADDITIONALNARRATION String ADDITIONALNARRATION for Report VoucherRegister
ADDRESS_LIST String ADDRESS_LIST for Report VoucherRegister
ADJFROMDATE Date ADJFROMDATE for Report VoucherRegister
ADJPARTYGSTIN String ADJPARTYGSTIN for Report VoucherRegister
ADJPARTYINVOICEDATE Date ADJPARTYINVOICEDATE for Report VoucherRegister
ADJPARTYINVOICENO String ADJPARTYINVOICENO for Report VoucherRegister
ADJPARTYINVOICEVALUE String ADJPARTYINVOICEVALUE for Report VoucherRegister
ADJPARTYPAYMENTDATE Date ADJPARTYPAYMENTDATE for Report VoucherRegister
ADJTODATE Date ADJTODATE for Report VoucherRegister
ADVANCERECEIPTDATE Date ADVANCERECEIPTDATE for Report VoucherRegister
ADVANCERECEIPTNUMBER String ADVANCERECEIPTNUMBER for Report VoucherRegister
AGGREMENTORDERDATE Date AGGREMENTORDERDATE for Report VoucherRegister
AGGREMENTORDERNO String AGGREMENTORDERNO for Report VoucherRegister
AIRPORTNAME String AIRPORTNAME for Report VoucherRegister
AIRWAYBILLDATE Date AIRWAYBILLDATE for Report VoucherRegister
AIRWAYBILLNO String AIRWAYBILLNO for Report VoucherRegister
ALLINVENTORYENTRIES_LIST String ALLINVENTORYENTRIES_LIST for Report VoucherRegister
ALLLEDGERENTRIES_LIST String ALLLEDGERENTRIES_LIST for Report VoucherRegister
ALLOWCONSUMPTION String ALLOWCONSUMPTION for Report VoucherRegister
ALTEREDBY String ALTEREDBY for Report VoucherRegister
ALTEREDON String ALTEREDON for Report VoucherRegister
ALTERID String ALTERID for Report VoucherRegister
AREFORMTYPE String AREFORMTYPE for Report VoucherRegister
ARESERIALMASTER String ARESERIALMASTER for Report VoucherRegister
ARESERIALNUMBER String ARESERIALNUMBER for Report VoucherRegister
ASORIGINAL String ASORIGINAL for Report VoucherRegister
ASPAYSLIP String ASPAYSLIP for Report VoucherRegister
ATTDRECORDS_LIST String ATTDRECORDS_LIST for Report VoucherRegister
ATTENDANCEENTRIES_LIST String ATTENDANCEENTRIES_LIST for Report VoucherRegister
AUDITED String AUDITED for Report VoucherRegister
AUDITEDON String AUDITEDON for Report VoucherRegister
AUDITENTRIES_LIST String AUDITENTRIES_LIST for Report VoucherRegister
AUTHORITYADDRESS String AUTHORITYADDRESS for Report VoucherRegister
AUTHORITYNAME String AUTHORITYNAME for Report VoucherRegister
AUTOCOSTLEVEL String AUTOCOSTLEVEL for Report VoucherRegister
BASICBASEPARTYNAME String BASICBASEPARTYNAME for Report VoucherRegister
BASICBUYERADDRESS_LIST String BASICBUYERADDRESS_LIST for Report VoucherRegister
BASICBUYERNAME String BASICBUYERNAME for Report VoucherRegister
BASICBUYERSSALESTAXNO String BASICBUYERSSALESTAXNO for Report VoucherRegister
BASICDATETIMEOFINVOICE String BASICDATETIMEOFINVOICE for Report VoucherRegister
BASICDATETIMEOFREMOVAL String BASICDATETIMEOFREMOVAL for Report VoucherRegister
BASICDESTINATIONCOUNTRY String BASICDESTINATIONCOUNTRY for Report VoucherRegister
BASICDUEDATEOFPYMT String BASICDUEDATEOFPYMT for Report VoucherRegister
BASICDUEDATEOFPYMT String BASICDUEDATEOFPYMT for Report VoucherRegister
BASICFINALDESTINATION String BASICFINALDESTINATION for Report VoucherRegister
BASICORDERREF String BASICORDERREF for Report VoucherRegister
BASICPLACEOFRECEIPT String BASICPLACEOFRECEIPT for Report VoucherRegister
BASICPORTOFDISCHARGE String BASICPORTOFDISCHARGE for Report VoucherRegister
BASICPORTOFLOADING String BASICPORTOFLOADING for Report VoucherRegister
BASICSERIALNUMINPLA String BASICSERIALNUMINPLA for Report VoucherRegister
BASICSHIPDOCUMENTNO String BASICSHIPDOCUMENTNO for Report VoucherRegister
BASICSHIPPEDBY String BASICSHIPPEDBY for Report VoucherRegister
BASICSHIPVESSELNO String BASICSHIPVESSELNO for Report VoucherRegister
BASICVOUCHERCHEQUENAME String BASICVOUCHERCHEQUENAME for Report VoucherRegister
BASICVOUCHERCROSSCOMMENT String BASICVOUCHERCROSSCOMMENT for Report VoucherRegister
BILLOFENTRYDATE Date BILLOFENTRYDATE for Report VoucherRegister
BILLOFENTRYNO String BILLOFENTRYNO for Report VoucherRegister
BILLOFLADINGDATE Date BILLOFLADINGDATE for Report VoucherRegister
BILLOFLADINGNO String BILLOFLADINGNO for Report VoucherRegister
BONDAMOUNT String BONDAMOUNT for Report VoucherRegister
BONDDATEOFISSUE Date BONDDATEOFISSUE for Report VoucherRegister
BONDEXPIRYDATE Date BONDEXPIRYDATE for Report VoucherRegister
BONDNUMBER String BONDNUMBER for Report VoucherRegister
BUYERADDRESSTYPE String BUYERADDRESSTYPE for Report VoucherRegister
BUYERPINNUMBER String BUYERPINNUMBER for Report VoucherRegister
BUYERSCSTNUMBER String BUYERSCSTNUMBER for Report VoucherRegister
CARRIERNAME String CARRIERNAME for Report VoucherRegister
CASHPARTYDEDTYPE String CASHPARTYDEDTYPE for Report VoucherRegister
CASHPARTYPAN String CASHPARTYPAN for Report VoucherRegister
CERTIFICATEDATE Date CERTIFICATEDATE for Report VoucherRegister
CERTIFICATENUMBER String CERTIFICATENUMBER for Report VoucherRegister
CERTIFICATETYPE String CERTIFICATETYPE for Report VoucherRegister
CHALLANTYPE String CHALLANTYPE for Report VoucherRegister
CHANGEVCHMODE String CHANGEVCHMODE for Report VoucherRegister
CHEQUEDEPOSITORNAME String CHEQUEDEPOSITORNAME for Report VoucherRegister
CLASSNAME String CLASSNAME for Report VoucherRegister
CLEARINGAGENTNAME String CLEARINGAGENTNAME for Report VoucherRegister
COMMONNATUREOFPAYMENT String COMMONNATUREOFPAYMENT for Report VoucherRegister
CONSIGNEECIRCLE String CONSIGNEECIRCLE for Report VoucherRegister
CONSIGNEECITY String CONSIGNEECITY for Report VoucherRegister
CONSIGNEECSTNUMBER String CONSIGNEECSTNUMBER for Report VoucherRegister
CONSIGNEEGSTIN String CONSIGNEEGSTIN for Report VoucherRegister
CONSIGNEEIECODE String CONSIGNEEIECODE for Report VoucherRegister
CONSIGNEELBTREGNNO String CONSIGNEELBTREGNNO for Report VoucherRegister
CONSIGNEELBTZONE String CONSIGNEELBTZONE for Report VoucherRegister
CONSIGNEEMAIL String CONSIGNEEMAIL for Report VoucherRegister
CONSIGNEEMOBILENUMBER String CONSIGNEEMOBILENUMBER for Report VoucherRegister
CONSIGNEEOTHERS String CONSIGNEEOTHERS for Report VoucherRegister
CONSIGNEEPINCODE String CONSIGNEEPINCODE for Report VoucherRegister
CONSIGNEEPINNUMBER String CONSIGNEEPINNUMBER for Report VoucherRegister
CONSIGNEESTATENAME String CONSIGNEESTATENAME for Report VoucherRegister
CONSUMERIDENTIFICATIONNUMBER String CONSUMERIDENTIFICATIONNUMBER for Report VoucherRegister
CONTRACTORTIN String CONTRACTORTIN for Report VoucherRegister
COSTCENTRENAME String COSTCENTRENAME for Report VoucherRegister
COUNTRYOFRESIDENCE String COUNTRYOFRESIDENCE for Report VoucherRegister
CREDITLETTERDATE Date CREDITLETTERDATE for Report VoucherRegister
CREDITLETTERREF String CREDITLETTERREF for Report VoucherRegister
CSTFORMISSUEDATE Date CSTFORMISSUEDATE for Report VoucherRegister
CSTFORMISSUENUMBER String CSTFORMISSUENUMBER for Report VoucherRegister
CSTFORMISSUESERIESNUM String CSTFORMISSUESERIESNUM for Report VoucherRegister
CSTFORMISSUETYPE String CSTFORMISSUETYPE for Report VoucherRegister
CSTFORMRECVDATE Date CSTFORMRECVDATE for Report VoucherRegister
CSTFORMRECVNUMBER String CSTFORMRECVNUMBER for Report VoucherRegister
CSTFORMRECVSERIESNUM String CSTFORMRECVSERIESNUM for Report VoucherRegister
CSTFORMRECVTYPE String CSTFORMRECVTYPE for Report VoucherRegister
CURBOMNAME String CURBOMNAME for Report VoucherRegister
CURRBASICBUYERNAME String CURRBASICBUYERNAME for Report VoucherRegister
CURRBASICPURCHASEORDERNO String CURRBASICPURCHASEORDERNO for Report VoucherRegister
CURRBASICSHIPDELIVERYNOTE String CURRBASICSHIPDELIVERYNOTE for Report VoucherRegister
CURRBUYERADDRESSTYPE String CURRBUYERADDRESSTYPE for Report VoucherRegister
CURRPARTYADDRESSTYPE String CURRPARTYADDRESSTYPE for Report VoucherRegister
CURRPARTYLEDGERNAME String CURRPARTYLEDGERNAME for Report VoucherRegister
CURRPARTYNAME String CURRPARTYNAME for Report VoucherRegister
CURRSTATENAME String CURRSTATENAME for Report VoucherRegister
CUSTOMDUTYPAID String CUSTOMDUTYPAID for Report VoucherRegister
DATE Date DATE for Report VoucherRegister
DELIVERYCITY String DELIVERYCITY for Report VoucherRegister
DELIVERYOTHERS String DELIVERYOTHERS for Report VoucherRegister
DELIVERYPINCODE String DELIVERYPINCODE for Report VoucherRegister
DELIVERYSTATE String DELIVERYSTATE for Report VoucherRegister
DESTINATIONGODOWN String DESTINATIONGODOWN for Report VoucherRegister
DESTINATIONPERMITNUMBER String DESTINATIONPERMITNUMBER for Report VoucherRegister
DESTINATIONTAXUNIT String DESTINATIONTAXUNIT for Report VoucherRegister
DIFFACTUALQTY String DIFFACTUALQTY for Report VoucherRegister
DISPATCHCITY String DISPATCHCITY for Report VoucherRegister
DISPATCHDATE Date DISPATCHDATE for Report VoucherRegister
DISPATCHPINCODE String DISPATCHPINCODE for Report VoucherRegister
DUTYHEADDETAILS_LIST String DUTYHEADDETAILS_LIST for Report VoucherRegister
ECDATE Date ECDATE for Report VoucherRegister
ECFEEAMOUNT String ECFEEAMOUNT for Report VoucherRegister
ECFEEDEPOSITBYAWARDER String ECFEEDEPOSITBYAWARDER for Report VoucherRegister
ECFEEDEPOSITBYCONTRACTOR String ECFEEDEPOSITBYCONTRACTOR for Report VoucherRegister
ECFEERATE String ECFEERATE for Report VoucherRegister
ECISSUINGAUTHORITY String ECISSUINGAUTHORITY for Report VoucherRegister
ECNUMBER String ECNUMBER for Report VoucherRegister
EFFECTIVEDATE Date EFFECTIVEDATE for Report VoucherRegister
EICHECKPOST String EICHECKPOST for Report VoucherRegister
EIDEFAULTLED_CLASSADDLRATE String EIDEFAULTLED_CLASSADDLRATE for Report VoucherRegister
EIDEFAULTLED_CLASSNAME String EIDEFAULTLED_CLASSNAME for Report VoucherRegister
EIDEFAULTLED_CLASSRATE String EIDEFAULTLED_CLASSRATE for Report VoucherRegister
EIDEFAULTLED_ISUSERDEFINED String EIDEFAULTLED_ISUSERDEFINED for Report VoucherRegister
EIDEFAULTLED_ISZRBASICSERVICE String EIDEFAULTLED_ISZRBASICSERVICE for Report VoucherRegister
EMIRATEPOS String EMIRATEPOS for Report VoucherRegister
ENTEREDBY String ENTEREDBY for Report VoucherRegister
ENTRYCHECKPOSTLOCATION String ENTRYCHECKPOSTLOCATION for Report VoucherRegister
EWAYBILLDETAILS_LIST String EWAYBILLDETAILS_LIST for Report VoucherRegister
EXCHGCURRENCYNAME String EXCHGCURRENCYNAME for Report VoucherRegister
EXCHGRATE String EXCHGRATE for Report VoucherRegister
EXCISECLASSIFICATIONNAME String EXCISECLASSIFICATIONNAME for Report VoucherRegister
EXCISENOTIFICATIONNO String EXCISENOTIFICATIONNO for Report VoucherRegister
EXCISENOTIFICATIONSERIALNO String EXCISENOTIFICATIONSERIALNO for Report VoucherRegister
EXCISEOPENING String EXCISEOPENING for Report VoucherRegister
EXCISETARIFFTYPE String EXCISETARIFFTYPE for Report VoucherRegister
EXCISETAXOVERRIDE String EXCISETAXOVERRIDE for Report VoucherRegister
EXCISETREASURYNAME String EXCISETREASURYNAME for Report VoucherRegister
EXCISETREASURYNUMBER String EXCISETREASURYNUMBER for Report VoucherRegister
EXCISEUNITNAME String EXCISEUNITNAME for Report VoucherRegister
EXCLUDEDTAXATIONS_LIST String EXCLUDEDTAXATIONS_LIST for Report VoucherRegister
EXITCHECKPOSTLOCATION String EXITCHECKPOSTLOCATION for Report VoucherRegister
EXPORTERCOUNTRY String EXPORTERCOUNTRY for Report VoucherRegister
FBTFROMDATE Date FBTFROMDATE for Report VoucherRegister
FBTPAYMENTTYPE String FBTPAYMENTTYPE for Report VoucherRegister
FBTTODATE Date FBTTODATE for Report VoucherRegister
FOREIGNSELLERNAME String FOREIGNSELLERNAME for Report VoucherRegister
FORJOBCOSTING String FORJOBCOSTING for Report VoucherRegister
FORM16ISSUEDATE Date FORM16ISSUEDATE for Report VoucherRegister
FWDAGENTNAME String FWDAGENTNAME for Report VoucherRegister
GOODSRCPTDATE Date GOODSRCPTDATE for Report VoucherRegister
GOODSVEHICLENUMBER String GOODSVEHICLENUMBER for Report VoucherRegister
GSTACTIVITYSTATUS String GSTACTIVITYSTATUS for Report VoucherRegister
GSTADDITIONALDETAILS String GSTADDITIONALDETAILS for Report VoucherRegister
GSTBANKACCOUNTHOLDER String GSTBANKACCOUNTHOLDER for Report VoucherRegister
GSTBANKACCOUNTNUMBER String GSTBANKACCOUNTNUMBER for Report VoucherRegister
GSTBANKACCOUNTTYPE String GSTBANKACCOUNTTYPE for Report VoucherRegister
GSTBANKBRANCHADDRESS String GSTBANKBRANCHADDRESS for Report VoucherRegister
GSTBANKBRANCHNAME String GSTBANKBRANCHNAME for Report VoucherRegister
GSTBANKIFSCCODE String GSTBANKIFSCCODE for Report VoucherRegister
GSTBANKMICRCODE String GSTBANKMICRCODE for Report VoucherRegister
GSTBANKNAME String GSTBANKNAME for Report VoucherRegister
GSTCHALLANDATE Date GSTCHALLANDATE for Report VoucherRegister
GSTCHALLANEXPIRYDATE Date GSTCHALLANEXPIRYDATE for Report VoucherRegister
GSTCHALLANNUMBER String GSTCHALLANNUMBER for Report VoucherRegister
GSTCINNUMBER String GSTCINNUMBER for Report VoucherRegister
GSTCPINNUMBER String GSTCPINNUMBER for Report VoucherRegister
GSTDEBITDOCNUMBER String GSTDEBITDOCNUMBER for Report VoucherRegister
GSTEWAYCONSIGNEEADDRESS_LIST String GSTEWAYCONSIGNEEADDRESS_LIST for Report VoucherRegister
GSTEWAYCONSIGNORADDRESS_LIST String GSTEWAYCONSIGNORADDRESS_LIST for Report VoucherRegister
GSTINSTRUMENTNUMBER String GSTINSTRUMENTNUMBER for Report VoucherRegister
GSTINVASSESSABLEVALUE String GSTINVASSESSABLEVALUE for Report VoucherRegister
GSTITCDOCUMENTTYPE String GSTITCDOCUMENTTYPE for Report VoucherRegister
GSTITCREVERSALDETAILS String GSTITCREVERSALDETAILS for Report VoucherRegister
GSTMERCHANTID String GSTMERCHANTID for Report VoucherRegister
GSTNATUREOFRETURN String GSTNATUREOFRETURN for Report VoucherRegister
GSTNOTEXPORTED String GSTNOTEXPORTED for Report VoucherRegister
GSTPYMTMODEOFDEPOSIT String GSTPYMTMODEOFDEPOSIT for Report VoucherRegister
GSTREASONFORREJECTION String GSTREASONFORREJECTION for Report VoucherRegister
GSTRECONSTATUS String GSTRECONSTATUS for Report VoucherRegister
GSTREGISTRATIONTYPE String GSTREGISTRATIONTYPE for Report VoucherRegister
GUID String GUID for Report VoucherRegister
HASCASHFLOW String HASCASHFLOW for Report VoucherRegister
HASDISCOUNTS String HASDISCOUNTS for Report VoucherRegister
HOLDREFERENCE String HOLDREFERENCE for Report VoucherRegister
IGNOREGSTINVALIDATION String IGNOREGSTINVALIDATION for Report VoucherRegister
IGNOREORIGVCHDATE String IGNOREORIGVCHDATE for Report VoucherRegister
IGNOREPOSVALIDATION String IGNOREPOSVALIDATION for Report VoucherRegister
IMPORTEREXPORTERCODE String IMPORTEREXPORTERCODE for Report VoucherRegister
INCLUDEADVPYMTVCH String INCLUDEADVPYMTVCH for Report VoucherRegister
INSPDOCDATE Date INSPDOCDATE for Report VoucherRegister
INSPDOCNO String INSPDOCNO for Report VoucherRegister
INVDELIVERYDATE Date INVDELIVERYDATE for Report VoucherRegister
INVENTORYENTRIESIN_LIST String INVENTORYENTRIESIN_LIST for Report VoucherRegister
INVENTORYENTRIESOUT_LIST String INVENTORYENTRIESOUT_LIST for Report VoucherRegister
INVOICEDELNOTES_LIST String INVOICEDELNOTES_LIST for Report VoucherRegister
INVOICEEXPORTLIST_LIST String INVOICEEXPORTLIST_LIST for Report VoucherRegister
INVOICEINDENTLIST_LIST String INVOICEINDENTLIST_LIST for Report VoucherRegister
INVOICEORDERLIST_LIST String INVOICEORDERLIST_LIST for Report VoucherRegister
ISATTDDATAPRESERVED String ISATTDDATAPRESERVED for Report VoucherRegister
ISBLANKCHEQUE String ISBLANKCHEQUE for Report VoucherRegister
ISBOENOTAPPLICABLE String ISBOENOTAPPLICABLE for Report VoucherRegister
ISCANCELLED String ISCANCELLED for Report VoucherRegister
ISCOSTCENTRE String ISCOSTCENTRE for Report VoucherRegister
ISCSTAGTFORMC String ISCSTAGTFORMC for Report VoucherRegister
ISDECLAREDTOCUSTOMS String ISDECLAREDTOCUSTOMS for Report VoucherRegister
ISDELETED String ISDELETED for Report VoucherRegister
ISDELIVERYSAMEASCONSIGNEE String ISDELIVERYSAMEASCONSIGNEE for Report VoucherRegister
ISDESIGNATEDZONEPARTY String ISDESIGNATEDZONEPARTY for Report VoucherRegister
ISDISPATCHSAMEASCONSIGNOR String ISDISPATCHSAMEASCONSIGNOR for Report VoucherRegister
ISEXCISEMANUFACTURERON String ISEXCISEMANUFACTURERON for Report VoucherRegister
ISEXCISEOVERRIDDEN String ISEXCISEOVERRIDDEN for Report VoucherRegister
ISEXCISESUPPLYVCH String ISEXCISESUPPLYVCH for Report VoucherRegister
ISEXCISEVOUCHER String ISEXCISEVOUCHER for Report VoucherRegister
ISFORJOBWORKIN String ISFORJOBWORKIN for Report VoucherRegister
ISGSTOVERRIDDEN String ISGSTOVERRIDDEN for Report VoucherRegister
ISINVOICE String ISINVOICE for Report VoucherRegister
ISISDVOUCHER String ISISDVOUCHER for Report VoucherRegister
ISMSTFROMSYNC String ISMSTFROMSYNC for Report VoucherRegister
ISONHOLD String ISONHOLD for Report VoucherRegister
ISOPTIONAL String ISOPTIONAL for Report VoucherRegister
ISOVERSEASTOURISTTRANS String ISOVERSEASTOURISTTRANS for Report VoucherRegister
ISPOSTDATED String ISPOSTDATED for Report VoucherRegister
ISSERVICETAXOVERRIDDEN String ISSERVICETAXOVERRIDDEN for Report VoucherRegister
ISSHIPPINGWITHINSTATE String ISSHIPPINGWITHINSTATE for Report VoucherRegister
ISSTXNONREALIZEDVCH String ISSTXNONREALIZEDVCH for Report VoucherRegister
ISSUBWORKSCONTRACT String ISSUBWORKSCONTRACT for Report VoucherRegister
ISTCSOVERRIDDEN String ISTCSOVERRIDDEN for Report VoucherRegister
ISTDSOVERRIDDEN String ISTDSOVERRIDDEN for Report VoucherRegister
ISTDSTCSCASHVCH String ISTDSTCSCASHVCH for Report VoucherRegister
ISVATDUTYPAID String ISVATDUTYPAID for Report VoucherRegister
ISVATOVERRIDDEN String ISVATOVERRIDDEN for Report VoucherRegister
ISVATPAIDATCUSTOMS String ISVATPAIDATCUSTOMS for Report VoucherRegister
ISVATPRINCIPALACCOUNT String ISVATPRINCIPALACCOUNT for Report VoucherRegister
ISVATRESTAXINVOICE String ISVATRESTAXINVOICE for Report VoucherRegister
ISVOID String ISVOID for Report VoucherRegister
LBTMAPPEDCATEGORY String LBTMAPPEDCATEGORY for Report VoucherRegister
LBTMAPPEDZONE String LBTMAPPEDZONE for Report VoucherRegister
LBTNATUREOFLIABILITY String LBTNATUREOFLIABILITY for Report VoucherRegister
LEDGERENTRIES_LIST String LEDGERENTRIES_LIST for Report VoucherRegister
LORRYRECPTDATE Date LORRYRECPTDATE for Report VoucherRegister
LORRYRECPTNO String LORRYRECPTNO for Report VoucherRegister
LUTDATEOFISSUE Date LUTDATEOFISSUE for Report VoucherRegister
LUTEXPIRYDATE Date LUTEXPIRYDATE for Report VoucherRegister
LUTNUMBER String LUTNUMBER for Report VoucherRegister
MASTERID String MASTERID for Report VoucherRegister
MFGJOURNAL String MFGJOURNAL for Report VoucherRegister
MFGRADDRESSTYPE String MFGRADDRESSTYPE for Report VoucherRegister
NARRATION String NARRATION for Report VoucherRegister
NATUREOFSALES String NATUREOFSALES for Report VoucherRegister
OLDAUDITENTRIES_LIST String OLDAUDITENTRIES_LIST for Report VoucherRegister
ORDERLINESTATUS String ORDERLINESTATUS for Report VoucherRegister
ORIGINVOICEDETAILS_LIST String ORIGINVOICEDETAILS_LIST for Report VoucherRegister
PARTYADDRESSTYPE String PARTYADDRESSTYPE for Report VoucherRegister
PARTYGSTIN String PARTYGSTIN for Report VoucherRegister
PARTYINVDATE Date PARTYINVDATE for Report VoucherRegister
PARTYINVNO String PARTYINVNO for Report VoucherRegister
PARTYLEDGERNAME String PARTYLEDGERNAME for Report VoucherRegister
PARTYNAME String PARTYNAME for Report VoucherRegister
PARTYORDERDATE Date PARTYORDERDATE for Report VoucherRegister
PARTYORDERNO String PARTYORDERNO for Report VoucherRegister
PAYROLLMODEOFPAYMENT_LIST String PAYROLLMODEOFPAYMENT_LIST for Report VoucherRegister
PERSISTEDVIEW String PERSISTEDVIEW for Report VoucherRegister
PLACEOFSUPPLY String PLACEOFSUPPLY for Report VoucherRegister
PLACEOFSUPPLYCOUNTRY String PLACEOFSUPPLYCOUNTRY for Report VoucherRegister
PLACEOFSUPPLYSTATE String PLACEOFSUPPLYSTATE for Report VoucherRegister
POINTOFTRANSACTION String POINTOFTRANSACTION for Report VoucherRegister
PORTCODE String PORTCODE for Report VoucherRegister
PORTNAME String PORTNAME for Report VoucherRegister
POSCARDLEDGER String POSCARDLEDGER for Report VoucherRegister
POSCARDNUMBER String POSCARDNUMBER for Report VoucherRegister
POSCASHLEDGER String POSCASHLEDGER for Report VoucherRegister
POSCASHRECEIVED String POSCASHRECEIVED for Report VoucherRegister
POSCHEQUEBANKNAME String POSCHEQUEBANKNAME for Report VoucherRegister
POSCHEQUELEDGER String POSCHEQUELEDGER for Report VoucherRegister
POSCHEQUENUMBER String POSCHEQUENUMBER for Report VoucherRegister
POSGIFTLEDGER String POSGIFTLEDGER for Report VoucherRegister
POSSTAXPARTYLEDGERNAME String POSSTAXPARTYLEDGERNAME for Report VoucherRegister
PREVBOMNAME String PREVBOMNAME for Report VoucherRegister
PRICELEVEL String PRICELEVEL for Report VoucherRegister
PRIORITYSTATECONFLICT String PRIORITYSTATECONFLICT for Report VoucherRegister
PROCESSINGDURATION String PROCESSINGDURATION for Report VoucherRegister
PURPOSEOFPURCHASE String PURPOSEOFPURCHASE for Report VoucherRegister
RECONCILATIONDATE Date RECONCILATIONDATE for Report VoucherRegister
REFERENCE String REFERENCE for Report VoucherRegister
REFERENCEDATE Date REFERENCEDATE for Report VoucherRegister
REFUNDVOUCHERDATE Date REFUNDVOUCHERDATE for Report VoucherRegister
REFUNDVOUCHERNUMBER String REFUNDVOUCHERNUMBER for Report VoucherRegister
REQUESTORRULE String REQUESTORRULE for Report VoucherRegister
RETURNINVOICEDATE Date RETURNINVOICEDATE for Report VoucherRegister
SERIALMASTER String SERIALMASTER for Report VoucherRegister
SERIALNUMBER String SERIALNUMBER for Report VoucherRegister
SETTLEMENTTYPE String SETTLEMENTTYPE for Report VoucherRegister
SHIPAGENTNAME String SHIPAGENTNAME for Report VoucherRegister
SHIPNAME String SHIPNAME for Report VoucherRegister
SHIPPINGBILLDATE Date SHIPPINGBILLDATE for Report VoucherRegister
SHIPPINGBILLNO String SHIPPINGBILLNO for Report VoucherRegister
SRVTREGNUMBER String SRVTREGNUMBER for Report VoucherRegister
STATADJUSTMENTTYPE String STATADJUSTMENTTYPE for Report VoucherRegister
STATENAME String STATENAME for Report VoucherRegister
STATPAYMENTTYPE String STATPAYMENTTYPE for Report VoucherRegister
STTAXBANKCHALLANNUMBER String STTAXBANKCHALLANNUMBER for Report VoucherRegister
STTAXCHALLANDATE Date STTAXCHALLANDATE for Report VoucherRegister
STTVCHRHANDLE String STTVCHRHANDLE for Report VoucherRegister
SUMAUTOVCHNUM String SUMAUTOVCHNUM for Report VoucherRegister
SUPPLEMENTARYDUTYHEADDETAILS_LIST String SUPPLEMENTARYDUTYHEADDETAILS_LIS for Report VoucherRegister
SUPPLIERIECODE String SUPPLIERIECODE for Report VoucherRegister
SUPPLIERLBTREGNNO String SUPPLIERLBTREGNNO for Report VoucherRegister
SUPPLIERLBTZONE String SUPPLIERLBTZONE for Report VoucherRegister
TAXADJUSTMENT String TAXADJUSTMENT for Report VoucherRegister
TAXBANKACCOUNTNUMBER String TAXBANKACCOUNTNUMBER for Report VoucherRegister
TAXBANKBRANCHNAME String TAXBANKBRANCHNAME for Report VoucherRegister
TAXBANKCHALLANNUMBER String TAXBANKCHALLANNUMBER for Report VoucherRegister
TAXBANKNAME String TAXBANKNAME for Report VoucherRegister
TAXCHALLANBSRCODE String TAXCHALLANBSRCODE for Report VoucherRegister
TAXCHALLANDATE Date TAXCHALLANDATE for Report VoucherRegister
TAXCHEQUEDATE Date TAXCHEQUEDATE for Report VoucherRegister
TAXCHEQUENUMBER String TAXCHEQUENUMBER for Report VoucherRegister
TAXPAYMENTTYPE String TAXPAYMENTTYPE for Report VoucherRegister
TAXPAYPERIODFROMDATE Date TAXPAYPERIODFROMDATE for Report VoucherRegister
TAXPAYPERIODTODATE Date TAXPAYPERIODTODATE for Report VoucherRegister
TAXUNITNAME String TAXUNITNAME for Report VoucherRegister
TDNOFAWARDER String TDNOFAWARDER for Report VoucherRegister
TDSDEDNSTATUS String TDSDEDNSTATUS for Report VoucherRegister
TDSDEDUCTED String TDSDEDUCTED for Report VoucherRegister
TDSNATUREOFPAYMENT String TDSNATUREOFPAYMENT for Report VoucherRegister
TDSSECTIONNO String TDSSECTIONNO for Report VoucherRegister
TEMPCLASSNATURE String TEMPCLASSNATURE for Report VoucherRegister
TEMPCONSIGNEEPINCODENUMBER String TEMPCONSIGNEEPINCODENUMBER for Report VoucherRegister
TEMPCONSIGNORPINCODENUMBER String TEMPCONSIGNORPINCODENUMBER for Report VoucherRegister
TEMPGSTEWAYBILLDATE Date TEMPGSTEWAYBILLDATE for Report VoucherRegister
TEMPGSTEWAYBILLNUMBER String TEMPGSTEWAYBILLNUMBER for Report VoucherRegister
TEMPGSTEWAYCONSADDRESS String TEMPGSTEWAYCONSADDRESS for Report VoucherRegister
TEMPGSTEWAYCONSBILLDATE Date TEMPGSTEWAYCONSBILLDATE for Report VoucherRegister
TEMPGSTEWAYCONSBILLNUMBER String TEMPGSTEWAYCONSBILLNUMBER for Report VoucherRegister
TEMPGSTEWAYCONSFROMPLACE String TEMPGSTEWAYCONSFROMPLACE for Report VoucherRegister
TEMPGSTEWAYCONSIGNEE String TEMPGSTEWAYCONSIGNEE for Report VoucherRegister
TEMPGSTEWAYCONSIGNEEADDRESSTYPE String TEMPGSTEWAYCONSIGNEEADDRESSTYPE for Report VoucherRegister
TEMPGSTEWAYCONSIGNOR String TEMPGSTEWAYCONSIGNOR for Report VoucherRegister
TEMPGSTEWAYCONSIGNORADDRESS String TEMPGSTEWAYCONSIGNORADDRESS for Report VoucherRegister
TEMPGSTEWAYCONSIGNORADDRESSTYPE String TEMPGSTEWAYCONSIGNORADDRESSTYPE for Report VoucherRegister
TEMPGSTEWAYCONSIGNORSTATE String TEMPGSTEWAYCONSIGNORSTATE for Report VoucherRegister
TEMPGSTEWAYCONSIGNORTIN String TEMPGSTEWAYCONSIGNORTIN for Report VoucherRegister
TEMPGSTEWAYCONSPINCODE String TEMPGSTEWAYCONSPINCODE for Report VoucherRegister
TEMPGSTEWAYCONSPINCODENUMBER String TEMPGSTEWAYCONSPINCODENUMBER for Report VoucherRegister
TEMPGSTEWAYCONSSHIPFROMSTATE String TEMPGSTEWAYCONSSHIPFROMSTATE for Report VoucherRegister
TEMPGSTEWAYCONSSHIPTOSTATE String TEMPGSTEWAYCONSSHIPTOSTATE for Report VoucherRegister
TEMPGSTEWAYCONSSTATE String TEMPGSTEWAYCONSSTATE for Report VoucherRegister
TEMPGSTEWAYCONSTIN String TEMPGSTEWAYCONSTIN for Report VoucherRegister
TEMPGSTEWAYDISTANCE String TEMPGSTEWAYDISTANCE for Report VoucherRegister
TEMPGSTEWAYDOCUMENTTYPE String TEMPGSTEWAYDOCUMENTTYPE for Report VoucherRegister
TEMPGSTEWAYFROMPLACE String TEMPGSTEWAYFROMPLACE for Report VoucherRegister
TEMPGSTEWAYPINCODE String TEMPGSTEWAYPINCODE for Report VoucherRegister
TEMPGSTEWAYPINCODENUMBER String TEMPGSTEWAYPINCODENUMBER for Report VoucherRegister
TEMPGSTEWAYSTATUS String TEMPGSTEWAYSTATUS for Report VoucherRegister
TEMPGSTEWAYSUBTYPE String TEMPGSTEWAYSUBTYPE for Report VoucherRegister
TEMPGSTEWAYTRANSPORTERDOCDATE Date TEMPGSTEWAYTRANSPORTERDOCDATE for Report VoucherRegister
TEMPGSTEWAYTRANSPORTERDOCNO String TEMPGSTEWAYTRANSPORTERDOCNO for Report VoucherRegister
TEMPGSTEWAYTRANSPORTERID String TEMPGSTEWAYTRANSPORTERID for Report VoucherRegister
TEMPGSTEWAYTRANSPORTERNAME String TEMPGSTEWAYTRANSPORTERNAME for Report VoucherRegister
TEMPGSTEWAYTRANSPORTMODE String TEMPGSTEWAYTRANSPORTMODE for Report VoucherRegister
TEMPGSTEWAYVEHICLENUMBER String TEMPGSTEWAYVEHICLENUMBER for Report VoucherRegister
TEMPGSTEWAYVEHICLETYPE String TEMPGSTEWAYVEHICLETYPE for Report VoucherRegister
TEMPGSTOVRDNINELIGIBLEITC String TEMPGSTOVRDNINELIGIBLEITC for Report VoucherRegister
TEMPGSTOVRDNINELIGIBLEITCSTR String TEMPGSTOVRDNINELIGIBLEITCSTR for Report VoucherRegister
TEMPGSTOVRDNISREVCHARGEAPPL String TEMPGSTOVRDNISREVCHARGEAPPL for Report VoucherRegister
TEMPGSTOVRDNISREVCHARGEAPPLSTR String TEMPGSTOVRDNISREVCHARGEAPPLSTR for Report VoucherRegister
TEMPGSTOVRDNTAXABILITY String TEMPGSTOVRDNTAXABILITY for Report VoucherRegister
TEMPGSTRATEDETAILS.LIST String TEMPGSTRATEDETAILS.LIST for Report VoucherRegister
TEMPISUSERDEFINEDCLASS String TEMPISUSERDEFINEDCLASS for Report VoucherRegister
TEMPISVCHSUPPLFILLED String TEMPISVCHSUPPLFILLED for Report VoucherRegister
TEMPVATCLASSIFICATION String TEMPVATCLASSIFICATION for Report VoucherRegister
TRANSBUYERLANDINGDATE Date TRANSBUYERLANDINGDATE for Report VoucherRegister
TRANSCATEGORY String TRANSCATEGORY for Report VoucherRegister
TRANSPORTERADDRAREA String TRANSPORTERADDRAREA for Report VoucherRegister
TRANSPORTERADDRBLDG String TRANSPORTERADDRBLDG for Report VoucherRegister
TRANSPORTERADDRDIST String TRANSPORTERADDRDIST for Report VoucherRegister
TRANSPORTERADDRFAX String TRANSPORTERADDRFAX for Report VoucherRegister
TRANSPORTERADDRPHONE String TRANSPORTERADDRPHONE for Report VoucherRegister
TRANSPORTERADDRPINCODE String TRANSPORTERADDRPINCODE for Report VoucherRegister
TRANSPORTERADDRROAD String TRANSPORTERADDRROAD for Report VoucherRegister
TRANSPORTERADDRROOM String TRANSPORTERADDRROOM for Report VoucherRegister
TRANSPORTERADDRSTATE String TRANSPORTERADDRSTATE for Report VoucherRegister
TRANSPORTERADDRTOWN String TRANSPORTERADDRTOWN for Report VoucherRegister
TRANSPORTERNAME String TRANSPORTERNAME for Report VoucherRegister
TRANSPORTERVEHICLE2 String TRANSPORTERVEHICLE2 for Report VoucherRegister
TRANSPORTLOCALTIN String TRANSPORTLOCALTIN for Report VoucherRegister
TRANSPORTMODE String TRANSPORTMODE for Report VoucherRegister
TRANSSALELANDINGDATE Date TRANSSALELANDINGDATE for Report VoucherRegister
TRANSSOURCEPLACE String TRANSSOURCEPLACE for Report VoucherRegister
TYPEOFEXCISEVOUCHER String TYPEOFEXCISEVOUCHER for Report VoucherRegister
URDORIGINALSALEVALUE String URDORIGINALSALEVALUE for Report VoucherRegister
USEFORCOMPOUND String USEFORCOMPOUND for Report VoucherRegister
USEFOREXCISE String USEFOREXCISE for Report VoucherRegister
USEFORFINALPRODUCTION String USEFORFINALPRODUCTION for Report VoucherRegister
USEFORGAINLOSS String USEFORGAINLOSS for Report VoucherRegister
USEFORGODOWNTRANSFER String USEFORGODOWNTRANSFER for Report VoucherRegister
USEFORINTEREST String USEFORINTEREST for Report VoucherRegister
USEFORSERVICETAX String USEFORSERVICETAX for Report VoucherRegister
USEFORTAXUNITTRANSFER String USEFORTAXUNITTRANSFER for Report VoucherRegister
USETRACKINGNUMBER String USETRACKINGNUMBER for Report VoucherRegister
VALUEOFSUBWORKSCONT String VALUEOFSUBWORKSCONT for Report VoucherRegister
VALUEOFWORKSCONTRACT String VALUEOFWORKSCONTRACT for Report VoucherRegister
VATADJADDLDETAILS String VATADJADDLDETAILS for Report VoucherRegister
VATADJUSTMENTTYPE String VATADJUSTMENTTYPE for Report VoucherRegister
VATBANKACCNUMBER String VATBANKACCNUMBER for Report VoucherRegister
VATBANKBRANCH String VATBANKBRANCH for Report VoucherRegister
VATBANKNAME String VATBANKNAME for Report VoucherRegister
VATBRANCHCODE String VATBRANCHCODE for Report VoucherRegister
VATBRANCHNAME String VATBRANCHNAME for Report VoucherRegister
VATBRIEFDESCRIPTION String VATBRIEFDESCRIPTION for Report VoucherRegister
VATCANCINVDATE Date VATCANCINVDATE for Report VoucherRegister
VATCANCINVNO String VATCANCINVNO for Report VoucherRegister
VATCANCPURCNAME String VATCANCPURCNAME for Report VoucherRegister
VATCANCPURCTIN String VATCANCPURCTIN for Report VoucherRegister
VATCERTIFICATENO String VATCERTIFICATENO for Report VoucherRegister
VATCFORMISSUESTATE String VATCFORMISSUESTATE for Report VoucherRegister
VATCHALLANDATE Date VATCHALLANDATE for Report VoucherRegister
VATCHALLANNUMBER String VATCHALLANNUMBER for Report VoucherRegister
VATCONSIGNMENTNO String VATCONSIGNMENTNO for Report VoucherRegister
VATCONTRACTEEDISTRICT String VATCONTRACTEEDISTRICT for Report VoucherRegister
VATCONTRACTEENAME String VATCONTRACTEENAME for Report VoucherRegister
VATCONTRACTEETDN String VATCONTRACTEETDN for Report VoucherRegister
VATCSTE1DATE Date VATCSTE1DATE for Report VoucherRegister
VATCSTE1SERIALNO String VATCSTE1SERIALNO for Report VoucherRegister
VATCSTE1SERIESNO String VATCSTE1SERIESNO for Report VoucherRegister
VATDDCHEQUEDATE Date VATDDCHEQUEDATE for Report VoucherRegister
VATDDCHEQUENO String VATDDCHEQUENO for Report VoucherRegister
VATDEALERTYPE String VATDEALERTYPE for Report VoucherRegister
VATDEPOSITDATE Date VATDEPOSITDATE for Report VoucherRegister
VATDESIGOFPURCHASER String VATDESIGOFPURCHASER for Report VoucherRegister
VATDESTINATIONPLACE String VATDESTINATIONPLACE for Report VoucherRegister
VATDESTINATIONSTATE String VATDESTINATIONSTATE for Report VoucherRegister
VATDEVICENO String VATDEVICENO for Report VoucherRegister
VATDISPATCHTIME String VATDISPATCHTIME for Report VoucherRegister
VATDOCUMENTDATE Date VATDOCUMENTDATE for Report VoucherRegister
VATDOCUMENTNUMBER String VATDOCUMENTNUMBER for Report VoucherRegister
VATDOCUMENTTYPE String VATDOCUMENTTYPE for Report VoucherRegister
VATEFORMAPPLICABLE String VATEFORMAPPLICABLE for Report VoucherRegister
VATEFORMAPPLICABLENO String VATEFORMAPPLICABLENO for Report VoucherRegister
VATEXEMPTCERTIFICATENO String VATEXEMPTCERTIFICATENO for Report VoucherRegister
VATEXPORTENTRYNO String VATEXPORTENTRYNO for Report VoucherRegister
VATFORMSTATUS String VATFORMSTATUS for Report VoucherRegister
VATGOODSRCPTNO String VATGOODSRCPTNO for Report VoucherRegister
VATGOODSRECEIPTDATE Date VATGOODSRECEIPTDATE for Report VoucherRegister
VATGOODSRECEIPTNUMBER String VATGOODSRECEIPTNUMBER for Report VoucherRegister
VATGOODSVALUE String VATGOODSVALUE for Report VoucherRegister
VATINCOURSEOF String VATINCOURSEOF for Report VoucherRegister
VATISAGNSTCANCSALES String VATISAGNSTCANCSALES for Report VoucherRegister
VATISASSESABLECALCVCH String VATISASSESABLECALCVCH for Report VoucherRegister
VATISPURCEXEMPTED String VATISPURCEXEMPTED for Report VoucherRegister
VATMOBILENUMBER String VATMOBILENUMBER for Report VoucherRegister
VATORDERDATE Date VATORDERDATE for Report VoucherRegister
VATORDERNO String VATORDERNO for Report VoucherRegister
VATPAIDAGAINST String VATPAIDAGAINST for Report VoucherRegister
VATPARTYITCCLAIMED String VATPARTYITCCLAIMED for Report VoucherRegister
VATPARTYORGNAME String VATPARTYORGNAME for Report VoucherRegister
VATPARTYORGTYPE String VATPARTYORGTYPE for Report VoucherRegister
VATPARTYTAXLIABILITY String VATPARTYTAXLIABILITY for Report VoucherRegister
VATPARTYTRANSRETURNDATE Date VATPARTYTRANSRETURNDATE for Report VoucherRegister
VATPARTYTRANSRETURNNUMBER String VATPARTYTRANSRETURNNUMBER for Report VoucherRegister
VATPARTYTYPE String VATPARTYTYPE for Report VoucherRegister
VATPERMITFORM String VATPERMITFORM for Report VoucherRegister
VATPURCHASERCPTTYPE String VATPURCHASERCPTTYPE for Report VoucherRegister
VATPYMTMODEOFDEPOSIT String VATPYMTMODEOFDEPOSIT for Report VoucherRegister
VATPYMTTAXDESC String VATPYMTTAXDESC for Report VoucherRegister
VATSELLERTIN String VATSELLERTIN for Report VoucherRegister
VATSOURCESTATE String VATSOURCESTATE for Report VoucherRegister
VATSUBMISSIONDATE Date VATSUBMISSIONDATE for Report VoucherRegister
VATTDSAMT String VATTDSAMT for Report VoucherRegister
VATTDSBARCODE String VATTDSBARCODE for Report VoucherRegister
VATTDSDATE Date VATTDSDATE for Report VoucherRegister
VATTDSDEDUCTORNAME String VATTDSDEDUCTORNAME for Report VoucherRegister
VATTDSRATE String VATTDSRATE for Report VoucherRegister
VATTRANSBILLNO String VATTRANSBILLNO for Report VoucherRegister
VATTRANSBILLQTY String VATTRANSBILLQTY for Report VoucherRegister
VATTRANSPORTERADDRESS String VATTRANSPORTERADDRESS for Report VoucherRegister
VATTRANSSOURCE String VATTRANSSOURCE for Report VoucherRegister
VATTYPEOFDEVICE String VATTYPEOFDEVICE for Report VoucherRegister
VATVEHICLENUMBER String VATVEHICLENUMBER for Report VoucherRegister
VCHGSTCLASS String VCHGSTCLASS for Report VoucherRegister
VCHTAXTYPE String VCHTAXTYPE for Report VoucherRegister
VCHTAXUNIT String VCHTAXUNIT for Report VoucherRegister
VOUCHERDESTINATIONGODOWN String VOUCHERDESTINATIONGODOWN for Report VoucherRegister
VOUCHERKEY Long VOUCHERKEY for Report VoucherRegister
VOUCHERNUMBER String VOUCHERNUMBER for Report VoucherRegister
VOUCHERSOURCEGODOWN String VOUCHERSOURCEGODOWN for Report VoucherRegister
VOUCHERTIME String VOUCHERTIME for Report VoucherRegister
VOUCHERTYPENAME String VOUCHERTYPENAME for Report VoucherRegister
VOUCHERTYPEORIGNAME String VOUCHERTYPEORIGNAME for Report VoucherRegister
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.

StockItem

Retrieve StockItems.

Table Specific Information
Select

The connector will use the Tally API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.

  • String supports the '=, !=,<, <=, >, >=, LIKE, ORDER BY' comparisons.

For example these queries are processed server side:

SELECT * FROM StockItem WHERE Narration LIKE 'Item%'

SELECT * FROM StockItem WHERE GSTApplicable != NULL

SELECT * FROM StockItem WHERE ValuationMethod = 'Default' AND CostingMethod = 'Avg. Cost'

SELECT * FROM StockItem WHERE LastSaleParty = 'OutState Party [GST Test]' OR OutwardQuantity = '0 Nos'

SELECT * FROM StockItem WHERE IsBatchWiseOn > 'No'

SELECT * FROM StockItem ORDER BY RemoteAltGUID Desc
Columns
Name Type Description
Name String The Name value of the StockItem.
ActiveFrom Date The ActiveFrom value of the StockItem.
ActiveTo Date The ActiveTo value of the StockItem.
PriceLevelDate Date The PriceLevelDate value of the StockItem.
Guid String The Guid value of the StockItem.
PriceLevel String The PriceLevel value of the StockItem.
Parent String The Parent value of the StockItem.
Category String The Category value of the StockItem.
Narration String The Narration value of the StockItem.
RemoteGUID String The RemoteGUID value of the StockItem.
RemoteAltGUID String The RemoteAltGUID value of the StockItem.
RequestorRule String The RequestorRule value of the StockItem.
TDSApplicable String The TDSApplicable value of the StockItem.
TCSApplicable String The TCSApplicable value of the StockItem.
GSTApplicable String The GSTApplicable value of the StockItem.
TaxClassificationName String The TaxClassificationName value of the StockItem.
Description String The Description value of the StockItem.
GSTTypeofSupply String The GSTTypeofSupply value of the StockItem.
ServiceTaxApplicable String The ServiceTaxApplicable value of the StockItem.
ExciseApplicability String The ExciseApplicability value of the StockItem.
SalesTaxCessApplicable String The SalesTaxCessApplicable value of the StockItem.
VATApplicable String The VATApplicable value of the StockItem.
LedgerName String The LedgerName value of the StockItem.
CostingMethod String The CostingMethod value of the StockItem.
ValuationMethod String The ValuationMethod value of the StockItem.
BaseUnits String The BaseUnits value of the StockItem.
AdditionalUnits String The AdditionalUnits value of the StockItem.
ExciseTaxType String The ExciseTaxType value of the StockItem.
NatureofItem String The NatureofItem value of the StockItem.
ExciseItemClassification String The ExciseItemClassification value of the StockItem.
OldBasicTariffType String The OldBasicTariffType value of the StockItem.
TCSCategory String The TCSCategory value of the StockItem.
BasicTariffType String The BasicTariffType value of the StockItem.
VatCommodity String The VatCommodity value of the StockItem.
EntryTaxCommodity String The EntryTaxCommodity value of the StockItem.
VatBaseUnit String The VatBaseUnit value of the StockItem.
VatTrailUnit String The VatTrailUnit value of the StockItem.
ReOrderPeriod String The ReOrderPeriod value of the StockItem.
ReOrderRoundType String The ReOrderRoundType value of the StockItem.
MinOrderPeriod String The MinOrderPeriod value of the StockItem.
MinOrderRoundType String The MinOrderRoundType value of the StockItem.
GSTRepUoM String The GSTRepUoM value of the StockItem.
GSTConvUnit String The GSTConvUnit value of the StockItem.
IsCostCentresOn String The IsCostCentresOn value of the StockItem.
IsBatchWiseOn String The IsBatchWiseOn value of the StockItem.
IsPerishableOn String The IsPerishableOn value of the StockItem.
IsEntryTaxApplicable String The IsEntryTaxApplicable value of the StockItem.
IsCostTrackingOn String The IsCostTrackingOn value of the StockItem.
IsMstFromSync String The IsMstFromSync value of the StockItem.
IsUpdatingTargetId String The IsUpdatingTargetId value of the StockItem.
AsOriginal String The AsOriginal value of the StockItem.
IsRateInclusiveVAT String The IsRateInclusiveVAT value of the StockItem.
IgnorePhysicalDifference String The IgnorePhysicalDifference value of the StockItem.
IgnoreNegativeStock String The IgnoreNegativeStock value of the StockItem.
TreatSalesasManufactured String The TreatSalesasManufactured value of the StockItem.
TreatPurchasesasConsumed String The TreatPurchasesasConsumed value of the StockItem.
TreatRejectsasScrap String The TreatRejectsasScrap value of the StockItem.
HasMfgDate String The HasMfgDate value of the StockItem.
AllowUseofExpiredItems String The AllowUseofExpiredItems value of the StockItem.
IgnoreBatches String The IgnoreBatches value of the StockItem.
IgnoreGodowns String The IgnoreGodowns value of the StockItem.
CalcOnMRP String The CalcOnMRP value of the StockItem.
ExcludeJrnlForValuation String The ExcludeJrnlForValuation value of the StockItem.
IsMRPInclOfTax String The IsMRPInclOfTax value of the StockItem.
IsAddlTaxExempt String The IsAddlTaxExempt value of the StockItem.
IsSupplementryDutyOn String The IsSupplementryDutyOn value of the StockItem.
GVATIsExciseAppl String The GVATIsExciseAppl value of the StockItem.
ReOrderAsHigher String The ReOrderAsHigher value of the StockItem.
MinOrderAsHigher String The MinOrderAsHigher value of the StockItem.
IsExciseCalculateonMRP String The IsExciseCalculateonMRP value of the StockItem.
InclusiveTax String The InclusiveTax value of the StockItem.
GSTCalcSlabOnMRP String The GSTCalcSlabOnMRP value of the StockItem.
ModifyMRPRate String The ModifyMRPRate value of the StockItem.
SortPosition Decimal The SortPosition value of the StockItem.
Alterid Decimal The Alterid value of the StockItem.
RemoteAlterID Decimal The RemoteAlterID value of the StockItem.
Denominator Decimal The Denominator value of the StockItem.
Conversion Decimal The Conversion value of the StockItem.
RateofMRP Decimal The RateofMRP value of the StockItem.
BasicRateOfExcise Decimal The BasicRateOfExcise value of the StockItem.
RateOfEntryTax Decimal The RateOfEntryTax value of the StockItem.
RateofVAT Decimal The RateofVAT value of the StockItem.
RateofSAT Decimal The RateofSAT value of the StockItem.
VatBaseNo Decimal The VatBaseNo value of the StockItem.
VatTrailNo Decimal The VatTrailNo value of the StockItem.
VatActualRatio Decimal The VatActualRatio value of the StockItem.
ReOrderPeriodLength Decimal The ReOrderPeriodLength value of the StockItem.
ReOrderRoundLimit Decimal The ReOrderRoundLimit value of the StockItem.
MinOrderPeriodLength Decimal The MinOrderPeriodLength value of the StockItem.
MinOrderRoundLimit Decimal The MinOrderRoundLimit value of the StockItem.
GSTItemUnits Decimal The GSTItemUnits value of the StockItem.
GSTRepUnits Decimal The GSTRepUnits value of the StockItem.
OpeningBalance String The OpeningBalance value of the StockItem.
OpeningValue Decimal The OpeningValue value of the StockItem.
BasicValue String The BasicValue value of the StockItem.
BasicQty String The BasicQty value of the StockItem.
ReorderBase String The ReorderBase value of the StockItem.
MinimumOrderBase String The MinimumOrderBase value of the StockItem.
OpeningRate String The OpeningRate value of the StockItem.
tempGSTCGSTRate Decimal The tempGSTCGSTRate value of the StockItem.
tempGSTSGSTRate Decimal The tempGSTSGSTRate value of the StockItem.
tempGSTIGSTRate Decimal The tempGSTIGSTRate value of the StockItem.
tempGSTStateCessRate Decimal The tempGSTStateCessRate value of the StockItem.
tempIsVATfieldsEdited String The tempIsVATfieldsEdited value of the StockItem.
tempApplDate Date The tempApplDate value of the StockItem.
tempClassification String The tempClassification value of the StockItem.
tempNature String The tempNature value of the StockItem.
tempPartyEntity String The tempPartyEntity value of the StockItem.
tempBusinessNature String The tempBusinessNature value of the StockItem.
tempVATRate Decimal The tempVATRate value of the StockItem.
tempAddlTax Decimal The tempAddlTax value of the StockItem.
tempCessOnVat Decimal The tempCessOnVat value of the StockItem.
tempTaxType String The tempTaxType value of the StockItem.
tempMajorCommodityName String The tempMajorCommodityName value of the StockItem.
tempCommodityName String The tempCommodityName value of the StockItem.
tempCommodityCode String The tempCommodityCode value of the StockItem.
tempSubCommodityCode String The tempSubCommodityCode value of the StockItem.
tempUOM String The tempUOM value of the StockItem.
tempTypeofGoods String The tempTypeofGoods value of the StockItem.
tempTradeName String The tempTradeName value of the StockItem.
tempGoodsNature String The tempGoodsNature value of the StockItem.
tempSchedule String The tempSchedule value of the StockItem.
tempScheduleslNo String The tempScheduleslNo value of the StockItem.
tempIsInvDetailsEnable String The tempIsInvDetailsEnable value of the StockItem.
tempValuationType String The tempValuationType value of the StockItem.
tempIsCalcOnQty String The tempIsCalcOnQty value of the StockItem.
tempMRPRate String The tempMRPRate value of the StockItem.
tempMRPApplDate Date The tempMRPApplDate value of the StockItem.
MailingName String The MailingName value of the StockItem.
TargetRemoteId String The TargetRemoteId value of the StockItem.
OldAuditEntryIds Decimal The OldAuditEntryIds value of the StockItem.
Closingbalance String The Closingbalance value of the StockItem.
Inwardquantity String The Inwardquantity value of the StockItem.
Outwardquantity String The Outwardquantity value of the StockItem.
Closingvalue Decimal The Closingvalue value of the StockItem.
Inwardvalue String The Inwardvalue value of the StockItem.
Outwardvalue Decimal The Outwardvalue value of the StockItem.
Closingrate String The Closingrate value of the StockItem.
Lastsaledate Date The Lastsaledate value of the StockItem.
Lastsaleparty String The Lastsaleparty value of the StockItem.
Lastsaleprice String The Lastsaleprice value of the StockItem.
Lastsaleqty String The Lastsaleqty value of the StockItem.
Lastpurcdate Date The Lastpurcdate value of the StockItem.
Lastpurcparty String The Lastpurcparty value of the StockItem.
Lastpurcprice String The Lastpurcprice value of the StockItem.
Lastpurccost String The Lastpurccost value of the StockItem.
Lastpurcqty String The Lastpurcqty value of the StockItem.
Consumption Decimal The Consumption value of the StockItem.
Thisyearbalance Decimal The Thisyearbalance value of the StockItem.
Prevyearbalance Decimal The Prevyearbalance value of the StockItem.
Thisquarterbalance Decimal The Thisquarterbalance value of the StockItem.
Prevquarterbalance Decimal The Prevquarterbalance value of the StockItem.
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.

Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT operations with Tally.

Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Tally, along with an indication of whether the procedure succeeded or failed.

Tally Connector Stored Procedures

Name Description
CreateSchema Creates a schema definition of a table in Tally.
ExportReport Export Report.
ImportData Imports Data into Tally

CreateSchema

Creates a schema definition of a table in Tally.

CreateSchema

Creates a local schema file (.rsd) from an existing table or view in the data model.

The schema file is created in the directory set in the Location connection property when this procedure is executed. You can edit the file to include or exclude columns, rename columns, or adjust column datatypes.

The connector checks the Location to determine if the names of any .rsd files match a table or view in the data model. If there is a duplicate, the schema file will take precedence over the default instance of this table in the data model. If a schema file is present in Location that does not match an existing table or view, a new table or view entry is added to the data model of the connector.

Input
Name Type Required Description
TableName String True The name of the table.
FileName String False The full file path and name of the schema to generate, required if the location connection property is not set. Ex : 'C:\Users\User\Desktop\Tally\company.rsd'
Result Set Columns
Name Type Description
Result String Whether or not the schema was successfully downloaded.
FileData String If the FileName and FileStream are not provided, this contains the content of the file.

ExportReport

Export Report.

Input
Name Type Required Description
ReportName String True The Name of the Report to be downloaded. The allowed values are Balance Sheet, Profit and Loss, Stock Summary, Ratio Analysis, Trial Balance, RTS FilteredVouchers, Negative Stock, Negative Ledgers, Bank Group summary, Ledger Vouchers, Group Summary, Group Vouchers, Voucher Register, Bills Receivable, Bills Payable, Ledger Outstandings, Group Outstandings, Statistics, Cost Category Summary, Cost Centre Breakup, Ledger Cost Breakup, Group Cost Breakup, Godown Summary, ITEMMONTHLYSUMMARY, STOCKVOUCHERS, STOCKSUMMARY, Prlevel.
ReportParameter String False Report Parameter if required for the report eg: GROUPNAME=BANK ACCOUNTS
ReportFormat String False The format of the downloaded report: XML or HTML The allowed values are XML, HTML. The default value is HTML.
ExportLocation String False Download location
FromDate Date False From Date
ToDate Date False To Date
Company String False 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.
Encoding String False The FileData input encoding type. The allowed values are NONE, BASE64. The default value is BASE64.
Result Set Columns
Name Type Description
Status String The status of the operation
FileData String If the ExportLocation and FileStream are not provided, this contains the content of the file.

ImportData

Imports Data into Tally

Input
Name Type Required Description
XMLPath String False Full path of the xml file to be Imported.
XMLContent String False XML Content to be imported.
Result Set Columns
Name Type Description
Status String Stored procedure execution status.

System Tables

You can query the system tables described in this section to access schema information, information on data source functionality, and batch operation statistics.

Schema Tables

The following tables return database metadata for Tally:

Data Source Tables

The following tables return information about how to connect to and query the data source:

  • sys_connection_props: Returns information on the available connection properties.
  • sys_sqlinfo: Describes the SELECT queries that the connector can offload to the data source.

Query Information Tables

The following table returns query statistics for data modification queries:

  • sys_identity: Returns information about batch operations or single updates.

sys_catalogs

Lists the available databases.

The following query retrieves all databases determined by the connection string:

SELECT * FROM sys_catalogs
Columns
Name Type Description
CatalogName String The database name.

sys_schemas

Lists the available schemas.

The following query retrieves all available schemas:

SELECT * FROM sys_schemas
Columns
Name Type Description
CatalogName String The database name.
SchemaName String The schema name.

sys_tables

Lists the available tables.

The following query retrieves the available tables and views:

SELECT * FROM sys_tables
Columns
Name Type Description
CatalogName String The database containing the table or view.
SchemaName String The schema containing the table or view.
TableName String The name of the table or view.
TableType String The table type (table or view).
Description String A description of the table or view.
IsUpdateable Boolean Whether the table can be updated.

sys_tablecolumns

Describes the columns of the available tables and views.

The following query returns the columns and data types for the Company table:

SELECT ColumnName, DataTypeName FROM sys_tablecolumns WHERE TableName='Company'
Columns
Name Type Description
CatalogName String The name of the database containing the table or view.
SchemaName String The schema containing the table or view.
TableName String The name of the table or view containing the column.
ColumnName String The column name.
DataTypeName String The data type name.
DataType Int32 An integer indicating the data type. This value is determined at run time based on the environment.
Length Int32 The storage size of the column.
DisplaySize Int32 The designated column's normal maximum width in characters.
NumericPrecision Int32 The maximum number of digits in numeric data. The column length in characters for character and date-time data.
NumericScale Int32 The column scale or number of digits to the right of the decimal point.
IsNullable Boolean Whether the column can contain null.
Description String A brief description of the column.
Ordinal Int32 The sequence number of the column.
IsAutoIncrement String Whether the column value is assigned in fixed increments.
IsGeneratedColumn String Whether the column is generated.
IsHidden Boolean Whether the column is hidden.
IsArray Boolean Whether the column is an array.
IsReadOnly Boolean Whether the column is read-only.
IsKey Boolean Indicates whether a field returned from sys_tablecolumns is the primary key of the table.

sys_procedures

Lists the available stored procedures.

The following query retrieves the available stored procedures:

SELECT * FROM sys_procedures
Columns
Name Type Description
CatalogName String The database containing the stored procedure.
SchemaName String The schema containing the stored procedure.
ProcedureName String The name of the stored procedure.
Description String A description of the stored procedure.
ProcedureType String The type of the procedure, such as PROCEDURE or FUNCTION.

sys_procedureparameters

Describes stored procedure parameters.

The following query returns information about all of the input parameters for the CreateSchema stored procedure:

SELECT * FROM sys_procedureparameters WHERE ProcedureName='CreateSchema' AND Direction=1 OR Direction=2
Columns
Name Type Description
CatalogName String The name of the database containing the stored procedure.
SchemaName String The name of the schema containing the stored procedure.
ProcedureName String The name of the stored procedure containing the parameter.
ColumnName String The name of the stored procedure parameter.
Direction Int32 An integer corresponding to the type of the parameter: input (1), input/output (2), or output(4). input/output type parameters can be both input and output parameters.
DataTypeName String The name of the data type.
DataType Int32 An integer indicating the data type. This value is determined at run time based on the environment.
Length Int32 The number of characters allowed for character data. The number of digits allowed for numeric data.
NumericPrecision Int32 The maximum precision for numeric data. The column length in characters for character and date-time data.
NumericScale Int32 The number of digits to the right of the decimal point in numeric data.
IsNullable Boolean Whether the parameter can contain null.
IsRequired Boolean Whether the parameter is required for execution of the procedure.
IsArray Boolean Whether the parameter is an array.
Description String The description of the parameter.
Ordinal Int32 The index of the parameter.

sys_keycolumns

Describes the primary and foreign keys.

The following query retrieves the primary key for the Company table:

SELECT * FROM sys_keycolumns WHERE IsKey='True' AND TableName='Company'
Columns
Name Type Description
CatalogName String The name of the database containing the key.
SchemaName String The name of the schema containing the key.
TableName String The name of the table containing the key.
ColumnName String The name of the key column.
IsKey Boolean Whether the column is a primary key in the table referenced in the TableName field.
IsForeignKey Boolean Whether the column is a foreign key referenced in the TableName field.
PrimaryKeyName String The name of the primary key.
ForeignKeyName String The name of the foreign key.
ReferencedCatalogName String The database containing the primary key.
ReferencedSchemaName String The schema containing the primary key.
ReferencedTableName String The table containing the primary key.
ReferencedColumnName String The column name of the primary key.

sys_foreignkeys

Describes the foreign keys.

The following query retrieves all foreign keys which refer to other tables:

SELECT * FROM sys_foreignkeys WHERE ForeignKeyType = 'FOREIGNKEY_TYPE_IMPORT'
Columns
Name Type Description
CatalogName String The name of the database containing the key.
SchemaName String The name of the schema containing the key.
TableName String The name of the table containing the key.
ColumnName String The name of the key column.
PrimaryKeyName String The name of the primary key.
ForeignKeyName String The name of the foreign key.
ReferencedCatalogName String The database containing the primary key.
ReferencedSchemaName String The schema containing the primary key.
ReferencedTableName String The table containing the primary key.
ReferencedColumnName String The column name of the primary key.
ForeignKeyType String Designates whether the foreign key is an import (points to other tables) or export (referenced from other tables) key.

sys_primarykeys

Describes the primary keys.

The following query retrieves the primary keys from all tables and views:

SELECT * FROM sys_primarykeys
Columns
Name Type Description
CatalogName String The name of the database containing the key.
SchemaName String The name of the schema containing the key.
TableName String The name of the table containing the key.
ColumnName String The name of the key column.
KeySeq String The sequence number of the primary key.
KeyName String The name of the primary key.

sys_indexes

Describes the available indexes. By filtering on indexes, you can write more selective queries with faster query response times.

The following query retrieves all indexes that are not primary keys:

SELECT * FROM sys_indexes WHERE IsPrimary='false'
Columns
Name Type Description
CatalogName String The name of the database containing the index.
SchemaName String The name of the schema containing the index.
TableName String The name of the table containing the index.
IndexName String The index name.
ColumnName String The name of the column associated with the index.
IsUnique Boolean True if the index is unique. False otherwise.
IsPrimary Boolean True if the index is a primary key. False otherwise.
Type Int16 An integer value corresponding to the index type: statistic (0), clustered (1), hashed (2), or other (3).
SortOrder String The sort order: A for ascending or D for descending.
OrdinalPosition Int16 The sequence number of the column in the index.

sys_connection_props

Returns information on the available connection properties and those set in the connection string.

When querying this table, the config connection string should be used:

jdbc:cdata:tally:config:

This connection string enables you to query this table without a valid connection.

The following query retrieves all connection properties that have been set in the connection string or set through a default value:

SELECT * FROM sys_connection_props WHERE Value <> ''
Columns
Name Type Description
Name String The name of the connection property.
ShortDescription String A brief description.
Type String The data type of the connection property.
Default String The default value if one is not explicitly set.
Values String A comma-separated list of possible values. A validation error is thrown if another value is specified.
Value String The value you set or a preconfigured default.
Required Boolean Whether the property is required to connect.
Category String The category of the connection property.
IsSessionProperty String Whether the property is a session property, used to save information about the current connection.
Sensitivity String The sensitivity level of the property. This informs whether the property is obfuscated in logging and authentication forms.
PropertyName String A camel-cased truncated form of the connection property name.
Ordinal Int32 The index of the parameter.
CatOrdinal Int32 The index of the parameter category.
Hierarchy String Shows dependent properties associated that need to be set alongside this one.
Visible Boolean Informs whether the property is visible in the connection UI.
ETC String Various miscellaneous information about the property.

sys_sqlinfo

Describes the SELECT query processing that the connector can offload to the data source.

Discovering the Data Source's SELECT Capabilities

Below is an example data set of SQL capabilities. Some aspects of SELECT functionality are returned in a comma-separated list if supported; otherwise, the column contains NO.

Name Description Possible Values
AGGREGATE_FUNCTIONS Supported aggregation functions. AVG, COUNT, MAX, MIN, SUM, DISTINCT
COUNT Whether COUNT function is supported. YES, NO
IDENTIFIER_QUOTE_OPEN_CHAR The opening character used to escape an identifier. [
IDENTIFIER_QUOTE_CLOSE_CHAR The closing character used to escape an identifier. ]
SUPPORTED_OPERATORS A list of supported SQL operators. =, >, <, >=, <=, <>, !=, LIKE, NOT LIKE, IN, NOT IN, IS NULL, IS NOT NULL, AND, OR
GROUP_BY Whether GROUP BY is supported, and, if so, the degree of support. NO, NO_RELATION, EQUALS_SELECT, SQL_GB_COLLATE
STRING_FUNCTIONS Supported string functions. LENGTH, CHAR, LOCATE, REPLACE, SUBSTRING, RTRIM, LTRIM, RIGHT, LEFT, UCASE, SPACE, SOUNDEX, LCASE, CONCAT, ASCII, REPEAT, OCTET, BIT, POSITION, INSERT, TRIM, UPPER, REGEXP, LOWER, DIFFERENCE, CHARACTER, SUBSTR, STR, REVERSE, PLAN, UUIDTOSTR, TRANSLATE, TRAILING, TO, STUFF, STRTOUUID, STRING, SPLIT, SORTKEY, SIMILAR, REPLICATE, PATINDEX, LPAD, LEN, LEADING, KEY, INSTR, INSERTSTR, HTML, GRAPHICAL, CONVERT, COLLATION, CHARINDEX, BYTE
NUMERIC_FUNCTIONS Supported numeric functions. ABS, ACOS, ASIN, ATAN, ATAN2, CEILING, COS, COT, EXP, FLOOR, LOG, MOD, SIGN, SIN, SQRT, TAN, PI, RAND, DEGREES, LOG10, POWER, RADIANS, ROUND, TRUNCATE
TIMEDATE_FUNCTIONS Supported date/time functions. NOW, CURDATE, DAYOFMONTH, DAYOFWEEK, DAYOFYEAR, MONTH, QUARTER, WEEK, YEAR, CURTIME, HOUR, MINUTE, SECOND, TIMESTAMPADD, TIMESTAMPDIFF, DAYNAME, MONTHNAME, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, EXTRACT
REPLICATION_SKIP_TABLES Indicates tables skipped during replication.
REPLICATION_TIMECHECK_COLUMNS A string array containing a list of columns which will be used to check for (in the given order) to use as a modified column during replication.
IDENTIFIER_PATTERN String value indicating what string is valid for an identifier.
SUPPORT_TRANSACTION Indicates if the provider supports transactions such as commit and rollback. YES, NO
DIALECT Indicates the SQL dialect to use.
KEY_PROPERTIES Indicates the properties which identify the uniform database.
SUPPORTS_MULTIPLE_SCHEMAS Indicates if multiple schemas may exist for the provider. YES, NO
SUPPORTS_MULTIPLE_CATALOGS Indicates if multiple catalogs may exist for the provider. YES, NO
DATASYNCVERSION The Data Sync version needed to access this driver. Standard, Starter, Professional, Enterprise
DATASYNCCATEGORY The Data Sync category of this driver. Source, Destination, Cloud Destination
SUPPORTSENHANCEDSQL Whether enhanced SQL functionality beyond what is offered by the API is supported. TRUE, FALSE
SUPPORTS_BATCH_OPERATIONS Whether batch operations are supported. YES, NO
SQL_CAP All supported SQL capabilities for this driver. SELECT, INSERT, DELETE, UPDATE, TRANSACTIONS, ORDERBY, OAUTH, ASSIGNEDID, LIMIT, LIKE, BULKINSERT, COUNT, BULKDELETE, BULKUPDATE, GROUPBY, HAVING, AGGS, OFFSET, REPLICATE, COUNTDISTINCT, JOINS, DROP, CREATE, DISTINCT, INNERJOINS, SUBQUERIES, ALTER, MULTIPLESCHEMAS, GROUPBYNORELATION, OUTERJOINS, UNIONALL, UNION, UPSERT, GETDELETED, CROSSJOINS, GROUPBYCOLLATE, MULTIPLECATS, FULLOUTERJOIN, MERGE, JSONEXTRACT, BULKUPSERT, SUM, SUBQUERIESFULL, MIN, MAX, JOINSFULL, XMLEXTRACT, AVG, MULTISTATEMENTS, FOREIGNKEYS, CASE, LEFTJOINS, COMMAJOINS, WITH, LITERALS, RENAME, NESTEDTABLES, EXECUTE, BATCH, BASIC, INDEX
PREFERRED_CACHE_OPTIONS A string value specifies the preferred cacheOptions.
ENABLE_EF_ADVANCED_QUERY Indicates if the driver directly supports advanced queries coming from Entity Framework. If not, queries will be handled client side. YES, NO
PSEUDO_COLUMNS A string array indicating the available pseudo columns.
MERGE_ALWAYS If the value is true, The Merge Mode is forcibly executed in Data Sync. TRUE, FALSE
REPLICATION_MIN_DATE_QUERY A select query to return the replicate start datetime.
REPLICATION_MIN_FUNCTION Allows a provider to specify the formula name to use for executing a server side min.
REPLICATION_START_DATE Allows a provider to specify a replicate startdate.
REPLICATION_MAX_DATE_QUERY A select query to return the replicate end datetime.
REPLICATION_MAX_FUNCTION Allows a provider to specify the formula name to use for executing a server side max.
IGNORE_INTERVALS_ON_INITIAL_REPLICATE A list of tables which will skip dividing the replicate into chunks on the initial replicate.
CHECKCACHE_USE_PARENTID Indicates whether the CheckCache statement should be done against the parent key column. TRUE, FALSE
CREATE_SCHEMA_PROCEDURES Indicates stored procedures that can be used for generating schema files.

The following query retrieves the operators that can be used in the WHERE clause:

SELECT * FROM sys_sqlinfo WHERE Name = 'SUPPORTED_OPERATORS'

Note that individual tables may have different limitations or requirements on the WHERE clause; refer to the Data Model section for more information.

Columns
Name Type Description
NAME String A component of SQL syntax, or a capability that can be processed on the server.
VALUE String Detail on the supported SQL or SQL syntax.

sys_identity

Returns information about attempted modifications.

The following query retrieves the Ids of the modified rows in a batch operation:

SELECT * FROM sys_identity
Columns
Name Type Description
Id String The database-generated ID returned from a data modification operation.
Batch String An identifier for the batch. 1 for a single operation.
Operation String The result of the operation in the batch: INSERTED, UPDATED, or DELETED.
Message String SUCCESS or an error message if the update in the batch failed.

sys_information

Describes the available system information.

The following query retrieves all columns:

SELECT * FROM sys_information
Columns
Name Type Description
Product String The name of the product.
Version String The version number of the product.
Datasource String The name of the datasource the product connects to.
NodeId String The unique identifier of the machine where the product is installed.
HelpURL String The URL to the product's help documentation.
License String The license information for the product. (If this information is not available, the field may be left blank or marked as 'N/A'.)
Location String The file path location where the product's library is stored.
Environment String The version of the environment or rumtine the product is currently running under.
DataSyncVersion String The tier of Sync required to use this connector.
DataSyncCategory String The category of Sync functionality (e.g., Source, Destination).

Advanced Configurations Properties

The advanced configurations properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure. Click the links for further details.

Authentication

Property Description
URL The URL of the Tally instance. Default value is http://{hostname or server ip}:9000.
Company The Name of the Company in Tally.

SSL

Property Description
SSLServerCert The certificate to be accepted from the server when connecting using TLS/SSL.

Schema

Property Description
Location A path to the directory that contains the schema files defining tables, views, and stored procedures.
BrowsableSchemas This property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA, SchemaB, SchemaC.
Tables This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA, TableB, TableC.
Views Restricts the views reported to a subset of the available tables. For example, Views=ViewA, ViewB, ViewC.

Miscellaneous

Property Description
MaxRows Limits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses.
Other These hidden properties are used only in specific use cases.
PseudoColumns This property indicates whether or not to include pseudo columns as columns to the table.
Timeout The value in seconds until the timeout error is thrown, canceling the operation.
UserDefinedViews A filepath pointing to the JSON configuration file containing your custom views.

Authentication

This section provides a complete list of authentication properties you can configure.

Property Description
URL The URL of the Tally instance. Default value is http://{hostname or server ip}:9000.
Company The Name of the Company in Tally.

URL

The URL of the Tally instance. Default value is http://{hostname or server ip}:9000.

Data Type

string

Default Value

""

Remarks

The URL of the Tally instance. Default value is http://{hostname or server ip}:9000

Company

The Name of the Company in Tally.

Data Type

string

Default Value

""

Remarks

Enter the Name of the Company if you want to fetch data of the Company which is not selected in the tool at the moment. Please make sure that Company 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. Default value is blank. In case of blank it will fetch data of the Company that is selected in the Tally Tool.

SSL

This section provides a complete list of SSL properties you can configure.

Property Description
SSLServerCert The certificate to be accepted from the server when connecting using TLS/SSL.

SSLServerCert

The certificate to be accepted from the server when connecting using TLS/SSL.

Data Type

string

Default Value

""

Remarks

If using a TLS/SSL connection, this property can be used to specify the TLS/SSL certificate to be accepted from the server. Any other certificate that is not trusted by the machine is rejected.

This property can take the following forms:

Description Example
A full PEM Certificate (example shortened for brevity) -----BEGIN CERTIFICATE----- MIIChTCCAe4CAQAwDQYJKoZIhv......Qw== -----END CERTIFICATE-----
A path to a local file containing the certificate C:\\cert.cer
The public key (example shortened for brevity) -----BEGIN RSA PUBLIC KEY----- MIGfMA0GCSq......AQAB -----END RSA PUBLIC KEY-----
The MD5 Thumbprint (hex values can also be either space or colon separated) ecadbdda5a1529c58a1e9e09828d70e4
The SHA1 Thumbprint (hex values can also be either space or colon separated) 34a929226ae0819f2ec14b4a3d904f801cbb150d

If not specified, any certificate trusted by the machine is accepted.

Certificates are validated as trusted by the machine based on the System's trust store. The trust store used is the 'javax.net.ssl.trustStore' value specified for the system. If no value is specified for this property, Java's default trust store is used (for example, JAVA_HOME\lib\security\cacerts).

Use '*' to signify to accept all certificates. Note that this is not recommended due to security concerns.

Schema

This section provides a complete list of schema properties you can configure.

Property Description
Location A path to the directory that contains the schema files defining tables, views, and stored procedures.
BrowsableSchemas This property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA, SchemaB, SchemaC.
Tables This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA, TableB, TableC.
Views Restricts the views reported to a subset of the available tables. For example, Views=ViewA, ViewB, ViewC.

Location

A path to the directory that contains the schema files defining tables, views, and stored procedures.

Data Type

string

Default Value

%APPDATA%\Tally Data Provider\Schema

Remarks

The path to a directory which contains the schema files for the connector (.rsd files for tables and views, .rsb files for stored procedures). The folder location can be a relative path from the location of the executable. The Location property is only needed if you want to customize definitions (for example, change a column name, ignore a column, and so on) or extend the data model with new tables, views, or stored procedures.

If left unspecified, the default location is "%APPDATA%\Tally Data Provider\Schema" with %APPDATA% being set to the user's configuration directory:

Platform %APPDATA%
Windows The value of the APPDATA environment variable
Mac ~/Library/Application Support
Linux ~/.config

BrowsableSchemas

This property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC.

Data Type

string

Default Value

""

Remarks

Listing the schemas from databases can be expensive. Providing a list of schemas in the connection string improves the performance.

Tables

This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC.

Data Type

string

Default Value

""

Remarks

Listing the tables from some databases can be expensive. Providing a list of tables in the connection string improves the performance of the connector.

This property can also be used as an alternative to automatically listing views if you already know which ones you want to work with and there would otherwise be too many to work with.

Specify the tables you want in a comma-separated list. Each table should be a valid SQL identifier with any special characters escaped using square brackets, double-quotes or backticks. For example, Tables=TableA,[TableB/WithSlash],WithCatalog.WithSchema.`TableC With Space`.

Note that when connecting to a data source with multiple schemas or catalogs, you will need to provide the fully qualified name of the table in this property, as in the last example here, to avoid ambiguity between tables that exist in multiple catalogs or schemas.

Views

Restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC.

Data Type

string

Default Value

""

Remarks

Listing the views from some databases can be expensive. Providing a list of views in the connection string improves the performance of the connector.

This property can also be used as an alternative to automatically listing views if you already know which ones you want to work with and there would otherwise be too many to work with.

Specify the views you want in a comma-separated list. Each view should be a valid SQL identifier with any special characters escaped using square brackets, double-quotes or backticks. For example, Views=ViewA,[ViewB/WithSlash],WithCatalog.WithSchema.`ViewC With Space`.

Note that when connecting to a data source with multiple schemas or catalogs, you will need to provide the fully qualified name of the table in this property, as in the last example here, to avoid ambiguity between tables that exist in multiple catalogs or schemas.

Miscellaneous

This section provides a complete list of miscellaneous properties you can configure.

Property Description
MaxRows Limits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses.
Other These hidden properties are used only in specific use cases.
PseudoColumns This property indicates whether or not to include pseudo columns as columns to the table.
Timeout The value in seconds until the timeout error is thrown, canceling the operation.
UserDefinedViews A filepath pointing to the JSON configuration file containing your custom views.

MaxRows

Limits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses.

Data Type

int

Default Value

-1

Remarks

Limits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses.

Other

These hidden properties are used only in specific use cases.

Data Type

string

Default Value

""

Remarks

The properties listed below are available for specific use cases. Normal driver use cases and functionality should not require these properties.

Specify multiple properties in a semicolon-separated list.

Integration and Formatting
Property Description
DefaultColumnSize Sets the default length of string fields when the data source does not provide column length in the metadata. The default value is 2000.
ConvertDateTimeToGMT Determines whether to convert date-time values to GMT, instead of the local time of the machine.
RecordToFile=filename Records the underlying socket data transfer to the specified file.

PseudoColumns

This property indicates whether or not to include pseudo columns as columns to the table.

Data Type

string

Default Value

""

Remarks

This setting is particularly helpful in Entity Framework, which does not allow you to set a value for a pseudo column unless it is a table column. The value of this connection setting is of the format "Table1=Column1, Table1=Column2, Table2=Column3". You can use the "*" character to include all tables and all columns; for example, "*=*".

Timeout

The value in seconds until the timeout error is thrown, canceling the operation.

Data Type

int

Default Value

60

Remarks

If Timeout = 0, operations do not time out. The operations run until they complete successfully or until they encounter an error condition.

If Timeout expires and the operation is not yet complete, the connector throws an exception.

UserDefinedViews

A filepath pointing to the JSON configuration file containing your custom views.

Data Type

string

Default Value

""

Remarks

User Defined Views are defined in a JSON-formatted configuration file called UserDefinedViews.json. The connector automatically detects the views specified in this file.

You can also have multiple view definitions and control them using the UserDefinedViews connection property. When you use this property, only the specified views are seen by the connector.

This User Defined View configuration file is formatted as follows:

  • Each root element defines the name of a view.
  • Each root element contains a child element, called query, which contains the custom SQL query for the view.

For example:

{
    "MyView": {
        "query": "SELECT * FROM Company WHERE MyColumn = 'value'"
    },
    "MyView2": {
        "query": "SELECT * FROM MyTable WHERE Id IN (1,2,3)"
    }
}

Use the UserDefinedViews connection property to specify the location of your JSON configuration file. For example:

"UserDefinedViews", C:\Users\yourusername\Desktop\tmp\UserDefinedViews.json

Note that the specified path is not embedded in quotation marks.