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 Harmony 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:
- sys_catalogs: Lists the available databases.
- sys_schemas: Lists the available schemas.
- sys_tables: Lists the available tables and views.
- sys_tablecolumns: Describes the columns of the available tables and views.
- sys_procedures: Describes the available stored procedures.
- sys_procedureparameters: Describes stored procedure parameters.
- sys_keycolumns: Describes the primary and foreign keys.
- sys_indexes: Describes the available indexes.
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.
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. |
Property | Description |
---|---|
SSLServerCert | The certificate to be accepted from the server when connecting using TLS/SSL. |
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. |
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.