Excel Add-In for Tally

Build 20.0.7695

Employees

Retrieve Employee Details.

Table Specific Information

Select

The {i 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 {i.

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

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7695