Employees
Retrieve Employee Details.
Table Specific Information
Select
The 本製品 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 本製品.
- 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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Company | String | Name of the Company whose data need to be fetched. Please make sure it is selected and unlocked atleast once in the Tally tool after the tool is launched. It need not be in the selected state at the moment. |